Table row is not adding !!!
Posted: Wed Apr 16, 2014 10:43 pm
I'm a learner of PHP and MySQL. For learning purpose I'm trying to enter a table row using Terminal. But unfortunately, the row is not adding to the table and there is no confirmation. The code is below :
When I'm issuing
It's showing
Thanks in advance.
Code: Select all
INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, how_many, alien_description, what_they_did, fang_spotted, other, email) VALUES ('Sally', 'Jones', '3 days ago', '1 day', 'four', 'green with six tentacles', 'We just talked and played with a dog', 'yes', 'I may have seen your dog. Contact me.', 'sally@gregs-list.net') Code: Select all
SELECT * FROM aliens_abduction;Please help me experts how can I solve this issue. Where is my fault?Empty set
Thanks in advance.