MySql Flashcards

1
Q

5 data types supported by MYSQL

A

INT, FLOAT, VARCHAR, TEXT and DAteTime

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How to start the MySQL client ?

A

MySQL -h dB-mysql.zenit -u uli705_a13 -p

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Show existing databases

A

show databases;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Show all the tables in the database

A

show tables;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Show all the columns from the table

A

show columns from products;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How to load data into the table automatically ?

A

load data local infile “fileName”
into table tableName
fields terminated by “,”
(columns name);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How lo login and execute a command file in a single line ?

A

mysql -h hostNam -u username -p

databaseName < command.txt

How well did you know this?
1
Not at all
2
3
4
5
Perfectly