mysql 相关

First, dump your MySQL database in PostgreSQL-compatible format
########1、
mysqldump --compatible=postgresql --default-character-set=utf8 \
-r databasename.mysql -u root databasename


eg：
mysqldump --compatible=postgresql --default-character-set=utf8 -r utc1.mysql -u kmcfly testdatabase  -p


Then, convert it using the dbconverter.py script
########2、
python db_converter.py databasename.mysql databasename.psql



It'll print progress to the terminal.


Finally, load your new dump into a fresh PostgreSQL database using:
########3、
psql -f databasename.psql




#############################################################################
postgresq 登录命令
psql -U postgres -h localhost -p 5432
密码：
postgres


##error select * from results t1 left join "utc-exam_development.results" t2 on t1.id = t2.id where t2.id is null;

select * from db_dji_exam.results t1 left join results t2 on t1.id = t2.id where t2.id is null;


查看db_dji_exam.results 比results多的记录
select * from db_dji_exam.results t1 left join results t2 on t1.id = t2.id where t2.id is null;
查看answer_info比results多的记录
select * from answer_info t1 left join results t2 on t1.results_id = t2.id where t2.id is null;
查看answer_info表里results_id 重复的表

select * from answer_info where results_id in (select results_id from answer_info group by results_id having count(*) >1)