Browsing: 数据库
最近在查看服务器导出的MySQL sql文件时发现如下代码: /*!50001 CREATE VIEW `cxda_cheat_view` AS SELECT1 AS `studentID`,1 AS `name`,1 AS `gender`,1 AS `subject`,1 AS `result`,1 AS `detail`,1 AS `grade`,1 AS `politicalStatu
mysql报错: 1449 -The user specified as a definer (xxx@%) does not exist 一般发生在mysql切换服务器导入导出之后,在使用存储过程、视图时产生错误! 这是因为我们切换服务器后mysql的用户名设置错
最近有个需求,要在mysql的select查询结果中增加一个自增列,实现方法如下: 两句查完: set @rownum=0;select (@rownum:=@rownum+1),colname from [tablename or (subquery) a]; 一句查完: select @rownum:=@rownu
On Update和On Delete是SQL语言的一个标准,用于数据库外键定义,设置当主键表中的被参考列的数据发生变化时,外键表中响应字段的变换规则。 On Update表示主键表中被参考字段的值被更新
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
To understand the ne…
MongoDB和MySQL都是流行的数据…
To understand the ne…