It sounds like you want to easily create a new MySQL table that is a copy of a table in a different DBMS.
The way I would do it is generate a DDL script from the other DBMS (create table etc.) For example, SQL Server has a "generate script" wizard that does it for you automatically. Then take the DDL and modify it to meet your MySQL needs. Then you can run the script in MySQL Query Browser (make sure you're pointed at the right database, or put a USE command at the beginning of your script). Presto, you have the table you want. -----Original Message----- From: revDAVE [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 8:25 AM To: mysql@lists.mysql.com Subject: Importing - Adding Fields Into MySql From A List Newbie question! I have a list of field names from another database (not mysql) - like: name phone1 phone2 street city state zip info etc.... (a bunch more fields) Q: Is there a way I can add these to an existing empty/blank table? Maybe I can use: - phpMyAdmin ? - sql commands with php - loop thru a list of these names? - import field names from CSV? - some other method? I tried a test with php and got NO errors - but no result either ( looked with phpMyAdmin after - the table didn't add or drop the fields... Nothing changed) <?php $sql = 'ALTER TABLE `ztest` ADD `myfield2` VARCHAR(10) NOT NULL;'; $sql = 'ALTER TABLE `ztest` DROP `myfield1`;'; ?> I have phpMyAdmin and If there's a way add tables w / php - maybe that would work also.... If I can just get all the field names in the table as text fields - that would be ok for now - then I can individually change the field type by hand w phpMyAdmin... -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
