View gist:7c660580953a9562d5a7
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 |
View centerdiv.css
body | |
{ | |
margin: 0px | |
} | |
#horizon | |
{ | |
color: white; | |
background-color: #0ff; | |
text-align: center; |