In this video I discuss the basic MySQL queries, including select, update, delete and insert. The goal is to show the basic syntax of the query and thus none of them are highly complicated….
Original source
[MySQL Tutorial]: Basic Queries (Select, Update, Delete, Insert)
10 responses to “[MySQL Tutorial]: Basic Queries (Select, Update, Delete, Insert)”
Thanks! for taking the time to make the video, it really helped me out.
Thank you
How can insert a column in mysql database's table. Pls let me explain it. Thnx
cheers!
thank you
It's a very good tutorial for beginner who want to lean MySQL, thank you.
@chimamiresatoh It can be done with a single query.
The basic syntax is as follows:
INSERT INTO `table_name` (`columns`, `here`) VALUES('1','2'), ('1', '2')
So in your case:
INSERT INTO `table_name` (`Name`, `Job`) VALUES('Name1', 'Job1'), ('Name2', 'Job2')
Hope this helped!
How would I go about populating a table with several values, but ignoring certain columns?
For instance, allowing the ID field to auto-increment, but inserting several values into `Name` and several into `Job`?
Can I do that with a single query?
@gugsah It's a very common error especially for beginner programmers!
Glad to hear this was helpful! Happy coding!
Thank you for this. I was getting syntax errors because I had replaced all back-ticks with regular single quotes because these latter were more visible to me. I was being done in by back-ticks!! LOL.
Thanks again!