Mysql: Difference between revisions
From AWVVO
Jump to navigationJump to search
| Line 28: | Line 28: | ||
| | | | ||
|} | |} | ||
== Show column names in database == | |||
<syntaxhighlight lang="SQL" copy> | |||
SELECT TABLE_NAME, COLUMN_NAME | |||
FROM INFORMATION_SCHEMA.COLUMNS | |||
WHERE TABLE_SCHEMA = 'SFC' | |||
ORDER BY TABLE_NAME, column_name | |||
</syntaxhighlight> | |||
Revision as of 09:13, 12 March 2025
Create user
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'newuser'@'localhost';
| show version | mysql -V | ||
|---|---|---|---|
Show column names in database
SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'SFC'
ORDER BY TABLE_NAME, column_name
