A Listing of MySQL Instructions. We just lately lined a subject MySQL at… | by Mandeep Kaur

0
8

On this Article we offer you detailed Info on A Listing of MySQL Instructions. We just lately lined a subject MySQL at… | by Mandeep Kaur
:

Mandeep Kaur
© Mandeep Kaur

We just lately lined a subject MySQL at Georgia Tech Coding Bootcamp. SQL, Structured Question Language, is a programming language designed to handle information saved in relational databases. SQL instructions are directions, coded into SQL statements, that are used to speak with the database to carry out particular duties, capabilities and queries with information. I want to share a listing of crucial instructions that are very important for a very good developer.

SELECT column_name
FROM table_name;

SELECT statements fetch information from a database.

UPDATE table_name
SET some_column = some_value
WHERE some_column = some_value;

UPDATE statements permit us to edit rows in a desk.

DELETE FROM table_name
WHERE some_column = some_value;

DELETE statements take away rows from a desk.

INSERT INTO table_name (column_1, column_2, column_3)
VALUES (value_1, ‘value_2’, value_3);

REALIZET statements add a brand new row to a desk.

CREATE DATABASE databasename;

CREATE DATABASE statements create a brand new SQL database.

ALTER DATABASE database_name
[COLLATE collation_name ]

ALTER DATABASE statements change the traits of a database.

CREATE TABLE table_name (
column_1 datatype,
column_2 datatype,
column_3 datatype
);

CREATE TABLE statements create a brand new desk within the database.

ALTER TABLE table_name
ADD column_name datatype;

ALTER TABLE statements add, delete, or modify columns in an present desk.

DROP TABLE table_name;

DROP TABLE statements drop an present desk in a database.

CREATE INDEX index_name
ON table_name (column_name1, column_name2…);

Index statements create on present tables to retrieve the rows rapidly.

ALTER TABLE table_name
DROP INDEX index_name;

DROP INDEX statements delete an index in a desk.

Thanks for studying.

#Listing #MySQL #Instructions #lined #subject #MySQL #Mandeep #Kaur