retrieve data from more db
HI, I have data on more than 1 db to separate in year name like these: cust2000-- contain customer infomation in year 2000 cust2001-- contain customer infomation in year 2001 all db have the same field name. I have put db name and table name in separate file (something like include.php). How I write php code to retrieve my interest value to display in one time? for more help pls describe how to layout compare table in the code. Thank you, SF - 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
libmysqld
Hi, Can anyone tell me how i get a win32 mysql embedded library? Thanks, Jeroen - 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
Query speed
Hi All, Tried the following three statements and they are wither too slow or do not give me what I want. Basically what I want is to search for records for a whole month and display totals for that month for each individual day. The date field is indexed. Tried.. select count(num) as mycount from table_name where month(date) = 08 and year(date) = 2001 and action = 1 group by dayofmonth(date); this one takes too long As does this one. select dayofmonth(date) as mydate, count(num) as mycount from table_name where month(date)=08 and year(date)=2001 and action=1 group by dayofmonth(date); and this one just outputs the total figure for the month select dayofmonth(date) as mydate, count(num) as mycount from table_name where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by dayofmonth(date); can anyone help to point me in the right direction. many thanks Leon. - 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: Query speed
Hi, Check the section about How MySQL Optimizes queries for you version - there is a bit about how indices are not used when calling a function that may be relevant. Hope it helps Quentin -Original Message- From: Leon Noble [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 11:26 p.m. To: [EMAIL PROTECTED] Subject: Query speed Hi All, Tried the following three statements and they are wither too slow or do not give me what I want. Basically what I want is to search for records for a whole month and display totals for that month for each individual day. The date field is indexed. Tried.. select count(num) as mycount from table_name where month(date) = 08 and year(date) = 2001 and action = 1 group by dayofmonth(date); this one takes too long As does this one. select dayofmonth(date) as mydate, count(num) as mycount from table_name where month(date)=08 and year(date)=2001 and action=1 group by dayofmonth(date); and this one just outputs the total figure for the month select dayofmonth(date) as mydate, count(num) as mycount from table_name where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by dayofmonth(date); can anyone help to point me in the right direction. many thanks Leon. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
error starting mysql
i have installed MySQL on W2000 my my.ini is : [mysqld] basedir=C:/MySQL #bind-address=192.168.0.1 datadir=C:/MySQL/data #language=C:/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M innodb_data_home_dir = c:/IbData innodb_data_file_path = ibdata1:200M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 when i run mysqld-max-nt --console i have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files 011101 11:21:53 Can't init databases ??? - 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: Query speed
Leon Noble writes: select dayofmonth(date) as mydate, count(num) as mycount from table_name where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by dayofmonth(date); This query makes no sense at all. I don't think the date will ever be equal to that string constant, unless it's the special -00-00. Really, what you want to consider is all dates between 2001-08-01 and 2001-08-31, right? The why not use something like WHERE date BETWEEN '2001-08-01 AND '2001-08-31'? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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 starting mysql
Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: newby question about datetime fields
Hi ppl! I have a table with datetime type column in it. when I make request select * from my_table order by my_datetime I get the normal sort i.e. first the oldest dates but I want to get reverse sort to have most recent dates to be the first. How can I do this? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_20_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
VB/MySQL
Hi, Is it possible to work with VB and MySQL directly using dlls, just like working with VB and SQL Server. QB - 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 make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box
well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver make sure the mysql client is installed and try logging into the db from the clilike this: myslq -h some.host.com -u whoami -pMYPASSWD DBNAME if you get in then you've follow the instructions in the mysql handbook properlyRemember to use mysqladmin to reload the new grants before you try the remote connection...or you'll be left with some rather frustrating troubleshooting and quite probably the jitters from that extra few doses of coffee... cheers, m! [EMAIL PROTECTED] wrote: Can someone pls advise me on how to make a website running in an apache webserver on a Linux box connect to a remote mySQL database on a separate Sun box? Thank you. - (on foxtrot) Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the WPP Group shall be understood as neither given nor endorsed by it. - - 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: VB/MySQL
Yes it is possible, Create a System DSN by using Settings-- Control Panel --32 Bit ODBC data Sources. And use ADO to connect MySQL database. Hope this helps. Mustafa - Original Message - From: Quan Bang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 14:44 PM Subject: VB/MySQL Hi, Is it possible to work with VB and MySQL directly using dlls, just like working with VB and SQL Server. QB - 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 starting mysql
i log administrator i have created the directory c:\ibdata\ibdata1 same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: MySQLGUI?
Henrik Holmberg writes: Hi Can MySQLGUI start and stop the daemon? /Henrik It can stop it if you have root privileges on the server. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Update JDBC Driver (gweMysql Driver)
Hi, Michael Widenius wrote: Tomohiro, could you be kind and put a copy kind a put a link from the MySQL software portal to your page ? This way it will be easier for other MySQL users to find your software! http://www.mysql.com/portal/software/html/index.html Sure. Thank you so much. -- TAKAHASHI, Tomohiro - 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
Missing mysql_install_db on Windows binary distribution
I'm totally new to mysql so I may be asking a real dumb question here. Does anyone know whether the running of mysql_install_db necessary for the Windows distribution of mysql? I downloaded the binary mysql-3.23.43-win.zip file yesterday and ran the setup. However, there is no mysql_install_db installed (as described in the Technical Reference Manual. Is this still necessary? Also, is this what installs a test/sample database? Thanks in advance, Wilson _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 starting mysql
Hi! At 01:50 PM 11/1/01 -, you wrote: i log administrator i have created the directory c:\ibdata\ibdata1 Ok, that explains the error: ibdata1 should be a file. If you have a directory of the same name 'ibdata1', then Windows tries to open a DIRECTORY for reading, which does not succeed, of course. Make sure you have directories C:\ibdata and C:\iblogs but no subdirectories to these. Regards, Heikki same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERROR_ACCESS_DENIED Maybe you should log in to your Win2000 computer as the Administrator? when i run mysqld-max-nt --consolei have the error message: InnoDB: operating system error number 5 in a file operation. InnoDB: operating system error number 5 in a file operation. InnoDB: Error in creating or opening c:\IbData\ibdata1 InnoDB: Could not open data files011101 11:21:53 Can't init databases Regards, Heikki http://www.innodb.com/ibman.html - 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: newby question about datetime fields
select * from my_table order by my_datetime DESC -Original Message- From: brainheap [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 5:16 AM To: MySQL mailing list Subject: newby question about datetime fields Hi ppl! I have a table with datetime type column in it. when I make request select * from my_table order by my_datetime I get the normal sort i.e. first the oldest dates but I want to get reverse sort to have most recent dates to be the first. How can I do this? Thanks for any help :0) Alex - 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 ignoring writes
Erik G. Burrows writes: I'm having a wierd problem with MySQL, that seems to be begging that I wait for the next release, but I wonder if anyone else is getting this. I'm running MySQL 3.23.42, and using the Berkeley DB table type to get transactional ability. Occasionally, MySQL will simply stop accepting INSERTs and UPDATEs to my tables! DELETEs work, but UPDATESs and INSERTs don't. All the actual data files are owned by mysql, group mysql, read/write for user and group, there's nothing in the mysqld.log or the error log, and there's plenty of space on the disk. Very wierd. It seems to be a datafile corruption problem, because I can restore the files from backup and the database will run fine, for a while. Any clues or workarrounds out there? -Erik G. Burrows Hi! To help us find a solution to this, please follow the information at http://www.mysql.com/doc/B/u/Bug_reports.html to make a complete bug report that we can easily reproduce at our end, preferably by just piping to the 'mysql' command line tool. If you manage to do this, then you should email it to [EMAIL PROTECTED] All repeatable bug reports posted to this list will be handled promptly. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: retrieve data from more db
Simply indicate the database name in you query: SELECT cust2000.mytable.*, cust2001.mystable.* FROM cust2000.mytable, cust2001.mystable WHERE cust2000.mytable.cust_ID=cust2001.mystable.cust_ID; -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:24 AM To: [EMAIL PROTECTED] Subject: retrieve data from more db HI, I have data on more than 1 db to separate in year name like these: cust2000-- contain customer infomation in year 2000 cust2001-- contain customer infomation in year 2001 all db have the same field name. I have put db name and table name in separate file (something like include.php). How I write php code to retrieve my interest value to display in one time? for more help pls describe how to layout compare table in the code. Thank you, SF - 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: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly
On Wed, 2001-10-31 at 21:53, [EMAIL PROTECTED] wrote: Description: Configuring MySQL 4.0.0 with --with-ssl causes the server to act as though interactive_timeout and/or wait_timeout were set to approximately 6 seconds, although the variables seem to have normal values. Thank you for bug report. I will reproduce and fix it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Räpina, Estonia ___/ 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: deadlock - Innodb Monitor
Gisella, At 04:24 PM 10/31/01 -0800, you wrote: Heikki, The output I get from the Monitor does not have the section -- LOCKS HELD BY TRANSACTIONS -- that I see in the manual (www.mysql.com/doc), section 7.5.9.1, The InnoDB Monitor. sorry, the manual lags behind the release. And 3.23.44 will again have an improved InnoDB monitor with somewhat different output. I see two transactions issuing table locks to the same tables, and within the same transactions, there are two locks in one table, one for the table (IX, what kind of lock is this?), IX means intention exclusive. It means the transaction may have row level exclusive locks in the table (inserted rows, or updated rows, or X-locks set by SELECT FOR UPDATE). and a record lock (X, exclusive?) for the secondary index?, X means exclusive yes. where the second transaction shows, two identical record locks for the index row? It can happen. I went to your company's doc site, http://www.innodb.com/ibman.html and also to the main page and could not find some information about how to interpret the output. For example, lock modes X, IX, S, ... sync array info reservation count, signal count, etc. and all short abbreviations. Sorry, the manual is not up-to-date, and much of that cryptic data is intended to myself for debugging purposes. It will take time to sieve the data which is useful for users. And of course there is the additional 1500 pages of documentation: the InnoDB source code :). In the problem I have it seems that I get a table lock and then a record lock on the same table, but on the index row. ?? When the test program I'm running gets the error 100, this is part of what the monitor outputs: = 011031 13:15:02 INNODB MONITOR OUTPUT = TRANSACTIONS Purge done for all trx's with n:o 0 3033149, undo n:o 0 0 Total number of lock structs in row lock hash table 3 ---TRANSACTION 0 3033122, OS thread id 2032, not started, runs or sleeps MySQL thread id 13, query id 143542 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033115, OS thread id 2020, not started, runs or sleeps MySQL thread id 12, query id 143545 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033156, OS thread id 2060, not started, runs or sleeps MySQL thread id 11, query id 143628 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033145, OS thread id 488, not started, runs or sleeps MySQL thread id 10, query id 143632 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033148, OS thread id 1872, not started, runs or sleeps MySQL thread id 9, query id 143619 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033131, OS thread id 1276, not started, runs or sleeps MySQL thread id 7, query id 143551 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033116, OS thread id 1256, not started, runs or sleeps MySQL thread id 5, query id 143587 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033151, OS thread id 1428, not started, runs or sleeps MySQL thread id 4, query id 143621 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 2956333, OS thread id 1956, not started, runs or sleeps MySQL thread id 3, query id 13 PCATEST3 192.168.1.113 PCAServer ---TRANSACTION 0 3033146, OS thread id 1548, active, runs or sleeps, has 3 lock struct(s), undo log entries 1 MySQL thread id 6, query id 143631 PCATEST3 192.168.1.113 PCAServer Trx read view will not see trx with id = 0 3033147, sees 0 3033144 TABLE LOCK table MyPCAServer/payinst trx id 0 3033146 lock_mode IX TABLE LOCK table MyPCAServer/walletpayinst trx id 0 3033146 lock_mode IX RECORD LOCKS space id 0 page no 298 n bits 672 table MyPCAServer/walletpayinst index idx_walletpayinst_payiindex trx id 0 3033146 lock_mode X ---TRANSACTION 0 3033144, OS thread id 1980, active, runs or sleeps, has 4 lock struct(s), undo log entries 1 MySQL thread id 8, query id 143630 PCATEST3 192.168.1.113 PCAServer Trx read view will not see trx with id = 0 3033145, sees 0 3033145 TABLE LOCK table MyPCAServer/payinst trx id 0 3033144 lock_mode IX TABLE LOCK table MyPCAServer/walletpayinst trx id 0 3033144 lock_mode IX RECORD LOCKS space id 0 page no 298 n bits 672 table MyPCAServer/walletpayinst index idx_walletpayinst_payiindex trx id 0 3033144 lock_mode X Record lock, heap no 1 RECORD: info bits 0 0: len 9; hex 73757072656d756d00; asc supremum;; RECORD LOCKS space id 0 page no 298 n bits 672 table MyPCAServer/walletpayinst index idx_walletpayinst_payiindex trx id 0 3033144 lock_mode X Ok, if the deadlocks come from the tables payinst and walletpayinst, then it looks like there are are record lock waits in the index idx_walletpayinst_payiindex A trx has an X lock on the supremum record of a page. That might be the high end of the index. The next step is for you to look what SQL statements access these tables, what indexes they use, and what kind of operations they do. Especially, do you use SELECT
RE: Help - Migration to mysql from a legacy ISAM
Ian Collins writes: So how do you use the HANDLER command in a C program? I perused the code for 3.2x for this, and ended up installing mysql-4.0.0. I found what I believe to be the code for HANDLER in libmysqld/sql_handler.cc in the functions, mysql_ha_open, mysql_ha_close, mysql_ha_read Am I correct (or, as I surmise, off on a tangent)? Are there any examples anywhere of how to use these? Many regards, Ian Collins. Hi! You do not use HANDLER command in C program. You run a query with a HANDLER command, like : if (mysql_query(mysql,HANDLER OPEN ...) { if (mysql_query(mysql,HANDLER READ ..) { mysql_store_result ... etc etc etc } } -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: ASP with MySQL
Raymond, I would expect so (although I haven't tried it), since both ODBC and OLEDB providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I have used MyODBC with VBA in an Access 2000 front end to a MySQL database, and it works, albeit with a few minor glitches and less than stellar performance. Both drivers are, I believe, available from the MySQL site http://www.mysql.com. Cheers, Fred Woolsey -Original Message- From: Raymond Tsang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:09 PM To: '[EMAIL PROTECTED]' Subject: ASP with MySQL Hi, I would like to ask if MySQL can work with ASP, providing I have installed ChiliASP on a Unix server. Thanks. Regards, Raymond Tsang Building Access Database Developer PowerTel Limited 55 Clarence Street, Sydney 2000 Tel: 8264 3839 Fax: 8264 4555 Email: [EMAIL PROTECTED] ** PowerTel Limited, winners of Broadband Wholesale Carrier of the year, CommsWorld Telecomms Awards 2001 Best Emerging Telco, Australian Telecom Awards 2001 ** This email (including all attachments) is intended solely for the named addressee. It is confidential and may contain commercially sensitive information. If you receive it in error, please let us know by reply email, delete it from your system and destroy any copies. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the prior written consent of the copyright owner. Emails may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems. We give no warranties in relation to these matters. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. ** - 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
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - 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 with MySQL
Raymond, We run ASP with MySQL constantly using both ADO and a JDBC connections to it and experience great stability with it... this is with ASP on a WinNT/Win2K platform... we've never tried ChiliASP best wishes Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) -Original Message- From: Woolsey, Fred [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:41 PM To: [EMAIL PROTECTED] Subject: RE: ASP with MySQL Raymond, I would expect so (although I haven't tried it), since both ODBC and OLEDB providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I have used MyODBC with VBA in an Access 2000 front end to a MySQL database, and it works, albeit with a few minor glitches and less than stellar performance. Both drivers are, I believe, available from the MySQL site http://www.mysql.com. Cheers, Fred Woolsey -Original Message- From: Raymond Tsang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:09 PM To: '[EMAIL PROTECTED]' Subject: ASP with MySQL Hi, I would like to ask if MySQL can work with ASP, providing I have installed ChiliASP on a Unix server. Thanks. Regards, Raymond Tsang Building Access Database Developer PowerTel Limited 55 Clarence Street, Sydney 2000 Tel: 8264 3839 Fax: 8264 4555 Email: [EMAIL PROTECTED] ** PowerTel Limited, winners of Broadband Wholesale Carrier of the year, CommsWorld Telecomms Awards 2001 Best Emerging Telco, Australian Telecom Awards 2001 ** This email (including all attachments) is intended solely for the named addressee. It is confidential and may contain commercially sensitive information. If you receive it in error, please let us know by reply email, delete it from your system and destroy any copies. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the prior written consent of the copyright owner. Emails may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems. We give no warranties in relation to these matters. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. ** - 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 - 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: ODBC Call Fails
Alex, If MyODBC is simply passing the query in this case along to MySQL, the MySQL engine will choke on the subquery IN (SELECT ..., since MySQL doesn't support subqueries. I have had success, however, using subqueries with Access and MySQL by linking the MySQL tables to Access using the Get External Data menu command, then processing the tables in Access. Hope this helps. Cheers, Fred Woolsey -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 6:29 AM To: [EMAIL PROTECTED] Subject: ODBC Call Fails Hi all, Not sure if this is the right place to ask this one but here goes! I'm trying to export an Access 2000 database to MySQL and remain using Access as the front end. Everything seems to be working fine, except for this one line of code which is giving me and ODBC call failed error. CurrentDb.Execute DELETE * FROM SpecialismForContacts WHERE (SpecialismForContacts.ContactID= Forms!frmPhotographingContact!txtContactID ) AND (SpecialismForContacts.SpecialismID IN (SELECT SpecialismID FROM Specialisms WHERE Specialisms.AreaID= cboArea )), dbFailOnError Does anyone have any insights to why this is? Alex - 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: Web Hosting
You might want to try Hurricane Electric, I've been using them for over a year, MySQL, Telent, cgi, email account, DNS support starting at $10/month. http://www.he.net They've been great. Cheers, T On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote: My current web hosting company (www.ehost.com) does not support MySql. Is there a way that I can install within my own CGI-bin library? If not, are there any other open-source RDBMS available that would work independently of hosting servic? Thanks, Joe Come visit http://www.joe-fan.com For the Fans, by the Fans ! - 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: Web Hosting
I use www.ccwebhost.com for about two years... $13/mo for 200mb of space and their tech support is beyond excellent! mySQL support, CGI-BIN, FTP, PHP4, SSI, SSL, etc... Anything and practically everything! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Tony [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 10:45 AM To: [EMAIL PROTECTED]; Joe Fan; [EMAIL PROTECTED] Subject: Re: Web Hosting You might want to try Hurricane Electric, I've been using them for over a year, MySQL, Telent, cgi, email account, DNS support starting at $10/month. http://www.he.net They've been great. Cheers, T On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote: My current web hosting company (www.ehost.com) does not support MySql. Is there a way that I can install within my own CGI-bin library? If not, are there any other open-source RDBMS available that would work independently of hosting servic? Thanks, Joe Come visit http://www.joe-fan.com For the Fans, by the Fans ! - 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 - 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 what does the and mean?
At 11:57 AM -0500 11/1/01, Barbara Ferrell wrote: i am typing a command C:\apache\mysql\bin mysql = C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = Andrew Murphy's help. but i wondered what it meant? i have looked in = the books.. is part of the DOS prompt. filename signifies input redirection, that is, that you want the mysql command to read as input the contents of the named file, rather than reading what you type in interactively. - 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: Web Hosting
I use netmegs.net for my metropets.org site and they have been wonderful - answer questions quickly and accurately, and virtually no down time. Anne - Original Message - From: Tony [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Joe Fan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 11:45 AM Subject: Re: Web Hosting You might want to try Hurricane Electric, I've been using them for over a year, MySQL, Telent, cgi, email account, DNS support starting at $10/month. http://www.he.net They've been great. Cheers, T On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote: My current web hosting company (www.ehost.com) does not support MySql. Is there a way that I can install within my own CGI-bin library? If not, are there any other open-source RDBMS available that would work independently of hosting servic? Thanks, Joe Come visit http://www.joe-fan.com For the Fans, by the Fans ! - 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 - 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
Truncated data on spaces..?
Hello, Does the data stored in a VARCHAR field get truncated on spaces? All my fields contain the data up to the first space... What should I use ? Thanks a lot, sincerely, Gil. [ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ] -- PGP public key at: keskydee.com/gil.asc ICQ: 3310801 - 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: Newsgroups
Try mailing.database.mysql. Unfortunately its one way, postings on the mailing list do make it to the newsgroup but postings on the newsgroup don't make it to the mailing list. Fred Van Andel - 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 what does the and mean?
i am typing a command C:\apache\mysql\bin mysql = C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = Andrew Murphy's help. but i wondered what it meant? i have looked in = the books.. Barbara, Asking Windows questions here is likely to attract all manner of unwanted attention... C:\apache\mysql\bin mysqlC:\apache\mysql\scripts\temp.sql... C:\apache\mysql\bin = the current DOS directory for MySQL to work properly (unless you set up a PATH) mysql = the program to be executed C:\apache\mysql\scripts\temp.sql... = the 'script' of SQL commands = a redirection pipe/modifier Normally after starting MySQL it will take all its commands from the keyboard. In this case you want it to work off the commands in the *.sql file. The redirection instructs that 'keyboard' commands are to be taken instead, from the *.sql file. Ok? =dn - 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: Re: Truncated data on spaces..?
database,sql,query,table At 12:29 PM -0500 11/1/01, Gil G. wrote: Hello, Does the data stored in a VARCHAR field get truncated on spaces? Trailing spaces, yes. All my fields contain the data up to the first space... What should I use ? One of the TEXT types. Thanks a lot, sincerely, Gil. - 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: Alphabetizing book titles
At 1:09 PM -0500 11/1/01, Ian M. Evans wrote: Back when I was working with MSSQL I needed to alphabetize movie titles in the proper library format where 'A' 'An and 'The are ignored. For MSSQL I was told to use: select * from titles order by case when title like 'The %' then substring (title, 5, 255) when title like 'A %' then substring (title, 3, 255) when title like 'An %' then substring (title, 4, 255) else Title end That worked like a charm, yet MySQL doesn't seem to accept that. Any solutions or advice? What version of MySQL are you using? Older than 3.23.3? -- Ian Evans Digital Hit Entertainment http://www.digitalhit.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: Trying to Start Two Servers
On Wednesday 31 October 2001 21:42, Gary Huntress wrote: I'm up to over 1 databases in one data directory and that is becoming a performance problem as users make their connections. I would like to begin running multiple servers on the same box.I made my first attempt tonight and was confused. Before I screw up a production box perhaps someone can tell me what I'm doing wrong. Wow. That's a lot! I always start my server with this script: safe_mysqld --log --datadir=/mnt/db -O wait_timeout=1000 -O max_connections=1000 We make totally separate directories: /database/instance1 /database/instance2 Within each tree, we have everything MySQL needs except the binaries. I.e. /database/instance1/etc config including my.cnf /database/instance1/run pid file, Unix socket /database/instance1/log log files /database/instance1/bin tuned scripts to run _this_ instance only /database/instance1/var database table directories for this instance /database/instance1/tmp temp dir for this instance. We leave the mysqld etc. binaries wherever they normally live. We start the whole thing with a slightly hacked version of safe_mysqld safe_mysqld --defaults-file=/database/instance1/etc/my.cnf That my.cnf file defines the port, socket, log files, data directory, temp directory etc. The scripts in .../instance1/bin are very important for what we do. They have hardcoded data in them to make them only work on that instance of the database. Thus, we can start and stop and instance by going into the instance-specific bin directory and running a script: db_ctrl stop We do _not_ have to pass the instance path. The reason for this is that it helps prevent a whole class of errors that the system admins might make accidentally by typing the wrong instance. They need to actually type the full path to the instance bin dir. That has helped reduce errors a lot. I still have an old data directory in /usr/local/mysql/var so I thought I could just change the pid, socket, and data directory via: safe_mysqld --pid-file=/usr/local/mysql/var/kettlebrook.pid --socket=/tmp/ mysql3307.sock --port=3307 --datadir=/usr/local/mysql/var -O wait_timeout=1000 -O max_connections=1000 to run it on port 3307. But, your Unix socket is in /tmp without any differentiation from the other instance. The primary server starts fine. When I run the second one, I have gotten address already in use errors (is there already a server running? or something to that effect) I thought I had successfully created a second *independent* server that nobody else should be using so I did: The address in use might be from the other socket, not the IP address. I would run mysqld directly on the command line and see what errors it tells you. I've had better luck debugging my my.cnf files that way than trying to use safe_mysqld. mysql -pmypassword -P3307 This will connect to the Unix port on localhost. If you want to connect to the IP side, you'll have to specify a host that is not localhost (the default above). connected ok , and did a processlist. It showed numerous web connections, and it apppeared that I was connected to my production server on 3306 rather than 3307. Use SHOW VARIABLES to make sure that the data dir is where you think it is supposed to be. Then, I issued mysqladmin -pmypassword -P3307 shutdown hoping to shut down the second test server. It shut down the main server on 3306, as evidenced by my webserver indicating connection problems. I was able to repeat this several times. Note above. You are not connecting to the port that you think you are. If you do not pass a hostname other than localhost, you'll connect through the Unix socket. My question is basically thisdid I somehow (probably in my first lame attempts) get some of my socket files mixed up and/or pid files and they were simply out of sync with the proper server?2) Should I be able to properly control two servers using the two safe_mysqld command lines above? We do it all the time. Just make sure that your sockets are differentiated and that you are using a FQDN if you are trying to connect via IP instead of a Unix socket. Best, Kyle bot fodder: sql, mysql, query -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MicroTelco Services saves money on every Fax: - Fax to email (FREE) - Fax to PSTN based Fax (Up to 95% Savings) - Fax Broadcasting: Send 100s of faxes to fax machines and email addresses in the time it takes to send just one! === So send a fax today and let us know what you think! For more info. visit: www.internetfaxjack.com === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: Importing fixed-width delimited large text files?
Damned filter. Anything quoted once is my post. Grrr... database,sql,query,table Erica Douglass writes: I have a text file that is fixed-width delimited (that is, fields are delimited by certain column widths.) What is the workaround for this? Will importing large files work if I have tab-delimited rows? If so, what is the procedure to convert from fixed-width delimited to tab-delimited? Yep, there's no way to specify a format like that with LOAD DATA INFILE, but tab-separated files work like a charm. I'd probably use sed to convert the data. Here's an example of something that would do the job for 3-column data with 3 characters in the first column and 4 in the second. Note that it doesn't strip trailing spaces from the fields. sed s/^\(.\{3\}\)\(.\{4\}\)/\1\T\2T/\3 filename filename.tab Replace the letter T with tab. You might have to hit ctrl-v tab to get a tab in the shell. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
DB permissions Question
Im sorry, this is a very basic question -- but I am new to using SQL via the web. I am on my own server, able to create databases/tables and manipulate them to my heart's content at the command line connecting as root. I cannot connect to the DBs any other way, however (e.g. logging in at regular admin or user level). And of course, when I try to run any sort of a query via a web browser using PHP code, I get a permissions error. Question 1: How do I set up permissions on the DB to accept record insert/update/select for any user. Question 2: For the function mysql_connect within PHP I don't understand what I should be using for user and Password to allow for this access. Apologies for this newbie question. References to a site that can take me through this and/or a simple explanation will be excellent! Anne - 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
no mysqladmin
Description: Just installed this release with rpm, which says: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost -p password 'new-password' Unfortunately there's no /usr/bin/mysqladmin file in my system. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Jose Solorzano Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.43 (Official MySQL RPM) Environment: System: Linux localhost 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Jun 7 18:00 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5072386 Jan 10 2001 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 10 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 10 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - 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: Editing Forms
MySQL provides a rich list of APIs with which scripts and programs perform data management. Other than directly entering INSERT and UPDATE commands directly at the mySQL command line, there is not built-in data entry functionality. Data entry (including, verification, validation, limit-checking) is performed by scripts (PERL, PHP) or programs, such as those written in C. SUBJECTIVE_OPINION The easiest method to create data entry is browser-enabled forms using a PHP script front-end. The API is quite extensive and easily handles tasks I've had to write hundreds of lines of code in years past. Since everyone has a browser on their desktop, this prevents you from developing thick-client interface. If some client-side calculations are required (thin-client technology), these can be easily handled in JAVA or JAVASCRIPT. Finally, having started from a browser-based application, migrating your application and database to the internet is far less costly and time-consuming /SUBJECTIVE_OPINION The lack of data-entry and programming functionality is a fact-of-life of the SQL-family of relational databases. Like you, I, too, come from a dBase/FoxPro/Access development world where these capabilities were built-in to the database engine itself. The SQL-family simply provides an API access to your data and leaves insertion, update, retrieval, and display to your own devices. -Original Message- From: Robert A. Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: Editing Forms I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end tool but am unsure of where Paradox is going and my customers are tired of the lost indexes and val files that come with Paradox even though I feel that it has served them very well. On to the question. I cannot get a sense of what a MySQL database would look like. In Paul Dubois's book and Sams Teach Yourself the references in the index have a paucity of references to data entry. The favoured version being to dump the data in from another file. I must write a data-entry front end for a large amount of data for a small business. Half of the code I usually write is meant to present the user with a fast, secure, set of customized data entry forms. I can find almost no code for this outside of the browser interface. Am I barking up the wrong tree with MySQL asking it to be something that its not or am I simply too myopic in my search. Can I put together a database that will function in a small office that may eventually, and I say this with some hesitation, move access of the data to the web. My problem is trying to envision the end product and am I am having great difficultly. Would Delphi and/or Kylix make this a viable operation. Thank You Robert Smith - 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: no mysqladmin
You don't need the /usr/bin/. Try just: mysqladmin -u root -p password 'new-password'. If your setting this for the first time, you don't even need the -p. Jason -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:37 PM To: [EMAIL PROTECTED] Subject: no mysqladmin Description: Just installed this release with rpm, which says: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost -p password 'new-password' Unfortunately there's no /usr/bin/mysqladmin file in my system. How-To-Repeat: Fix: Submitter-Id:submitter ID Originator: Jose Solorzano Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category:mysql Class: Release: mysql-3.23.43 (Official MySQL RPM) Environment: System: Linux localhost 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Jun 7 18:00 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5072386 Jan 10 2001 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 10 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 10 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - 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: Editing Forms
Hi, If your Paradox Apps are written in a reasonably DB-independent way using Delphi Components, and not expoiting and Paradox-only features (are there any?), then porting those same applications to MySQL via ODBC should be a manageable task. If you do need to start from scratch, and the functionality is simple, then an Access Forms app, using MySQL Linked tables would be an option. M2CW Quentin -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:38 a.m. To: [EMAIL PROTECTED] Subject: RE: Editing Forms MySQL provides a rich list of APIs with which scripts and programs perform data management. Other than directly entering INSERT and UPDATE commands directly at the mySQL command line, there is not built-in data entry functionality. Data entry (including, verification, validation, limit-checking) is performed by scripts (PERL, PHP) or programs, such as those written in C. SUBJECTIVE_OPINION The easiest method to create data entry is browser-enabled forms using a PHP script front-end. The API is quite extensive and easily handles tasks I've had to write hundreds of lines of code in years past. Since everyone has a browser on their desktop, this prevents you from developing thick-client interface. If some client-side calculations are required (thin-client technology), these can be easily handled in JAVA or JAVASCRIPT. Finally, having started from a browser-based application, migrating your application and database to the internet is far less costly and time-consuming /SUBJECTIVE_OPINION The lack of data-entry and programming functionality is a fact-of-life of the SQL-family of relational databases. Like you, I, too, come from a dBase/FoxPro/Access development world where these capabilities were built-in to the database engine itself. The SQL-family simply provides an API access to your data and leaves insertion, update, retrieval, and display to your own devices. -Original Message- From: Robert A. Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: Editing Forms I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end tool but am unsure of where Paradox is going and my customers are tired of the lost indexes and val files that come with Paradox even though I feel that it has served them very well. On to the question. I cannot get a sense of what a MySQL database would look like. In Paul Dubois's book and Sams Teach Yourself the references in the index have a paucity of references to data entry. The favoured version being to dump the data in from another file. I must write a data-entry front end for a large amount of data for a small business. Half of the code I usually write is meant to present the user with a fast, secure, set of customized data entry forms. I can find almost no code for this outside of the browser interface. Am I barking up the wrong tree with MySQL asking it to be something that its not or am I simply too myopic in my search. Can I put together a database that will function in a small office that may eventually, and I say this with some hesitation, move access of the data to the web. My problem is trying to envision the end product and am I am having great difficultly. Would Delphi and/or Kylix make this a viable operation. Thank You Robert Smith - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
RE: Installing Calendar 0.9.33 on Mac OS X
First pointer - what errors are you getting! -Original Message- From: Greg [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:32 a.m. To: [EMAIL PROTECTED] Subject: Installing Calendar 0.9.33 on Mac OS X Newbie here who has PHP and MySQL going, but can't figure out how to install calendar. I suspect this is because I don't understand UNIX and permissions and which account I'm in. Here are the instructions edited: Unpack the calendar software in its own directory somewhere where your web server will find it. Where might this be? I'm not at all clear on where the webserver will find it. I tried putting it my Sites folder. MySQL (from command line): mysqladmin create intranet (This will create a database named intranet.) I get an error when I try this from the command line. I went into mysql and created the database, but then the next command baffles me. Create the calendar tables using the supplied tables.sql file: MySQL (from command line): mysql intranet tables-mysql.sql (where intranet is the name of your database) I get an error. thanks for any help or pointers. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
PHP4 and MySQL
PHP4.0.6 claims to have MySQL with it. Is this all installed with one installation file? Is it just one run of the setup file and you have PHP and MySQL installed together? Benj - 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: PHP4 and MySQL
Benj Arriola writes: Knowing PHP supports every database, why on the download page it mentions something about MySQL? And why use the words built-in. I was assuming MySQL came with it already. Normally you need to link with the mysql client libraries, but PHP provides a substitute for those. There are some warnings about using the builtin MySQL support, but as fas as I recall it's only a problem if you have both PHP3 and PHP4 as concurrent apache modules. I might be wrong on this tho. I guess to find out, I'll have to install it, but being far from the US and with small bandwith, downloading large files is not always ideal to do. :-) There are plenty of mirrors, but they're all pretty well-connected to each other, so I think they mostly exist to provide a primitive form of load balancing. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: PHP4 and MySQL
Being a PHP programmer, I know that PHP supports almost every database invented on earth. Now on the download page: http://www.php.net/downloads.php Under Windows Binaries: PHP 4.0.6 zip Package says MySQL support BUILT-IN Knowing PHP supports every database, why on the download page it mentions something about MySQL? And why use the words built-in. I was assuming MySQL came with it already. I guess to find out, I'll have to install it, but being far from the US and with small bandwith, downloading large files is not always ideal to do. :-) I was just checking if someone has already got the latest PHP version for Windows and would ask if ever MySQL did come with it. Benj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 5:30 AM To: [EMAIL PROTECTED] Subject: Re: PHP4 and MySQL At a certain time, now past, Benj Arriola spake thusly: PHP4.0.6 claims to have MySQL with it. Is this all installed with one installation file? Is it just one run of the setup file and you have PHP and MySQL installed together? I'm sure it says something to the extent of having MySQL _support_ within PHP. If you get PHP from the source, then no...it's not a one click install and you've got both. http://www.php.net/manual/en/ref.mysql.php ~ELH~ -- Eric L. Howard e l h @ o u t r e a c h n e t w o r k s . c o m www.OutreachNetworks.com313.297.9900 Advocate of the Theocratic Rule - 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: PHP4 and MySQL
For windows binaries, if you want to enable other databases, you have to uncomment the associated .dll file in the php.ini. Php doesn't have a seperate dll file for mysql, as the module is build right in (you couldn't disable it if you wanted to). When you compile it directly, if you don't specify any options, then you automatically get mysql support. That's what it means by 'built in'. Chris -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 4:41 PM To: [EMAIL PROTECTED] Subject: RE: PHP4 and MySQL Being a PHP programmer, I know that PHP supports almost every database invented on earth. Now on the download page: http://www.php.net/downloads.php Under Windows Binaries: PHP 4.0.6 zip Package says MySQL support BUILT-IN Knowing PHP supports every database, why on the download page it mentions something about MySQL? And why use the words built-in. I was assuming MySQL came with it already. I guess to find out, I'll have to install it, but being far from the US and with small bandwith, downloading large files is not always ideal to do. :-) I was just checking if someone has already got the latest PHP version for Windows and would ask if ever MySQL did come with it. Benj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 5:30 AM To: [EMAIL PROTECTED] Subject: Re: PHP4 and MySQL At a certain time, now past, Benj Arriola spake thusly: PHP4.0.6 claims to have MySQL with it. Is this all installed with one installation file? Is it just one run of the setup file and you have PHP and MySQL installed together? I'm sure it says something to the extent of having MySQL _support_ within PHP. If you get PHP from the source, then no...it's not a one click install and you've got both. http://www.php.net/manual/en/ref.mysql.php ~ELH~ -- Eric L. Howard e l h @ o u t r e a c h n e t w o r k s . c o m www.OutreachNetworks.com313.297.9900 Advocate of the Theocratic Rule - 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 - 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: PHP4 and MySQL
Now on the download page: http://www.php.net/downloads.php Under Windows Binaries: PHP 4.0.6 zip Package says MySQL support BUILT-IN Knowing PHP supports every database, why on the download page it mentions something about MySQL? And why use the words built-in. I was assuming MySQL came with it already. I guess to find out, I'll have to install it, but being far from the US and with small bandwith, downloading large files is not always ideal to do. :-) Benj, Your interpretation is both reasonable, and a commonly taken one. [note to site authors: please consider] Unfortunately the operative word here is support, not MySQL. The observation is that the comment support built in only has meaning to those who have been using the PHP/MySQL combination for some time/versions of the software. At one time support was not built in and anyone wanting to access MySQL from PHP had to do something about it. If you (when you can) take a look at the PHP.ini file you will see that there is a list of extensions that can be used or ignored - think in terms of optional APIs - some want one db, some another, but no one wants to load up and use up space on unwanted interfaces. (At least up until recently) If you look there you will see MySQL in the list - together with a note that there is no need to 'activate' the extension. So much for history and understanding ambiguous statements on the web page (particularly to do so with an optimistic frame of mind - how much can I avoid downloading...) You must download a suitable version of the PHP software AND a suitable version of the MySQL software (source or compiled, *NIX or Windows, etc). However once you have endured those trials, you will be pleased to know that without further downloads/compiles/etc, the two will play together nicely on your machine! =dn PS go and make friends with someone who has a fast/permanent connection and a CD-burner! - 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
make fails on AIX 4.3.3 using the IBM xlc/xlC compiler
Hi! Garry == Garry Williams [EMAIL PROTECTED] writes: Description: Garry Note: Thanks to Mr. Chakarat Skawratananond Technical Consultant, Garry Rapid Port Team, IBM Server Group in Austin, TX USA for his Garry invaluable help in diagnosing these problems. Garry make fails because the _AIX32_CURSES symbol is defined before Garry including curses.h for the mysql.cc compile The reason we have this define defined in global.h is to avoid a problem with older AIX compiler/header files. If we remove this, then we will instead get a problem with other AIX systems :( Garry Here's the error: Garry - Garry --- Garry Target all is up to date. Garry Making all in client Garry xlC -ma -O3 -qstrict -qoptimize=3 -qmaxmem=10240 -DUNDEF_THREADS_HACK -I./../include-I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -c mysql.cc Garry /usr/include/curses.h, line 1751.14: 1540-0063 (S) The text bool is unexpected. Garry make: 1254-004 The error code from the last command is 1. Do you know why the define causes a problem? bool should never be defined in curses.h when compiling with a C++ compiler... Garry --- Garry Once this is fixed (by commenting out the #define's in the Garry global.h and my_global.h files -- see below for patch), the Garry link of client/.libs/mysqlbinlog from client/mysqlbinlog.o Garry fails. This failure is owing to an undefined symbol: Garry ._my_b_write . cut Garry This failure is because the mysqlclient library was linked with Garry the -bexpall option. The manual page for ld has this to say about Garry -bexpall: Garryexpall Exports all global symbols, except imported symbols, Garryunreferenced symbols defined in archive members, and symbols Garrybeginning with an underscore (_). You may export additional symbols Garryby listing them in an export file. This option does not affect Garrysymbols exported by the autoexp option. This option only applies to GarryAIX Version 4.2 or later. Garry Since the linking of mysqlbinlog requires symbols beginning with Garry underscore, the -bexpall option is inappropriate. The correct Garry option is -qmkshrobj . Thanks a lot for the clear description! I will instead fix this by changing the name of _my_b_write to something that doesn't start with an underscore to fix this! (This is a more portable solution) cut Regards, Monty - 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
Can I use the concept of Effective Date with MySQL?
I need to select the appropriate price for a product in a table, and the product has a compund key with 2 fields: product number and date. For every transaction with a certain product, I need to retrieve the price that was 'current' at the specific time when that transaction took place. In joining two tables, I need to relate the price of a product to every sales transaction where that product was used, not only by product number but also by the effective date for that price. How can I do this? Is there a 'closest' function (the highest value that is or = ) to be used in a WHERE statment ? I've been searching for this for hours and could not fnd a solution with MySql. Thanks! Alejandro [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: Can I use the concept of Effective Date with MySQL?
SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1; -Original Message- From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:53 PM To: [EMAIL PROTECTED] Subject: Can I use the concept of Effective Date with MySQL? I need to select the appropriate price for a product in a table, and the product has a compund key with 2 fields: product number and date. For every transaction with a certain product, I need to retrieve the price that was 'current' at the specific time when that transaction took place. In joining two tables, I need to relate the price of a product to every sales transaction where that product was used, not only by product number but also by the effective date for that price. How can I do this? Is there a 'closest' function (the highest value that is or = ) to be used in a WHERE statment ? I've been searching for this for hours and could not fnd a solution with MySql. Thanks! Alejandro [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: Can I use the concept of Effective Date with MySQL?
I have had to do this problem and i solved it by having 4 fields, Normalprice (PrPrice), Tempprice (PrTempPrice), Start date (PrStart) End Date (PrStop). In the select IF(((CURDATE() = PRStart) and (PRStop = CURDATE())), PrTempPrice, PrPrice) as CurrentPrice hope this helps On Thu, 1 Nov 2001, Rick Emery wrote: Date: Thu, 1 Nov 2001 17:20:00 -0600 From: Rick Emery [EMAIL PROTECTED] To: 'Alejandro Zuzenberg' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Can I use the concept of Effective Date with MySQL? SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1; -Original Message- From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:53 PM To: [EMAIL PROTECTED] Subject: Can I use the concept of Effective Date with MySQL? I need to select the appropriate price for a product in a table, and the product has a compund key with 2 fields: product number and date. For every transaction with a certain product, I need to retrieve the price that was 'current' at the specific time when that transaction took place. In joining two tables, I need to relate the price of a product to every sales transaction where that product was used, not only by product number but also by the effective date for that price. How can I do this? Is there a 'closest' function (the highest value that is or = ) to be used in a WHERE statment ? I've been searching for this for hours and could not fnd a solution with MySql. Thanks! Alejandro [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - 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
Some question about establish a Cluster for Mysql,Help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - 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
no warning if setting date to value with all letters
I'm doing experiments with the table pet where the field birth is of type date. How come UPDATE pet SET birth = a2b WHERE name = snort; gives: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 but UPDATE pet SET birth = ab WHERE name = snort; gives: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 After a few more tests I determined that I'm getting a warning if I try to set the field to a value consisting of a mixture of letters and numbers, but I get no warning if the new value consists only of letters. Shouldn't I get a warning if I try to set a date field to a value consisting of all letters? -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - 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: VB/MySQL
The better way is use myvbql.dll at http://www.icarz.com/mysql/ . Your code can use both recordset style (ado full syntax only) and sql style (complex but useful). I recommend to use sql style when u need to manipulate data. SF At 14:57 1/11/2001 +0200, M.Ocak wrote: Yes it is possible, Create a System DSN by using Settings-- Control Panel --32 Bit ODBC data Sources. And use ADO to connect MySQL database. Hope this helps. Mustafa - Original Message - From: Quan Bang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 14:44 PM Subject: VB/MySQL Hi, Is it possible to work with VB and MySQL directly using dlls, just like working with VB and SQL Server. QB - 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 - 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 do I return the results of a count to a variable
At 11:34 AM +0100 11/1/01, Harald Fuchs wrote: In article p05100345b8063ddb205a@[192.168.1.31], Paul DuBois [EMAIL PROTECTED] writes: [snip] Of all the methods suggested I like the look of the one above and will try that one first. $count = $sth-fetchrow_array(); $rows = $sth-rows() Note that use of rows() to get the row count for a SELECT is deprecated in the DBI docs, which say that if you want to know the number of rows in a result set, fetch and count them. (The reason is that rows() just doesn't work at all for some database engines. On the other hand, it appears to work just fine for MySQL...) ... unless you use 'mysql_use_result' instead of the default 'mysql_store_result'. Another reason to avoid rows(). :-) - 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
Need Help with PHP / Apache
Can someone help? Using Linux (Mandrake 8.0), I'm still having great difficulties getting Apache and PHP installed/configured to interface the MySQL database I'm using. I've repeatedly tried compiling PHP and Apache from source, with no luck (I even used newer/older versions the several times I tried). I've tried installing the most recent RPM's (after uninstalling source code directories, and any previously installed RPM's), and it doesn't work either. After installing Apache from compiled source code, I was able to view the webpage on http://localhost, but I got stumped trying to get PHP running. Using the RPM's, I went to http://localhost, and it just gave me an empty directory with no webpage. I stopped and restarted the Apache server between each attempt, as follows: /usr/sbin/apachectl stop /usr/sbin/apachectl start Here are the webpages geared toward beginners, that I used: http://www.devshed.com/Server_Side/PHP/PHP101 http://www.e-gineer.com/instructions/install-php4x-for-apache1xx-on-linux.phtml Tonight, I got a segfault while doing a make on PHP. i uninstalled Apache, and installed the Apache version recommended by the website. The recommended Apache version compiled and installed easily. the recommended version of php got a segfault as follows: zend_alloc.c: In function `_ecalloc': zend_alloc.c:242: Internal error: Segmentation fault. Please submit a full bug report. See URL:https://qa.mandrakesoft.com/ for instructions. make[1]: *** [zend_alloc.lo] Error 1 make[1]: Leaving directory `/usr/local/etc/php-4.0.3pl1/Zend' make: *** [all-recursive] Error 1 Hopefully someone can point me to what I should be doing. I didn't keep a log of all my activity, so I don't remember which module I compiled in, or whatever - I'm still learning so I really don't know anyway. All I want to do at the moment is get a good Forms interface using Apache/PHP) for inputting data into MySQL database - the MySQL frontends aren't what I wanted.. Thanks. Chip. [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
a bug or intentional? -- problem with multiple table query
I am having a problem with a query and I don't know if it is a bug or intentional. Anyway any input is greatly appreciated. Here is a basic query that is simpler than what I am dealing with but should demonstrate my problem. Lets say: SELECT A.1, A.2 FROM A yeilds: test1 test2 then: SELECT A.1, A.2 FROM A, B yeilds nothing, unless B has something in it. my problem is that b does not always have something in it. I need to have B in the FROM list because I use it in the WHERE statement. I am curious if this is intentional, but mainly I would like to know if there is a way around it other than putting a dummy entry in the tables. If anyone cares here is the real query: SELECT DISTINCT services.serviceid, services.name from admin_permissions, pop_permissions, admin_pops, services WHERE (concat('service_',services.serviceid)=admin_permissions.object AND (admin_permissions.can_change=1 OR admin_permissions.can_grant=1) AND admin_permissions.userid=1) OR (concat('service_',services.serviceid)= pop_permissions.object AND (pop_permissions.can_change=1 OR pop_permissions.can_grant=1) AND pop_permissions.popid=admin_pops.popid AND admin_pops.userid=1) ORDER BY services.name - 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: a bug or intentional? -- problem with multiple table query
Hi, You need to read up on Left Joins, which will insert a 'NULL' row in the results for B where there isn't a real one. Regards Quentin -Original Message- From: Q [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 4:40 p.m. To: [EMAIL PROTECTED] Subject: a bug or intentional? -- problem with multiple table query I am having a problem with a query and I don't know if it is a bug or intentional. Anyway any input is greatly appreciated. Here is a basic query that is simpler than what I am dealing with but should demonstrate my problem. Lets say: SELECT A.1, A.2 FROM A yeilds: test1 test2 then: SELECT A.1, A.2 FROM A, B yeilds nothing, unless B has something in it. my problem is that b does not always have something in it. I need to have B in the FROM list because I use it in the WHERE statement. I am curious if this is intentional, but mainly I would like to know if there is a way around it other than putting a dummy entry in the tables. If anyone cares here is the real query: SELECT DISTINCT services.serviceid, services.name from admin_permissions, pop_permissions, admin_pops, services WHERE (concat('service_',services.serviceid)=admin_permissions.object AND (admin_permissions.can_change=1 OR admin_permissions.can_grant=1) AND admin_permissions.userid=1) OR (concat('service_',services.serviceid)= pop_permissions.object AND (pop_permissions.can_change=1 OR pop_permissions.can_grant=1) AND pop_permissions.popid=admin_pops.popid AND admin_pops.userid=1) ORDER BY services.name - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Grouping behavior question
I often find myself in the following situation: I have a master table and a detail table, the detail table contains chronologically ordered items (statuses) that relate to the master record. I now need to display one line for each of the master records with the latest status from the detail table. I have experimented with the GROUP BY and ORDER BY clauses of MySQL, but it seems to have a mind of its own with regard to which detail record gets returned in the collapsed result set. Is there any way I can influence the record in a secondary table that is returned as a result of grouping on a primary table? I tried selecting a MAX on the timestamp field, in the hope that somehow the resolution of that maximum would leave the other fields in the record sticky to the position that the maximum was found... with no success... I really would like to avoid changing the structure of all my database tables to contain the latest statuses in the master table. For one thing this clutters up the database design by replicating information. Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407 - 480 811 - 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: Editing Forms
Robert -- Just in case what Quentin and Rick said isn't clear, the MySQL DLLs/libraries are linkable and usable from Delphi/KYLIX. Quentin's note gives a good hint about one way to do it. I seem to recall from my last job that there are people around using Delphi as a front end to MySQL, so you shouldn't be alone if you do go that route. BTW, there are open source solutions for the user-interface which don't require the web browser. I've heard people mention GTK in this context. There was even a book (about building user interfaces for MySQL with GTK+) mentioned on this list in the last several days (by the publisher, looking for more reviewers, and I thought about volunteering for the free book). But I think using Delphi should be straightforward enough to get you started with MySQL. Joel Rees [EMAIL PROTECTED] Robert A. Smith [EMAIL PROTECTED] wrote: I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end tool [snipped] - 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 mysql cluster!help!
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - 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 with MySQL
Hi, It's extremely favourable to use MySQL with ASP but I can't find a lot of web host support both. Most of them support only one of them, MySQL and PHP is a good pair while ASP and MSSQL is another pair. Any suggestion that support both? Thank you. ST Ooi At 03:48 PM 01/11/2001 +, you wrote: Raymond, We run ASP with MySQL constantly using both ADO and a JDBC connections to it and experience great stability with it... this is with ASP on a WinNT/Win2K platform... we've never tried ChiliASP best wishes Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) -Original Message- From: Woolsey, Fred [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 3:41 PM To: [EMAIL PROTECTED] Subject: RE: ASP with MySQL Raymond, I would expect so (although I haven't tried it), since both ODBC and OLEDB providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I have used MyODBC with VBA in an Access 2000 front end to a MySQL database, and it works, albeit with a few minor glitches and less than stellar performance. Both drivers are, I believe, available from the MySQL site http://www.mysql.com. Cheers, Fred Woolsey -Original Message- From: Raymond Tsang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:09 PM To: '[EMAIL PROTECTED]' Subject: ASP with MySQL Hi, I would like to ask if MySQL can work with ASP, providing I have installed ChiliASP on a Unix server. Thanks. Regards, Raymond Tsang Building Access Database Developer PowerTel Limited 55 Clarence Street, Sydney 2000 Tel: 8264 3839 Fax: 8264 4555 Email: [EMAIL PROTECTED] ** PowerTel Limited, winners of Broadband Wholesale Carrier of the year, CommsWorld Telecomms Awards 2001 Best Emerging Telco, Australian Telecom Awards 2001 ** This email (including all attachments) is intended solely for the named addressee. It is confidential and may contain commercially sensitive information. If you receive it in error, please let us know by reply email, delete it from your system and destroy any copies. This email is also subject to copyright. No part of it should be reproduced, adapted or transmitted without the prior written consent of the copyright owner. Emails may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems. We give no warranties in relation to these matters. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. ** - 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 - 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: Editing Forms
BTW, there are open source solutions for the user-interface which don't require the web browser. I've heard people mention GTK in this context. There was even a book (about building user interfaces for MySQL with GTK+) Maybe even PHP-GTK (Win or *nix) Example GUIs; http://teak.sourceforge.net/screenshots.php php-gtk + gtkhtml + scintilla http://midgard.hklc.com/help_browser.png There is also the Agata project that is a PHP-GTK frontend to Posgresql, I think someone is working on a MySQL version. http://agata.codigoaberto.org.br http://www.sanisoft.com/agata.zip PHP-GTK supports libglade allowing you to use Glade http://glade.gnome.org/ generated GUI. I think most of these are fairly new, it may not suit what you are after. (info from http://gtk.php.net/ [EMAIL PROTECTED] http://sitework.pt/deafcat http://guru.josefine.at/~mfischer/articles/article-php-gtk.html ) HTH Andrew Braund [snipped] - 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
Query on Mysql
Hi ! I would like to use ASP(Active Server Pages) Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.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
Ask for Linux+MySQL installation help
Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/local/MySQL # ./configure ¨Cprefix=/usr/local/MySQL # make # make install Instalation Success; 2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: # gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c # gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient Compile and link all success; 3. But, when I run the program, error occurs. Error message is as follows: # ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory 4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: # rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm I compile and link it with same makefile. This time, everything is OK. Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. My E-mail address is: [EMAIL PROTECTED]
Ask for Linux+MySQL installation help
Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/local/MySQL # ./configure ¨Cprefix=/usr/local/MySQL # make # make install Instalation Success; 2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: # gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c # gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient Compile and link all success; 3. But, when I run the program, error occurs. Error message is as follows: # ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory 4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: # rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm I compile and link it with same makefile. This time, everything is OK. Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. My E-mail address is: [EMAIL PROTECTED]
Excluding results based on contents of secondary table
Perhaps this is more of a general SQL question than a MySQL specific one, and I may be exposing my ignorance by asking this, but I figure it's worth a shot. I have two tables, 'a' and 'b'. Each contains a value 'c'. I want to select all 'a' rows where a.c is not in the set of b.c. Is this possible using a single query? What I do now is select all the b.c values, build up a where clause from those results, then select from a, but it's an extra query I'd rather not do. Thanks for any help anyone out there can provide. -Moishe - 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: Ask for Linux+MySQL installation help
try to copy mysql libraries to /usr/local/lib and /usr/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib From: YANG [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Ask for Linux+MySQL installation help Date: Fri, 2 Nov 2001 13:43:46 +0800 (CST) Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/local/MySQL # ./configure ¨Cprefix=/usr/local/MySQL # make # make install Instalation Success; 2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: # gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c # gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient Compile and link all success; 3. But, when I run the program, error occurs. Error message is as follows: # ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory 4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: # rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm I compile and link it with same makefile. This time, everything is OK. Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. My E-mail address is: [EMAIL PROTECTED] _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - 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: Grouping behavior question
Hi Mr. Jerry, Since Mysql does not support sub query, you will have to use temporary table instead. Create temporary table tmptbl1 Select keycol, Max(datetimecol) as maxdate from detailtable group by Keycol; Create temporary table tmptbl2 Select distinct T.Keycol, D.Status from tmptbl1 T, detailtable D Where T.Keycol = D.keycol and T.maxdate = D.datetimecol; Select M.*, T2.Status From mastertable M, tmptbl2 T2 Where M.Keycol = T2.Keycol; I think this is the most straight forward way to solve your problem. I have not checked the above commands. Hope this works for you. Anvar. At 02:41 PM 02/11/2001 +1100, you wrote: I often find myself in the following situation: I have a master table and a detail table, the detail table contains chronologically ordered items (statuses) that relate to the master record. I now need to display one line for each of the master records with the latest status from the detail table. - 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 mysql cluster!help!
I feel a little wierd doing this, since I'm a newbie here, but here goes: Do you want to be a paying customer of MySQL AB, or do you want to participate as a member of the volunteer community? If you want MySQL AB to give you a quote on designing a cluster of MySQL servers (or whatever), you need to go to their home page at www.mysql.com, look for the links to their consulting pages, and contact them directly. If you want help from the volunteer community, this is the right place, but you need to do some more homework. None of us have the time to design you a MySQL server cluster for free. We can give you some hints, but you have to do the work. What kind of homework? Start at MySQL AB's homepage and look around. Read the documents a bit. Search the documents using appropriate keywords, cluster, for instance. Find the mailing list archive and search it, too. Go to Google, at www.google.com, and do a search there. You might try mysql cluster or something similar. When you get stuck, figure out what your questions are, and then come back and tell us what you found, and ask your questions. And good luck. Joel Rees [EMAIL PROTECTED] - Original Message - From: Magic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 02, 2001 1:26 PM Subject: how to mysql cluster!help! Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li - 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
when column contains spaces
I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or , it does not work. Thanks in advance. Zhidian - 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: Query on Mysql
You have to setup an ODBC connection using the MySQL ODBC Driver (MyODBC), and then you use ASP to create connection and recordset objects. Chris -Original Message- From: murali madhav [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:40 AM To: [EMAIL PROTECTED] Subject: Query on Mysql Hi ! I would like to use ASP(Active Server Pages) Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.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