[MySQL Tutorial]: Basic Queries (Select, Update, Delete, Insert)




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


10 responses to “[MySQL Tutorial]: Basic Queries (Select, Update, Delete, Insert)”

  1. @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!

  2. 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!

Leave a Reply