Re: REPAIR TABLE

2002-09-20 Thread Pekka Saarinen
| +--++--++ 1 row in set (0.00 sec) REPAIR TABLE supports MyISAM only: http://www.mysql.com/doc/en/REPAIR_TABLE.html - Pekka Saarinen http://photography-on-the.net - - Before posting

Re: Cannot create Full-Text INDEX

2002-09-10 Thread Pekka Saarinen
running (you need to have a couple of rows of data there first). - Pekka Saarinen http://photography-on-the.net - - Before posting, please check: http://www.mysql.com

GMT?

2002-08-26 Thread Pekka Saarinen
Hi, Is there a way convert result of SELECT NOW() or SELECT SYSDATE() or SELECT CURRENT_TIMESTAMP to GMT, in a query? Thanks, Pekka - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Table locking questions

2002-08-15 Thread Pekka Saarinen
. - Pekka Saarinen http://photography-on-the.net - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Supplied argument is not a valid MySQL result resource!!

2002-08-15 Thread Pekka Saarinen
= '$edit_id' ); if (!$qid ) { print mysql_error(); } if ($qid ) { $frm = mysql_fetch_array($qid); } - Pekka Saarinen http://photography-on-the.net - - Before posting, please check

Re: MySQL database design

2002-08-11 Thread Pekka Saarinen
At 8/11/2002, you wrote: MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map? Or you can advise me of how to arrange my keys, or

Re: MySQL database design

2002-08-11 Thread Pekka Saarinen
the real data in your database. Pekka - Pekka Saarinen http://photography-on-the.net - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

strange backquote problem

2002-07-25 Thread Pekka Saarinen
with standard backquotes and how to fix this??? I'd really like to know what is going on there. http://www.mysql.com/doc/L/e/Legal_names.html tells backquotes really must be there. Thanks, Pekka Saarinen http://photography-on-the.net