SQL knowledge notes are absolutely useful

1. know a field name, how to find it in the database in which table?

Use INFORMATION_SCHEMA;
SELECT table_name from COLUMNS WHERE column_name= ' field name ';

MySQL View library table field information is in Information_schemal, get data dictionary and other information to pass this view.

2. How do I find a constraint?

3. How do I view the build statement?

Show create table tablename;

To view the Jos_modules table Structure command:

Show create table jos_modules;

4. How do I view the table structure?

DESC TableName;

To view the Jos_modules table Structure command:

Desc Jos_modules;

5. How do I view table structure modification records for a table?

MySQL does not support direct viewing and can only be viewed through log files.

Oracle and SQL Server can.

SQL knowledge notes are absolutely useful