show columns for more than one tables

Dear all,
can i do something like this SHOW COLUMNS FROM Project_T,
Project_module_t ??

Did you try? what happened when you tried?

yes ofcourse i did try it. it gave me the following error:



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' tablename' at line 1

can you show your actual query? looks like you have an error with single quotes around your table names.