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