Forcing import

2008-07-10 Thread Warren Windvogel

Hi,

Is there a way to force mysql to import a dump which contains a mysql 
reserved word as a field name?


Regards
Warren

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Forcing import

2008-07-10 Thread MarisRuskulis
Warren Windvogel wrote:
 Hi,

 Is there a way to force mysql to import a dump which contains a mysql
 reserved word as a field name?

 Regards
 Warren

You can use sed to replace column names with other.
for example:
sed 's/timestamp (timestamp) not null/datetime (timestamp) not null/g'
which replaces column name timestamp with datetime, and in the same way
replace column names in INSERT statements


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]