Import on phpMyAdmin

--------------020707050008090509000709
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

04142005 1704 GMT-6

Ok. I just said I couldnt find the code on control center but I did find
it. Now I want to get the code into the hosted db.

I receive this error:


You have an error in your SQL syntax near 'defaultCURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,`first_name` varchar( 30' at line 3

Ok. This code is right from mycontrolcenter and it worked on
my machine but I have to assume that something is different on
theirs. How do I fix this?

Wade


--------------020707050008090509000709--

Re: Import on phpMyAdmin

Wade,

You need a space between 'default' abnd 'CURRENT_TIMESTAMP'

You should probably include your entire query along with the error message.

Randy Clamons
Systems Programming
Novaspace.com


> ------------Original Message------------
> From: Wade
> To: php_mysql@yahoogroups.com, php-list@yahoogroups.com, win32@lists.mysq=
l.com
> Date: Thu, Apr-14-2005 3:06 PM
> Subject: Import on phpMyAdmin
>
> 04142005 1704 GMT-6
> =

> Ok. I just said I couldnt find the code on control center but I did =

> find =

> it. Now I want to get the code into the hosted db.
> =

> I receive this error:
> =

> =

> You have an error in your SQL syntax near 'defaultCURRENT_TIMESTAMP ON =

> =

> UPDATE CURRENT_TIMESTAMP,`first_name` varchar( 30' at line 3
> =

> Ok. This code is right from mycontrolcenter and it worked on
> my machine but I have to assume that something is different on
> theirs. How do I fix this? =

> =

> Wade
> =

> =



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org