![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
金泽龙
这个作者很懒,什么都没留下…
展开
-
数据库名调整记录
改数据库名称先建好要改成的库create database rhyme;再单独改表名rename table rhymes.Cihai to rhyme.Cihai;rename table rhymes.Words to rhyme.Words;django调整修改settings里db2的库名为rhyme,再迁移python manage.py makemigrationspython manage.py migrate报错“Table ‘Cihai’ already exi原创 2020-10-29 16:53:44 · 111 阅读 · 0 评论 -
mysql存储过程建临时表和游标
CREATE PROCEDURE two(IN `mount` integer)BEGIN DECLARE aa INT(11); DECLARE bb INT(11); DECLARE cc VARCHAR(222); #select yin into bb from cihai where yin like '%/%' ; set aa = 1; drop TEMPORARY table if EXISTS temp; create TEMPORARY table temp(`lr` i原创 2020-09-03 09:50:00 · 278 阅读 · 0 评论