MySQL
Below are the most used MySQL commands: | |
For creating a table: | |
CREATE TABLE example (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER); | |
To grab everything from the table | |
SELECT * FROM example; | |
To get the number of rows from the table | |
SELECT COUNT(1) FROM example; | |
To insert a row into the table | |
INSERT INTO example (name, age) VALUES (‘veer’, 27); | |
To delete the row from the table | |
DELETE FROM example WHERE name = ‘veer’; | |
Updating a record | |
UPDATE example SET age = 30 WHERE name = ‘veer’; | |
Fetching rows on some condition | |
SELECT * FROM example WHERE name LIKE ‘%veer%’; | |
Fetching rows on multiple conditions | |
SELECT * FROM example WHERE (name LIKE '%veer%') AND (age > 25); | |
Fetching data only for selected fields | |
SELECT name, age FROM example where age > 25; | |
Explaining the execution plan of the query. It’s particularly useful if you need to figure out why a query is so slow. | |
EXPLAIN SELECT * FROM example; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment