Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
> >> > Basics of database design: store what you know. > >> > > >> > Given that NULLs basically means the absence of a value > >> > (eg: unknown), you shouldn't be storing NULLs. > >> > > >> Nonsense!! > > > > That's a bold statement ... > > > >> That's simply wrong. A null means "unknown or not ap

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
> At 7:48 pm -0500 14/3/06, Rhino wrote: > >>Ah, so now things become clear, a NULL actually can mean > >>two things? So much for clarity then... > > > >Come on; that's not fair. "Unknown" and "not applicable" are more like different senses of the same thing, not two opposite things. > > > IIRC (

Re: insert my_ulonglong data with C API

2006-03-14 Thread Dan Nelson
In the last episode (Mar 15), said: > Hello,everyone! > > My table has a bigint column which needs store 8bytes integer. > > I looked up in Mysql Menual. It seems that , if I use C API I can > only use preapared statement functions to insert bigint values. > > I can not use mysql_real_query

insert my_ulonglong data with C API

2006-03-14 Thread 古雷
Hello,everyone! My table has a bigint column which needs store 8bytes integer. I looked up in Mysql Menual. It seems that , if I use C API I can only use preapared statement functions to insert bigint values. I can not use mysql_real_query or mysql_query to insert bigint values because I do not

Re: Accountability with MySQL

2006-03-14 Thread James Harvard
At 7:48 pm -0500 14/3/06, Rhino wrote: >>Ah, so now things become clear, a NULL actually can mean >>two things? So much for clarity then... > >Come on; that's not fair. "Unknown" and "not applicable" are more like >different senses of the same thing, not two opposite things. IIRC (but please don'

Re: Accountability with MySQL

2006-03-14 Thread Rhino
- Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; Sent: Tuesday, March 14, 2006 2:16 PM Subject: Re: Accountability with MySQL > >Should you have a flag for the status "movement complete" ? I would > >say >>yes but instead of a simple

Re: Accountability with MySQL

2006-03-14 Thread Rhino
- Original Message - From: "Bruno B B Magalháes" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 14, 2006 2:07 PM Subject: Re: Accountability with MySQL I am designing a simple accountability system so all the partners can have direct access to it by intranet. I was designing the da

Re: Very large from

2006-03-14 Thread James Harvard
At 4:24 pm -0500 14/3/06, fbsd_user wrote: >user has to use the power bar to move deeper into the form Out of curiosity, what's "the power bar"? >From a db perspective one single insert is preferable, IMO. Firstly you don't >have to declare as NULL required fields that will be entered in the sec

restoring backup, problem with BLOB?

2006-03-14 Thread Andrew stolarz
Hello List, I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours to restore. the area where its really hanging is when its importing the "BLOB" There are about 1200 records, totaling about 10mb in size for these blobs. I am running MyISAM, my current memory settings read

RE: Very large from

2006-03-14 Thread fbsd_user
Well not wanting to be rude back. But the question is dealing with how best to control the writing of data to mysql. No where do I say anything about using php. I could be using perl for all you know. But I respect your right to state your thoughts, but just don't agree with it. I think this is a b

RE: Very large from

2006-03-14 Thread fbsd_user
I understand the save the page form data into the session. But I don't know what you mean by just pass it from page to page. Would that mean having all the fields in regular form fields to accept the entered data and also hidden corresponding fields to hide page 1 data in as page 2 is entered and f

Re: Very large from

2006-03-14 Thread Peter M. Groen
On Tuesday 14 March 2006 22:24, fbsd_user wrote: > Have to develop form with over 100 input fields plus 40 different > drop downs. Seeking advice on technique to use. Thinking about > single form where user has to use the power bar to move deeper into > the form. This has benefit that every thing i

RE: mysql.sock gone

2006-03-14 Thread Anton Krall
No crons that would delete the tmp directory.. In fact, all the other files stay there... Just mysql.sock goes away... |-Original Message- |From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] |Sent: Tuesday, March 14, 2006 3:15 PM |To: Anton Krall; mysql@lists.mysql.com |Subje

Re: Very large from

