This repository includes some of mine practiced mysql problems including basic concepts, normalization, joins, Wildcards & Functions.
MySQL is the most popular open-source database management system used to organize data into one or more tables, having data types related to each other. These data types are used to extract, modify, or structure the data.
mysql start/login command: mysql -u root -p
Password: ********
Following are some of the helpful commands:
| mysql | client commands |
|---|---|
| ? | (?) for `help'. |
| clear | (\c) Clear the current input statement. |
| connect | (\r) Reconnect to the server. Optional arguments are db and host. |
| exit | (\q) Exit mysql. Same as quit. |
| help | (\h) Display this help. |
| status | (\s) Get status information from the server. |