Jump to content


Photo

Table setup in phpMyAdmin


  • Please log in to reply
4 replies to this topic

#1 TommyLox

TommyLox

    New member

  • New Members
  • 6 posts

Posted 16 February 2012 - 06:12 AM

I am new to PHP and MySQL and whilst following Stefan's tutorial, I finished watching 'SQL_basics-introduction' where Stefan shows the database 'killer', but he doesn't create a table as he didnt fill in the options, so the tutorial ends as killer(0).

Then I go to the next tutorial, SQL-basic_introduction, and a table has been created: killer(1), but I do not know how to replicate this! The tutorial did not explain how to set 'auto-increment', so when I follow the tutorial like so: INSERT INTO people (name) VALUES ("Tommy"), phpMyAdmin gives me an error message: #1062 - Duplicate entry '0' for key 'id'.

I cannot proceed with the tutorials until I can replicate the setup of that table as Stefan has, can anyone fill this gap for me please? Step by step instructions would be much appreciated!
  • 0

#2 TommyLox

TommyLox

    New member

  • New Members
  • 6 posts

Posted 16 February 2012 - 06:18 AM

I am new to PHP and MySQL and whilst following Stefan's tutorial, I finished watching 'SQL_basics-introduction' where Stefan shows the database 'killer', but he doesn't create a table as he didnt fill in the options, so the tutorial ends as killer(0).

Then I go to the next tutorial, SQL-basic_introduction, and a table has been created: killer(1), but I do not know how to replicate this! The tutorial did not explain how to set 'auto-increment', so when I follow the tutorial like so: INSERT INTO people (name) VALUES ("Tommy"), phpMyAdmin gives me an error message: #1062 - Duplicate entry '0' for key 'id'.

I cannot proceed with the tutorials until I can replicate the setup of that table as Stefan has, can anyone fill this gap for me please? Step by step instructions would be much appreciated!


  • 0

#3 TommyLox

TommyLox

    New member

  • New Members
  • 6 posts

Posted 16 February 2012 - 06:24 AM

Correction - the subsequent tutorial was 'SQL_insert_statement' (not SQL_basic_introduction).

So, my issue is that I cannot follow the steps in the 'SQL_insert_statement.mov' as Stefan did not explain how setup the killer(1) table, i.e how to specify auto_increment. Please help as I cannot carry on with the tutorials until I successfully setup tables as Stefan/phpMyAdmin requires.
  • 0

#4 Ben

Ben

    Administrator

  • Administrators
  • 5,656 posts
  • LocationChico, CA

Posted 16 February 2012 - 09:58 AM

I'd suggest looking at these three videos introducing MySQL and PHPMyAdmin -- I haven't watched them in a while, but I believe they should give you the basics you need to continue. http://killerphp.com/mysql/videos/
  • 0
Benjamin Falk
Falken Creative : Twitter

#5 TommyLox

TommyLox

    New member

  • New Members
  • 6 posts

Posted 16 February 2012 - 11:25 AM

Appreciated Ben. I eventually figured it out - the tutorials I had were indexed 1-9, so I assumed they'd be in order, but I was wrong..! No biggie, but thank you nonetheless.
  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users