TommyLox Posted February 16, 2012 Report Share Posted February 16, 2012 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! Quote Link to comment Share on other sites More sharing options...
TommyLox Posted February 16, 2012 Author Report Share Posted February 16, 2012 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! Quote Link to comment Share on other sites More sharing options...
TommyLox Posted February 16, 2012 Author Report Share Posted February 16, 2012 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. Quote Link to comment Share on other sites More sharing options...
falkencreative Posted February 16, 2012 Report Share Posted February 16, 2012 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/ Quote Link to comment Share on other sites More sharing options...
TommyLox Posted February 16, 2012 Author Report Share Posted February 16, 2012 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.