MySQL: How to create a TABLE

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;

hey bro code
i'm trying to tape the same scrito but i get 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.''

how to solve it please

Hello sir,
I'm glad that i found your channel to learn SQL. I'm completely new to this subject.
i came across an error while creating a table column (" hourly pay decimal(5,1)"). could you please clarify?

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.

Just wow❤

Legendary !

The Modify clause isnt working. It does'nt highlight or anthing like ALTER or SELECT, almost as if mysql is reading it as normal txt. Anyone else has this problem?

For numbers suppose if this is a real life job scenario, do we still use VARCHAR as a data type or is there any alternative to add larger numbers in a database? Like in Java you can use double or even long so is there something similar?

👍👍

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

Astrix is also known as star. <--- In simple words,

thanks bro

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

what a chad you are bro!!!

Why make things complicated using this SQL when companies can use excel and Microsoft access?

sir thr was error in install the key ring pugin plss hlp

bro ur beast in teaching

More SQL please sir

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

Bro or Sir please upload REACTJS full course

React Js please!

React Js please!

SQL, sweet. Maybe react or firebase tutorials in the future.

Please create a full tutorial on rust

yo bro can u teach us php because im strugling with it ❤

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

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

Broilliant vid as usual.

Clear and and easy to follow.

Thanks Bro

bro i love u ur amazing

yes pleaaaase full SQL tutorial

Ty bro

Hey bro, love your videos!!
Would you consider making NoSQL,GIT/GITHUB,Linux terminal videos in the near future?

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

bro u are just awesome

Bro code!

Code king 👑 bro code

Bro, you are awesome, bro!

good to see u again

We want courses in cyber security and ethical hacking

thenks bro 🤔

reallyyyy happy to see you back again🥺🥺

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

thank you so much bro code I'm your handicap student

THANKS A LOT KING

Top top top

I’m a regular visitor on this channel hahaha

Thank you!!

SQL