• Sunday , 24 September 2017

Beginners MYSQL Database Tutorial 3 # MySQL INSERT Statement Query

Code Canyon



MySQL INSERT Statement Searches related to insert statement mysql insert select statement mysql insert statement mysql java update statement mysql delete …

Original source

3d Ocean

Related Posts

36 Comments

  1. Krish
    July 5, 2017 at 18:16

    How to open SQL Window, which is appearing on video. On the first day when I installed it appears on screen now is unable to open the window. Where to click for open SQL Window

  2. Kulbinder Singh
    July 5, 2017 at 18:16

    slomotion

  3. Trzbne
    July 5, 2017 at 18:16

    I really like the method you are showing both the two methods of handling database tables, and compare them. Good habit 🙂

  4. Mohammed Uddin
    July 5, 2017 at 18:16

    there's no Edit Table for me.. why is it?

  5. RHH1095
    July 5, 2017 at 18:16

    When you used query to insert data the column with fieldname of name was highlited in BLUE color.  Is there a reason for this change by MySQL?

  6. rishabh goel
    July 5, 2017 at 18:16

    can you please tell me in how to connect the created query with the php.i am facing difficulty in doing this

  7. priya katyal
    July 5, 2017 at 18:16

    Thank you, really nice videos. Understand everything

  8. Aura Arzadon
    July 5, 2017 at 18:16

    thank you and God bless

  9. Sajjad Ali KHAN
    July 5, 2017 at 18:16

    mysqlworkbench connection to java netbean sir i need a complet video :v th

  10. Be Humble
    July 5, 2017 at 18:16

    Next time, use Capital letter for the first letter of any first and last names.

  11. Be Humble
    July 5, 2017 at 18:16

    Thanks for uploading tutorials like this.

  12. Muhammad Usman
    July 5, 2017 at 18:16

    No joins No views…. Loll

  13. Jason Zimmerman
    July 5, 2017 at 18:16

    Is it just me or is he making simple INSERTS off camera. Hell with this. Moving on to another tutorial. Too many simple issues.

  14. Jason Zimmerman
    July 5, 2017 at 18:16

    I cant stand these damn links to the next video. Just spent a minute trying to click the x so that I can see the actual video behind it. But the x is behind the more info button on my screen. I don't know if it was like this for anyone else. But why put all the links in the beginning and middle of the video. What am I gonna do skip the last half of tut 3 and go to 4. At least put the links in the right spot so you don't make your video's annoying as fk.

  15. Jason Zimmerman
    July 5, 2017 at 18:16

    where did we get a table named edata? I'm confused.

  16. Idemudia onaiwu john
    July 5, 2017 at 18:16

    well done

  17. Ali Sattar
    July 5, 2017 at 18:16

    Thanks in advance 🙂

    This is the correct form to write any insert query and your query is not correct.

    INSERT INTO `database123`.`edata` (`idEmployeeInfo`, `name`, `surname`, `age`) VALUES ('your_employee_id', 'your_name', 'your_surname', 'your_age');

    Regards 😉

    Ali Sattar

  18. Pete Duindorp
    July 5, 2017 at 18:16

    I know you made this video many years about but I wanted to give you full credits for posting it. Especially with the error in it that you then solve during the vid. I am glad you didn't decide to re-shoot it but posted it as you worked on it. Nice work.

  19. Mohamed Zeid
    July 5, 2017 at 18:16

    When i Right click the table name i cant find edit table and i find another long menu other than the menu in the video ?!

  20. Bhanu Prakash Annaboina
    July 5, 2017 at 18:16

    thanks bro i get the basicallyc idea about instaling mysql database, creating tables and select the data from table. thanQ very much…..

  21. hasnain muzaffar
    July 5, 2017 at 18:16

    I have a question if someone can help.
    when I create a new database, Where mySQL save that file? If I need to copy that database at other Machine.
    Or how can I copy an existing database to other machine?

  22. Anu Anick
    July 5, 2017 at 18:16

    Thanks!

  23. litikify
    July 5, 2017 at 18:16

    if you are using the last version of mysql, then to edit the table select "select rows – limit 1000". After inserting the information select "apply" button, and after- "execute " button = "lightning" . When you will run again "select rows" you will see your previously inserted information . 

  24. simran singh
    July 5, 2017 at 18:16

    Please if anyone can help.

  25. simran singh
    July 5, 2017 at 18:16

    I am not able to "edit table". When I right click on the table there is no "edit table" option, only a "alter table" option which doesn't edit data.

  26. Syed Belgam
    July 5, 2017 at 18:16

    Thanks Nate ! that helped 

  27. Shane Raweewonrungjumrus
    July 5, 2017 at 18:16

    I am not able to "edit table". When I right click on the table there is no "edit table" option, only a "alter table" option which doesn't edit data.

  28. Mallusof
    July 5, 2017 at 18:16

    Choose the "Select Rows" option instead. You'll see something similar.

  29. Nyron Bhawani
    July 5, 2017 at 18:16

    when i right click on the name of the table, i am bot seeing edit table data. Please help

  30. Christian Jensen
    July 5, 2017 at 18:16

    seems like your trying to input a character value, while 'id_departamento' is set to have only integer values.

  31. rocky
    July 5, 2017 at 18:16

    the screen is not clear at times..pls check it

  32. Jaster Chan
    July 5, 2017 at 18:16

    i hate sql ..

  33. Xiao Qin
    July 5, 2017 at 18:16

    aww i hate those command line toturial !! :DDD

  34. Xiao Qin
    July 5, 2017 at 18:16

    u are very helpful!!!

  35. Jose Eduardo D' Luna Paredes
    July 5, 2017 at 18:16

    after add my information y click in apply and show me this error :

    "ERROR 1366: Incorrect integer value: 'negocios' for column 'id_departamento' at row 1
    SQL Statement:
    INSERT INTO `examen_db`.`departamento` (`id_departamento`, `nombre`, `profesores`, `cursos`) VALUES ('negocios', 'administracion', 'jorge ', 'espanol')

  36. Adi Narayana
    July 5, 2017 at 18:16

    Nice video to learn basics.

Leave A Comment

You must be logged in to post a comment.