Sukriti Macker Profile picture
Jun 6, 2021 β€’ 7 tweets β€’ 2 min read β€’ Read on X
SQL is the most wanted skill in Data Science!! 😱

A Beginner's Guide to MySQL basic queries - Part 3!! 😎

Making mistakes while creating tables is common. Let's learn how to update and fix them! 😬

Thread 🧡
βœ… UPDATE THE TABLE

1. Add a column to the existing table:-

ALTER table table_name ADD (column_name datatype);

(Note: Adding a constraint to a column is optional)

πŸ‘‰ E.g., Adding the ADDRESS column to the classroom1 table. Addition of a new column to the table classroom1
2. Add MULTIPLE columns at once:-

ALTER table table_name ADD (colname1 datatype1, colname2 datatype2);

πŸ‘‰ E.g., Adding Email_id and ContactNo columns to the classroom1 table Adding multiple columns at once in classroom1 table.
3. Changing the name of a column:-

ALTER table table_name CHANGE old_column_name new_column_name datatype;

πŸ‘‰ E.g., Changing the column name rollno to ID Column Renaming
4. Modifying (Changing) the datatype of the existing column:-

ALTER table table_name MODIFY column_name datatype;

πŸ‘‰ E.g., Changing the datatype of the Address column to datatype CHAR. Changing the datatype of a column
5. Delete a column:-

ALTER table table_name DROP column column_name;

πŸ‘‰ E.g., Dropping the column EmailID from the classroom1 table. Dropping a single column
6. Delete multiple columns at once:-

ALTER table table_name DROP column colname1, DROP column colname2;

πŸ‘‰ E.g., Dropping the columns ContactNo & Address from the classroom1 table.

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Sukriti Macker

Sukriti Macker Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sukriti_Macker

Apr 4, 2022
Machine Learning Roadmap for BEGINNERS with resources!! πŸ€–πŸ§΅

1. Study mathematical concepts:-
a) Linear Algebra
b) Calculus
c) Probability
d) Statistics

2. Pick your programming language (preferably Python)
3. Start of with the basic Machine Learning Algos

4. Projects

5. Practice, practice, practice

Resources πŸ‘‡πŸ§΅
A) Linear Algebra
πŸ”— khanacademy.org/math/linear-al…

B) Calculus
πŸ”— youtube.com/playlist?list=…

C) Probability
πŸ”— edx.org/course/probabi…

D) Statistics
πŸ”— Notes: mathsbox.org.uk/twi/astats.pdf

πŸ”— Lec:
Read 5 tweets
Jan 31, 2022
Let's talk about R, shall we? πŸ‘©β€πŸ’»

8 Top Courses (FREE & Certification) for R Programming!! πŸ‘‡ 🧡
➑️ R Programming by @freeCodeCamp
Free 2 Hours course to get you started!

πŸ”—
➑️ R Programming by @simplilearn
Free 7 Hours course. Great for Beginners!

πŸ”—
Read 10 tweets
Jan 24, 2022
Statistics plays a crucial role in Data Science!! πŸ“Š

Do you should know how to understand & interpret your data?? πŸ€”

Top FREE Courses for Statistics you must check out πŸ‘‡πŸ§΅
➑️ FreeCodeCamp on YouTube

πŸ”—
➑️ KhanAcademy
This learning platform is the best! I just love it.

πŸ‘‰ High School Level Stats (for foundation)
πŸ”— khanacademy.org/math/probabili…
Read 7 tweets
Jan 11, 2022
Being in the industry of data science and machine learning, I cannot stress the importance of knowing Microsoft Excel. 🀯

Top 4 Free MS Excel Resources πŸ‘‡ 🧡
➑️ Microsoft Excel by freeCodeCamp

➑️ Microsoft Excel by Edureka

Read 6 tweets
Nov 27, 2021
Looking for Linux Command Line Courses?
Look no further! 🀩

Top 4 Free Linux Command Line Courses πŸ‘‡πŸ‘‡
Some might not know the answer to:-

What is Linux?? ➑️ linux.com/what-is-linux/
➑️ Linux Commands by Edureka
πŸ”—
Read 7 tweets
Nov 20, 2021
Learn Git and GitHub together!

Some of you may be new to the programming world. Don't worry! I got you. πŸš€

5 Top FREE resources for Git & GitHub πŸ‘‡ 🧡
➑️ Git and GitHub for Beginners - Crash Course
πŸ”—
➑️ Git & GitHub Crash Course For Beginners
πŸ”—
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(