Tusaha Maqaalka
MySQLSidee loo sameeyaa taxane?database MySQLSamee bayaan isku xiga oo toos ah
Isticmaalka taxanaha MySQL
Taxanaha MySQL waa tiro ka mid ah isugeynta: 1, 2, 3, ..., maadaama miiska xogta uu yeelan karo hal goob oo keliya furaha is-kordhinta, haddii aad rabto inaad si toos ah u kordhiso qaybaha kale, waxaad isticmaali kartaa taxanaha MySQL si aad gaadhaan
Cutubkan waxaan ku sharxi doonaa sida loo isticmaalo MySQL taxanaha.
Isticmaal AUTO_INCREMENT
Habka ugu fudud ee loo isticmaalo taxanaha MySQL waa in la isticmaalo MySQL AUTO_INCREMENT si loo qeexo tiirarka.
tusaale
Jadwalka xogta Cayayaanka waxaa lagu abuuray tusaalahan soo socda, kaas oo aan qiimo lagu cayimin si loo gaaro korriin toos ah.
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 秒)
Hel AUTO_INCREMENT qiimaha
Macmiilka MySQL waxaad isticmaali kartaa shaqada LAST_INSERT_ID() ee SQL si aad u hesho qiimaha tiirarka otomaatiga u dambeeya ee la geliyo miiska.
Hawlaha u dhigma ayaa sidoo kale lagu bixiyaa qoraalka PHP ama PERL si loo helo qiimaha tiirka ugu dambeeya ee is-kordhiyey ee la geliyo miiska.
Tusaale ahaan PERL
Isticmaal mysql_insertid hantida si aad u hesho qiimaha AUTO_INCREMENT.Tusaalooyinka waa sida soo socota:
$ dbh - > do (“INSERT INTO insect(name,date,origin) VALUES('moth','2001-09-14','windowsill')“ ); my $ seq = $ dbh - > { mysql_insertid };
Tusaale ahaan PHP
PHP waxay ku helaysaa qiimaha tiirka AUTO_INCREMENT ee weedha SQL ee la fuliyay iyada oo loo marayo mysql_insert_id() shaqada.
mysql_query (“INSERT INTO昆虫(名字,日期,起源) VALUES('moth','2001-09-14','windowsill')“ ,$ conn_id ); $ seq = mysql_insert_id ($ conn_id );
dib u habeynta isku xigxiga
Haddii aad tirtirto diiwaanno badan oo ku jira shaxda xogta oo aad rabto in aad dib u habayn ku samayso tiirka AUTO_INCREMENT ee xogta hadhay, waxaad sidaas samayn kartaa adiga oo tirtiraya tiirka iskii u kordhinta ka dibna ku dara mar kale.Si kastaba ha ahaatee, qalliinkan waa inuu aad uga taxaddaraa, haddi ay ahaan lahayd.Isla mar ahaantaana la tirtiro, diiwaanno cusub ayaa lagu daraa, waxaana laga yaabaa inay jiraan jahawareer xogta.
mysql > ALTER TABLE昆虫DROP ID ; mysql > ALTER TABLE昆虫 - > ADD ID INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST ,- > ADD PRIMARY KEY (id );
Deji qiimaha bilowga ee taxanaha
Guud ahaan, qiimaha bilawga ee taxanaha waa 1, laakiin haddii aad u baahan tahay inaad qeexdo qiimaha bilawga ah ee 100, markaa waxaan ku samayn karnaa bayaankan soo socda:
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 ;
Ama waxaad sidoo kale isticmaali kartaa bayaankan soo socda ka dib marka shaxda si guul leh loo sameeyo:
mysql > ALTER TABLE t AUTO_INCREMENT = 100 ;
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) wadaaga "Sidee MySQL u abuurtaa taxane? Xogta MySQL si ay u abuurto odhaah isku xigta oo is-kordhinta", si ay kuu caawiso.
Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-498.html
Ku soo dhawoow kanaalka Telegramka ee Chen Weiliang's blog si aad u hesho wararkii ugu dambeeyay!
📚 Hagahan waxa uu ka kooban yahay qiimo aad u weyn, 🌟Tani waa fursad naadir ah, ha seegin! ⏰⌛💨
Share iyo like saar hadaad jeceshahay!
Wadaagistaada iyo jeceylkaaga ayaa ah dhiirigelintayada joogtada ah!