Is it possible to dump an SQLite table in a format something like this?

INSERT INTO employee (last_name, first_name, mi, username, id, extension, home_phone, cell_phone, status, email_primary, email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14', '555-1212', '525-2123', 'a', '[EMAIL PROTECTED]', NULL);

I have a need to move data between DBMS's where the field order may not be known.

Thanks,
Steve Bergman



Reply via email to