I want to add a column to a number of tables:
my tables are in the format of No_tmp e.g 1_tmp .. 9999_tmp
No = a number 1 - 1000 ... I want to be able to add a column to all No_tmp tables every single table
Then I want to insert a text value eg "abcdef" in some tables
is it posible, I don't wish to do it manually on each table
tables 1 - 223 I want to insert "guppy" into the "group" field
tables 224 - 399 I want to insert "barb" into the "group" field
tables 400 - 475 I want to insert "goldfish" into the "group" field
I figured out what I needed was the ALTER command ..
I probably did not word my question very well.
Both answers provided are good.
What I have is a large number of csv files with different sized tables, different column sizes, different numbers of columns etc, so I'm making new tables for each group of items, and logging the details of each new table in a master, from that I can analyse the structure and find common fields.
My choice of using numbers as part of the table name just makes it more readable than choosing random characters, and is easily accomplished and automated. Once I have the data I'll then start to look at normalising / formatting it.
Thank you for the answers.