MySQL

Question 1

RDBMS?

Answer 1

MySQL FTW!

Question 2

Start MySQL

Answer 2

mysql -h localhost -u root -p

Question 3

Create new database

Answer 3

CREATE DATABASE database_name;

Question 4

Change database

Answer 4

USE database_name;

Question 5

Create new table

Answer 5

CREATE TABLE newTable (field1 VARCHAR(30), field2 CHAR(1) NOT NULL, field3 INT NOT NULL DEFAULT 0, field4 DATE, field5 DEC (1,2), field6 BLOB);

Question 6

Describe a table

Answer 6

DESC newTable;

Question 7

Insert data to a table

Answer 7

INSERT INTO myTable (field1, field2, field3) VALUES (‘val’, ‘v’, ‘1’);

Question 8

Selecting data

Answer 8

SELECT field1 FROM myTable WHERE field2 = ‘ammatasiri’;

Question 9

Arithmetic operators

Answer 9

AND, OR, <>, =, <, >

Question 10

Arithmetic selection

Answer 10

SELECT field1 FROM myTable WHERE field2 = ‘ammatasiri’ AND field3 = 2;

Question 11

Like? No Facebook shit!

Answer 11

SELECT field1 FROM myTable WHERE field2 LIKE‘ammatahu%’;

Question 12

I’ve got “%” but WTF is “_” ?

Answer 12

SELECT * FROM myTable WHERE field2 LIKE‘_utto’;

Question 13

Single quotes?

Answer 13

Fuck yeah! But not for INT, DEC numbers when selecting

Question 14

”*” is asterisk right?

Answer 14

It’s a “star” retard. ESS KIU EL.

Question 15

Between

Answer 15

SELECT * FROM myTable WHERE field5 BETWEEN 5 and 10;

Question 16

Do you love SQL, MySQL?

Answer 16

Son of a bitch.

Question 17

How about something different?

Answer 17

Pr0n?

Question 18

Can I use something else instead of OR?

Answer 18

SELECT * FROM youStupidTable WHERE field1 IN (‘three’, ‘different’, ‘pigs’);

Question 19

w00t! Can I use NOT?

Answer 19

SELECT * FROM youStupidTable WHERE field1 NOT IN (‘stairway’, ‘to’, ‘heaven’);

Question 20

You mean, like everwhere?

Answer 20

Yes everywhere. NOT BETWEEN your crotch. NOT IN her pussy. NOT LIKE that bicth.

Question 21

How do you know all these?

Answer 21

Because I have a pirated PDF document of Oreilly’s Head First SQL.

Question 22

I can haz GUI?

Answer 22

phpMyAdmin, MySQL Workbench and blah blah blah! But command line is enough for learning.

Question 23

So that’s it?

Answer 23

This is just a premature ejaculation. There are more to learn on SQL. But I’m too lazy to use this website even. Correct if there are mistakes in flashcards. Kthaxbai!