Akwụkwọ ndekọ ederede
MySQL nchekwa dataKedu ka esi ṅomiri nhazi okpokoro na?Detuo nkwupụta ọdịnaya data tebụl
MySQLDetuo tebụl
Ọ bụrụ na anyị kwesịrị ịmegharị tebụl data MySQL kpamkpam, gụnyere nhazi nke tebụl, indexes, ụkpụrụ ndabara, wdg.Ọ bụrụ naanị ijiMepụta tebụl ... Họrọiwu agaghị ekwe omume.
Isiakwụkwọ a ga-ewebata otu esi edetu tebụl data MySQL kpamkpam, usoro ndị a bụ:
- 使用Gosi imepụta tebụliwu nweta ike datatable (Mepụta Isiokwu) nkwupụta, nke nwere nhazi, ndeksi, wdg nke tebụl data mbụ.
- Detuo nkwupụta SQL nke egosiri site na iwu na-esonụ, gbanwee aha tebụl data, wee mebie nkwupụta SQL. Iwu a dị n'elu ga-eṅomi kpamkpam nhazi tebụl data.
- Ọ bụrụ na ịchọrọ iṅomi ọdịnaya nke tebụl, ịnwere ike ijiTinye n'ime… Họrọ nkwupụta imezu.
ihe atụ
Gbalịa ihe atụ na-esonụ ka ịmegharị tebụl chenweiliang_tbl.
nzọụkwụ nke mbụ:
Nweta nhazi zuru oke nke tebụl 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 秒) 错误:没有指定查询
Nzọụkwụ XNUMX:
Gbanwee aha tebụl data nke nkwupụta SQL wee mebie nkwupụta 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 秒)
Nzọụkwụ XNUMX:
Mgbe ịmechara nzọụkwụ nke abụọ, ị ga-emepụta clone table clone_tbl na nchekwa data.Ọ bụrụ na ịchọrọ iṅomi data site na tebụl data ị nwere ike ijiTinye n'ime… Họrọ nkwupụta imezu.
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
Mgbe ịmechara usoro ndị a dị n'elu, ị ga-enwe akwụkwọ zuru ezu nke tebụl, gụnyere nhazi tebụl na data tebụl.
Ụzọ ọzọ ị ga-esi detuo tebụl
Ụzọ ọzọ ị ga-esi mepụta tebụl zuru ezu:
CREATE TABLE targetTable LIKE sourceTable ; INSERT INTO targetTable SELECT * FROM sourceTable ;
ozo:
Ị nwere ike idetuo ụfọdụ ubi ndị a na tebụl:
CREATE TABLE newadmin AS ( SELECT用户名,密码从管理员 )
Ị nwere ike nyegharịa ubi tebụl ahụ emepụtara ọhụrụ aha:
CREATE TABLE newadmin AS ( SELECT id ,username AS uname ,password AS pass FROM admin )
Enwere ike iṅomi akụkụ nke data:
CREATE TABLE newadmin AS ( SELECT * FROM admin WHERE LEFT (username ,1 )= 's' )
Enwere ike ịkọwa ozi ubi na tebụl mgbe ị na-eke tebụl:
CREATE TABLE newadmin ( id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ) 如 ( SELECT * FROM admin )
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kesara "Otu esi emegharị tebụl na nchekwa data MySQL?Detuo Nkwupụta Ọdịnaya Ọdịnaya nke tebụl" iji nyere gị aka.
Nnọọ ka ị kesaa njikọ nke akụkọ a:https://www.chenweiliang.com/cwl-490.html
Nabata na ọwa Telegram nke blọgụ Chen Weiliang ka ị nweta mmelite kachasị ọhụrụ!
📚 Ntuziaka a nwere nnukwu uru, 🌟Nke a bụ ohere dị ụkọ, echefula ya! ⏰⌛💨
Kekọrịta na-amasị ma ọ bụrụ na-amasị gị!
Ịkekọrịta na mmasị gị bụ mkpali anyị na-aga n'ihu!