* Ayyaparaju Ganapathiraju > 1). Is there an equivalent to creating a schema in MySQL. I would like to > create tables in multiple schemas within the same database. Some of the > tables will have foregign keys across schemas.
No, there is no consept of 'schema' in mysql, other than the implicit 'schema' resulting from the existing table definitions in a database. > I'm aware that I can create multiple databases and switch between > databases > using "use <database name>". Yes, and you can also use multiple databases in the same sql statement, using the database.table and database.table.column syntax: select db1.table1.col1,db2.table2.col2 from db1.table1,db2.table2 where db1.table1.id = db2.table2.id > 2). How can I edit a statement within mysql. Suppose if I make a > typo in a large select statement, can I go into an editor and fix > it, then execute it from the buffer. If you have a new version of mysql, see the standard client \e command. It is mentioned here, but I have not found any further documentation: <URL: http://www.mysql.com/doc/en/mysql.html > The \e command is not available in earlier versions of mysql, but I did not find any mention of it in the change history, so I don't know when it became available. Somewhere between versions 3.23.30 and 3.23.55. I normally use a text editor, and then either copy&paste my statements directly into the mysql client, or I execute it from a command line with: mysql dbname < script.sql (or "mysql -h host -u usrname -p dbname < script.sql") HTH, -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php