Published By
Created On
18 Feb 2020 15:21:29 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
MySQL - Add Records and Search Tables (insert, select)
Find code and diagrams at: https://www.EliTheComputerGuy.com
nsert into table(column1, column2) values(‘value1’,’value2’); – Inserts records into Table. TEXT type values need single quotation marks ‘ ‘.
Select * from table; – Selects ALL records from table and displays ALL columns
Select * from table order by column; – Selects all records, shows all columns and then orders by column.
Select * from table order by column desc – Changes ordering to be depending.
Select * from table where column = ‘x’; – Shows records where the value in column equals what is requested. For number values you can use = conditions and more.
Select column1,column2 from table; – Only displays data from specified columns
Select column1, column2 from table where column = ‘x’ order by column; – Shows specific columns where ‘x’ is true and is ordered by a column.
Setup MySQL Lab:
show databases;
create database classDB;
use classDB;
Create table users(
user_id INT Auto_INCREMENT PRIMARY KEY,
name TEXT,
age INT,
gender TEXT
);
show tables;
desc users;
...
https://www.youtube.com/watch?v=JSmJzvUo8wQ
nsert into table(column1, column2) values(‘value1’,’value2’); – Inserts records into Table. TEXT type values need single quotation marks ‘ ‘.
Select * from table; – Selects ALL records from table and displays ALL columns
Select * from table order by column; – Selects all records, shows all columns and then orders by column.
Select * from table order by column desc – Changes ordering to be depending.
Select * from table where column = ‘x’; – Shows records where the value in column equals what is requested. For number values you can use = conditions and more.
Select column1,column2 from table; – Only displays data from specified columns
Select column1, column2 from table where column = ‘x’ order by column; – Shows specific columns where ‘x’ is true and is ordered by a column.
Setup MySQL Lab:
show databases;
create database classDB;
use classDB;
Create table users(
user_id INT Auto_INCREMENT PRIMARY KEY,
name TEXT,
age INT,
gender TEXT
);
show tables;
desc users;
...
https://www.youtube.com/watch?v=JSmJzvUo8wQ
Author
Content Type
Unspecified
video/mp4
Language
Unspecified
More from the publisher
Controlling
VIDEO
YOUTU
youtube-community-guidelines-strikes
Eli the Computer Guy: https://www.EliTheComputerGuy.com
Failed Normal Videos: https://www.FailedNormal.com
The Daily Blob Podcast: http://thedailyblob.com
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
TELL
tell-the-world-what-you-want
Many times all you need to do to get what you want is to ask. The simple act of asking can bring valuable results that may go above and beyond what you imagined was possible.
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
MASS
mass-delete-unused-tags-in-wordpress
No description available
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
MYSQL
mysql-data-types-introduction
Find code and diagrams at: https://www.EliTheComputerGuy.com
In MySQL, and other databases, you can set what type of data a value in a table can be. Whether it’s text, a number, or even a file. This is used to prevent bad data from being added to the database and stop issues such as “bob +2”.
There are numerous Data Types that can be used in MySQL. Even using a number can be an INT, FLOAT, DECIMAL and more.
You use the Data Type most appropriate not just for the current use of the database, but which you expect will work in the future.
You can create problems by using a Data Type setting that your use outgrows. So if you set a DECIMAL value to only accept 5 digits, but at some point you need to store 6 digits in that field this will case issues.
Front End Validation is used to try to prevent bad data from being sent to the database.
Acknowledgements from the MySQL database back end are used to prevent “silent failures” where data is not properly inserted into the database, but the user does not realize there is an issue.
MySQL Reference – https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQLTutorial Cheat Sheet – http://www.mysqltutorial.org/mysql-data-types.aspx
...
https://www.youtube.com/watch?v=Ajn6asmOPMg
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
TESLA
tesla-closing-stores-today
Eli the Computer Guy: https://www.EliTheComputerGuy.com
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
PROGR
programming-intro-what-are-coding
Find code and diagrams at: https://www.EliTheComputerGuy.com
...
https://www.youtube.com/watch?v=hXCQQ_wMfxo
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
PHP -
php-for-loops
For loops are ways to repeat specific code based on whether a condition continues to be true.
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
TICKE
ticketmaster-hacked-competitor-to
Download Podcast at:
iTunes - https://podcasts.apple.com/us/podcast/eli-the-computer-guy/id1526481218
Podbean - https://etcg.podbean.com
Spotify - https://open.spotify.com/show/00FRz8g7OkNZdR4WJpTZwr
...
https://www.youtube.com/watch?v=IKGy1UlwUWA
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
ONEWE
oneweb-launching-48k-internet-satellites
Download Podcast at:
iTunes - https://podcasts.apple.com/us/podcast/eli-the-computer-guy/id1526481218
Podbean - https://etcg.podbean.com
Spotify - https://open.spotify.com/show/00FRz8g7OkNZdR4WJpTZwr
...
https://www.youtube.com/watch?v=WJy5A1wkINE
Transaction
Created
4 weeks ago
Content Type
Language
video/mp4