RE: How to search by groups efficiently with MySql 4.0.15?

2003-10-11 Thread Pak Gza
- Original Message - From: Pak Gza [EMAIL PROTECTED] To: Jouni Hartikainen [EMAIL PROTECTED] Sent: Saturday, October 11, 2003 7:03 PM Subject: Re: How to search by groups efficiently with MySql 4.0.15? how about: select record.* from link where group_id='x' left join record

Error: unable to execute query

2003-10-09 Thread Pak Gza
hello, Im writing a db software using delphi7 mysql(3.23.41) (with standard dbexpress and data access components) The problem is: sometimes i get the error message unable to execute query, and the connection breaks. i only saw this occur on UPDATEs or INSERTs, but every time a different line

Default date format

2001-07-18 Thread pak
Is there a default format for Date ? /mm/dd or mm/dd/ or dd/mm/ ? I am not sure which format I should use in SQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Referential Integrity

2001-07-10 Thread pak
MySQL does not support RI, anyone has good suggestion that do this in the program ? As this would be a nightmare if I have 50 detail tables to update programmatically. - Before posting, please check:

MySQL manual

2001-01-23 Thread Pak Tse
I cannot download the PDF format of the manual from the website. Any help ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request