RE: Foriegn Key

Hi Arul, Thanks, I m using MySQl 3.23. Will u please tell me how it is possible. Regards D K Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Foriegn Key

Hi All, Can anybody tell mysql supports foreign constraints. If i use Referential Integrity cascade then, will MySql delete the same record in another table? Thanks in advance. Regards Daya Krishan Dubey - Before posting, plea

RE: problem

U did not clarify that either u r accessing MYSQl through java beans or u have specified the driver in that JRun itself..U require to start mysql as service on ur machine for that u need to click winmysqladmin.exe at mysql\bin dir .. hope it should work.. D K Dubey -Original Message- From

RE: get months between two dates

Hi Frank, Thanks, but it is fine if the year is same. If years are different then result may comes in -ve value. D K Dubey -Original Message- From: Frank Gates [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 5:09 PM To: D.K.Dubey Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject

RE: get months between two dates

Hi Van, I read that before sending u the query. In that no where is mention to subtract the dates and finding the no months between dates. D K Dubey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Monday, June 24, 2002 11:43 AM To: D.K.Dubey

get months between two dates

Hi, Can anybody tell me how i can calculate the months between two dates in mysql. thanks in advance Regards D K Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: database restore - please help

You wrote:: deleted my database today by mistake and I have a backup from yesterday made as follows: mysqldump -A >> backup.txt How can I restore this database? Thanks for your help in advance. Scott Do get the backup write the command mysql databasename < backup.txt Regards Daya Krishan

Re: Loading BLOB into a MySQL-DB

Hi Chris, See the code how load BLOB into a MySQl String saveSql = "INSERT INTO Table (DataCol) VALUES (?)" try { bos = new ByteArrayOutputStream(); oos = new ObjectOutputStream(new BufferedOutputStream(bos)); fileObj.writeObjectData(oos); oos.