Short Description: We have a new customer accessible server that we want on the same subnet as our other workstations but want to keep someone from...

zacware

06-09-2006 06:11 PM
zacware

Gentlemen; I have a situation that should be quite minor but it seems I have struggling with it for some reason or another. Here's what's up: I...

bobmct

06-09-2006 12:23 PM
bobmct

Hi, I have two tables: the first one has all details about persons, the second associate the id of each person to the id of his team...

AT

06-09-2006 08:13 AM
Paul Lautman

Dear people, I writen a application in vb.net with the MySQL Connector/NET 1.0 provider. But I can't get a connection with the MySQL database. The...

Gerrit de Haan

06-09-2006 03:43 AM
Paul Lautman

I just bought some web space which has mysql capabilities..... I am using SSH and have created a database and a table........ now I would like...

don

06-08-2006 10:03 AM
Bob Lanteigne

I had difficulty in finding memo field too. My db tools trial software expired a couple of days ago and I was convinced that when I was constructing...

Jenny Rice

06-08-2006 03:16 AM
Jenny Rice

I have some views whose identifier is same as that of table. I am unable to import the data with the command mysql -uuser -ppassword dbname <...

soup_or_power (AT) yahoo (DOT) com

06-08-2006 12:56 AM
Giuseppe Maxia

I have two questions rolled in one. I am considering how I can test to determine whether or not a load operation succeeded. Data files arrive, and...

Ted

06-07-2006 06:09 PM
Ted

When importing a previously gzipped dump using phpMyAdmin, the maximum size allowed for the compressed file is 50mg. Does anyone know how this...

deko

06-07-2006 06:08 AM
Jerry Stuckle

Hi We are developing an application that stores logging data in a mysql database. Due to some facts, we decided to store the loggingdata in a...

Hans

06-07-2006 02:27 AM
Hans

I've had 4.1 installed for over a year and for all this time have been connecting successfully from Tomcat and Java stand-alone classes.. now just...

Frances

06-06-2006 08:23 PM
Frances

if I upgrade from 4.1 to 5.0 can I use the same db's? my problem: I have 4.1 installed, but yesterday I installed xampp (for PHP development) it...

Frances

06-06-2006 09:47 AM
Frances

Recently, someone has told me that they've been able to run queries written like "ins/**/ert ..." work on their server. I've tried it on two...

yawnmoth

06-06-2006 03:16 AM
Mike Lischke

C wrote: Can you help me? Tahnks in advance. Just like it says - it can't find your user.myi file, This is the user table in your database.

Jerry Stuckle

06-05-2006 08:43 PM
Jerry Stuckle

This may be something I need to sleep on, but I'd be grateful for some tips. I need to create a delivery list, which I can maintain in order,...

turnitup

06-05-2006 05:39 PM
strawberry

I recently installed MySQL 3.23 because it was included with my linux distribution. HTen i went to mysq.com and found that it is highly recommended...

Marco A. Cruz Quevedo

06-05-2006 11:40 AM
Marco A. Cruz Quevedo

..NET 1.1 - C# MySQL 4.0.1 MySQL Connector/NET 1.0 Trying to get my .NET 1.1 web app to prod environment on 3rd party web host(no access to windows,...

drummer

06-05-2006 08:40 AM
ZoombyWoof

Hi there, I am currently running a mysql 4.0.18 installation on a production server. Now I would like to update the version to catch up with...

Merlin

06-05-2006 12:39 AM
Bas S.Th. Verdult

When I read a file into a table I get a message saying that there are 5 warnings - but how do I read these warnings - where are they stored?

don

06-03-2006 08:01 AM
Axel Schwenke

I have created a MySQL database for my company which is accessed by PHP pages. I would like to permit some users to edit the records but allow others...

Bob Sanderson

06-03-2006 07:39 AM
Jerry Stuckle

Hi all, table size on mysql ( win XP ), is known as being at least 2 GO. but what i see in structure field of phpmyadmin is Type...

alfred wallace

06-03-2006 05:01 AM
alfred wallace

Hi, I have an optimization question. Is there a way to count instances of each unique entry in a column (not unique entries)? Let me explain using...

kev

06-02-2006 03:51 PM
kev

Hi Having problem with delete query. Below is query: $unconfirmedstatus = 'Unconfirmed'; $firstquery = "DELETE FROM Pendingsales WHERE time < NOW()...

Donna Elles

06-02-2006 03:33 PM
Bill Karwin

Am I interpreting this line correctly : /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; Looks like a C style comment, but ends...

AT

06-02-2006 07:18 AM
AT

Does anyone know of any good MySQL magazines that I could subscribe to? I have googled, but no luck finding anything useful. Thanks for any info.

RiseOfThePhoenix

06-02-2006 05:24 AM
Axel Schwenke

