Using INSERT and SELECT SQL Queries

Video loading...

Join Drupalize.Me to watch this video

Join today and gain instant access to our entire video library.

Log in Sign up
  • 0:05
    with Leanna Pelham
  • 0:08
    How do we add data to a table?
  • 0:12
    With a query.
  • 0:13
    Whenever you want to add a new row to a table,
  • 0:15
    use the INSERT INTO query.
  • 0:18
    INSERT INTO means add a new row to this table.
  • 0:22
    The syntax is a little odd, but always the same.
  • 0:26
    INSERT INTO, the table name, a comma list
  • 0:29
    of the fields you want to fill in, the word VALUES,
  • 0:32
    then a comma list of their values.
Loading ...

Using INSERT and SELECT SQL Queries

Loading...

In this tutorial you'll get familiar with the INSERT and SELECT SQL commands to let you add and retrieve data from your database.

Downloads: 
Log in or sign up to download companion files.

Additional resources:
There are no resources for this video. If you believe there should be, please contact us.