MySQL Control Center 0.8.8 released
Hi! After a very successful Alpha period, MySQL Control Center goes Beta ! All the critical features are already coded in this release and from now on, the next releases of the 0.8.X branch will only be minor-enhancements / features and bug-fix releases type releases. Apart from several bug-fixes and minor-enhancements, this release includes the following new translation files: French (Philippe Boxho) Russian (Alexander Ustimenko) Simplified Traditional Chinese (Deng Jie) German (Mat Leinmueller) We strongly suggest users upgrade their existing MySQL Control Center version to the new 0.8.8 release. Some of the new features in this release are: *Added support for command line parameters under Linux. *Added support for Restore Workspace *Trailing white-spaces from passwords are not stripped anymore. *Fixed a bug that didn't set empty passwords correctly when editing users. *Fixed a bug which crashed MySQLCC when connecting to a MySQL server which was started with the --skip-show-database option. * Fixed a bug which didn't parse correctly queries such as: SELECT f1 FROM t1 WHERE f1 LIKE 'Foo''%'; The complete changelog can be found at the following url: http://www.mysql.com/products/mysqlcc/changelog.html Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/?ref=mjdc __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com MySQL Users Conference and Expo http://www.mysql.com/events/uc2003/ - 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
MySQL Control Center 0.8.6 has been released!
Hi! MySQL Control Center 0.8.6 has just been released. MySQL Control Center will now be known as MySQL Control Center and *not* MyCC. It's short name will now be MySQLCC. 0.8.6 is pretty stable and is a recommended update for all users ! Some of the changes for this release are: *Renamed the executable name from mycc to mysqlcc .. the same goes for the main config directory and config file. *Added inline inserting capabilities to the Results Panel. *Added inline deleting capabilities to the Results Panel. *Inline-Editing now supports updating BLOB / TEXT Binary fields when the table doesn't have any keys or when the BLOB, TEXT or Binary field is defined as a key *One can now copy selections instead of cell-values in the Results Panel. *Enhanced the way copy works in the Query Window *Fixed a bug in the Create Alter Table window which didn't support NULL defaults and also didn't parse DEFAULT NULL correctly; One can now specify a NULL default by pressing CTRL + 0 (same as for inline editing). *Added several visual enhancements to the Query Window *Alter / Create Table doesn't reset the field length when changing the field type anymore unless the types are in different sets. *Double-Clicking in a read-Only-Column (Results Panel) now opens up the default editor .. that is ImageViewer for BLOB fields and the Text Editor for TEXT fields. *Disabled HTML rendering in the text editor. For more information read the Changelog.txt file included in the distributions! You can download MySQL Control Center from the following url: http://www.mysql.com/downloads/gui-mycc.html Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/?ref=mjdc __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com - 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
MyCC 0.8.4 released.
Hi! MySQL Control Center (MyCC) 0.8.4 alpha has been released. MyCC is the new GUI client developed and provided by MySQL AB which is a platform independent MySQL administration client based on Trolltech's QT toolkit. Currently Linux and Windows are supported. MyCC 0.8.4 is a bugfix release. MyCC 0.8.3 has a couple of critical bugs that affect users who will be using the newly added features: 'New Table' 'Edit Table'. If you are currently using MyCC 0.8.3 and are planning to use the above 2 features, please upgrade to the latest MyCC release. Inline Editing and CREATE ALTER Table screens are working. Since these features are new, we suggest you use them with extreme caution in production servers. Some of the new features included in 0.8.4 are: * CREATE ALTER Table screens * Inline Editing for query results * Load From File to BLOB/Text fields * Support for Unicode characters * Multiple queries can now be executed in the Query Window * Several enhancements * Several bug-fixes For more information, check the MyCC webpage at: http://www.mysql.com/products/mycc/index.html Download: http://www.mysql.com/downloads/gui-mycc.html Changelog: http://www.mysql.com/products/mycc/changelog.html Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/?ref=mjdc __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com - 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: MyCC problems with qt3.0.4
Hi!
This problem is now fixed in the current BK tree and will OK in 0.8.3.
Below is the modification you need to make MyCC work with Qt 3.04!
+++ mycc/src/CSqlEditor/syntaxhighliter_sql.cpp
@@ +125 @@
SyntaxHighlighter_SQL::SyntaxHighlighter_SQL()
: QTextPreProcessor(), lastFormat( 0 ), lastFormatId( -1 )
{
- formats.setAutoDelete(true);
+#ifdef WIN32
+ formats.setAutoDelete(true); //This avoids a mem-leak under Win32 ?
+#endif
hasSqlSyntaxHighlighting = false;
hasDatabaseSyntaxHighlighting = false;
QIntDictIteratorSqlFormat it(*g_SqlEditorStyles);
for ( ; it.current(); ++it )
if (it.current()-ID != SQLKeyWord::highlight_PARENTHESES_MATCHING)
addFormat(it.current()-ID, new QTextFormat(it.current()-Font,
it.current()-Color));
}
-Original Message-
From: Kevin Lester [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 2:36 PM
To: [EMAIL PROTECTED]
Subject: MyCC problems with qt3.0.4
I'm running a pretty standard install of RedHat 7.2 on a x86
machine. I compiled MyCC with qt3.0.4 and everything worked
well except when I closed a popup window the program would
seg fault. I re-compiled it using qt3.0.2 and it works fine
now. You might want to make sure that users know they must
use 3.0.2 if they want it to work properly. Of course
fixing the problem with qt3.0.4 would be nice as well. :)
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
___/ www.mysql.com
-
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: mysql on Linux
Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [EMAIL PROTECTED] - 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
MyCC 0.8.1 is released
Hi! MySQL Control Center (MyCC) is the new GUI client for MySQL databases. MyCC is developed and provided by MySQL AB - a commercial company that builds its business providing services around the MySQL database. MyCC is a platform independent graphical client which is based on Trolltech's QT toolkit. Currently source code as well as Linux static and Win32 binaries are provided. Compiling MyCC for other platforms should not require too much effort as long as MySQL QT compile properly. All users are recommended to upgrade to the latest version. MyCC 0.8.1 includes several bug-fixes and enhancements. Changes in release 0.8.1-alpha -- * MyCC now has support for Adding, Removing and Modifying users. * Updated the Spanish Translation File. * Several Minor bug fixes. * Fixed a bug that crashed Win9X / ME platforms * MyCC is now compatible with MySQL 3.22 * All non-working features are now disabled. * Better Memory Management. * Loading many tables now takes a lot less time. * All icons are now cached to provide better performance. * Fixed an bug in the Database Tree view. * Optimized several parts of the code. * Added Table retrieval method option in the server registration dialog. * Added 'Test Connection' in the server registration dialog. Please send comments / bug-reports and feature-requests to [EMAIL PROTECTED] You can download the latest version from: http://www.mysql.com/downloads/gui-mycc.html Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com - 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: MyCC version 0.0.8 alpha - BUG
Hi! I haven't found 0.8.1. When I do, I will upgrade. You can either get it from http://www.mysql.com/downloads/gui-mycc.html We just updated the website today :) It is apparent that you are setting an explicit window size and position The above is true. What I'll do is speed up the saveMe() method for the main window-manager which will save both coordinates and sizes for windows. Hopefully this will fix things out. The window-sizes position will be the same as the exit ones used in the previous execution. Thanks for you bug-report ...I'll fix this for 0.8.2. Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com I don't think that making the window smaller will solve the problem. It is apparent that you are setting an explicit window size and position, rather than letting Windows pick on. If you adopt the latter strategy, this problem should not occur on native multi-monitor systems, but may on certain 3rd-party solutions; and I wouldn't worry about those. Who wants to do special case coding for them anyway? I haven't looked into how to select a starting window size on a multi-monitor system: i.e. how do you get the display caps for each monitor as opposed to the display caps for all monitors together, or even how do you discover how many monitors are active on a system. I think I might do that tomorrow, as I'm curious myself. I haven't encountered this problem in other apps except WinMySQLadmin 1.3. This is probably because most apps either let Windows pick their size and position, or else use the exit size and position. Thomas Downing IPC Trading Systems, Inc. Fairfield CT, USA -Original Message- From: Jorge del Conde [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 5:00 PM To: Downing, Thomas Subject: RE: MyCC version 0.0.8 alpha - BUG Hi! First, I suggest you upgrade to the newest version which is 0.8.1. 0.0.8 was the first pre-alpha release and a lot of optimizations bug-fixes and much better memory management where done to 0.8.1. The window positions are not saved yet, this will be done by the next release (currently in the TODO file) Assuming the above doesn't make it to the next release, do you think making the initial window size smaller would fix things ? A dedicated mailing-list for MyCC has been created, the address is [EMAIL PROTECTED] ! Have you ever had these kinds of problems with any other application ? Regards, Jorge CUT - 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: SHOW STATUS LIKE 'Uptime'
Hi! Thanks a lot for you bug report. This has already been fixed and it will be available as soon as 0.8.1 (note the versioning scheme change) is released. Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Charles Burnett [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 5:05 PM To: [EMAIL PROTECTED] Subject: SHOW STATUS LIKE 'Uptime' Hi. I recently installed MyCC 0.0.8 on Windows XP, and when attempting to connect to a MySQL 3.22.30-MIPS server, MyCC crashes after automatically issuing the following command: SHOW STATUS LIKE 'Uptime'. I've tested this using the generic mysql client, and indeed the server reports that this is an invalid command. I've checked the MySQL manual, and this looks like correct syntax, but obviously my server does not like it. I've already tried upgrading to 3.23.47 but am having little luck attempting to compile it on my Cobalt RaQ2 (I'd probably need to update gcc and glibc, which I'm not willing to do at this stage). Can this be fixed? Thanks! - 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: MySQL, Red Hat Linux and php
Hi, As always, the best version of MySQL to work with is the latest stable release 3.23.46 :) Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:03 AM To: [EMAIL PROTECTED] Subject: MySQL, Red Hat Linux and php Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - 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: new user.
Hi, You can use DESCRIBE [TABLE_NAME] or SHOW FIELDS FROM [TABLE_NAME] or SHOW COLUMNS FROM [TABLE_NAME] I suggest you read the manual because this is explained thoroughly in section 6.6.2 http://www.mysql.com/doc/D/E/DESCRIBE.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Sumit Ranjan [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 3:19 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: new user. hi there ! can anybody please tell me what is the query to obtain the table strusture ??? TIA Sumit Ranjan - 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: make problems
Hi, A simple fix for this is to search for -lmysqlclient in PHP_DIR/config_vars.mk and replace it with -lmysqlclient -lz After that, you will need to run make again make install. Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Tom Cruickshank [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 5:21 PM To: [EMAIL PROTECTED] Subject: make problems Hello, I am not sure if this is the right mailing list but since it's a mysql related problem, I thought I'd give it a shot.. I am installing apache on my linux box with php4 capabilities. When I configured php4 I added the mysql option...in short..something like this... gunzip apache_1.3.x.tar.gz tar xvf apache_1.3.x.tar gunzip php-x.x.x.tar.gz tar xvf php-x.x.x.tar cd apache_1.3.x ./configure --prefix=/www cd ../php-x.x.x ./configure --with-mysql=../mysql --with-apache=../apache_1.3.x --enable-track-vars make make install cd ../apache_1.3.x ./configure --activate-module=src/modules/php4/libphp4.a make unfortunately, when I try make in apache, I get to this error gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/share/apps/mysql/lib -rdynamic -L/usr/share/apps/mysql/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lmysqlclient -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lm -lcrypt /usr/share/apps/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/share/apps/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/usr/share/apps/apache_1.3.20/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/usr/share/apps/apache_1.3.20' make: *** [build] Error 2 [root@test apache_1.3.20]# Would anyone have any ideas! Thanks! Sincerely, Tom Cruickshank - 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: Execute multiple scripts
Hi, The purpose of the execute parameter I to execute a command and then quit; An example of how to use the --execute or -e parameter follows: Prompt mysql -e select * from user mysql [prints everything from mysql.user to stdout] If you want to execute the contents of a file through the console, you would do something like: Prompt mysql --user=USER --password=PASSWORD DATABASE WI_UPUSER.sql Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Järkeborn Joacim [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:40 AM To: [EMAIL PROTECTED] Subject: Execute multiple scripts Hi, I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, CREATE TABLE, lots of INSERT INTO and finally a COMMIT. I need to run all these script in mysql console. My plan is to write a perl script that looks into the directory and fetch all *.sql scripts and then execute them in mysql console. But I can't running the mysql console with a script as parameter. I have tried the following commands: mysql --user=USER --password=PASSWORD DATABASE \. C:/Files/data/WI_UPUSER.sql mysql --execute=C:/Files/data/WI_UPUSER.sql --user=USER --password=PASSWORD DATABASE None of them works! How can I do this? BR Joacim - 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: INSERT INTO ... SET ...
Hi, From the manual: The col_name=expression syntax is supported in MySQL Version 3.22.10 or later. Section 7.21 INSERT Syntax http://www.mysql.com/doc/I/N/INSERT.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:56 AM To: [EMAIL PROTECTED] Subject: INSERT INTO ... SET ... Hi all, A week ago or so, someone on this list had a problem with inserting data. I thought the reason was because they had mixed up the INSERT and UPDATE statements. ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ... However, they said this statement works from the MySQL prompt. I have just found time to try this syntax today and I was amazed to find that it does work in MySQL though it didn't work for Access. In all the years I have worked/studied SQL, not once have I come across the INSERT INTO ... SET ... syntax. My questions are: 1. Is this a valid statement? 2. Is it ANSI standard? 3. Is this a MySQL feature / bug or do other DBs support this? 4. If it is valid, where is it documented? All the SQL books that I've ever come across, do not contain such a syntax. - 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: Adding to a database
Hi, You need to check the ALTER TABLE syntax in the manual. http://www.mysql.com/doc/A/L/ALTER_TABLE.html Unless you use the FIRST or AFTER clause, all the new fields will be added at the bottom of the table. This procedure will *NOT* break your database. Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Allen May [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 6:19 PM To: [EMAIL PROTECTED] Subject: Adding to a database I need some reasurance... I have an existing MySQL database that has basic user information. I am using it to authenticate users on our web site. I has ID, Password, FirstName, LastName etc. We want to add columns at the end of this database for more detail... City, State, Zip, Phone, etc. I am litle uneasy that I may completely mess up my existing database if I do this. Can someone give feedback of A) a better suggestion or B) if doing this will break my database? Thanks for any feedback. -Allen - 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: strange integer problem
Hi, Your syntax is incorrect. cout ID: *Row[0]; // it returns 48 too much It seems you are printing the ordinal value of Row[0] Try using cout ID: Row[0]; Instead. cout Name: (char *) Row[1]; This works because all you're doing is a casting to char * Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Christian Terboven [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 5:45 PM To: [EMAIL PROTECTED] Subject: strange integer problem Hi all! I`ve got a quite strange problem. When querying my database, all my integer values are exactly 48 too high. Assuming the following code (using Linux): Database layout: (ID INT, Name CHAR(100), ...) m_pResult = mysql_store_result(m_Connection); // get the first record m_iCurrentDataset = 0; mysql_data_seek(m_pResult, m_iCurrentDataset); MYSQL_ROW Row; Row = mysql_fetch_row(m_pResult); cout ID: *Row[0]; // it returns 48 too much cout Name: (char *) Row[1];// works fine Has anybody an idea? Thanks in advance Christian Terboven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - 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: Select and =MAX()
Hi, What version of MySQL are you using ? How is price defined ? .. In the below example, I defined price as float(9,2). mysql SELECT * - FROM a; +---+ | price | +---+ | 19.95 | | 10.99 | | 3.99 | | 3.45 | | 1.69 | | 1.45 | | 1.25 | +---+ 7 rows in set (0.01 sec) mysql SELECT price - FROM a - HAVING price=MAX(price); +---+ | price | +---+ | 19.95 | +---+ 1 row in set (0.01 sec) mysql Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: bobby [mailto:bobby] On Behalf Of R Talbot Sent: Wednesday, June 27, 2001 8:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Select and =MAX() Jorge When I issue your suggested commands here are the resulted rows.. mysql SELECT price -FROM shop -HAVING price=MAX(price); Empty set (0.01 sec) But when I issue... mysql select price from shop order by price desc; +---+ | price | +---+ | 19.95 | | 10.99 | | 3.99 | | 3.45 | | 1.69 | | 1.45 | | 1.25 | +---+ 7 rows in set (0.01 sec) Why?? - 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: Select and = MAX()
Hi, You are using an aggregate function (MAX) in a condition which requires you to use the HAVING statement instead of the WHERE statement. Your query should look something like: SELECT price FROM shop HAVING price=MAX(price); Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: bobby [mailto:bobby] On Behalf Of R Talbot Sent: Tuesday, June 26, 2001 7:16 PM To: [EMAIL PROTECTED] Subject: Select and = MAX() Following the Tutorial Creating and populating the table Shop in the db Test.. Why won't the following syntax work? mysql select price - from shop - where price=Max(price) ; ERROR : Invalid use of group function Bob T - 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: Table Creation woes
Hi, Your problem is a common mistake made by those who don't read the manual. http://www.mysql.com/doc/R/e/Reserved_words.html as described in the above web-page, describe is a reserved word. Regards, Jorge MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Matt TrollBoy Wiseman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 4:52 PM Subject: Table Creation woes can someone tell me what I'm doing wrong here?I keep getting the error You have an error in your SQL syntax near 'describe text, fulltext text, section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6 and I don't understand why: CREATE TABLE article( id INT (4) DEFAULT '0' NOT NULL AUTO_INCREMENT, title VARCHAR (128) DEFAULT '0', logosmall VARCHAR (128) DEFAULT '0', logolarge VARCHAR (128) DEFAULT '0', describe text, fulltext text, section VARCHAR (32) DEFAULT '0', type VARCHAR (32) DEFAULT '0', PRIMARY KEY(id), UNIQUE(id) ); - 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: what's the problem????
Hi Have you installed the service in the CSM (console service manager) yet ? Go to the command prompt and type [mysql_dir]\bin\mysqld-nt --install (mysqld-max-nt for MySQL MAX). Afterwards start the service by either going to the CSM and starting it or by typing net start mysql from the command prompt. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Jeff Davidson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 12:12 PM Subject: what's the problem We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed it) What next?? We've messed around with dos commands with no luck. We are obviously missing something vital??? What is it??? Help!!! Thanks - 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: ASP and my sql??
Hi, I would go for a CGI As Sinisa has already stated, it would make your data-retrieval front-end faster and more OS independent. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: Jorge del Conde [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:06 AM Subject: Re: ASP and my sql?? Hi everyone, 1) Thanks for all your ideas. 2) Infact I am already using C-API for data retrieval from mySQL and I want to provide admin utility to my application which runs on a web server.I donot want to use ODBC.It tends to bind my application mostly to windows.Currently I am considering the fllowing options: i) ASP ii) Using java swing in applets iii) A CGI program iv) Using AWT and applets v)Any other Your views will be of great value in selecting the right technology... Regards, Ravi --- Jorge del Conde [EMAIL PROTECTED] wrote: Hi Dennis, You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. This is not entirely correct. ODBC is merely just one more way to connect to MySQL. MySQL just like many other databases in the industry has an API which can be used to connect to the server with out going through all the Microsoft imposed protocols such as ODBC ADO. A good example of this is PHP (http://www.php.net) . In general, PHP does not use nor require ODBC to be installed in order to access a MySQL database. So is the case for Zeos (http://www.zeoslib.org/) which is a free set of components for accessing MySQL (and other databases) directly by means of the API calls rather than ODBC (for Delphi C++ Builder). In terms of Microsoft's software, which all support ActiveX, there is at least one COM object that I know of that can connect directly to MySQL without using MyODBC. Such component is called MySQLX and can be found in http://www.scibit.com . Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 7:06 PM Subject: Re: ASP and my sql?? It depends on what you mean by without using ODBC. You CAN connect to a MySQL database without a DSN name, you can just declare an IP address and a DB name, but I'm pretty sure that this method still uses the MySQL ODBC driver and it must be installed on the server. You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. PLUG I wrote a case study for ASPToday on ASP and MySQL integration. You can view the synopsis and the article by going to: http://www.asptoday.com/content/casestudies/20010302.asp /PLUG Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 1:03 PM Subject: ASP and my sql?? Hi, I wonder to know of any other ways to connect to mySQL from ASP without using ODBC Regards, Ravi - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http
Re: ASP and my sql??
Hi, There is a company called Scibit that develops a commercial AcitveX (COM) object called MySQLX that can be used to access directly MySQL from ASP or any other COM supporting language. the url is www.scibit.com Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - 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: ASP and my sql??
Hi Dennis, You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. This is not entirely correct. ODBC is merely just one more way to connect to MySQL. MySQL just like many other databases in the industry has an API which can be used to connect to the server with out going through all the Microsoft imposed protocols such as ODBC ADO. A good example of this is PHP (http://www.php.net) . In general, PHP does not use nor require ODBC to be installed in order to access a MySQL database. So is the case for Zeos (http://www.zeoslib.org/) which is a free set of components for accessing MySQL (and other databases) directly by means of the API calls rather than ODBC (for Delphi C++ Builder). In terms of Microsoft's software, which all support ActiveX, there is at least one COM object that I know of that can connect directly to MySQL without using MyODBC. Such component is called MySQLX and can be found in http://www.scibit.com . Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 7:06 PM Subject: Re: ASP and my sql?? It depends on what you mean by without using ODBC. You CAN connect to a MySQL database without a DSN name, you can just declare an IP address and a DB name, but I'm pretty sure that this method still uses the MySQL ODBC driver and it must be installed on the server. You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. PLUG I wrote a case study for ASPToday on ASP and MySQL integration. You can view the synopsis and the article by going to: http://www.asptoday.com/content/casestudies/20010302.asp /PLUG Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 1:03 PM Subject: ASP and my sql?? Hi, I wonder to know of any other ways to connect to mySQL from ASP without using ODBC Regards, Ravi - 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: Simple C++ question
Hi David, #include something.h #include somethingelse.h as you see, and are used. Use when the file you want to include is not in the same directory your project is in AND is available thought the compilers include path configuration. Use when the file you want to include is in the same directory as your project or when you define at compile time a path where some include files will be gotten from. This is a very basic C/C++ question and it is likable you'll run into many other problems, so I suggest to go to http://www.mysql.com/portal/books/html/ and get yourself a good C/ C++ book ! Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: David Ayliffe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 27, 2001 9:17 AM Subject: Simple C++ question Its been a while since i've last touched c++ and i'm trying to include two files stdio.h and mysql.h I know that to include stdio.h I enclose it in but mysql.h is in the same folder as the project I know I can't use but what do I use instead? Thanks lots David Ayliffe ([EMAIL PROTECTED]) - 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: Configuring PHP for MySQL
Hi, This Q should be asked in the php lists instead, but in the mean time, try configuring php like so: ./configure --with-mysql that usually does the trick when RPM's are installed ... Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 11:39 PM Subject: Configuring PHP for MySQL I just installed the latest version of MySQL (3.23.38 I believe) from an RPM on Red Hat Linux 7.0. My question is when configuring PHP4 I need to include the --with-mysql= ? statement. Where would the correct file be with the RPM install. I have tried almost every directory I can find that seems related to MySQL and I always get an error when I go to configure saying something like header files not found in __ (whatever directory I tried) Any help would be very appreciated!!! Thanks, and sorry for the newbie question. Justin Pease - 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: MySql on Windows 95
Hi, Yes, you can install MySQL in Win95 but keep in mind because of bugs in Win95 MySQL may not perform as expected. Win95 leaks memory each time a client connect to MySQL. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Charles Kugarakuripi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 6:18 AM Subject: MySql on Windows 95 Can I install MySql database on PC running win95 as an OS? Regards Charles - 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: How to create a script file?
Hi, Type all of the create statement in a text file (i.e. sql_file) and then just call mysql [database] sql_file from the prompt. As for the editor, you can use any common text file editor available (xemacs, vi, pico, nano). Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Vasu Thirumalai" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:48 PM Subject: How to create a script file? Hi!! I want to have a sql script to create the tables. i.e. have all the lines that I will type at the sql prompt in a script file called create_tables or something and execute that file to create the tables !! How to do ?Is there an editor for mysql where I can type out these lines. Please help me. Thank you Harini - 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: Trojan Horse Virus in MySQL?
Hi, None of the files located at www.mysql.com nor official mirrors contain viruses. The problem you're experiencing might be due to one the following: a) There is a bug in the "Trojan Remover" software you're using. b) You downloaded the latest MySQL-Win32 version from some non-official mirror. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Brian Gan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 11:38 Subject: Trojan Horse Virus in MySQL? I've had MySQL server 3.23.25 installed at first on my Windows2000 machine. Then Trojan Remover 4.17 some how suspected a "Sky Dance 3.03" trojan horse virus in \mysql\bin\mysqlshow.exe. Then I download and installed the newer version 3.23.35a today. There are 2 more executables that are suspected to have the same virus: mysqlbinlog.exe and mysqlimport.exe. Trojan Remover simply renamed these files so they cannot be run. Do these executables really contain trojan horse virus? Or it's just a mistake by Trojan Remover? Brian G. - 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: About licence
Hi, MySQL is distributed under GPL. That means it's free of charge. You can find and download the current version of MySQL at http://www.mysql.com/downloads/mysql-3.23.html How ever, do ask that Commercial Users take out one of our many support options to allow us to pay for the continued development of MySQL. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Piotr Szybiak" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 3:34 AM Subject: About licence Hi I am a 5th year student of University of Technology in Poznan (Poland). I would like to use MySQL in commerce project (Internet Auction). I will develope my Auction in Linux. Have I buy a licence from you ??? How many it cost. Pleace answer me, it is very important for me. Thank you. Piotrek -- Codzienne streszczenie prasy podatkowej, wzory formularzy a takze aktualne wskazniki i stawki. Odwiedzajac http://podatek.getin.pl/ jestes zawsze dobrze poinformowany! - 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: max connections
Hi, The maximum number of connections that mysql can accept is restricted by both: the OS and ulimit. In other words, you can set max_connections as high as you want without bypassing the limits specified in ulimit. If you do ulimit -n you should get the number of connections allowed (1024 by default I think) .. Read section 21.3 in the manual for having several servers running on different ports on the same machine. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 1:09 PM Subject: max connections hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - 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: Turn off MySql Warning Messages
Hi,
at a "@" before the command where you want to supress the error message:
I.E.
@mysql_connect("host",..);
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
___/
- Original Message -
From: "samsom, debra" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 22, 2001 11:28 AM
Subject: Turn off MySql Warning Messages
I would Like to Turn Off the following MySQL Connect Warning message.
Any
Suggestions???
Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in e:\program files\apache
group\apache\htdocs\dwg\dwg.php on line 22
Server Currently Unavailable
This is the code that is returning the above error message.
mysql_connect("localhost","root","")
or die ("Server Currently Unavailable");
Debra Samsom
Bristol Aerospace Ltd.
(204) 775-8331 3402
[EMAIL PROTECTED]
-
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: Error code 13
Hi, This sounds like a permissions problem. Make sure your database directory is set to 770 and that the files inside (tables) are set to 660. example: # chmod 770 demo # chmod 660 demo/* Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Rashid Zolqarnain" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 5:17 PM Subject: Error code 13 Hello, I copy a database "demo" from one server to another. The file types are the same as other databases that exist in the destination server. I stopped and restarted mysql server. When I try to use that database using the command "use demo" it gives me the following error "Error code 13 can't read ./demo" What could be be problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - 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: Unable to like libmysqlclient statically
Hi, Check that you have zlib installed and then just add -lz to the libraries you will be linking with. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Dave Juntgen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 3:18 PM Subject: Unable to like libmysqlclient statically Hello everyone.. I am trying to compile a CGI program written in C statically and I keep getting this one error. I am using MySQL version 3.23.31, the compiler error below shows that it is libmysqlclient.a that is having problems. Can anyone help? -Lgd -lgd -lcrypt -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib/my sql -lmysqlclient /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x99): undefined reference to `uncompress' /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x128): undefined reference to `compress' collect2: ld returned 1 exit status make[1]: *** [webchart.cgi] Error 1 make[1]: Leaving directory `/usr/local/prj/working/djuntgen/webchart_dev' make: *** [all] Error 2 Thanks for your help.. --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - 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: I have a question sir.
Hi,
It looks like if no C / C++ compiler is installed and if it is, it's not in
your path. Please tell us what OS is this and also send us the output of
the PATH environment variable.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
___/
- Original Message -
From: "???" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 25, 2001 8:50 PM
Subject: I have a question sir.
HI
I am installing mysql now.
But I got an error below.
Could you help me this problem.
**Error Message**
root@localhost mysql-3.22.32]#
./configure --prefix=/usr/local/mysql --with-ch
arset=euc_kr
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking target system type... i586-pc-linux-gnu
checking build system type... i586-pc-linux-gnu
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... no
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) no
checking for gcc... no
checking for cc... no
configure: error: no acceptable cc found in $PATH
[root@localhost mysql-3.22.32]#
-
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: Running mysql tests
Hi, you need to install the perl DBI package! What is DBI, sounds like data base interface or something like that. Do I need a latter perl or a different configure for my perl??? "The DBI is a database interface module for Perl. It defines a set of methods, variables and conventions that provide a consistent database interface independent of the actual database being used." --Tim Bunce visit the following url to get more information on DBI including downloads and all kinds of FAQ's. http://www.symbolstone.org/technology/perl/DBI/ Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "MacDonell, Dennis" [EMAIL PROTECTED] To: "'MySQL List'" [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 6:51 PM Subject: Running mysql tests Hi, There must be a simple answer to this but I'm not quite across it. I build mysql-3.23.32 yesterday, and seeing if everything worked. Going through the steps of INSTALL-SOURCE, everything seemed to be working until I got to the bit where you run all the tests. From the command line in /usr/local/mysql/sql-bench I typed ./run-all-tests I got the following message Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00502/alpha-dec_osf /usr/local/lib/perl5/5.00502 /usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf /usr/local/lib/perl5/site_perl/5.005 .) at ./run-all-tests line 36. BEGIN failed--compilation aborted at ./run-all-tests line 36. What is DBI, sounds like data base interface or something like that. Do I need a latter perl or a different configure for my perl??? Dennis ## Dennis Macdonell Systems Administrator AUSLIG mail: PO Box 2, Belconnen, ACT 2617 email: [EMAIL PROTECTED] ph: 61 2 6201 4326 fax: 61 2 6201 4377 ## - 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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Saving a query
Hi, I guess you're talking about Views. No, MySQL doesn't support views yetTo get arround it, put your query in your script (php ?) and if needed, insert it into a heap table (check the manual for heap tables). Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Steen Rabol" [EMAIL PROTECTED] To: "mysqllist" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 3:36 AM Subject: Saving a query Hi Is it possible to save a advanced query in the database and the call it from eg. php, like you can in Access ? Thanks in advance. Best Steen - 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: Error Code?
Hi, The problem you ran into is because you didn't start mysqld the right way! There are 3 options on how to start mysqld! a) cd mysql-distribution-directory ./bin/safe_mysqld b) Make a symlink from the mysql distribution to /usr/local/mysql so that you can start safe_mysqld from anywhere on the system c) provide full paths to safe_mysqld and mysqld. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Marcus Ouimet" [EMAIL PROTECTED] To: "MySQL" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 8:25 PM Subject: Error Code? MySQL was working fine but now it seems to be giving me an error: user:/usr/local/apache/bin# mysql -uusername -pmypassword Can't read dir of '.' (Errcode: 2) or user:/usr/local/apache/bin# mysqladmin -uusername -pmypassword create catalog mysqladmin: create of 'catalog' failed error: 'Can't create database 'catalog'. (errno: 2)' Any ideas? - 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: Dropping a field from a table
The ALTER TABLE syntax is explained thoroughly on section 7.8 on the manual
pages.
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
orADD [COLUMN] (create_definition, create_definition,...)
orADD INDEX [index_name] (index_col_name,...)
orADD PRIMARY KEY (index_col_name,...)
orADD UNIQUE [index_name] (index_col_name,...)
orADD FULLTEXT [index_name] (index_col_name,...)
or ADD [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)
[reference_definition]
orALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
orCHANGE [COLUMN] old_col_name create_definition
orMODIFY [COLUMN] create_definition
orDROP [COLUMN] col_name
orDROP PRIMARY KEY
orDROP INDEX index_name
orRENAME [TO] new_tbl_name
orORDER BY col
ortable_options
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
___/
- Original Message -
From: "Xavi Gracia" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 4:33 AM
Subject: Dropping a field from a table
Hi !
I'm new to the list, new to MYSQL in general, although not to SQL, and i was
wondering if it is possible to drop a field from a table in MYSQL and what
is the correct sintax to drop it.
I have been searching in the Dubois's MySQL book but it didn't told any
about, or at least i didn't found it.
Thanks in advance
-
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: Tables in memory
Hi, check the following for a description on HEAP tables. http://www.mysql.com/documentation/mysql/commented/manual.php?section=HEAP HEAP tables are suitable as temporary tables since they are not saved to disk. What you can do if heap tables suite your needs is to write a script which writes all of the records to another table. Keep in mind that if you use HEAP tables and mysql crashes, you will loose all the data. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Thierry Coopman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 5:04 AM Subject: Tables in memory Hi, I have read on some presentation that you can create a table in memory that then gets written to disk once every few hours. I can't find information about that in the documentation, but it would be a perfect solution for me. I need 500+ updates per second, so a table in memory would be the most ideal. But I was wondering if that table can be written to disc automaticly. (Once per day schould be enough actually) -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! You know that you are drinking too much coffee if: ... You speed walk in your sleep. - 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
