How to add data to a database, via SQL

Do you have a database and need some information integrated into it (steps 6+), or do you just want a database all to yourself (steps All)?

  1. download PHPMyadmin
  2. Open PHPMyadmin.                             
  3. open the SQL command prompt on the page.
  4. Create a database
    CREATE DATABASE databasename;
  5. Open the command panel for your database
  6. Enter:
    CREATE TABLE table_name(
    column1 INT,
    column2 TEXT,
    column3 VARCHAR(255),
    .....
    columnN DATE,
    PRIMARY KEY( one or more columns )
    );
  7. You have entered a table where you can add data to a database
  8. Now enter:
    INSERT INTO table_name( column1, column2....columnN)
    VALUES ( value1, value2....valueN);
  9. Congratulations, you have entered data directly into a database

Leave a Reply