Nzira yekudzokorora chimiro chetafura muMySQL database?Kopa tafura yedata yemukati chirevo

MySQL databaseMaitiro ekukopa tafura chimiro mu?Kopa tafura yedata yemukati chirevo

MySQLKopa tafura

Kana isu tichida kudzokorora zvizere iyo MySQL data tafura, kusanganisira chimiro chetafura, indexes, default values, nezvimwe.Kana chete kushandisaGADZIRA TAFURA ... SARUDZAmurayiro haugoneki.

Ichi chitsauko chichakuzivisa iwe nzira yekukopa zvizere MySQL data matafura.Matanho ndeaya anotevera:

• 使用SHOW CREATE TABLEraira tora kugadzira datatable (Gadzira tafura) chirevo, icho chine chimiro, indekisi, nezvimwe zvepakutanga data tafura.
• Kopa chirevo cheSQL chinoratidzwa nemurairo unotevera, shandura zita retafura yedata, uye ita chirevo cheSQL. Murairo uri pamusoro unokopa zvachose chimiro chetafura yedata.
• Kana iwe uchida kukopa zviri patafura, unogona kushandisaPINDA MU ... SARUDZA chirevo chekuita.

muenzaniso

Edza unotevera muenzaniso kudzokorora tafura chenweiliang_tbl.

nhanho yekutanga:

Wana chimiro chakazara chetafura yedata.

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

错误：没有指定查询

Nhanho yechipiri:

Shandura zita retafura yedata rechirevo cheSQL uye ita chirevo cheSQL.

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

Nhanho yechitatu:

Mushure mekuita nhanho yechipiri, iwe uchagadzira nyowani clone tafura clone_tbl mudura re database.Kana iwe uchida kukopa iyo data kubva patafura yedata yaunogona kushandisaPINDA MU ... SARUDZA chirevo chekuita.

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 

Mushure mekuita nhanho dziri pamusoro, iwe unozoteedzera tafura, kusanganisira chimiro chetafura uye data retafura.

Imwe nzira yekukopa tafura

Imwe nzira yekuita kopi yakazara yetafura:

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

zvimwe:

Unogona kukopa mamwe endima idzi patafura:

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

Iwe unogona kutumidzazve minda yetafura ichangogadzirwa:

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

Chikamu che data chinogona kukopwa:

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

Ruzivo rwemumunda mutafura rinogona kutsanangurwa paunenge uchigadzira tafura:

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