mysql sp_helptext_sp_help for MySQL显示字段类型和外键约束？

最新推荐文章于 2023-02-24 23:41:48 发布

3hurricane

最新推荐文章于 2023-02-24 23:41:48 发布

阅读量426

点赞数

文章标签： mysql sp_helptext

本文链接：https://blog.csdn.net/weixin_36241866/article/details/113889713

版权

在MySQL中，可以借助SHOW CREATE命令来实现sp_help。

案例1 -

对于表，语法如下-SHOW CREATE TABLE yourTableName;

案例2 -

对于存储过程，语法如下-SHOW CREATE PROCEDURE yourProcedureName;

让我们首先创建一个表-mysql> create table DemoTable

(

EmployeeId int NOT NULL AUTO_INCREMENT,

EmployeeFirstName varchar(40) NOT NULL,

EmployeeLastName varchar(40) NOT NULL,

EmployeeAge int,

EmployeeCountryName varchar(40),

EmployeeCityName varchar(40),

PRIMARY KEY(EmployeeId),

UNIQUE KEY(EmployeeFirstName,EmployeeCityName)

);

让我们为表实现以上语法-mysql> SHOW CREATE TABLE DemoTable;

这将产生以下显示字段名称和约束的输出-+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table

+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| DemoTable | CREATE TABLE `demotable` (`EmployeeId` int(11) NOT NULL AUTO_INCREMENT, `EmployeeFirstName` varchar(40) COLLATE utf8_unicode_ci NOT NULL, `EmployeeLastName` varchar(40) COLLATE utf8_unicode_ci NOT NULL, `EmployeeAge` int(11) DEFAULT NULL, `EmployeeCountryName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, `EmployeeCityName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`EmployeeId`), UNIQUE KEY `EmployeeFirstName` (`EmployeeFirstName`,`EmployeeCityName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |

1 row in set (0.03 sec)