D_C a =E9crit:
> hiya -
> Trying to use the excellent myPhpAdmin to export/backup data. But date
> fields are not enclosed in quotes. This gives an error when we try to
> re-import - the colons throw the import script for a loop.
> INSERT INTO `grammar` VALUES (5369, 'amari', 'because of
> too much', '', '', NULL, 1, 'dc', 2, 2005-01-03 21:31:19);
> The date field also changed to "varChar" doesnt seem to help.
> Appreciate ideas on any suggested workarounds...
I just tried the current phpMyAdmin version, and a datetime field is
enclosed with quotes when exported.