perror

2001-04-01 Thread P.V. Sajan
Hello All !! C:\mysql\binperror 1064 Illegal error code: 1064 This is impossible but its true as i've simply pasted the screenshot. I guess 1064 error stands for syntax.error The version i'm using is 3.22.32 shareware.on win98 Could anyone please explain this weird thing coz . 1064 is a

Re: Show grants ??? Doubt

2001-04-01 Thread P.V. Sajan
Whoof What a relief But one more doubt is "mysqlaccess" not shipped with on win32 platforms.The version i'm using is 3.22.32 shareware. I don't seem to find it Cheers Sajan - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: P.V. Sajan [EMAIL PRO

Last_Insert_ID ()

2001-03-31 Thread P.V. Sajan
Helllo All !! I 've a problem i want to retrieve the primary key value of the last Inserted record in a table and use it in another table. My Table is TRANS ( transID int not null auto_increment primary key, . ... .. ) Ordertable (OrderID int not null auto_increment primary key, transID int

Show grants ??? Doubt

2001-03-31 Thread P.V. Sajan
Hello all !! mysql show grants for root@localhost; ERROR 1064: You have an error in your SQL syntax near 'grants for root@localhost ' at line 1 Could anyone please tell me where i'm going wrong .. Thank you Sajan - Before

Doubt!!

2001-03-31 Thread P.V. Sajan
Hello all !! Is there any method by whick we can use the Sys Admin commands like Mysqlacess , Mysqldump , mysqladmin etc in Java. I mean thro ' " PreparedStatement/ Statment " classes Thank you Best Regards Sajan -

Locks

2001-03-30 Thread P.V. Sajan
THe manual says To avoid using ROLLBACK, you can use the following strategy: Use LOCK TABLES ... to lock all the tables you want to access. Test conditions. Update if everything is okay. Use UNLOCK TABLES to release your locks. I didn't quite understasnd the meaning of Test Conditions

Locks !!! Help !!!

2001-03-28 Thread P.V. Sajan
Hello All !!! I've 2 tables in a Shopping Cart Servlet TransactionTable is having a one to many relation with OrderTable create table TransactionTable ( TransId Integer Not Null Auto_Increment Primary Key, OrderDate TimeStamp, Not Null , GrandTotal Double Not Null , FullName VarChar(40) Not