How to setup mysql on Linux

June 30, 2015 By admin 1 Comment

12. To create tables in uxtechno database:

mysql&gt; CREATE TABLE student (name varchar(20), age int(3));
Query OK, 0 rows affected (0.00 sec)
mysql&gt;

mysql> CREATE TABLE student (name varchar(20), age int(3));

Query OK, 0 rows affected (0.00 sec)

mysql>

13. To see fields of a table “student “:

  mysql&gt;DESCRIBE student;

1	mysql>DESCRIBE student;

Sample output:

Pages: 1 2 3 4 5 6 7 8 9

Jouni "rautamiekka" Järvinen says
June 30, 2015 at 7:51 pm

Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.
Reply