Tag: 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