question about lock tables and unlock table

2003-09-05 Thread Steven Wu
Hi Need some help here: if I have two tables, alertLog, videoLog needed to lock during some processing as: mysql> LOCK TABLE alertLog READ, videoLog READ after two tables are lock and do some INSERT, mysql> INSERT INTO alertLog(alert); mysql> INSERT INTO videoLog(video)

Is there trigger function in MySQL ?

2003-08-14 Thread Steven Wu
in ORACLE databse ? Steven Wu

Re: store video file into MySQL database server

2003-07-22 Thread Steven Wu
Hi Jeremy D. Zawodny: I did not get any error message. It hust said "zero column change" and the filed, VIDEO contains NULL data after I give "SELECT * from GAME" command. Steven Wu - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To

store video file into MySQL database server

2003-07-22 Thread Steven Wu
ME GAME_ID, GAME_NAME, VIDEO VALUES(2, 'Termonator2', LOAD_FILE("/tmp/tm.mpg"); My email is [EMAIL PROTECTED] Steven Wu