MySQL multi table deletions.
Brought to you by:
ultralight32
I've been developing a front end in C# using MyOLEDB,
but I kept running into annoying problems, for example
last_insert_id() would never work for whatever reason.
So I decided to give MySQLDriverCS a try. Everythings
going great and everything seems to be working with
minimal alterations (ExectureScalarQuery() isnt
implemented?) except I can't seem to get multi table
deletions to work, heres a sample:
string sSQL = "delete from table1, table2, using table1
as t1, table2 as t2 where t1.id = t2.id and t1.id = 1";
MySQLCommand Command = new MySQLCommand
(sSQL, Connection);
Command.ExecuteNonQuery();
ExecuteNonQuery returns 0 and no tables have been
removed when they should be...
Logged In: YES
user_id=406263
Well that kind of things are sent directly to the MySQL native
client, if it doesn't make the job then MySQL native driver
cannot do this job. Try simpler queries.