[thelist] SQL: Can you spot the error?

Dan Craciun dcsquare at myrealbox.com
Tue Jul 15 02:06:23 CDT 2003


UPDATE news SET title = 'Krispy Kreme in Maple Grove Completed.f', date =
'2003/14/07', active = 1, article ='The new Krispy Kreme in xxxxx is now
open for business! xxxxx was awarded a sub-contract in the construction of
the popular doughnut franchise, and is currently in negations to help
construct a restaurant in xxxx.' WHERE news_id = 3

 MYSQL stores data in yyyy-mm-dd format (or in yy-mm-dd). When you update or
insert a date, the separator can be "/", "-", " " and some others I think,
but you must supply the date in one of those forms (year-month-day).

Cheers,

Dan CRACIUN



More information about the thelist mailing list