• Friday , 24 January 2020

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

Code Canyon



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

3d Ocean

Related Posts

10 Comments

  1. John Zoidberg
    December 17, 2017 at 15:13

    Thanks! for taking the time to make the video, it really helped me out.

  2. Solar Flare
    December 17, 2017 at 15:13

    Thank you

  3. Leonardo DDM
    December 17, 2017 at 15:13

    How can insert a column in mysql database's table. Pls let me explain it. Thnx

  4. HATEPOL1CY
    December 17, 2017 at 15:13

    cheers!

  5. Brian Sy
    December 17, 2017 at 15:13

    thank you

  6. Felix Leung
    December 17, 2017 at 15:13

    It's a very good tutorial for beginner who want to lean MySQL, thank you.

  7. SlothScripts
    December 17, 2017 at 15:13

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

  8. stop telling me to update my name damnit
    December 17, 2017 at 15:13

    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?

  9. SlothScripts
    December 17, 2017 at 15:13

    @gugsah It's a very common error especially for beginner programmers!

    Glad to hear this was helpful! Happy coding!

  10. Hénock Gugsa
    December 17, 2017 at 15:13

    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 Comment

You must be logged in to post a comment.