I'm not quite sure why I haven't run across this in the past, but now that I
have I am stumped. I am needing to update a table based on criteria found in
it and one other table, but I am uncertain how to proceed. If I had
subselects I would run the query as follows, I believe:
UPDATE suppliercatl
> Could anybody:
> 1) Recomend a good book which covers the basics of MySQL, &/or any good
> tutorials on the web?
The mysql documentation is very good, I use
http://www.mysql.com/doc/en/index.html as my home page, but you really have
to know what to look for in order to find it. It's been so lon
Hey all,
I've been given the task of adding a few hundred, and later a few thousand,
new records to my database that currently exist in (ugh...) an excel
spreadsheet. I was able to very quickly and efficiently deal with the
initial insertion of the main data to the main table, but am having
diffi
