mysql find tables with column name
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
AND TABLE_SCHEMA='YourDatabase';
mysql find tables with column name
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
AND TABLE_SCHEMA='YourDatabase';
how to output a different column name in mysql
-- MySQL
SELECT column1 AS name1, column2 AS name2
FROM table1;
-- AS allows your to replace the name of a column when outputting but does not
-- actually change the column name within the database.
php select data from mysql database without column name
SHOW COLUMNS FROM table_name;
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us