wzgdavid的博客

建了3个触发器1create trigger t before insert on books for each row  set new.name = 'aaaddd'   2create trigger t3 after delete on books for each rowdelete from a_student where sid=old.id...

一开始表格定义时把某字段定义成整数了，想改成小数，alter的时候sqlite说语法错误，网上查阅了一下，原来sqlite不能直接修改字段的，我直接重来一次django建表的过程，居然行了。 去http://www.sqlite.org/download.html下个sqlite shell ，添加到环境变量中，我直接放在python目录下了。     1，修改mode...

    Welcome to Try Redis, a demonstration of the Redis database!Please type TUTORIAL to begin a brief tutorial, HELP to see a list of supported commands, or any valid Redis command t...

进入mysql命令行mysql -h localhost -u root -p  1.导出数据库（sql脚本）  　　mysqldump -uroot -p db_name > test_db.sql　　2.mysql导出数据库一个表　　mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名　　mysqldump -u wcnc -p test_db...

先update一下$ sudo apt-get update 安装mysql$ sudo apt-get install mysql-server mysql-client$ sudoapt-get installlibmysqld-dev$ pip install MySQL-python安装postgresql$ sudo apt-get install po...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)而且又不能重启mysqlsudo service mysql restart 网上有什么ln  没用解决杀进程 重启ps -A |grep mysqld k...

postgresql中的表和mysql中的表结构不一样，过程中做点转换，特别是datetime的insert还有activated 字段在原表中是布尔型，mysql表中是tinyint型  import psycopg2import MySQLdbimport datetime, timepsycopg2_conn = psycopg2.connect(...