Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ – https://plus.google.com/+BuckyRoberts LinkedIn – https://www.linkedin.com/in/buc…
Original source
PHP Tutorial – 23 – Adding Tables to MySQL Database
(Programming, 101, Advanced, basic, boston, computer, database, how, howto, http://thenewbosto…, learn, mysql, mysql tutorial, php, PHPMyAdmin, Tables, to, tutorial, tutorials
39 responses to “PHP Tutorial – 23 – Adding Tables to MySQL Database”
For auto_increment, if you can't find it, check the box that says "A_I" no quotes.
Hey. How can I modify The ID by its Default number that I want to Put?
Thanks godness! Thanks!
how come there are times we get a "This is not a number" error message? and there was nothing I done otherwise in the table creation window… only I used a double data type for monetary values in my custom table.
Bucky what about the rest of the categories???
I just learned that from bucky's one tutorial about mySQL.
NOT NULL has same meaning as "required"
can you please tell me the purpose of creating a table? SQL is date base with table, and table contain informations of? I'm just so confused…
Hello there! Have you considered – Supreme Panic Magic (Have a quick look on google cant remember the place now)? Ive heard some interesting things about it and my mate said good bye the anxiety problem with it.
Love your tutorials but I do know of a field can and should have null ability. One example is Address2 If you don't have an apartment number or suit, there is no need for that field to be populated. Another might be MiddleInit. Not every one has a middle name. The examples could go on quite detailed but it is a needed function. Keep up the good work.
@cheesylard Lol, 2 years later he's famous!
yaaayyy… thanx alot.. i just created my first table..
hard as hell!
Is it the same as creating a Mysql table and a PHP form to connect?
"…And we'll, finally, be creating our frst computer game.. 😛
…Well creating the registration form too it." :'(
i love you.u r saving my life dude.I like the way u talk as well.it's actually fun
"…and we'll (finally) be creating our first computer game!"
mfw c':
6:52 – "In the next tutorial, we're gonna be creating our first computer game."
Me: "WHAT?!?!"
6:57 – "… Or at least the registration form."
Me: "Awwww…."
@Dragonblix The will provide you with username and password, if they don't email the administrators.
I have learned. thanks but I admit I obtuse long I realize these things .. but I must learn it because part of my major. this my major subject…
I have learned. thanks but I admit I obtuse long I realize these things .. but I must learn it because part of my major. this my major subject.
great vid
null filed means that they CAN be empty (they are null by default)
so when you creating some form in php with optional fields, values inputed by user can be empty and no error will apper when he press sumbit button because database does not require value in this field
You use the null field, if you want to let the user have an optional field such as telephone number or something that they might now want to enter.
You have taught me Python, JAVA and now this. Sir, I am in a great debit to you.
your soon to be famous!!
I would pay for a DvD with these tutorials in it…just so you know… 😉
null is used for optional info… duhh 🙂
Great tutorial!
Last time I worked with this stuff was about 1-2 years ago, so this was perfect for refreshing my memory.
I love this guy. I was nearly in tears trying to sort this out. 10/10
Great step by step, crystal clear instructions.
so far its been quite useful
mysql_query('CREATE TABLE `name` (id BIGINT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id))');
Hey, I actually do have something that uses null fields. I'm making a dictionary with conjugation and declension tables. Some words are defective, such as the word "can" which has no future tense, so all of its future tense fields will be null.
Wow you actually make sense compared to every other video I've watched. greatly appreciated.
why would anyone make a null field, well the answer is simple bucky..
think of it this way, u have few employees and some of them will have null as a value for commission that means they will never get commission,while some others will have a value of 0, meaning that they will have commission sometime while they work, but not at the current time.
thank you this is so use full thanks!!!!!
How do you inset values for multiple rows in a table? This Tut. shows only 1 row of values..but when you have more what's the easiest and fastest way? thanks
You've got the talent given by G-d for FREE so use it and share it for FREE.
Just like SCIENCE. SCIENCE is SHARING OF KNOWLEDGE
The reason for NULL is so that that value doesn't have to be assigned at any given time so say in a social network if you used NOT NULL on comments or friends you would have to set it as soon as you make a user or something( the value could be empty/0 though ). Allot of PHP developers don't know actual SQL just the essentials.