Kalozera wa Nkhani
MySQL databaseMomwe mungakopere mawonekedwe a tebulo mu?Koperani zomwe zili patebulo la data
MySQLkope tebulo
Ngati tifunika kubwereza kwathunthu tebulo la data la MySQL, kuphatikiza kapangidwe ka tebulo, ma index, zikhalidwe zosasinthika, ndi zina zambiri.Ngati ntchitoPANGANI TABLE ... SANKHANIkulamula sikutheka.
Mutuwu ukuwonetsani momwe mungakoperere ma tebulo a MySQL kwathunthu.
- 使用ONERANI CREATE TABLElamula kupeza pangani tebulo la data (Pangani MITU) mawu, omwe ali ndi ndondomeko, ndondomeko, ndi zina za tebulo loyambirira la deta.
- Koperani mawu a SQL osonyezedwa ndi lamulo ili, sinthani dzina la tebulo la data, ndikuchita SQL statement.
- Ngati mukufuna kukopera zomwe zili patebulo, mutha kugwiritsa ntchitoLOWANI MU ... SANKHANI mawu kukwaniritsa.
Chitsanzo
Yesani chitsanzo chotsatirachi kuti mutengere tebulo la chenweiliang_tbl.
chigawo choyamba:
Pezani dongosolo lonse la tebulo la deta.
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 秒) 错误:没有指定查询
Khwerero XNUMX:
Sinthani dzina la tebulo la data la mawu a SQL ndikuchita mawu a 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 秒)
Khwerero XNUMX:
Mukachita gawo lachiwiri, mupanga tebulo latsopano la clone_tbl mu database.Ngati mukufuna kukopera deta kuchokera pa tebulo la deta mungagwiritse ntchitoLOWANI MU ... SANKHANI mawu kukwaniritsa.
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
Pambuyo pochita masitepe omwe ali pamwambawa, mudzakhala ndi kope lathunthu la tebulo, kuphatikizapo ndondomeko ya tebulo ndi deta ya tebulo.
Njira ina yokopera tebulo
Njira ina yokopera tebulo lonse:
CREATE TABLE targetTable LIKE sourceTable ; INSERT INTO targetTable SELECT * FROM sourceTable ;
china:
Mutha kukopera ena mwa magawowa patebulo:
CREATE TABLE newadmin AS ( SELECT用户名,密码从管理员 )
Mutha kutchulanso magawo a tebulo lomwe langopangidwa kumene:
CREATE TABLE newadmin AS ( SELECT id ,username AS uname ,password AS pass FROM admin )
Gawo la data litha kukopera:
CREATE TABLE newadmin AS ( SELECT * FROM admin WHERE LEFT (username ,1 )= 's' )
Zomwe zili patebulo zitha kufotokozedwa popanga tebulo:
CREATE TABLE newadmin ( id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ) 如 ( SELECT * FROM admin )
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) adagawana "Momwe mungatengere mawonekedwe a tebulo mu database ya MySQL?Copy Table Data Content Statement" kuti ikuthandizeni.
Takulandirani kugawana ulalo wa nkhaniyi:https://www.chenweiliang.com/cwl-490.html
Takulandilani panjira ya Telegraph yabulogu ya Chen Weiliang kuti mupeze zosintha zaposachedwa!
📚 Bukuli lili ndi phindu lalikulu, 🌟Uwu ndi mwayi wosowa, musaphonye! ⏰⌛💨
Share ndi like ngati mukufuna!
Kugawana kwanu ndi zomwe mumakonda ndizomwe zimatilimbikitsa nthawi zonse!