Mokhoa oa ho pheta sebopeho sa tafole ho database ea MySQL?Kopitsa polelo ea litaba tsa tafole

MySQL databaseMokhoa oa ho kopitsa sebopeho sa tafole ka har'a?Kopitsa polelo ea litaba tsa tafole

MySQLKopitsa tafole

Haeba re hloka ho kopitsa tafole ea data ea MySQL ka botlalo, ho kenyelletsa sebopeho sa tafole, li-index, litekanyetso tsa kamehla, joalo-joalo.Haeba u sebelisa feelaBOPA TAFOLE … KHETHATaelo e ke ke ea phethahala.

Khaolo ena e tla hlahisa mokhoa oa ho kopitsa tafole ea data ea MySQL ka botlalo. Mehato ke e latelang:

• sebedisaPONTŠO BOPA TAFOLELaela ho etsa tafole ea data (QALANG LETLAPA) polelo, e nang le sebopeho, index, joalo-joalo ea tafole ea data ea mantlha.
• Kopitsa polelo ea SQL e bontšitsoeng ka taelo e latelang, fetola lebitso la tafole ea data, 'me u phethise polelo ea SQL.
• Haeba u batla ho kopitsa litaba tsa tafole, u ka li sebelisaKENYA HO ... KHETHA polelo ho fihlela.

Mohlala

Leka mohlala o latelang ho kopitsa tafole chenweiliang_tbl.

mohato oa pele:

Fumana sebopeho se felletseng sa tafole ea data.

mysql > SHOW CREATE TABLE chenweiliang_tbl \ G ; *************************** 1. row ******************** ******* Table ：chenweiliang_tbl
 Create Table ：CREATE TABLE`chenweiliang_tbl` （`chenweiliang_id` int （11 ）NOT NULL auto_increment ，`chenweiliang_title` varchar （100 ）NOT NULL default '' ，'chenweiliang_author` varchar （40 ）NOT NULL 默认'' ，
 
         
   
   
   
  `submission_date` 日期默认NULL ，
  PRIMARY KEY   （`chenweiliang_id` ），
  UNIQUE KEY `AUTHOR_INDEX` （`chenweiliang_author` ））ENGINE = InnoDB的1 行中集合（0.00 秒） 
 
  

错误：没有指定查询

Mohato oa bobeli:

Fetola lebitso la tafole ea data ea polelo ea SQL 'me u phethe polelo ea SQL.

mysql > CREATE TABLE`clone_tbl` （- > `chenweiliang_id` int （11 ）NOT NULL auto_increment ，- > `chenweiliang_title` varchar （100 ）NOT NULL default '' ，- > `chenweiliang_author` varchar （40 ）NOT NULL default '' ，- > `submission_date` 日期默认为NULL ，- > PRIMARY KEY   （`chenweiliang_id` ），- > UNIQUE KEY 
    
    
    
   
  
  `AUTHOR_INDEX` （`chenweiliang_author` ）- > ）ENGINE = InnoDB ; 查询OK ，0 行受影响（1.80 秒） 
 
 

Mohato oa boraro:

Kamora ho etsa mohato oa bobeli, o tla theha tafole e ncha ea clone_tbl sebakeng sa polokelo.Haeba u batla ho kopitsa data ho tsoa tafoleng ea data eo u ka e sebelisangKENYA HO ... KHETHA polelo ho fihlela.

mysql > INSERT INTO clone_tbl （chenweiliang_id ，- >                         chenweiliang_title ，- >                         chenweiliang_author ，- >                         submission_date ）- > SELECT chenweiliang_id ，chenweiliang_title ，- >         chenweiliang_author ，submission_date
     - > FROM chenweiliang_tbl ; 查询OK ，3 行受影响（0.07 秒）记录：3 重复：0
    
    
    
    
    
 
      警告：0 

Ka mor'a ho etsa mehato e ka holimo, u tla kopitsa tafole ka ho feletseng, ho kenyelletsa sebopeho sa tafole le data ea tafole.

Mokhoa o mong oa ho kopitsa tafole

Mokhoa o mong oa ho etsa kopi e felletseng ea tafole:

CREATE TABLE targetTable LIKE sourceTable ; 
INSERT INTO targetTable SELECT * FROM sourceTable ;

tse ling:

U ka kopitsa tse ling tsa likarolo tafoleng:

CREATE TABLE newadmin AS
 （
    SELECT用户名，密码从管理员
 ）

O ka reha mabitso a libaka tsa tafole e sa tsoa etsoa:

CREATE TABLE newadmin AS
 （  
    SELECT id ，username AS uname ，password AS pass FROM admin
 ）

U ka kopitsa karolo ea data:

CREATE TABLE newadmin AS
 （
    SELECT * FROM admin WHERE LEFT （username ，1 ）= 's' ）  

U ka hlalosa lintlha tsa sebaka tafoleng ha u ntse u theha tafole:

CREATE TABLE newadmin
 （
    id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
）
如
（
    SELECT * FROM admin
 ）