Create a MySQL Database, Tables and Insert Data

How do I create a MySQL database, tables, and insert (store) data into newly created tables?

MySQL is a free and open source database management system. You need to use sql commands to create database. You also need to login as mysql root user account. To create a database and set up tables for the same use the following sql commands:
Tutorial details
Difficulty Easy (rss)
Root privileges No
Requirements mysql
Time 10m

ADVERTISEMENTS

  1. CREATE DATABASE – create the database. To use this statement, you need the CREATE privilege for the database.
  2. CREATE TABLE – create the table. You must have the CREATE privilege for the table.
  3. INSERT – To add/insert data to table i.e. inserts new rows into an existing table.

Procedure for creating a database and a sample table

Login as the mysql root user to create database:
$ mysql -u root -p
Sample outputs:

mysql>

Add a database called books, enter:
mysql> CREATE DATABASE books;

Now, database is created. Use a database with use command, type:
mysql> USE books;

Next, create a table called authors with name, email and id as fields:
mysql> CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20));

To display your tables in books database, enter:
mysql> SHOW TABLES;
Sample outputs:

+-----------------+
| Tables_in_books |
+-----------------+
| authors         |
+-----------------+
1 row in set (0.00 sec)

Finally, add a data i.e. row to table books using INSERT statement, run:
mysql> INSERT INTO authors (id,name,email) VALUES(1,"Vivek","xuz@abc.com");
Sample outputs:

Query OK, 1 row affected (0.00 sec)

Try to add few more rows to your table:
mysql> INSERT INTO authors (id,name,email) VALUES(2,"Priya","p@gmail.com");
mysql> INSERT INTO authors (id,name,email) VALUES(3,"Tom","tom@yahoo.com");

To display all rows i.e. data stored in authors table, enter:
mysql> SELECT * FROM authors;
Sample outputs:

+------+-------+---------------+
| id   | name  | email         |
+------+-------+---------------+
|    1 | Vivek | xuz@abc.com   |
|    2 | Priya | p@gmail.com   |
|    3 | Tom   | tom@yahoo.com |
+------+-------+---------------+
3 rows in set (0.00 sec)

Now, you know how to create a database and a table. For further information please see MySQL data types and official documentation.

This entry is 4 of 5 in the CentOS Linux MySQL Server Tutorial series. Keep reading the rest of the series:
  1. CentOS install Mysql database server
  2. CentOS install MySQL client only
  3. MySQL Create a user accounts
  4. MySQL Create a database & tables and data
  5. Reinstall MySQL On Linux
🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source/DevOps topics:
CategoryList of Unix and Linux commands
File Managementcat
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Network Utilitiesdig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04

