Skip to content

Instantly share code, notes, and snippets.

Avatar

Anders Anton supermensa

View GitHub Profile
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;
You can’t perform that action at this time.