MySQL Workbench Create a table and Insert records

preview_player
Показать описание
Beginner level video of how to use MySQL Workbench to create a new table and insert records using SQL statements as well as directly editing in the table. Basics of tables and a few datatypes are covered including the difference between CHAR and VARCHAR

NOTE: I do mention this in my video but this is worth mentioning again:
I am creating a table that stores a user's name, email and password in plain text (not encrypted) JUST for demo purposes and so you can see it is writing properly. This is a TERRIBLE idea to do for a real project. In a later video I will demonstrate how to encrypt it while writing to the table with a PHP page so if you are storing a password be sure to use proper encryption.
Рекомендации по теме
Комментарии
Автор

Worth learning. You are very good with your presentation.

solomonl.quetee
Автор

Great video! Thank you for the clear and concise explanation. 👏

SIA
Автор

Wow thanks so much for
But what if you wanna insert from my winform code directly

sandylove
Автор

can we insert or delete data into table like in access in workbench ?

yubebute