Techblog Technical Blog about all things computer
  • MYSQL Basic Tutorial

    Filed under Databases
    Sep 16

    MYSQL Basic Tutorial

    The aim of this tutorial is to help you familiarize with basic MYSQL commands.

    1.) How to show the available databases.

    show databases;

    2.) How to create a database. For example you want to create a database called “test_database”

    create database test_databaseee;
    3.) Oops. You made a spelling mistake, test_database has extra e’s. To drop database use

    drop database test_databaseee;
    4.) To create test_database again type:

    create database test_database;
    5.) To select a database so you can access the tables without a database prefix:

    use test_database;
    6.) To show available tables in a database.

    show tables;
    7.) To create a table:

    create table test_table (

    name varchar(50),

    age int);
    8.) To look at the columns and structure of the table you just created:

    show table test_table;

    9.) To insert data to the table created above:

    insert into test_table(name, age)

    values (‘Bill Gates’, 50);

    10.) To insert multiple values into a table, separate the values by a comma:

    insert into test_table (name, age)

    values (‘Steve Balmer’, 55),

    (‘Larry Ellison’, 51),

    (‘Albert Einstein’, 100);

    11.) To view the data in your table:

    select * from test_table;
    12.) To delete a record from your table. For example you want to delete “Bill Gates” from the example above:

    delete from test_table

    where name = ‘Bill Gates’;

    13.) To update a column in a table. For example you want to update Albert Einstein’s age:

    update test_table set age = ‘200’ where name = ‘Albert Einstein’;

    Hope this tutorial was helpful. Feel Free to post your questions and I will answer them.

46 Responses to “MYSQL Basic Tutorial”

  1. Добрый вечер!

    С уважением,…

  2. Pillspot.org. Canadian Health&Care.Special Internet Prices.No prescription online pharmacy.PillSpot.org. .

    Categories: Anxiety/Sleep Aid.Eye Care.Pain Relief.Antidiabetic.Weight Loss.Stomach.Blood Pressure/Heart.Anti-allergic/Asthma.Antibiotics.Skin Care.Antiviral.Antidepressants.Mental HealthWomens Health.Vitamins/Herbal Supplements.Mens Health.Stop S…


  3. PillSpot.org. Canadian Health&Care.Special Internet Prices.Best quality drugs.No prescription online pharmacy. Online Pharmacy. Order pills online

    Buy:Viagra Professional.Cialis Soft Tabs.Soma.Zithromax.Levitra.Maxaman.Viagra Super Active+.Viagra Super Force.Viagra.Propecia.Cialis.Super Active ED Pack.Viagra Soft Tabs.Tramadol.VPXL.Cialis Super Active+.Cialis Professional….

  4. Need cheap generic LEVITRA?…

  5. ..

    Buygeneric pills…

  6. ..

    Buyno prescription…

  7. ..

    Buygeneric drugs…

  8. Buywithout prescription…

  9. ..

    Buynow it…

  10. ..

    Buynow it…

  11. Buygeneric drugs…

  12. .

    Buygeneric drugs…

  13. ..

    Buygeneric meds…

  14. .

    Buynow it…

  15. ..

    Buyit now…

  16. Buywithout prescription…

  17. .

    Buywithout prescription…

  18. Buygeneric drugs…

  19. Buyit now…

  20. Buyit now…

  21. .

    Buygeneric meds…

  22. ..

    Buydrugs without prescription…

  23. .

    Buygeneric meds…

  24. .

    Buyno prescription…

  25. .

    Buygeneric drugs…

  26. .

    Buynow it…

  27. .

    Buynow it…

  28. .

    Buygeneric meds…

  29. .

    Buygeneric meds vbg…

  30. ..

    Buynow it vhx…

  31. ..

    Buygeneric drugs lzt…

  32. ..

    Buygeneric drugs krg…

  33. .

    Buygeneric drugs zfk…

  34. ..

    Buygeneric drugs eet…

  35. ..

    Buygeneric meds qhr…

  36. ..

    Buygeneric meds qmo…

  37. .

    Buyno prescription luw…

  38. ..

    Buywithout prescription dyo…

  39. ..

    Buygeneric pills zdg…

  40. .

    Buywithout prescription yyn…

  41. ..

    Buydrugs without prescription faj…

  42. Buydrugs without prescription vrg…

  43. .

    Buyit now ojb…

  44. .

    Buygeneric drugs nih…

  45. .

    Buygeneric drugs axm…


  46. BUY DRUGS ONLINE : -====Allergy Cure Anthelmintics Pills < a href="http…

    Order Cheap Pills Today!…

Leave a Reply