SOME SQL COMMANDS FOR PHP

SQL COMMANDS:-My friend's know there is one question you sure thinking that what is the basic command that can help to use when we are making our website dynamically. I know this question arise cause of there are so many codes in SQL,  and if we know some of few commands, that is very useful:-
so lets start that main command :-

• SELECT- Extract the data from a database.
• UPDATE- Used to update data in a database.
• DELETE- Deletes data from a database.
• INSERT INTO- Insert new data into database.
• CREATE DATABASE- Create a new database.
• ALTER DATABASE- Modifies a new database.
• CREATE TABLE- Create a new table.
• ALTER TABLE- Modifies a table.
• DROP TABLE- Delete a table.
• CREATE INDEX- Create an index.
• DROP INDEX- Delete an  index.

1. SQL SELECT Syntax:-

                                SELECT column-name, column-name,   
                                FROM table-name;
                             
                               and,
                                SELECT *From Table-name;