ysykzheng
ysykzheng
/ add_auto_increment_to_int_single_pk.sql
Last active
July 31, 2020 03:10
— forked from carlosrobles/add_auto_increment_to_int_single_pk.sql
Add auto_increment to all the single PRIMARY KEY of type int of a database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use main_db; | |
| DROP TABLE if exists temp; | |
| CREATE TABLE temp ( | |
| `table` varchar(250) DEFAULT NULL, | |
| `colum` varchar(250) DEFAULT NULL, | |
| `type` varchar(250) DEFAULT NULL, | |
| `number_of_PK` tinyint(2) DEFAULT NULL, | |
| `alter` varchar(250) DEFAULT NULL |
ysykzheng
/ kindle-resources.md
Created
September 30, 2018 16:35
— forked from weakish/kindle-resources.md
#kindle 电子书相关资源网站
ysykzheng
/ stackoverflow.sql
Created
September 12, 2017 02:38
— forked from gousiosg/stackoverflow.sql
Script to import the stackexchange dumps into MySQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Copyright (c) 2013 Georgios Gousios | |
| # MIT-licensed | |
| create database stackoverflow DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; | |
| use stackoverflow; | |
| create table badges ( | |
| Id INT NOT NULL PRIMARY KEY, | |
| UserId INT, |