MySQL vs PostgreSQL

Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Force index

Hi, A table have index1 and index2. A SQL use index1 on Table A. I'd like to use index2 on Table A. How can I do for using index2? ORACLE has SQL hint which is force SQL execution plan. Thank you for your advice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

I want to get schema infomation in MySQL DB for schema.

Hi. ORACLE DBMS have a information for table or column in database dictionary, such as, USER_TAB_COLUMNS, USER_TABLES. Don't have any data base dictionary in MySQL, as ORACLE? thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

I'd like to know SQL query for table description.

Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? thank you. -- MySQL General Mailing List For list