Akwụkwọ ndekọ ederede
MySQLKedu ka esi emepụta usoro?MySQL nchekwa dataMepụta nkwupụta usoro na-abawanye na akpaghị aka
MySQL usoro ojiji
Usoro MySQL bụ ọnụọgụ ọnụọgụ: 1, 2, 3, ..., ebe ọ bụ na tebụl data nwere ike ịnwe naanị otu igodo ntinye akpaaka akpaaka, ma ọ bụrụ na ịchọrọ iji nweta nkwalite akpaka nke ubi ndị ọzọ, ị nwere ike iji usoro MySQL gaa. nweta.
N'isiakwụkwọ a anyị ga-akọwa otu esi eji usoro MySQL.
Jiri AUTO_INCREMENT
Ụzọ kachasị mfe iji usoro na MySQL bụ iji MySQL AUTO_INCREMENT iji kọwaa kọlụm.
ihe atụ
A na-emepụta tebụl data Insect na ihe atụ na-esonụ, ebe enweghị uru akọwapụtara maka uto akpaka.
mysql > CREATE TABLE昆虫 - > (- > id INT UNSIGNED NOT NULL AUTO_INCREMENT ,- > PRIMARY KEY (id ),- > name VARCHAR (30 )NOT NULL ,#昆虫类型- > 日期DATE NOT NULL ,#收集日期- > origin VARCHAR (30 )NOT NULL #where collected ); 查询OK ,0 行受影响(0.02 秒) mysql > INSERT INTO insects (id ,name ,date ,origin )VALUES - > (NULL ,'housefly' ,'2001-09-10' ,'kitchen' ),- > (NULL ,'millipede' ,'2001-09-10 ' ,'车道' ),- > (NULL ,'grasshopper' ,'2001-09-10' ,'front yard' ); 查询OK , 秒)记录:3 重复:0 警告:0 mysql > 选择* 从昆虫ORDER BY ID ; + ---- + ------------- + ------------ + ------------ + | id | 名字 | 日期 | 起源 | + ---- + ------------- + ------------ + ------------ + | 1 | 家蝇 | 2001 - 09 - 10 | 厨房 | | 2 | 千足虫 | 2001 - 09 - 10 | 车道 | | 3 | 蚱蜢| 2001 - 09 - 10 | 前院| + ---- + ------------- + ------------ + ------------ + 3 行中集(0.00 秒)
Nweta uru AUTO_INCREMENT
N'ime onye ahịa MySQL ị nwere ike iji ọrụ LAST_INSERT_ID() na SQL iji nweta uru nke kọlụm akpaaka agbakwunyere ikpeazụ etinyere na tebụl.
A na-enyekwa ọrụ ndị kwekọrọ na PHP ma ọ bụ PERL script iji nweta uru nke kọlụm mgbakwunye akpaaka ikpeazụ etinyere na tebụl.
Ọmụmaatụ PERL
Jiri ihe mysql_insertid nweta uru AUTO_INCREMENT.Ọmụmaatụ bụ ndị a:
$ dbh - > do (“INSERT INTO insect(name,date,origin) VALUES('moth','2001-09-14','windowsill')“ ); my $ seq = $ dbh - > { mysql_insertid };
Ọmụmaatụ PHP
PHP na-enweta uru nke kọlụm AUTO_INCREMENT na nkwupụta SQL etinyere site na ọrụ mysql_insert_id().
mysql_query (“INSERT INTO昆虫(名字,日期,起源) VALUES('moth','2001-09-14','windowsill')“ ,$ conn_id ); $ seq = mysql_insert_id ($ conn_id );
Tọgharia usoro
Ọ bụrụ na ihichapụ ọtụtụ ndekọ na tebụl data wee chọọ ịhazigharị kọlụm AUTO_INCREMENT nke data fọdụrụ, ị nwere ike ime ya site na ihichapụ kọlụm na-abawanye na akpaaka wee tinye ya ọzọ.Agbanyeghị, ọrụ a kwesịrị ịkpachara anya ma ọ bụrụ na ọ dị.N'otu oge nke ihichapụ, a na-agbakwunyere ndekọ ọhụrụ, na enwere ike inwe mgbagwoju anya data. Ọrụ ndị a bụ ndị a:
mysql > ALTER TABLE昆虫DROP ID ; mysql > ALTER TABLE昆虫 - > ADD ID INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST ,- > ADD PRIMARY KEY (id );
Tọọ uru mmalite nke usoro
N'ozuzu, mmalite uru nke usoro ahụ bụ 1, ma ọ bụrụ na ịchọrọ ịkọwapụta uru mmalite nke 100, mgbe ahụ anyị nwere ike iji nkwupụta ndị a mee ya:
mysql > CREATE TABLE昆虫 - > (- > id INT UNSIGNED NOT NULL AUTO_INCREMENT ,- > PRIMARY KEY (id ),- > name VARCHAR (30 )NOT NULL ,- > date DATE NOT NULL ,- > origin VARCHAR (30 )NOT NULL )engine = innodb auto_increment = 100 charset = utf8 ;
Ma ọ bụ ị nwekwara ike iji nkwupụta ndị a ka emechara tebụl nke ọma:
mysql > ALTER TABLE t AUTO_INCREMENT = 100 ;
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kesara "Olee otu MySQL si emepụta usoro? MySQL nchekwa data iji mepụta nkwupụta usoro na-abawanye nke onwe", iji nyere gị aka.
Nnọọ ka ị kesaa njikọ nke akụkọ a:https://www.chenweiliang.com/cwl-498.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!