2006-03-14 Thread David Logan
Not wanting to be rude but this question would probably be answered better in a php group. I realise there are many users of php that subscribe to this list, but this is a mysql list not php. If you go to http://www.php.net/support.php you will find a large number of resources (including lists

Re: Query Optimization Question

2006-03-14 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Yes, a ranged query should respond faster than a negation. In some cases you can seriously improve query performance for a negation query if you split it into two range queries unioned together. Here is a pseudo example: This query should be slow due to the table scan

Re: Very large from

2006-03-14 Thread Brett Harvey
Both methods are "commonly" used. Another method used is to have multiple pages like you've mentioned but save all the data into a session (of just pass it from page to page) until all 3 pages are complete and then write all the data at once The question to ask yourself is, do you want just

Very large from

2006-03-14 Thread fbsd_user
Have to develop form with over 100 input fields plus 40 different drop downs. Seeking advice on technique to use. Thinking about single form where user has to use the power bar to move deeper into the form. This has benefit that every thing is written to the database at one time, but the draw back

RE: mysql.sock gone

2006-03-14 Thread Logan, David (SST - Adelaide)
Do you have any cron jobs that clear the /tmp directory during the day? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard

mysql.sock gone

2006-03-14 Thread Anton Krall
Guys. I just started having a problem, Im running mysql-standard-4.1.12-pc-linux-gnu-i686 binaries under Fedora Core 3 and Ive been having problem where during some parts of the day, /tmp/mysql.oskc goes away, I can still see mysql running when I do a ps ax but when I try to connect to it, it says

Re: Cannot connect to server

2006-03-14 Thread James E Hicks III
Sara Woglom wrote: Thanks Shawn!! You should be thanking Mladen Adamovic for pointing you to: http://dev.mysql.com/doc/mysql/en/grant.html This page holds your answer. From the error message you got Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL serv

Re: migrating 4.0 to 4.1 character set problems

2006-03-14 Thread Sean O'Hara
Hi, I have figured out a way to get this to work. I am just posting what I did in case anyone else stumbles across my original message. I am sure there are other ways to get this to work, but this is the way that worked for me: ### # My HOW

Re: 'Into outfile' doesn't include the column names. How can it be done?

2006-03-14 Thread Jake Peavy
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > "Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM: > > > > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote: > > > > > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > > > > > > > Hi Ariel, > > > > > > > > Maybe th

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
> > >Should you have a flag for the status "movement complete" ? I would say > >>yes but instead of a simple checkbox, you could store a date value. That > >>gives you two pieces of information > >> > >>a) if the date is null then the movement is not complete. > >>b) if the date is NOT null then t

Re: Accountability with MySQL

