MySQL INSERT Statement Searches related to insert statement mysql insert select statement mysql insert statement mysql java update statement mysql delete …
Original source
Beginners MYSQL Database Tutorial 3 # MySQL INSERT Statement Query
MySQL INSERT Statement Searches related to insert statement mysql insert select statement mysql insert statement mysql java update statement mysql delete …
Original source
36 responses to “Beginners MYSQL Database Tutorial 3 # MySQL INSERT Statement Query”
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
slomotion
I really like the method you are showing both the two methods of handling database tables, and compare them. Good habit 🙂
there's no Edit Table for me.. why is it?
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?
can you please tell me in how to connect the created query with the php.i am facing difficulty in doing this
Thank you, really nice videos. Understand everything
thank you and God bless
mysqlworkbench connection to java netbean sir i need a complet video :v th
Next time, use Capital letter for the first letter of any first and last names.
Thanks for uploading tutorials like this.
No joins No views…. Loll
Is it just me or is he making simple INSERTS off camera. Hell with this. Moving on to another tutorial. Too many simple issues.
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.
where did we get a table named edata? I'm confused.
well done
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
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.
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 ?!
thanks bro i get the basicallyc idea about instaling mysql database, creating tables and select the data from table. thanQ very much…..
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?
Thanks!
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 .
Please if anyone can help.
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.
Thanks Nate ! that helped
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.
Choose the "Select Rows" option instead. You'll see something similar.
when i right click on the name of the table, i am bot seeing edit table data. Please help
seems like your trying to input a character value, while 'id_departamento' is set to have only integer values.
the screen is not clear at times..pls check it
i hate sql ..
aww i hate those command line toturial !! :DDD
u are very helpful!!!
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')
Nice video to learn basics.