Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # note: Must install pymysql: `pip3 install pymysql`
- import pymysql
- conn= pymysql.connect(host='localhost',user='root',password='password',db='s1',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
- a=conn.cursor()
- sql='CREATE TABLE `users` (`id` int(11) NOT NULL AUTO_INCREMENT,`email` varchar(255) NOT NULL,`password` varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;'
- a.execute(sql)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement