Row Count Discrepency

2005-12-31 Thread JJ
I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest why MySQL Adminstrator says the table has 497 rows, while doing a query or a count on the same table shows that it only has 434? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Table design suggestions?

2003-06-11 Thread JJ
I have to add group functionality to an existing database. The functionality required will be something like /etc/group in linux. I have a need to create and maintain a list of groups. Then, each group will have a list of members. I will need to be able to search by member name and get a list of wh

Re: UPDATE syntax help

2003-03-12 Thread JJ
That explains it then D'OH Is there a workaround? Thanks :-) - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 9:02 AM Subject: Re: UPDATE syntax help > At 8:33 +1000 3/13/03, MySQL

Re: UPDATE syntax help

2003-03-12 Thread JJ
Thanks... Currently I am doing exactly that. One data set open creating another. I was trying to speed the process up, although I am only dealing with 20,000 records so shouldn't complain. Thanks all for the suggestions... I look forward to 4.x JJ - Original Message - From: