asmith Posted December 28, 2007 Share Posted December 28, 2007 do you know anywhere i can find mysql acronym statements , i have a lot of similar record that would record in same columns in different tables, or in same table indiffrent columns, i'm tried of typing each sentence for all ! for example i want update 2 tables , set "john" in the "name" field column. something like : update table1,table2 set name="john" where id="5" that gives me name column is ambiguous . what this sentence should be ? and where can i find all of these sentences like ? Quote Link to comment Share on other sites More sharing options...
Barand Posted December 28, 2007 Share Posted December 28, 2007 If you get "ambiguous column name" it means you have a name column in more than one table so you need to specify which table you mean eg ... set table1.name = 'john' ... As for "mysql acronym statements", never heard of those. Try Google or wikipedia Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.