get the mysql table columns data type mysql
SHOW COLUMNS FROM mydb.mytable;get the mysql table columns data type mysql
SHOW COLUMNS FROM mydb.mytable;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.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
