happy_wealthy的博客

import pandas as pdleft = pd.DataFrame({‘key’: [‘K0’, ‘K1’, ‘K3’],‘A’: [‘A0’, ‘A1’, ‘A3’],‘B’: [‘B0’, ‘B1’, ‘B3’]})right = pd.DataFrame({‘key’: [‘K0’, ‘K1’, ‘K2’, ‘K3’,‘k4’],‘C’: [‘C0’, ‘C1’, ‘C2’, ‘C3’,‘c4’],‘D’: [‘D0’, ‘D1’, ‘D2’, ‘D3’,‘d4’],})

Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'cloudwise';缺点：只是一个模糊查找

create table new_nickname select * from meta_info where company=‘guoshou’ order by RAND() limit 150;

select table_name from meta_info where company=‘guoshou’ order by RAND() limit 150;

SELECT table_name, table_rowsFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_SCHEMA = ‘’;

mysql数据库可以放各种字符create database XXXXXX character set utf8mb4;

import pandas as pd#创建数据库连接from sqlalchemy import create_engineengine = create_engine('mysql+pymysql://matching_user:[email protected]:3306/bixin_test')board = pd.read_sql_table('turn_board_history', engine)board.head()