New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

mysql技巧 #10

Open

ichengzi opened this issue Mar 27, 2020 · 0 comments

Owner

ichengzi commented Mar 27, 2020 •

edited

Loading

查询表的信息，查看表的大致rows

SELECT 
    *
FROM
    information_schema.tables
    where table_name ='xxxx'

查询表定义

desc tablename;//表名

ichengzi mentioned this issue

ichengzi issue 目录 #49

Open

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment