clock  Mon - Sun 8.00 AM - 8.00 PM
fb
instagram
play store
pinterest

More

SQL Table

teknowize

SQL Table

1) SQL - Create a table

To create a table in the selected database.

 

Syntax -

create table table_name (
column1 datatype(range),
column2 datatype(range),
column3 datatype(range),
   ....
);

sql create a table

 

2) SQL - Show tables

To show all tables in the selected database.

 

Syntax -

show tables;

sql show table

 

3) SQL -Describe table name

To show detail about any table in selected database like number of fields, key, extra (auto-increment), data type, null etc.

 

Syntax -

desc table_name ;

sql describe table name

 

4) SQL - Delete a table

To delete a table in the selected database.

 

Syntax -

drop table  table_name ;

sql delete a table

 

5) SQL- Insert data into a table

To insert data in a table.

 

Syntax -

insert into table_name ( coloumn1_name, coloumn2_name, coloumn3_name, ………….. ) ;
values ( coloumn1_value, coloumn2_value, coloumn3_value, ……….);

sql inser data into a table

 

Note:- varchar value must be in the ‘…..’  or   “…..” when inserting data.

OR

We can also insert value by below code

Syntax -

insert into table_name;
values ( coloumn1_value, coloumn2_value, coloumn3_value, ……….);

sql insert data into a table

 

6) SQL - Show data of table

To show inserted data in the table which we created in the database.

 

Syntax -

select * from table_name ;

sql show data of table

 

7) SQL- Add column in a table

Using this, we can add a column in any table.

 

Syntax -

alter table table_name add column_name data_type(range) ;

sql add a column from table

 

8) SQL - Delete a column from the table

Using this we can delete any column from a table.

 

Syntax -

alter table table_name drop column column_name;

sql delete a column from table

 

 

Coursera, Codeacademy, Udacity, W3Schools, Udemy, Alison, TheNewBoston, edX, P.S.Codewars,Freecodecamp, Managing technical debt blog, Scrimba, Codepen, Codepen/challenges, The Odin Project, htmlreference.​io, cssreference.​io, Frontend Mentor, Dev Challenges, MDN, Code Mentor, Coding Dojo, CSS Battle, Codier, Ace Frontend, Can I Use, CSS Tricks, 30 Seconds of Code,tutorialspoint, Neumorphism, Shaddows Brumm, Fancy Border Radius, Glow Generator, Clothoid Corners, Glassmorphism, Clipy, CSS Filters, Base64 Image, Quantity Queries, Animations, Cubic-Bezier, Keyframes, Wait Animate, Transition.Style, graphic design, web design, website design, website builder, web developer, web designer, webdesign, ecommerce website, web design company, website creator, website designer, responsive web design, web development company, best website design, web design software, web page design, build a website, web developer salary, design website, web design courses, how to design a website, web design inspiration, website layout, web designer salary, web application development, ecommerce website design, web agency, software development company, web design tutorial, web programming, design company, website design templates, what is web designing, web developer jobs, website developer, web design agency, freelance web developer, web design services, freelance web designer, graphic design websites, web solutions, ecommerce website development, free website design, web development courses, webdev, web developers, web development tools, website design services, developpeur web, web design london, website design ideas, web designing and programming, design a website, web design and development, web dev, web development services, homepage design, best designed websites, cheap website design, learn web design, web design templates, web design tools, web design jobs, website design inspiration, web design india, flash website, website developers, designer websites, website services, website design cost, good website design, site design, simple website design, cool website designs, modern website design, graphic designer websites, webcode, best web design software, website making, free web design software, mobile website design, learn web development, front end web developer, how to become a web developer, web developer portfolio, web development company in india, python web development, web development tutorial, website company, website design and development, web company, webdesigning, professional website design, affordable web design, best web design company, creative web design, top website designs, website design pricing, web developer tools, how to develop a website

MySql