Database application on C++ for Course work of Magestry second semester
Remember that the command names are case sensitive. So SELECT does not equal to select and command will not be recognized by program
Commands to use:
SELECT ['*' | `column_1`, `column_2`, ..., `column_N`] FROM table_name
WHERE column_x [
[!]= ['text' | 25]
|
[NOT] IN [('text1', 'text2', ..., 'textN') | (1, 5, 3, ..., N)]
|
[NOT] LIKE '%search query%'
];
INSERT INTO `table_name`
VALUES('col1_val', 'col2_val', 'col3_val', ..., 'colN_val'),
('col1_val', 'col2_val', 'col3_val', ..., 'colN_val'),
('col1_val', 'col2_val', 'col3_val', ..., 'colN_val');
DELETE FROM `table_name` [WHERE {USE WHERE SINTACSIS US IN SELECT}];
UPDATE `table_name` SET `col1`='col_val1', `col2`='col_val2', ..., `colN`='col_valN'
[WEHERE {USE WHERE SINTACSIS AS IN SELECT}];
CREATE TABLE `table_name` (
'col_1' INT,
'col_2' VARCHAR(286),
'col_3' TEXT,
...
'col_N' {COLUMN_TYPE}
);
CREATE TABLE `users` (
'name' TEXT,
'age' INT,
'username' TEXT
);
DROP TABLE `table_name`;