newbie questions - MySql max limits and columns
Posted: Tue May 13, 2003 6:39 am
Hello everyone,
I have some questions about MySql.
Is there any way insert new column between existing columns? What I mean is, I want to add new column(s) into table, say the table tb_ mydata has columns email, name, phone, address and now I want to add company_name into it, is there any way I can add a company_name between name and phone? I want to make look like this:
email, name, company_name, phone, address
I just want to organize...
The other question is, are there any problems if I make a big tables? I have this table already has about 20 columns, and I want to add 15 or so more columns to that table. Should I make a new table instead of add new columns to the existing one?
Thanks in advance!
I have some questions about MySql.
Is there any way insert new column between existing columns? What I mean is, I want to add new column(s) into table, say the table tb_ mydata has columns email, name, phone, address and now I want to add company_name into it, is there any way I can add a company_name between name and phone? I want to make look like this:
email, name, company_name, phone, address
I just want to organize...
The other question is, are there any problems if I make a big tables? I have this table already has about 20 columns, and I want to add 15 or so more columns to that table. Should I make a new table instead of add new columns to the existing one?
Thanks in advance!