All,

Normallu just lurking, but as a newbie with MYSQL looking for a direction for this issue:

I have a table with a filed called year, integre, 5 positions. I have another field in the same table called yearanddate, which has a date format.

Values from yearanddate look like this: 2013-12-11 00:00:00. I want to copy the 2013 and put that into the yearfield, for each record.

Can that be done by just using SQL statements?

Alternatively can this be done by means of PHPMYADMIN?

Thanks for pointing me,

Best regards, Hans.

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

Reply via email to