MYSQL

Question 1

What is it called when you add records to a table

Answer 1

Populate the table

Question 2

What is a data base?

Answer 2

An organized collection of data

Question 3

Display multiple things from multiple tables

Answer 3

Name of table.title1,title2,name of table.table1,table2

Question 4

Change a field

Answer 4

ALTER TABLE tablename CHANGE name1 name2 VARCHAR(10);

Question 5

What do you do to stuff in a data base?

Answer 5

Initialize

Question 6

Show a table

Answer 6

SHOW TABLES;

Question 7

Show a column

Answer 7

SHOW COLUMNS FROM dogs.nDogs

Question 8

What is a primary key

Answer 8

A method that the DMS uses to select specific records

Question 9

How to add a primary key

Answer 9

ALTER TABLE nFogs ADD PRIMARY KEY (sn);

Question 10

Add a uni key

Answer 10

ALTER TABLE nDogs ADD UNIQUE (sn);

Question 11

What is MUL

Answer 11

Not a primary or unique key. Multiple instances

Question 12

Anchor tags

Answer 12

SELECT make FROM vehicle WHERE make REGEXP
'^(M|D)' beg M OR D
'(^M|D)' beg M con D 
'S$' end of word 
'A' anywhere

Question 13

Create a variable

Answer 13

SET @variable=100;

Question 14

Remove a NULL field

Answer 14

DELETE FROM vehicle WHERE colour is NULL;

Question 15

GROUP BY

Answer 15

SELECT make, model, FROM vehicle GROUP BY model;

Question 16

Delete a record

Answer 16

DELETE FROM nDogs WHERE name=”name”;