• Magyar nyelv
  • Gábor Kum

    Kum Gábor
    Specialist in use of Linux, free and open-source software at small and medium-sized enterprises, and in security of bank payment technologies. Also interested in today's privacy challenges, low-bitrate communications, and building a house as a hobby. Lives at the biggest lake of Central Europe, Lake Balaton.

  • Other projects

    HELLOTUX
    Promoting free software all over the world. Free software merchandise from Europe, in partnership with the leading Linux distributions and free software developers.
    www.hellotux.com
     

    Matek Oázis
    Hungary's number one maths e-learning site, with interactive videos, tests and games for children, students, adult learners, teachers and schools.
    www.matekoazis.hu

  • Magyar nyelv

KG.hu

MYSQL tábla és tartalmának másolása

6 February 2013, 3:20 pm (Central European Time)

Ha klónozni szeretnénk egy MYSQL táblát, a módszer a következő:


Új tábla létrehozása a meglévő alapján:
CREATE TABLE `új_tábla_neve` LIKE `régi_tábla_neve`;

Az adatok átmásolása a régi táblából az újba:
INSERT INTO `új_tábla_neve` SELECT * FROM `régi_tábla_neve`;

Kiváló megoldás komoly változtatások előtt a táblaszerkezet és az adatok ideiglenes mentésére.

 

Be the first who leaves a comment!

Leave a comment!

Your name:

Your e-mail (kept private and will not be shown):

Comment:

Please type the word candy here:

  • Gábor Kum

    Kum Gábor
    Specialist in use of Linux, free and open-source software at small and medium-sized enterprises, and in security of bank payment technologies. Also interested in today's privacy challenges, low-bitrate communications, and building a house as a hobby. Lives at the biggest lake of Central Europe, Lake Balaton.

  • Other projects

    HELLOTUX
    Promoting free software all over the world. Free software merchandise from Europe, in partnership with the leading Linux distributions and free software developers.
    www.hellotux.com
     

    Matek Oázis
    Hungary's number one maths e-learning site, with interactive videos, tests and games for children, students, adult learners, teachers and schools.
    www.matekoazis.hu