Skip to content

Instantly share code, notes, and snippets.

@AbudiMutamba
Created June 2, 2021 08:52
Show Gist options
  • Save AbudiMutamba/b52dff9ffc9d845c1598d0b23e0ea2b1 to your computer and use it in GitHub Desktop.
Save AbudiMutamba/b52dff9ffc9d845c1598d0b23e0ea2b1 to your computer and use it in GitHub Desktop.
My First SQL languge commands during the 1st Solver cohort at Ablestate creativities
#SELECT id, name FROM demo;
#INSERT INTO demo VALUES('7','David','Software Developer');
#SELECT * FROM demo;
#INSERT INto demo(name, hint) VALUES ('Uganda', 'The best country on the planet');
#UPDATE demo SET name = 'kenya' WHERE id = 9;
#DELETE FROM demo WHERE name = 'kenya';
#show DATABASES;
#USE db78196;
#SHOW TABLES;
/*CREATE TABLE students (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(100),
dob DATe,
PRIMAry KEY(id)
)*/
INSERT INTO students(name, dob) VALUES('Joanita','2001-06-10'),('charles','1999-12-08'),('Abudi','1998-26-10'),('Daniel','1997-10-28');
#use students;
#SELECT * FROM students;
/*INSERT INTO students(name, dob) VALUES('Abudi','1998-26-10'),('Daniel','1997-10-28');*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment