MySql Flashcards
1
Q
5 data types supported by MYSQL
A
INT, FLOAT, VARCHAR, TEXT and DAteTime
2
Q
How to start the MySQL client ?
A
MySQL -h dB-mysql.zenit -u uli705_a13 -p
3
Q
Show existing databases
A
show databases;
4
Q
Show all the tables in the database
A
show tables;
5
Q
Show all the columns from the table
A
show columns from products;
6
Q
How to load data into the table automatically ?
A
load data local infile “fileName”
into table tableName
fields terminated by “,”
(columns name);
7
Q
How lo login and execute a command file in a single line ?
A
mysql -h hostNam -u username -p
databaseName < command.txt