Getting table metadata in MySQL

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: models/Category_model.php

Line Number: 35

Backtrace:

File: /home/datxeeu/public_html/mydiary/application/models/Category_model.php
Line: 35
Function: _error_handler

File: /home/datxeeu/public_html/mydiary/application/controllers/News.php
Line: 70
Function: get_category_name

File: /home/datxeeu/public_html/mydiary/index.php
Line: 292
Function: require_once

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: models/Category_model.php

Line Number: 41

Backtrace:

File: /home/datxeeu/public_html/mydiary/application/models/Category_model.php
Line: 41
Function: _error_handler

File: /home/datxeeu/public_html/mydiary/application/controllers/News.php
Line: 71
Function: get_slug

File: /home/datxeeu/public_html/mydiary/index.php
Line: 292
Function: require_once

Getting table metadata in MySQL

Created by Tung NGUYEN on 2016-01-08 16:53:32

Last modified on 2016-01-08 16:53:32

I'm trying to find out how to get the following constraint information from a table in MySQL 5.0:

See the question in stackoverflow:

show columns from table_name;

show fields from table_name;

show create table table_name;

Notes: Cuoi cau lenh sql, co the them \G hoac \g thay cho dau ; Thu xem se thay hay day

Category:

Tags: 0