the admin doesn't always want users to choose or modify the primary key, for example, this video's id on the URL, it is unique for this video and it is NOT NULL but the user didn't choose it.
I tried leaving the data blank after using NOT NULL but it does not show error, though I don't see 'NULL' in the text field but still it accepts if I don't type anything and insert row.
It creates auto increment in the database for ex. 1. abc-- 2. def --3. ghi but if admin has deleted 1st record ABC... and than add new record as JKL, database automatically add to number 4 slot... 4. jkl How can i make it correct as 1.def -- 2. GHI -- 3. jkl???? plz help!!!
hey bucky, I am trying to create a row where one of the values is NULL, but I keep getting an error. I am using the same myPHPadmin that you are using, but can you tell me how I should create the structure so that it does allow me to put in a NULL value?
I think this one is the most hard but also useful tutorials about SQL
Omg, amazing! I've been reading a tut on this and was pretty lost. Now I understand this and like 3 other things I wasn't too sure on. Thanks!
If you need french translations for your tutorials... That's the only fucking thing that I can do to thank you for all you learned to me.
great tutorials...!!!
Thanks Bucky
I got to say: After subscribing to Bucky's videos...BAM! I got BACON on the TABLE!!
did he just pack a lip/throw in a bomb at 6:43? packing that Copenhagen longcut I like it
Great tutorials, thanks for this..
never mind I got it, I was altering the wrong row to say I wanted to be able to enter a NULL value
What's the point of adding NOT NULL to the primary key if the user won't even have the option to change the primary key?
the admin doesn't always want users to choose or modify the primary key, for example, this video's id on the URL, it is unique for this video and it is NOT NULL but the user didn't choose it.
you can change your id in Vkontakte(social network)
Hi Bucky! Would you show us how to make some web apps with Python or Java?
When will you be finishing the python game tut's?
Thank you sooooo much
I tried leaving the data blank after using NOT NULL but it does not show error, though I don't see 'NULL' in the text field but still it accepts if I don't type anything and insert row.
I coded something up and my auto increment skips random times....can u let me know why,....thanks...i use id with auto increment ....
It creates auto increment in the database for ex.
1. abc-- 2. def --3. ghi
but if admin has deleted 1st record ABC... and than add new record as JKL, database automatically add to number 4 slot...
4. jkl
How can i make it correct as 1.def -- 2. GHI -- 3. jkl????
plz help!!!
Found any solution mate?
U want to update that through query
it can't someone else id by default
3 years have passed but here is your answer update RandomCharsID
set RandomCharsID=RandomCharsID-1
how do you edit the variables from NOT NULL to blank or vice versa, or to add auto inc if the table was created already?
At last he uses "bacon", feeling sad for tuna.
@safizzleful What do you mean by "stuffs"?
thank u
Bacon is never stupid
is it possible to create a table inside a table?
hey bucky, I am trying to create a row where one of the values is NULL, but I keep getting an error. I am using the same myPHPadmin that you are using, but can you tell me how I should create the structure so that it does allow me to put in a NULL value?
Just don't put anything, it will default to null.
So for example username varchar(30) will default to NULL, but username varchar(30) NOT NULL won't.
Bucky where is 31 and 32?
how do you connect tables and stuff
Man could u make minecraft modding tutorials
BACON!!!
I would make the `username` a UNIQUE key too
its good and easy
hello, is there a possible that I could create AUTO INCREMENT using VARCHAR?
How many is varchar+1 ?
cawan :D
"His password is pasword because he is an idiot" LOL.
lol you're the idiot one IDIOT
slambacon :)
Me fcuking too! BTW the comment you replied was removed, just sayin
You have a deep scratch in your disk XP
What did I say? Nut?
nut null :)
@ondari90 watch?v=ELI2-pEk1FY
6:20 - MySQL Is a male.
sexist