MySQL Workbench Create a table and Insert records

Описание к видео MySQL Workbench Create a table and Insert records

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.

Комментарии

Информация по комментариям в разработке