Quomodo mensam structuram replicare in MySQL database?Effingo mensam data contentus dicitur

MySQL databaseQuomodo effingo tabulam structuram in?Effingo mensam data contentus dicitur

MySQLeffingo mensa

Si opus est ut tabulam datam MySQL penitus replicare, incluso structuram tabulae, indices, valorum defectuum, etc.Si modo utiCREATIO ... SELECTpraeceptum est impossibile.

Hoc capitulum te introducet quomodo omnino effingo MySQL data tabularum. Vestigia sunt haec:

• UseSHOW INDEX CREAREdatatable imperium adepto creo (TABLE) constitutio, quae structuram, indicem, etc. tabulae notitiae originalis continet.
• Effingo propositionem SQL ex sequenti mandato exhibens, nomen tabulae datae mitigabit, et enuntiatum SQL exequetur. Mandatum superius mandatum totam tabulam datam structuram effinget.
• Si tabulae contentum imitari vis, uti potesINDO ... SELECT dicitur consequi.

Exempli gratia

Conare hoc exemplum ad replicandum mensam chenweiliang_tbl.

unum gradum;

Adepto plenam structuram data mensa.

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

错误：没有指定查询

Duo gradus:

Tabulae datae nomen mutare SQL constitutionis et constitutionis SQL exequi.

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

Tres gradus:

Secundum gradum peractis, novam clone mensam clone_tbl in datorum creabis.Si vis ad effingo notitia ex data mensa uti potesINDO ... SELECT dicitur consequi.

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 

Gradibus superioribus peractis, exemplar tabulae integrum habebis, inclusa tabulae structurae ac tabulae notae.

Alio modo ut effingo mensam

Alius modus ad mensam plene effingo:

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

aliis;

Aliquid horum agrorum in mensa imitari potes;

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

Potes nominare agros mensae novae;

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

Pars data exscriptus potest:

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

Agri informationes in mensa definiri possunt, dum mensam creant;

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