2006-03-14 Thread Bruno B B Magalháes
>>I am designing a simple accountability system so all the partners can >> have >> direct access to it by intranet. >> >> I was designing the data model, and came up with this: >> >> CREATE TABLE `moviments` ( >> `moviment_id` int(20) NOT NULL auto_increment, >> `moviment_date` date NOT NULL def

Re: 'Into outfile' doesn't include the column names. How can it be done?

2006-03-14 Thread SGreen
"Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM: > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote: > > > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > > > > > Hi Ariel, > > > > > > Maybe this example helps you to create CSV output from MySQL. > > > The first SELECT gene

Re: mysql on Windows

2006-03-14 Thread SGreen
"Neil Tompkins" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:42:32 PM: > Apart from this are there any other known issues. When trialing mySQL on my > XP machine, I noticed all the tables were created in lower case ? Is this > normal ? > > Cheers > Neil > > > >From: Mark Leith <[EMAIL PROT

Re: 'Into outfile' doesn't include the column names. How can it be done?

2006-03-14 Thread Jake Peavy
On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote: > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > > > Hi Ariel, > > > > Maybe this example helps you to create CSV output from MySQL. > > The first SELECT generates the headerline; the second the data. > > ( SELECT 'FieldA','FieldB','FieldC',

Re: Accountability with MySQL

2006-03-14 Thread Rhino
- Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 14, 2006 1:28 PM Subject: Re: Accountability with MySQL >Should you have a flag for the status "movement complete" ? I would say yes but instead of a simple checkbox, you could store a date val

Re: mysql on Windows

2006-03-14 Thread Neil Tompkins
Apart from this are there any other known issues. When trialing mySQL on my XP machine, I noticed all the tables were created in lower case ? Is this normal ? Cheers Neil From: Mark Leith <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Neil Tompkins <[EMAIL PROTECTED]> CC: mysql@lists.

Re: Accountability with MySQL

2006-03-14 Thread Rhino
- Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 14, 2006 1:16 PM Subject: Re: Accountability with MySQL Hello Bruno, well about the date default value being invalid, well it´s working here in my system (MySQL 4.1.16, Mac OS X 10.4.5), and

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
Hello Shawn, > > well about the date default value being invalid, well it´s working here in > > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with > > this... > > Yes, it's a valid value in MySQL, but it's an invalid date, > that's what I'm trying to say. Why have an invalid d

MySQL JDBC Exception: "No operations allowed after connection closed"

2006-03-14 Thread amiljusevic
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14, J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to time I get the MySQL JDBC driver exception "No operations allowed after connection closed", after which DB calls from my application keep failing. The stack trac

Re: Accountability with MySQL

2006-03-14 Thread Rhino
- Original Message - From: "Bruno B B Magalháes" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 14, 2006 12:41 PM Subject: Accountability with MySQL I am designing a simple accountability system so all the partners can have direct access to it by intranet. I was designing the data mo

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
>Should you have a flag for the status "movement complete" ? I would say >yes but instead of a simple checkbox, you could store a date value. That >gives you two pieces of information > >a) if the date is null then the movement is not complete. >b) if the date is NOT null then the movement is compl

Re: Accountability with MySQL

2006-03-14 Thread SGreen
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:16:11 PM: > Hello Bruno, > > > well about the date default value being invalid, well it´s working here in > > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with > > this... > > Yes, it's a valid value in MySQL, bu

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
Hello Bruno, > well about the date default value being invalid, well it´s working here in > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with > this... Yes, it's a valid value in MySQL, but it's an invalid date, that's what I'm trying to say. Why have an invalid date as the

Re: Accountability with MySQL

2006-03-14 Thread SGreen
Bruno B B Magalháes <[EMAIL PROTECTED]> wrote on 03/14/2006 12:41:35 PM: > I am designing a simple accountability system so all the partners can have > direct access to it by intranet. > > I was designing the data model, and came up with this: > > CREATE TABLE `moviments` ( > `moviment_id` i

Re: Accountability with MySQL

2006-03-14 Thread Bruno B B Magalháes
Hi Martijn, well about the date default value being invalid, well it´s working here in my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with this... About the business logic I was thinking about showing the current month by default, and if the user wants he can select diferent d

Re: Accountability with MySQL

2006-03-14 Thread Martijn Tonies
Hello Bruno, > I am designing a simple accountability system so all the partners can have > direct access to it by intranet. > > I was designing the data model, and came up with this: > > CREATE TABLE `moviments` ( > `moviment_id` int(20) NOT NULL auto_increment, > `moviment_date` date NOT NUL

Re: timestamp

2006-03-14 Thread sheeri kritzer
Further, your reporting will skew the data -- let's say once a day you want to know the last time that row was read. Well, the first day, you'll get accurate numbers. The second day, though, you'll end up seeing that each row was read at latest the day before, because you read it searching for th

Accountability with MySQL

2006-03-14 Thread Bruno B B Magalháes
I am designing a simple accountability system so all the partners can have direct access to it by intranet. I was designing the data model, and came up with this: CREATE TABLE `moviments` ( `moviment_id` int(20) NOT NULL auto_increment, `moviment_date` date NOT NULL default '-00-00', `m

Re: missing mysqld.sock

2006-03-14 Thread Косов Евгений
Hi, Jon. mysqld.sock is a unix socket. mysqld creates it while starting and removes it when you stop the server. Jon Miller wrote: Is there a way to recreate the mysqld.sock file, it has gone missing from :/var/run/mysqld . Now MySQL will not run. Thanks Jon L. Miller, ASE, CNS, CLS, MCN

Re: E/R Tool

2006-03-14 Thread mysql
So did I Jim, on SuSE 9.2 pro. So I downloaded the windows versions to my laptop instead. Keith In theory, theory and practice are the same; In practice they are not. On Tue, 14 Mar 2006, Jim Douglas wrote: > To: [EMAIL PROTECTED] > From: Jim Douglas <[EMAIL PROTECTED]> > Subject: Re: E/R To

Re: Permissions block database creation

2006-03-14 Thread Косов Евгений
User ''@'localhost' just hasn't enough privileges to create databases. http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html Doug Pinkerton wrote: I'm a total newbie working through the tutorial in DuBois's _MySQL_. I've got MySQL running on my PowerBook. In Terminal, I can use the mysq

RE: Permissions block database creation

2006-03-14 Thread Marciano [Intercol]
You need to set GRANTs to create on the host. http://dev.mysql.com/doc/refman/5.0/en/grant.html -Original Message- From: Doug Pinkerton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 14, 2006 1:26 PM To: mysql@lists.mysql.com Subject: Permissions block database creation I'm a total new

Permissions block database creation

2006-03-14 Thread Doug Pinkerton
I'm a total newbie working through the tutorial in DuBois's _MySQL_. I've got MySQL running on my PowerBook. In Terminal, I can use the mysql client to get responses to things like SELECT NOW(). But the command CREATE DATABASE sampdb; results in the following error. ERROR 1044 (42000): Acce

Re: Complex Query

2006-03-14 Thread Peter Brawley
ElkinFernando Ortiz wrote: How i calculate for union the other 14 register in the same Query? ... SELECT e.Plant,e.Date,e.Hour,e.Consuption From Energy Where e.Plant=Var_Plant AND e.Date=Var_Date GROUP BY e.Plant,e.Date,e.H By having an hours table (hour tinyint) which you join to your energy

migrating 4.0 to 4.1 character set problems

2006-03-14 Thread Sean O'Hara
Hi, I am having character set problems while trying to migrate my data from a server running 4.0.25-standard to a server running 4.1.16. I believe that the orginal database was using the latin1 character set (not sure, is there any way to tell? show full column doesn't seem to be supporte

Re: missing mysqld.sock

2006-03-14 Thread Kishore Jalleda
did u try restarting mysqld Kishore Jalleda On 3/14/06, Jon Miller <[EMAIL PROTECTED]> wrote: > > Is there a way to recreate the mysqld.sock file, it has gone missing from > :/var/run/mysqld . Now MySQL will not run. > > > Thanks > > Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA > Director/S

Re: Complex Query

2006-03-14 Thread SGreen
"ElkinFernando Ortiz" <[EMAIL PROTECTED]> wrote on 03/10/2006 12:26:57 AM: > I will explain my problem in spanish and english. > > Se deben Presentar los consumos por 24 horas de energia para su ingreso. Si > el usuario ha digitado 10 registros, se deben presentar estos mas los otros > 14 corr

Re: mysql on Windows

2006-03-14 Thread Mark Leith
Hi Neil, Neil Tompkins wrote: Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? There is a known bug for Windows 2003 - bug #12071: http://bugs.mysql.com/bug.php?id=12071 You should use 4.0.19 or 5.0.19. Best regards Mark -- Mark Leith, Support Engi

missing mysqld.sock

2006-03-14 Thread Jon Miller
Is there a way to recreate the mysqld.sock file, it has gone missing from :/var/run/mysqld . Now MySQL will not run. Thanks Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au Resellers for: Novell Gold Partner, Cisco Part

RE: mysql on Windows

2006-03-14 Thread jblanchard
[snip] Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? {/snip] The operating system? Yuck yuck! :) It ran fine for me on 2k3 before I cam back to a *nix shop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysql on Windows

2006-03-14 Thread Neil Tompkins
Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? Cheers Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Merge tables.

2006-03-14 Thread Alec . Cawley
nigel wood <[EMAIL PROTECTED]> wrote on 14/03/2006 13:09:08: > [EMAIL PROTECTED] wrote: > > >"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10: > > > > > > > > > >>As an example: > >> > >>There was a table called event. > >> > >>This table is now broken up like this: > >> > >>even

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Tom Brown
Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. thanks both - that did t

Re: Merge tables.

2006-03-14 Thread nigel wood
[EMAIL PROTECTED] wrote: "Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10: As an example: There was a table called event. This table is now broken up like this: event __. So for every sensor, and every day, there is now a new table. So if I have 20 sensors, every day I

Re: Merge tables.

2006-03-14 Thread Alec . Cawley
"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10: > As an example: > > There was a table called event. > > This table is now broken up like this: > > event __. > > So for every sensor, and every day, there is now a new table. So if I > have 20 sensors, every day I will have 20

Re: Merge tables.

2006-03-14 Thread Martijn Tonies
> > > The developer insists that for scalability issues, this was the > > > answer. It is likely, for example in my deployment, that these tables > > > would see upwards of 10 million records or more. > > > > Well, if there are problems with scalability, I guess you could > > split it up in a few

Re: Merge tables.

2006-03-14 Thread Paul Halliday
On 3/14/06, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hello Paul, > > I suggest you reply to the mailinglist :-) ... > > > The developer insists that for scalability issues, this was the > > answer. It is likely, for example in my deployment, that these tables > > would see upwards of 10 million

Re: Merge tables.

2006-03-14 Thread Alec . Cawley
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 14/03/2006 11:32:10: > Hello Paul, > > I suggest you reply to the mailinglist :-) ... > > > The developer insists that for scalability issues, this was the > > answer. It is likely, for example in my deployment, that these tables > > would see upward

RE: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Logan, David (SST - Adelaide)
Hi Tom, Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. >From the manual at

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Prasanna Raj
Hi Tom, Use -q option on mysqldump ;) -q Won't buffer query, It will dump directly to stdout. --Praj On Tue, 14 Mar 2006 11:56:42 + Tom Brown <[EMAIL PROTECTED]> wrote: > Hi > > Trying to dump a complete db where 1 of the tables contains about 88 > million rows - When the dump runs o

MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Tom Brown
Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from ser

Re: update using 'set' keyword

2006-03-14 Thread Prasanna Raj
Hi Iam not sure about the answer correct me if iam wrong :( Dont use single quotes in count_of_logons .. Try : $sql = "UPDATE members SET count_of_logons = count_of_logons + 1 WHERE logon_id = '$logonid' AND logon_pw= '$logonpw' AND email_verifi

Re: Merge tables.

2006-03-14 Thread Martijn Tonies
Hello Paul, I suggest you reply to the mailinglist :-) ... > The developer insists that for scalability issues, this was the > answer. It is likely, for example in my deployment, that these tables > would see upwards of 10 million records or more. Well, if there are problems with scalability, I

Re: Merge tables.

2006-03-14 Thread Prasanna Raj
I guess u had 2.5 million records splited into 1600 tables if iam not wrong :) Why you split the tables to 1600 is there any specific count ? Why you moved to merge table reason behind ? Since 2.5 million records to 1600 is a huge count on nos of tables :( instead of one ;) --Praj On Tue

Re: Merge tables.

2006-03-14 Thread Martijn Tonies
Paul, > One of the databases I use just switched to using merge tables and now > my queries are painfully slow. One table, initially had about 2.5 > million records and now with the change this information is spread > across about 1600 tables. A simple query, say select count(*) has gone > from .0

Merge tables.

2006-03-14 Thread Paul Halliday
Hi, One of the databases I use just switched to using merge tables and now my queries are painfully slow. One table, initially had about 2.5 million records and now with the change this information is spread across about 1600 tables. A simple query, say select count(*) has gone from .04 to about 3

Complex Query

2006-03-14 Thread ElkinFernando Ortiz
I will explain my problem in spanish and english. Se deben Presentar los consumos por 24 horas de energia para su ingreso. Si el usuario ha digitado 10 registros, se deben presentar estos mas los otros 14 correspondientes desde la hora 11 hasta la 24 con los consumos en cero. Siempre un conjunto d

Re: Rollback is not take effect on MySQL 5.0.18

2006-03-14 Thread Truong Tan Son
Dear Sir, The status of mysql: mysql>show status; +---+--+ | Variable_name | Value| +---+--+ | Aborted_clients | 0| | Aborted_connects | 0| |