Default date format

2001-07-17 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) http://lists.mys

Re: Referential Integrity

2001-07-10 Thread pak
So is MySQL not suitable for large corporate database ? - Original Message - From: "Ken Sommers" <[EMAIL PROTECTED]> To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 1:24 PM Subject: Re: Referential Integrity | hello

String and integer in SQL statement

2001-07-10 Thread pak
I create a table, one field is integer type. I don't know why the following statements work : select * from table1 where field1 = 3; select * from table1 where field1 = '3'; - Before posting, please check: http://www.mysql.c

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: http://www.mysql.com/manu

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 thi