Flashcards
SQL commands
Cards in this deck (25)
- 1To create the databaseCREATE DATABASE ;
- 2To show all the created databasesSHOW DATABASES;
- 3To select a specific databaseUSE ;
- 4To delete a databaseDROP DATABASE ;
- 5To create a tableCREATE TABLE
(Column_name Data type (size),
Column_name Data type (size)); - 6To see the created tableDESCRIBE ;
- 7To set a primary key to a table while creating the table (2 methods)CREATE TABLE
(Column_name Data type (size) PRIMARY KEY,
Column_name Data type (size));
CREATE TABLE
(Column_name Data type (size),
Column_name Data type (size)
PRIMARY KEY(Column_name)); - 8To set a primary key to a created tableALTER TABLE ADD PRIMARY KEY ;
- 9To set a foreign key to a table while creating the tableFOREIGN KEY REFERANCE<*Table2Name* (Column name)>;
*Foreign key එක ලබාගන්නා tableඑක * - 10To set a foreign key to a created tableALTER TABLE ADD FOREIGN KEY
REFERANCE ; - 11(1)Deleting the primary key (2)Deleting the foreign key(1)ALTER TABLE DROP PRIMARY KEY;
(2)ALTER TABLE DROP FOREIGN KEY ; - 12Deleting a tableDROP TABLE ;
- 13Deleting only the data in the tableTRUNCATE TABLE ;
- 14@ Editing a table @ (01)Adding columns to a table (02)Deleting a column(01)ALTER TABLE ADD COLUMN (Column_name Datatype (size) *NULL/NOT NULL*);
(02)ALTER TABLE DROP ;
*අවශ්ය නම් පමණි.* - 15Inserting data to a table (3 methods)(01) INSERT INTO (Table_name)
VALUES (Value1, Value2, Value3,....);
*(02) INSERT INTO (Table_name)
(Column1, Column2,....)
VALUES (Value1, Value2,....);*
(03) INSERT INTO (Table_name)
SET ;
*Columns යොදන පිලිවෙලින්ම Values යෙදිය යුතුය.* - 16Selecting all data from a tableSELECT * FROM ;
- 17Select data according to a condition [WHERE]SELECT (Column1, Column2,....) FROM (Table_name) WHERE AND/OR ORDER BY ASC/DESC GROUP BY ;
- 18To select the number of values of a specific attributeSELECT COUNT FROM *WHERE *;
** - 19To select the number of repeated valuesSELECT DISTINCT FROM ;
- 20Select data according to a condition [HAVING]SELECT (Column1, Column2,....) FROM (Table_name) HAVING AND/OR ORDER BY ASC/DESC GROUP BY ;
- 21Select the maximum valueSELECT MAX FROM ;
- 22Select the minimum valueSELECT MIN FROM ;
- 23To get the sumSELECT SUM FROM ;
- 24To update dataUPDATE SET WHERE ;
- 25Delete a recordDELETE WHERE ;
Information
- Description
- Information Technology Flashcards on SQL commands, created by Follow Goals on 20/05/2021.
- Created by
- Follow Goals
- Views
- 0
- Rating