MySQL: AUTO_INCREMENT is awesome
HTML-код
- Опубликовано: 24 окт 2022
- #MySQL #tutorial #course
- AUTO_INCREMENT keyword used to automatically create a sequence of a column when inserting data. Applied to a column set as a ‘key’.
CREATE TABLE transactions (
transaction_id INT PRIMARY KEY AUTO_INCREMENT,
amount DECIMAL(5, 2)
);
ALTER TABLE transactions
AUTO_INCREMENT = 1000;
- AUTO_INCREMENT keyword used to automatically create a sequence of a column when inserting data. Applied to a column set as a ‘key’.
CREATE TABLE transactions (
transaction_id INT PRIMARY KEY AUTO_INCREMENT,
amount DECIMAL(5, 2)
);
ALTER TABLE transactions
AUTO_INCREMENT = 1000;
Bro do you have any idea about to put a django course
Thanks a lot dude. I was literally struggling in implementing this feature, searched for every possible solution but couldn't find it but then your video came into place and my whole problem was solved.
Keep posting such informative videos.
It is a great new to see that you have started with databases,
I am going to enjoy mastering Mysql.
thank you bro!
Thank you for the sql series. Very nice one!!
Thanks so much sir
Very useful
Thanks man you're the best!
Man you are awsome!❤️🥺✔️
Thank you so much!! It is really helpful, the one i struggled with is what to do with the values since it is auto incrementing, do i have to input a value to each? And also i have learned additional of the Alter Table
auto_increment=number_startID if you want something starting number at
Thank you so much 😊
can you do auto increment exactly the same as this one but with a prefixes at the front?
Teach bro code, I learn java for your course, i finished 41 leasons , that made me to creat a scientific calculator can you jake please. THANKS FOR UR HELP SIR
Is it possible to add it to an already completed table?
I have a question: I have created the user table and connected the database normally, but I have a problem with the register in my project and cannot insert it into the database. Now I go back to the database and adjust the auto-increment id. Does it affect the system? Thank you
and what if we have id 1,2,3,4,5 then remove id to 3,4 and after adding data it leads to id 6,7
how about an alphanumerical auto increment? can you help tho
I toggled Auto Increment on in MySQL Workbench instead of hand-coding, and for some reason the PK (word_id) isn't auto-incrementing. Any ideas of why this is?
Hi sir
I want to add auto_increment in two columns, is it possible
How to do in cached sqlite database app.db?
what if you delete the data? and the id not sorted correctly? Can anyone resolve this?
How to drop primary key from table???
In SQL aut increment not running
please bring Git course
YES, there is no good tutorial on the entire internet about git and gitHub. it's so fucked and wird
hello, i have to make it alphanumeric but still auto increment.
for example:
AB-1-0001 then if it reach AB-1-9999, then it will become AB-2-0000
i hope somebody can help me out with this. thanks in advance
php please ☺️
Yeah first again. 🎉 but where is the game bro 🥹
which game are you referring to? 🤔
@@BroCodez Actually I am not very good at games😂 but I’ve watched quarter final LoL worlds 2022. That has been amazing.😱This series made me scream so much🤭