Here is the clause defining a foreign key constraint. CONSTRAINT `contact_id_fk` FOREIGN KEY (`contact_id`) REFERENCES `conts` (`contact_id`) This...

Ted

06-01-2006 11:01 PM
Ted

Have a question about MySQL searching. I need to build a query that will search multiple fields on multiple tables. I know how to search within a...

Chris

06-01-2006 03:58 PM
Chris

Hallo, I'd like to join 2 db in one: I'd like to do query dealing the 2 db. I'd like to Join these db only for some querues and I want that these 2...

mario.lat_

06-01-2006 04:55 AM
Axel Schwenke

Given an insert into a simple table whose primary key is an autoincrement is there a reliable way to return the value in a 1-step process? I can grab...

Craig Taylor

05-31-2006 01:40 PM
Craig Taylor

I have a stored proceduren with a prepared statement inside, I would like to put the result fields into variables but I don´t know how, Should I use...

AT

05-31-2006 12:41 PM
AT

I am trying to allow users to upload large ZIP files to a mysql database table. Small zip files of under 1MB work fine, but not zip files of 7MB....

Garry Jones

05-31-2006 05:36 AM
Axel Schwenke

I thought this would be simple, but it has me stumped. I've got items that have attributes. Attributes are of the form "name=value", where "name"...

Tim Smith

05-30-2006 08:32 PM
strawberry

Hi all, I've just moved my development server to FC5 which includes MySQL 5. Everything is fine in my old apps except this one query!! SELECT...

huwpioden (AT) gmail (DOT) com

05-30-2006 04:40 PM
PFG

Hi Forgive my newbiness. I am starting my first project using an sql database and am trying to decide the best way to solve this. I have a table...

mcardeiro (AT) yahoo (DOT) com

05-30-2006 03:52 PM
mcardeiro (AT) yahoo (DOT) com

Hi group, I have a small question: I'm building a music site with lots of artists in them. Each artist can belong to a certain genre of music: e.g....

frizzle

05-30-2006 06:45 AM
frizzle

Hi How can I delete records in a table based on a timestamp where the timestamp is greater than 20 mins old. I am using part php and part mysql. This...

Dynamo

05-29-2006 03:32 PM
Dynamo

Is there a proper way to store a hierarchy in a relational database? Something like: primaryKey | nodeName | parentNodePrimaryKey | ...

AT

05-29-2006 03:15 PM
AT

Newbie here coming over from sql server. I'm using mysql query browser and I would like to execute some script I'm not creating a stored procedure...

Joe

05-29-2006 02:08 PM
PFG

Can anybody help me on this "how to?" I hava an application that communicates with MySQL server. For one query, i need the data from another sql...

Jacco

05-28-2006 12:05 PM
The Ewings

Hmm, perhaps I didn't explain myself too well on the problem I'm having with my database in my last post over a week ago. There's a table,...

Alex Buell

05-27-2006 04:24 PM
Paul Lautman

In order to do a full outer join in MySQL one must use a union. Is there any good reason to do SELECT ... LEFT JOIN UNION SELECT ... RIGHT JOIN

Paul Lautman

05-27-2006 06:50 AM
Jerry Stuckle

Hi there, I am doing a count on two tables and do want to know how many rows will be returned back. Unfortunatelly the result is instead of 3 is...

Merlin

05-26-2006 04:23 PM
Paul Lautman

I have 2 tables: "first" and "second" table "first" has 2 columns (id, a) and 2 records: id --- a 1 --- apples 2 --- pears table "second" has 2...

Ubi

05-26-2006 11:47 AM
Paul Lautman

Please pardon me if this has been discussed before. My question is this: In your opinion, what is the best language to develop a MySQL application...

The Ewings

05-25-2006 01:25 PM
The Ewings

Hi I ve a huge database created in MySQL by someone else. now i want to view all the tables and their relationships so tht i can design the queries....

AT

05-25-2006 11:31 AM
Bill Karwin

Given two tables, I need to insert each record in the first into the second that isn't already in the second, and I need to insert...

Ted

05-25-2006 11:28 AM
Bill Karwin

Sorry about that... Forgot I was using the no spam address. I'll do the work if someone wants to show weak security. clientliason (AT) hotmail...

News Feeds

05-25-2006 09:38 AM
News Feeds

Hey all. I just started usng mysql, and need a bit of help arriving at the following select date, datefunctionhere from table; DATE | ...

jared.pohl (AT) gmail (DOT) com

05-25-2006 07:20 AM
Luuk

Hi, I have a View which I woulk like to combine with a query VIEW --------- (SELECT `idguest` AS `idguest`, SUM(price) AS Expr1, 0 AS...

Jared

05-25-2006 03:23 AM
Martijn Tonies

Hi, I have few different sales tables and I would like to know how I can write qeury that produces following results.. Tables=(sale.accom,...

Jared

05-24-2006 11:15 PM
Jerry Stuckle