Re: Update statement giving errors

[Roland Bouman]

Hi,

[this has got nothing to do with transactions, post in the connector/.NET forum for this type of question]

Is this a valid dataformat in MySQL? I think you should just use:

Update myTable set DOB = '1979-02-23', Name = 'vvv', Age = 14 where UserId = 2

or else use on of the date/time formatting functions (see: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html)



Edited 1 time(s). Last edit at 01/04/2006 07:56PM by Roland Bouman.