i need to move the data from one column in table_1 to another column in table_2

can someone please write me some syntax ?

I am playing around with Joomla but i have no idea what i am doing. Any tips for me especially when it comes to the database that i need.

Why do i need a mysql database?

How do I do a mysqldump that only exports the structure of a database and not the actual data?

I have been learning mySQL for a while now- but have come to a confusing point and need help. I purchased a server and supports mysql and php + has been enabled in the settings. The server is a NAS TS-209.

I have made a simple webpage which uses php to simply load a database and display a record. The php really have no meaning other than learning experience and comftable in this area.

I have mySQL installed on my desktop and I have created a database + table and few records- but how do I get it on my server? This is what doesn t make sense to me and cannot find information on it. Some sites just say the usual jargon but doesn t actually mention how to put it on the server.

how do I log in to the server with mysql? do I have to install mysql on the server- and create a database this way?

any general answers is a plus.

Hi i want to make a wow server just for me i dont want to host it online not at this time any way and iv tryed everything i can think of on the guides videos all that and thares a conection they all us mysql and what ever repack file they want so i tryed this and this is what i get win i try and start mysql error do you have a nother server operating on port 3306.error shutingdown shutdown complet press any thing to continue and it exits. then im told i need 2 start logon server and it says acces dinide for user root and then password is hiden so then im told i need 2 start ascent and it says main data instalation faild exiting so last i need 2 start apache and it says no liseing sockets availibale can not open login files shuting down. so if any 1 knows what is going n here plz tell me because this is driveing me crazy thx.
ok well i did not make this clear but if any one out thare knows what is going on with my program and can tell me what to do from here to get my server up and running plz tell me.

how can i make these two commands so that i can copy and paste them into sql for my different tables.

UPDATE cefil3ed
SET ENTDATE= CONCAT(MID(ENTDATE-7-4)- - -MID(ENTDATE-1-2)- - -MID(ENTDATE-4-2))

UPDATE cefil3ed
SET `UPDATE`= CONCAT(MID(`UPDATE`-7-4)- - -MID(`UPDATE`-1-2)- - -MID(`UPDATE`-4-2))

i tried using union in between them but it did not work. any suggestions ?

-on mysql
UPDATE cefil3ed
SET ENTDATE= CONCAT(MID(ENTDATE-7-4)- - -
MID(ENTDATE-1-2)- - -MID(ENTDATE-4-2))

UPDATE cefil3ed
SET `UPDATE`= CONCAT(MID(`UPDATE`-7-4)- - -
MID(`UPDATE`-1-2)- - -MID(`UPDATE`-4-2))
its just these two- the bottom one is missing parentheses thats all.
thanks.