12. To create tables in uxtechno database:
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>DESCRIBE student;
Sample output:
How to setup mysql on Linux
You may like:
- Ultimate guide to configure logrotate utility
- 5 New features in RHEL 7 you should know about.
- 10 Steps about How to create LVM Volume
- How to execute commands on Multiple UNIX servers
- How to resolve “error: Failed dependencies:” error
- How to setup linux iSCSI target initiator on RHEL7 for Storage allocation
- 6 Columns of Linux FSTAB explained
- What is Linux standard input output error and how to redirect stdout and stderr to file in Linux
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.