@BroCodez

CREATE TABLE employees (
	employee_id int,
	first_name VARCHAR(50),
	last_name VARCHAR(50), 
	hourly_pay DECIMAL(5, 2),
	hire_date DATE

);

SELECT * FROM employees;

RENAME TABLE employees TO workers;

DROP TABLE employees;

ALTER TABLE employees
ADD phone_number VARCHAR(15);

ALTER TABLE employees
RENAME COLUMN phone_number TO email;

ALTER TABLE employees
MODIFY COLUMN email VARCHAR(100);

ALTER TABLE employees 
MODIFY email VARCHAR(100) 
AFTER last_name;

ALTER TABLE employees 
MODIFY email VARCHAR(100) 
FIRST;

ALTER TABLE employees
DROP COLUMN email;

@wolfdare1953

Crazy how you post this the same week as I start with SQL. Thanks a lot.

@swimsquirrelswim

I completely forgot how to do MySQL, after a year of not taking a subject that utilizes it.
Now I suddenly have an assignment due by midnight. So I just quickly needed a refresher.
Thank you for providing a short and to-the-point tutorial.

@imhungry7692

stop giving me exactly what I need for tomorrow every time its getting creepy .

@gamerslog4135

Your teaching methods are to the point, full of information, but can be easily and clearly understood. Thank you so much!

@andredubbs4854

hey bro, its so nice seeing you cover sql, an incredibly important language. thanks alot and keep the vids coming!!

@dejasbeautyxoxo1361

you are out here doing the LORD'S WORK THANK YOU!!!!!!!!

@Person_Alive

I'm gonna recommend this to everyone, your methods are just brilliant it goes to the point and just amazing thanks bro.
 (sorry for bad English still learning)

@HiraHana20

FINALLYYYYY, here's a series for SQL. Thanks a lot Bro!

@arvinvillalobos

Very good presentation, thanks for teaching us about how do we create a SQL table.

Greetings from Mexico.🎉

@gjbjagadish_185

bro ur beast in teaching

:thanksdoc:

@julianasnow71

This was really helpful.  I was stuck on how to change the type.  This answered my question.

@out-of-context_x

Thank you very much for a very useful hand-on training!

@spacex6997

I did not know that Mr Krabs had a first name.

@Diyanibeats

I’m self teaching. So I am a beginner and unfamiliar so please be patient with me. When do you use semi colons, asterisk and parenthesis? I know underscore is used for two words. Can you use sql for any software or is sql for a specific program ? What careers use sql? I see this skill listed under duties for data analyst . Thanks for this video very informative

@tablesidewithfirebride7927

Dude You're fantastic! Thank you for the videos!

@Oizys_Hiraya

can anyone help, it says this error  "Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar."

@Realshamsaba

reallyyyy happy to see you back again🥺🥺:elbowcough:

@Pikcspanda

Watching this before the exam😂

@Local-Seo-Nerd

Thank you so so so so so so so so so so much for this!