Re: [PHP-DB] Inserting data into MySQL

2003-03-15 Thread John Gray
yes, or you need to use the 'INSERT INTO ([field1, field2...]) values (['val1', 'val2'...]) syntax. check the mysql insert syntax. http://www.mysql.com/doc/en/INSERT.html - john On Sat, Mar 15, 2003 at 06:37:54PM -0500, Louie Henry [EMAIL PROTECTED] wrote: Good Day All! I have been working a

Re: [PHP-DB] Syncing the structure of two databases?

2003-03-13 Thread John Gray
it's not PHP, but mysqldiff is a perl tool that would probably give you the desired results. it can generate the SQL necessary to sync databases. http://adamspiers.org/computing/mysqldiff/ (sorry if anyone got this in duplicate, i was having probs sending to the list until i fixed the