Re: How to create a schema
* 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 copypaste 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
Re: How to create a schema
Thank you very much. That information is very helpful as I am just starting to use/learn MySQL. Raju Ganapathiraju From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Ayyaparaju Ganapathiraju [EMAIL PROTECTED] Subject: Re: How to create a schema Date: Wed, 19 Feb 2003 13:32:32 +0100 * 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 copypaste 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 _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - 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
How to create a schema
Hi, I have two questions here, please. 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. I'm aware that I can create multiple databases and switch between databases using use database name. 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. Any suggestions. Raju Ganapathiraju _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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
Re: How to create a schema
Maybe If I get you in the right way, the answer for your second question is you can use SQLYog or similar tools and can use them as a front end. http://www.webyog.com/ regards KS - Original Message - From: "Ayyaparaju Ganapathiraju" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 10:30 AM Subject: How to create a schema Hi, I have two questions here, please. 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. I'm aware that I can create multiple databases and switch between databases using "use database name". 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. Any suggestions. Raju Ganapathiraju _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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 - 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