ADVERTISEMENTS
199 comments… add one
  • ninja May 7, 2008 @ 0:43

    thank you very much, you helped me out! :)

    • vaheedulla Mar 4, 2011 @ 15:24

      thank you very much, you helped me out! :)

      • Anil Dec 30, 2011 @ 11:29

        thanks its so good example……….

        • denish Apr 20, 2014 @ 9:39

          God examples for beginers thanks

  • Ashish Jul 12, 2008 @ 4:48

    Hi, i saw this site very helpful for me for crating table with mysql thanks for supporting new users;

  • gh Aug 22, 2008 @ 6:16

    very cool and very helpfull…
    continue the good work vivek gite
    we are expecting many tutorial of urs …
    thanks for this one very useful

  • ST4R Jan 24, 2009 @ 13:36

    Hi very good tutorial :D keep up the good work you helped me alot :) i was wondering (if there wasnt any previous sessions opened) how do i use this table so it will show at my website (like linking php and sql or somthing like that) :) sorry for the stupid question but im just learning sql and php…oh and allso could it be possible to use php in a html website (so you can include some php code in you html)
    Thanks! :D

  • Rohit Feb 11, 2009 @ 6:36

    Nice start.
    Thanx.

  • Andreas moliana Apr 22, 2009 @ 11:29

    I think if you can try to make more example one can easily have a picture of how to get in use with MySQL . And your example may reflect data been put into table so as one can easily see how to use the data he has to create a table or tables.
    By the by, this is also of help can train people who wants to use mySQL their studies. many thanks!

  • izhar Apr 23, 2009 @ 4:17

    Thanks a lot. u make easy for me dude bcoz i am try a couple day to create sinog blegle tables but is not work…..good blees you.

  • Sumit Apr 23, 2009 @ 19:12

    Thanks a lot. Helped me very much.

  • chaminda Jun 23, 2009 @ 6:00

    how can we insert a column with data to existing table

    • neha singh Sep 12, 2011 @ 6:01

      alter table name add column new column name varchar(x);

    • venkatesh Aug 30, 2014 @ 12:45

      thank u very much,can u give me some query for join

  • shiva shankar Aug 4, 2009 @ 7:06

    pritty good for start up freshers,helped alot .

    could have some more command.

  • srinivas Aug 27, 2009 @ 9:32

    thanks for helping me

  • wawan Sep 11, 2009 @ 4:09

    THANKS U SO MUCH,,, 4 help me problem

  • Eric Oct 2, 2009 @ 6:58

    Thanks very much for that short tutorial. It was worth it and very articulate. God Bless.

  • chaitan kumar yadav Oct 3, 2009 @ 5:30

    how to enter data in tables…..

  • Damian Nov 24, 2009 @ 23:00

    Just learning SQL now. This was an incredibly useful tutorial. Thanks!

  • soundarya Jan 15, 2010 @ 7:38

    this information was v useful to me thanks a lot

  • Geetha Jan 20, 2010 @ 6:48

    Hi,
    How to connect this database with drupal

  • sowmiya Mar 15, 2010 @ 6:18

    very very nice and simple

  • gizachew Mar 17, 2010 @ 16:22

    hi how are u.it is fine and helpful for me so it is better u keep such a help and support.
    please keep it up

  • suryaprakash Apr 1, 2010 @ 11:01

    this is suryaprakash
    i am working on swing project in Java
    i want to insert Jtable information into DataBase table

    can it is possible..?
    if yes
    plz send a sample program
    waiting for u r Reply

    My email address is ::suryaprakash.pisay@gmail.com
    Thank u in Advance ..!

  • Anonymous Jun 30, 2010 @ 17:39

    thanks

  • Mahesh Aug 22, 2010 @ 6:37

    Nice info. But please specify the PHP code to be used to add data into MySQL database.

  • Cosmile D'souza Nov 23, 2010 @ 11:14

    Hey amigo, Thanks your help is greatly appreciated………

  • jigs Nov 27, 2010 @ 6:09

    how to connect data with the databse in the php

  • even Dec 5, 2010 @ 9:21

    thz alot

  • ahmad hussain Dec 17, 2010 @ 9:20

    I spending hours in search , finally founded this code , really very helpful . Just want to entitle you 5 start. Thx lot.

  • Nidhi Shah Jan 7, 2011 @ 6:30

    How to recover data from .ibd file if innodb is corrupted
    I have one test database and many table with the extension of .frm and .idb file. from frm file i got strucure of database but how to restore data from individiual file of .idb file.

    • lala Mar 6, 2014 @ 9:26

      Just restart ur mysql :D

  • Nidhi Shah Jan 7, 2011 @ 6:30

    this is suryaprakash
    i am working on swing project in Java
    i want to insert Jtable information into DataBase table

    can it is possible..?
    if yes
    plz send a sample program
    waiting for u r Reply

    My email address is ::suryaprakash.pisay@gmail.com
    Thank u in Advance ..!

    Reply

  • thiyagi Jan 10, 2011 @ 10:39

    thanks for the tut, was helpful..

  • Soumyadeep Ghosh Jan 11, 2011 @ 16:58

    hi!!!!!!!!!!!!this tutorial is very helpful to me.thanks for the post.

  • shoes Feb 21, 2011 @ 10:17

    can i get a full sample from this code..?
    thanks

  • jhalak roy Feb 23, 2011 @ 19:57

    thank u sooooooooooo much……helped me a lot……..

  • jay Feb 24, 2011 @ 16:27

    it really helped me about about this tutorial… i’m just a beginner but now i understand the syntax in using the mysql client. thank you very much.

  • aashish Feb 27, 2011 @ 18:02

    thankzzzzzzzzzzzz alot my frnd*****************************************
    very helpful for my practical exams

  • faran Mar 3, 2011 @ 7:09

    thanksssssss
    this material is very helpful for me for my projects

  • cute programmer Apr 8, 2011 @ 16:05

    thanks for this one, im quite confused why my code dont work even though its correct.

  • Chris Apr 10, 2011 @ 16:24

    I am using a webhost and has no shell access so unable to use command line.
    Here’s the problem:
    I have tried to “import” a table with its content into the existing database but it kept showing a 1062 error about key 1 ………… which I have no idea why and what to do.
    I tried to create a new table from within phpmyadmin but it requires me to indicate how many fields and then to fill in those empty boxes…which I have no idea what to put in there.

    So, i thought of using bigdump to try to import this table into the database or to do a manual import by copying the content of the table into the SQL tab’s Sql Query box from within phpmyadmin.
    Are the above two options suitable?
    What would be your best suggestion and guidance on how to proceed so as to succeed in getting this table into the database?

    Any assistance, guidance and advice, would be much appreciated.

    Thanks in advance and best wishes.
    Chris

  • ThankfulGuy Apr 18, 2011 @ 10:34

    Thanks dude! it helped me!

  • VIVEK.R May 9, 2011 @ 11:12

    THANK YOU FOR GIVING SUCH A HELPFUL WEBSITE.

  • panda Jun 12, 2011 @ 18:13

    Thanks alotttt:)

  • dariel Jun 26, 2011 @ 10:04

    thank you it’s helpful to find my error in syntax…. tnx

  • Ken Jun 29, 2011 @ 2:23

    Sir what command should i use if i want to copy in mysql or wamp.?

  • rashid Iqbal Jul 1, 2011 @ 10:46

    I want to change the password of user from users table, but the password values shown in table are in encrypted form. how can I change the user password

    • george davis Jul 3, 2011 @ 19:23

      try to change the password in xammp or wampp depending on the server you are using.log in and in the specific database for the specific user, you can change the password. make sure you click GO..
      hope this helps…

  • george davis Jul 3, 2011 @ 19:21

    Thanks a lot. Am a beginner in mysql programming and this is good start from here.
    George

  • suranga wickramasinghe Jul 20, 2011 @ 13:37

    A great work ,i was able to add huge knowledge within few minitues. thankX lot dear teacher…

  • Gamachis Aug 18, 2011 @ 9:24

    it is really helpful.. wonderful dude!!!

  • Anuj Aug 18, 2011 @ 15:17

    Thanks bro

    very use full

    i wasn’t able to understand what was the matter but now i understood

    once again thnks

  • Anuj Aug 18, 2011 @ 15:18

    How can i deleabte a table?

    • satz Oct 29, 2011 @ 11:17

      to delete a database,
      DROP DATABASE ;

  • Dharmang Aug 19, 2011 @ 12:33

    hey man this is very helpful to user like me who is new in linux

  • rohan Aug 30, 2011 @ 9:17

    thankxxxxxxxxxxx a lot..

  • Marifel Sep 9, 2011 @ 7:03

    …’it’s very simple/…

  • Marifel Sep 9, 2011 @ 7:09

    i learned this when i was first year college…

    • Dank Man Jul 31, 2016 @ 11:56

      Then why the fuck are you looking at tutorials?

  • prabhamuralidharan Oct 18, 2011 @ 11:59

    Really thank you very much!!!!!!!! because i was struggling with mysql how to create table and databases, now am clear all about that!!!!. In all aspects basic knowledge is very important. so this website have given that knowledge and the explanations also was very understandable! thank you very munch!!!!!!!!
    prabhamuralidharan

  • Naresh Oct 18, 2011 @ 16:51

    thanks for helping in such a simple way

  • satz Oct 29, 2011 @ 11:15

    This is awesome for beginners. Thnx

  • Rak Oct 31, 2011 @ 18:59

    Great Article for beginners like me.

    Appriciate your help. Keep up the good work.

    Thanks,

  • suresh Nov 15, 2011 @ 7:16

    hi ..thnx a lot.
    u helped me a lot..

  • Amol Jan 18, 2012 @ 13:27

    Hey thnkx….its realy good ….

  • PRABHAKAR MISHRA Jan 31, 2012 @ 9:26

    Thanks,

    It was real cool stuff!!

  • assu Feb 9, 2012 @ 7:01

    hai,thank u so much……………………….

  • jack Feb 14, 2012 @ 22:23

    thanks a lot!!!

  • subhash Mar 20, 2012 @ 15:34

    Great Article for beginners like me.

    Appreciate your help. Keep up the good work.

    Thanks,
    Thanks a lot.

  • Vijay Apr 2, 2012 @ 5:44

    thanks very good article..

  • Abhishek Apr 30, 2012 @ 11:33

    Actually First it was not working, then i tried again and it worked..! A Very GreatThank You for Article. I’ll Share this on every way possible!

  • Atheist May 2, 2012 @ 9:15

    Thanks a lot!

  • Flav May 4, 2012 @ 11:17

    Thank you so much for the help

  • ang May 9, 2012 @ 17:35

    Thank you very much, just what (and all) I needed

  • Ephesian May 13, 2012 @ 3:02

    Thanks a lot for the help. I followed your example and it worked well. This site is really helpful.

  • prakash May 24, 2012 @ 11:19

    Hi,

    Thanks for the simple syntax to understand the concept.

    Really appreciate u sir.

    Thanx
    Prakash……

  • Abhay Ramesh Chennagiri Jun 9, 2012 @ 19:35

    Thanks a ton…

  • sudhag Jun 18, 2012 @ 6:54

    Good HIT

  • vaybhav Jun 20, 2012 @ 5:43

    that was really helpful

  • pratik Jul 4, 2012 @ 6:30

    it i cant copy the code, but i can copy it from the view page source..HUH

  • sushma Gawande Jul 5, 2012 @ 7:01

    please give the details of more command so anybody can learn it himself.

  • arpita bose Jul 9, 2012 @ 8:59

    this is great fr a novice…thx!

  • wenzy Jul 10, 2012 @ 15:14

    tnx a lot..

    • bestman Oct 31, 2012 @ 8:41

      mysql

  • preeti Jul 24, 2012 @ 6:11

    hi
    sql me database ko isa tara hi programing krte h ky bolo……………………

  • rohan Jul 26, 2012 @ 18:48

    thank you very much for this valuable information.really appreciable.

  • Raj Nathani Aug 8, 2012 @ 19:32

    Thanks a lot man :)

  • Ritesh Aug 12, 2012 @ 20:16

    Thanx a lot…

  • mohan Aug 22, 2012 @ 13:23

    thank u sir@

  • dude Aug 28, 2012 @ 7:33

    Thanks, this helped a bit on my first go at sql. looks like I have a lot of reading to do ;)

  • Mohit Golchha Sep 5, 2012 @ 14:36

    thanks..!!:)

  • vicky Sep 9, 2012 @ 8:57

    tis sql queries r soo simple..and easy to understand…thanks

  • Damrudhard Sep 10, 2012 @ 5:33

    Thanks for writing the tutorial.
    God Bless you!

  • Lotake Dhiraj Sep 12, 2012 @ 6:42

    its usefull…..

  • Ria Sep 15, 2012 @ 7:07

    thankuuu

  • swapnil Sep 19, 2012 @ 8:29

    thank u

  • akbar Oct 1, 2012 @ 9:19

    dear any help me,
    i have create visual basic window form and how to add record in datagridview and update form pl help now i have frustrate

  • shibin Oct 6, 2012 @ 4:07

    thankx..

  • Neha Purohit Oct 7, 2012 @ 11:02

    It is good to start. :-D

  • aamir Oct 10, 2012 @ 5:58

    insert into new_table(‘product name’) values(‘abc’).

    I have a space in my column name. I want to insert and fetch the details from the column. can any one show me how to go about it .
    any help would be appreciated.

    thank you

  • mahen Oct 14, 2012 @ 14:34

    veyuseful tanks alot:——–

  • LeoPrince Oct 16, 2012 @ 5:28

    thankx a lot for this page

  • mohammed shiraz Oct 16, 2012 @ 5:31

    kept everything simple nice work man!

  • shadab Oct 17, 2012 @ 17:44

    Thanks, to save my time……..
    I was forgate actually, afterall it helps me…!

  • rupendra singh Oct 19, 2012 @ 17:51

    So thanks of u………

  • shashikant Oct 24, 2012 @ 4:29

    kindly suggest,how extract data from mysql database through php programming language?….
    give one example…

  • Engrr Abdul Rasheed Memon Nov 6, 2012 @ 10:05

    veyuseful tanks alot

  • bill Nov 11, 2012 @ 19:55

    Thanks a lot man. Really helpful.

  • Kiran Nov 18, 2012 @ 17:07

    getting an error . . javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:8888/contactdb

  • Stepmudere Nov 19, 2012 @ 14:06

    thanks a lot guys

  • Neeraj Nov 25, 2012 @ 14:58

    awesome yrrrrrr.,.,.,.,, really like it……
    it helps me alot……. thanx thanx thanx…… :)

  • Noor Dec 18, 2012 @ 17:03

    Really Really Brilliant…..
    100000000 stars from my side. Thanks a lot.

  • Anil Jan 3, 2013 @ 8:34

    thanks its simple and good example

  • sakthikumar Jan 7, 2013 @ 15:38

    thankyou

  • Bharath Jan 10, 2013 @ 5:11

    thanks……..
    it helped me and kindly can u tel how to connect mysql with php……..!!!!!

  • vishal Jan 15, 2013 @ 14:58

    hey
    thnxx its very helpful :)

  • lhon Feb 18, 2013 @ 5:04

    add me in
    thanks for this its very simple and understandable

  • ba Feb 21, 2013 @ 19:18

    Damn it, you’re awesome. I bought a book for $49 read for 3 hours, can not find out how to create a table, but after read yours in 15 minutes, boom, there I go.

  • Md. Mahidul Hasan Feb 25, 2013 @ 19:52

    Thanks, It is a great help for the new mysql learner like me !!! :D

  • winfred Mar 2, 2013 @ 15:49

    really am happy uve helped me. God bless u.

  • satheesh Mar 7, 2013 @ 5:05

    really excellent………..

  • Tushar Mar 19, 2013 @ 6:20

    Thank u

  • mussa kadir Mar 26, 2013 @ 11:14

    thanxs,i was able to solve my problem at last.

  • harry Apr 5, 2013 @ 19:03

    how i can create mysql from beigning

  • Bashi Apr 9, 2013 @ 14:41

    thanku yaar……… It helps me!

  • Malik zubair Apr 10, 2013 @ 7:53

    How to create data base and how i can implement it?

  • relik Apr 25, 2013 @ 22:08

    love this website. thanks.

  • k. arun May 5, 2013 @ 5:38

    thanx sir

  • Sabareesh May 15, 2013 @ 6:36

    Good one dude..Thanks

  • Nitin Jun 14, 2013 @ 12:18

    good example but how can i copy other database table in my database.

    help me.

    • Nitin shrivatsva Jun 14, 2013 @ 12:37

      CREATE TABLE databasename2.tablename LIKE databasename1.tablename;
      INSERT INTO databasename2.tablename SELECT * FROM databasename1.tablename;

  • abii Jul 5, 2013 @ 5:20

    thanxx

  • pawan Aug 8, 2013 @ 4:32

    how to insert database use in mysql

  • KOMAL Aug 10, 2013 @ 18:28

    Thank you so muchhh………very good start

  • fidaaslam Aug 15, 2013 @ 16:47

    thank you so much..

  • Naraimha Aug 29, 2013 @ 14:24

    it’s very easy to understand
    Thank u Very much

    • archana Sep 7, 2013 @ 5:51

      hai how to create data entery in online job

  • sam Oct 19, 2013 @ 6:49

    thanks u

  • jameel Nov 1, 2013 @ 5:36

    how to create the new database in php

  • s bhat Nov 4, 2013 @ 13:11

    I have uploaded and extracted wordpress from c panel file manager to root directory(public html) but after that cant create mysql directory, pl. give step by step instruction how to create mysql database and add wordpress.

  • neo Dec 4, 2013 @ 7:30

    good work. thanx

  • Nirmalya Dec 7, 2013 @ 7:49

    yeah great example…:)

  • khim lal Dec 17, 2013 @ 8:58

    Thanks for helping me to understand these basic step in such simple way.. :)

  • Suman jain Dec 20, 2013 @ 9:06

    my rows are not effecting . what might be the problem ?
    syntax is correct

  • Ananya Jan 22, 2014 @ 17:26

    Really helpful!

  • Raj Jan 30, 2014 @ 5:47

    Thanks a lot. Helped me very much.

  • ram Feb 5, 2014 @ 10:39

    its very nice, i understud that table

    Finally, add a data i.e. row to table books using INSERT statement, run:
    mysql> INSERT INTO authors (id,name,email) VALUES(1,”Vivek”,”xuz@abc.com”);

    Sample outputs:

    Query OK, 1 row affected (0.00 sec)

  • ankul Feb 9, 2014 @ 12:12

    how to enter the values by using “&” in mysql table ..from command prompt???

  • rohit Feb 20, 2014 @ 6:56

    thanks dear………..

  • vishal Feb 21, 2014 @ 9:00

    $ mysql -u root -p
    Above command is not running in my system even after entering root password.
    It show output as:
    ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
    So,how i will log into the mysql ?

  • Caracono Mar 14, 2014 @ 15:02

    Thanks! so helpful…

  • nyanji Mar 25, 2014 @ 8:36

    worked like a charm…thanks alot

  • Ram Mar 27, 2014 @ 7:31

    Thanx a lot

  • fred Mar 27, 2014 @ 13:11

    hi,can you pls help me create product form using php programming language in wed base.i mean the codes.tnks

  • Anitha Apr 4, 2014 @ 11:45

    Am new to Mysql, this article was very helpful for me and am very impressed with your document….thanks a lot ….

  • sheik Apr 9, 2014 @ 10:06

    thank u so much you are so great

  • Rinky Apr 13, 2014 @ 14:22

    thnaks to help us..

  • ritesh Apr 17, 2014 @ 6:22

    thankx alot this was very helpful.but can anyone tell me how to import data from terminal to table that is created in database.is there any kind of command.plz let me know

  • suchetan Apr 22, 2014 @ 12:09

    Thanks for the tutorial. :)

  • Ashraf May 5, 2014 @ 10:04

    Thanks to help us. It’s a good example…………….

  • sindhu May 12, 2014 @ 6:02

    hank u helped me alot

  • anup May 22, 2014 @ 17:43

    it was very helpful n very simple example……………..thanks alot

  • SAMWEL MMASA Aug 15, 2014 @ 21:09

    thanks a lot it very helpfull for me

  • Parshant singh Sep 2, 2014 @ 9:34

    thanks dude….

  • Nkateko Malungana Oct 15, 2014 @ 12:52

    Help me creating a books database using MySQL as indicated in the table

  • Kris Leblanc Oct 17, 2014 @ 12:14

    Good day, I have just started studying SQL, thank you for this tutorial on MySQL, I have been using Microsoft SQL server, and I wanted to try MySQL.

    I followed your instructions and I created a database, tables, and data, I did this same thing in MS SQL and used the following query to create a new table called result with a condition that screens > 1, here is my code:

    /* Using SQL Server syntax */

    /* creating the new table with a query */
    select
    t1.player_id,
    t1.name,
    t1.mac,
    t2.name as du_name,
    t3.name as config_name
    into [result]
    from player t1
    inner join display_unit t2 on(t1.player_id=t2.player_id)
    inner join configuration t3 on(t1.player_id=t3.player_id)
    where t2.screens > 1

    /* what is the syntax to get this to work on MySQL???/*

  • HASNAIN MEHMOOD Jan 8, 2015 @ 13:15

    blessn for u…………………….

  • shanny Apr 16, 2015 @ 11:04

    i have database and i need u to tell me how to import blob data from that database and write it in my client program . need to enter 10 data in the table here in client program.

  • Shakil Ahamd May 16, 2015 @ 11:17

    Very Helpful for me. keep it up

  • Tapan Das Jun 2, 2015 @ 12:45

    Thnx.
    It is very good & easy example of dbms to insert data in its .

  • saumya Jun 11, 2015 @ 9:05

    you helped me a lot thank you

  • warunwilliam Jun 15, 2015 @ 7:22

    thank dude i rate u five stars(*****)

  • SARAVANAN T K Jun 26, 2015 @ 9:07

    thank u very much ..

    super ji

  • rajendra khindkar Jun 30, 2015 @ 5:30

    thanks a lot ,its simple and good example for beginers

  • Rishabh Kumar Jun 30, 2015 @ 21:50

    Thanx Dude You Helped Me a lot

  • Nell Jul 17, 2015 @ 10:10

    Very helpful I was using outdated syntax and this tutorial helped me a lot with the current syntax. :D ♫

  • bala Jul 21, 2015 @ 6:09

    THANKS!!! THIS IS AWESOME

  • Sony saji Jul 29, 2015 @ 8:56

    Very helpful thank you!!!!!!!

  • Gutema Jul 29, 2015 @ 12:33

    very good tutorial I got what I want really!!!

  • abu nasar Aug 18, 2015 @ 5:35

    Very helpful,,,,thanks

  • vudang Aug 25, 2015 @ 9:59

    thanks,
    how to insert 10000 rows from file list.txt to mysql in centos

  • mallikarjuna rao Aug 29, 2015 @ 17:02

    plz hoe to insert data in table send date in my mail id plz my id is m.malli0005@gmail.com

  • A.Sen Sep 27, 2015 @ 6:36

    Very helpful indeed… Thanks a lot

  • shubham kashyap Oct 2, 2015 @ 17:25

    i waste whole one day to write basic sql stmt in cmd. so very helpful…thanku so much much much muchhhhhhhhhhhhhh……………………..

  • mohan Oct 16, 2015 @ 18:10

    Thanks…!!!!!!!!!!!!

  • pardeep Oct 26, 2015 @ 12:03

    iT WILL not work on live server. it will say permission is not available on server to that user.

  • Bashir Oct 28, 2015 @ 10:45

    Thanks for your contribution

  • pradeep yadav Nov 4, 2015 @ 5:10

    this is very helpful thnx

  • sam Nov 18, 2015 @ 11:40

    its helped me a lot ……………..thanks a lot

  • Prez Nov 22, 2015 @ 14:25

    cool and helpful !!!!

  • Richa Pasari Nov 29, 2015 @ 4:59

    what is the procedure for creating database for image and how to retrieve it

  • Bharath Dec 16, 2015 @ 15:33

    Thanks , it is very good example for create database and table and insert data.

  • Samuel May 10, 2016 @ 22:45

    please can you add daclearation of variables to it

  • Samuel May 10, 2016 @ 23:10

    this is good please i want more introduction sorry for the first comment;

  • evy Jul 8, 2016 @ 16:02

    very HELPFUL !!! thanks:)))

  • ocean Aug 2, 2016 @ 11:49

    Write a simple program to connect ms access database and insert data in the table named “student” which have four fields named “id”, “name”, “address”,”DOB”,and “class” can you please provide me a whole code?

  • Rumuz Nov 26, 2017 @ 20:54

    Thank you very much :)

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.