Pehea e hoʻopili ai i ka ʻōnaehana papa ma ka waihona MySQL?E kope i ka ʻōlelo maʻiʻo ʻikepili papa

MySQL waihonaPehea e kope ai i ka ʻōnaehana papa ma ?E kope i ka ʻōlelo maʻiʻo ʻikepili papa

MySQLpapaʻaina kope

Inā pono mākou e hoʻopili hou i ka papa ʻikepili MySQL, me ke ʻano o ka papaʻaina, nā kuhikuhi, nā waiwai paʻamau, etc.Inā hoʻohana waleHULU PAPA ... KOHOhiki ole ke kauoha.

E hōʻike ana kēia mokuna iā ʻoe pehea e kope piha ai i nā papa ʻikepili MySQL. Penei nā ʻanuʻu:

• 使用HOIKE HANA PAPAkauoha e hana i ka papa ʻikepili (OLELO HOOLAHA) ka ʻōlelo, aia i loko o ke ʻano, index, etc. o ka papa ʻikepili kumu.
• E kope i ka ʻōlelo SQL i hōʻike ʻia e kēia kauoha, e hoʻololi i ka inoa papa ʻikepili, a e hoʻokō i ka ʻōlelo SQL.
• Inā makemake ʻoe e kope i ka ʻike o ka papaʻaina, hiki iā ʻoe ke hoʻohanaE hookomo i loko o… KOHO ʻōlelo e hoʻokō ai.

laʻana

E ho'āʻo i kēia laʻana e hana hou i ka papa chenweiliang_tbl.

ʻanuʻu ʻekahi:

E kiʻi i ke ʻano piha o ka papa ʻikepili.

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 秒） 
 
  

错误：没有指定查询

ʻAnuʻu ʻelua:

Hoʻololi i ka inoa papa ʻikepili o ka ʻōlelo SQL a hoʻokō i ka ʻōlelo 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 秒） 
 
 

Kaʻanuʻu ʻekolu:

Ma hope o ka hana ʻana i ka hana ʻelua, e hana ʻoe i kahi papa clone clone_tbl hou i ka waihona.Inā makemake ʻoe e kope i ka ʻikepili mai ka papa ʻikepili hiki iā ʻoe ke hoʻohanaE hookomo i loko o… KOHO ʻōlelo e hoʻokō ai.

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 

Ma hope o ka hana ʻana i nā ʻanuʻu i luna, e loaʻa iā ʻoe kahi kope piha o ka papaʻaina, me ka hoʻonohonoho papaʻaina a me ka ʻikepili papa.

ʻO kekahi ala e kope ai i kahi pākaukau

ʻO kekahi ala e hana ai i kope piha o ka papaʻaina:

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

nā:

Hiki iā ʻoe ke kope i kekahi o kēia mau kahua ma ka pākaukau:

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

Hiki iā ʻoe ke inoa hou i nā kahua o ka papaʻaina hou i hana ʻia:

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

Hiki ke kope ʻia kekahi hapa o ka ʻikepili:

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

Hiki ke wehewehe ʻia ka ʻike kahua ma ka pākaukau i ka wā e hana ana i ka pākaukau:

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