CREATE VIEW

I can't find this syntax in mysql tutorial and the program does not accept it. Is there another method of achieving this ? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Saving a table to a text file

I keep on getting errors for saving table to an external file. I think there is something wrong with the syntax. Could someone help me to correct it ? mysql mysqldump -r database table1; Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Inserting values via a SELECT statement

Is there any way that SQL can accomplish the insertion of values through a select statement, eg, INSERT into table1 VALUES ( select a, b, c, d from table2 where condition); Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Supported data types

Does MySQL support serial (auto-increment a number) and currency types ? It seems that both are not supported but I would just like to confirm this. Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Enquiry on rhe use of MySQL

Hi, I've just installed MySQL on my PC but do not know which program to access in order to use it. Does anyone knows ? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]