adi501
07-17-2008, 01:03 AM
Hello.
I have two tables in the MySql database. Initially i have generated these tables by converting .CSV files into MySql tables using the following statement.
LOAD DATA LOCAL INFILE '.csv' INTO TABLE TABLENAME FIELDS TERIMINATED BYC ',' LINES TERMINATED BY '/n' (FIELD1, FIELD2, FIELD3.....)
That above statement worked fine and i have generated the tables.
Now my question is i want to generate scripts for these tables so that i can upload it in to the production server.
How can i generate scripts for these tables.
Any help will be really appreciated.
Thanks in Advance.
I have two tables in the MySql database. Initially i have generated these tables by converting .CSV files into MySql tables using the following statement.
LOAD DATA LOCAL INFILE '.csv' INTO TABLE TABLENAME FIELDS TERIMINATED BYC ',' LINES TERMINATED BY '/n' (FIELD1, FIELD2, FIELD3.....)
That above statement worked fine and i have generated the tables.
Now my question is i want to generate scripts for these tables so that i can upload it in to the production server.
How can i generate scripts for these tables.
Any help will be really appreciated.
Thanks in Advance.