acronym?

[asmith]

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 ?

 

[Barand]

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