Is it possible to Rename Database
Is it possible to rename a database? - 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
Compute SQL Function Not Supported
I take it the Computer SQL Function is not support by MySQL and if not is there a substitute for it? If you are unfamiliar with the command it works like this: SELECT type, price FROM products ORDER BY type COMPUTE SUM(price) You will get a summary of prices by type in your results.
RE: Compute SQL Function Not Supported
Okay I may have been a bit vague on my description. SELECT location, date, type, price, FROM products ORDER BY location, type, date Group By location, type COMPUTE SUM(price) Is there something similar for compute? -Original Message- From: Chris Bolt [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:07 PM To: [EMAIL PROTECTED] Subject: RE: Compute SQL Function Not Supported SELECT type, sum(price) FROM products GROUP BY type ORDER BY type I take it the Computer SQL Function is not support by MySQL and if not is there a substitute for it? If you are unfamiliar with the command it works like this: SELECT type, price FROM products ORDER BY type COMPUTE SUM(price) You will get a summary of prices by type in your results. - 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
RE: Compute SQL Function Not Supported
Please strike previous message the query should be: SELECT location, date, type, price, FROM products ORDER BY location, date, type Group By location, date, type COMPUTE SUM(price) -Original Message- From: Brandon Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:14 PM To: Chris Bolt; [EMAIL PROTECTED] Subject: RE: Compute SQL Function Not Supported Okay I may have been a bit vague on my description. Is there something similar for compute? -Original Message- From: Chris Bolt [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:07 PM To: [EMAIL PROTECTED] Subject: RE: Compute SQL Function Not Supported SELECT type, sum(price) FROM products GROUP BY type ORDER BY type I take it the Computer SQL Function is not support by MySQL and if not is there a substitute for it? If you are unfamiliar with the command it works like this: SELECT type, price FROM products ORDER BY type COMPUTE SUM(price) You will get a summary of prices by type in your results. - 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
RE: Performance MySQL with C-API
Not only database design but system as well. Drive speed, drive fragmentation and I/O resources can play a large factor in database speed. Could you have a better disk environment on the Solaris machine versus the win32-machine? -Original Message- From: Ansgar Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 9:29 AM To: [EMAIL PROTECTED] Subject: Re: Performance MySQL with C-API insert 200 strings + timestamps a second through the API. Does that sound too less or am I expecting too much? Do benchmarks or test results for the C API exist? If someone has more experience on this or knows a place where I can find out more, plz let me know. I just ran this test on a win32-machine with 500MHz, 196 MB RAM and IDE-drive: - created table test with 3 fields: id (unsigned int, primary key, autoincrement, not null), string (varchar 128), ts (timestamp 14) - generated 10.000 random string-values (32 chars each) and made 1 insert-query out of them: insert into test (string) values (randomstring1), values (randomstring3), ... values (randomstring1) - executed this query with mysql-front (same as C-API) Result: less than one second execution time! On our sun solaris (450MHz, 256RAM) the same query needed 1,6 seconds (through php!). I think execution time depends very much on database-design. Greetings, Ansgar Becker - 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