All posts for tag "sql"
Total 1 posts
📄 Use ChatGpt to Write SQL
C:2023-03-21
M:2023-03-21
Get the information for a whole database change the string your_database_name to your database name
1 SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'your_database_name' ORDER BY TABLE_NAME, ORDINAL_POSITION; then you can use this information to question him.
multiple lines version:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA FROM information_schema.