Re: mysqlxml
PROTECTED] To: mel list_php [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: mysqlxml Date: Thu, 12 May 2005 11:42:32 +0200 mel list_php wrote: Hi guys, I was trying to download the mysqlxml patch for mysql 5.0 but didn't succeed from the url: http://d.udm.net/bar/myxml/mysqlxml.tar.g does anybody know where I could find it? Did anybody tried to use it or have any link to a doc/tutorial in addition to the presentation of Alexander Barkov (http://mysql.r18.ru/~bar/myxml/XMLXpathSupportInMySQL.pdf)? Thanks, Melanie try http://mysql.r18.ru/~bar/myxml/ _ Be the first to hear what's new at MSN - sign up to our free newsletters! http://www.msn.co.uk/newsletters -- . These pages are best viewed by coming to my house and looking at . . my monitor. [S. Lucas Bergman (on his website)]. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger 7.0 today! http://messenger.msn.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [q] 4.1.2 Collation how to...
Andrey, thanks for your report! You're right, There was a bug that the client library didn't take in account --with-charset and --with-collation configure attributes. This bug was fixed in 4.1.3 which is going to be released soon. A temporary solution with 4.1.2 is to use SET NAMES koi8r after connection. Or run mysqld with --init-command=SET NAMES koi8r. Regards. Andrey Kotrekhov wrote: SQL Hi, All! This is configure scrypt haw I have compiled mysql 4.1.2 ./configure \ --prefix=/usr/local/mysql_4 \ --without-debug \ --with-charset=koi8r \ --with-collation=koi8r_general_ci \ --with-extra-charset=koi8u,cp1251 \ --with-mysqld-user=mysql \ --without-berkeley-db \ --without-isam \ --without-innodb \ --enable-thread-safe-client After that any programs using libmysqlclient has the problem with collation if they try compare char fields. I try ask query show variables and see: Variable_name=character_set_client Value=latin1 Variable_name=character_set_connection Value=latin1 Variable_name=character_set_databaseValue=koi8r Variable_name=character_set_results Value=latin1 Variable_name=character_set_server Value=koi8r Variable_name=character_set_system Value=utf8 Variable_name=character_sets_dir Value=/usr/local/mysql_4/share/mysql/charsets/ Variable_name=collation_connection Value=latin1_swedish_ci Variable_name=collation_databaseValue=koi8r_general_ci Variable_name=collation_server Value=koi8r_general_ci What options for configure should I set that my programs/clients have character_set_client and etc is set to koi8r ? Is this possible? May be it is bug? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-4 4 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is it possible?
Eugene R. Miller wrote: This is kind of a silly question is there an easy way to ... SELECT Status, rating, COUNT(*) FROM song GROUP BY pldupldqd, rating ORDER BY Status, rating DESC This gives me all the information I need ... What I would like to do is something... like SELECT rating, count(WHERE pldupldqd = 0), count (WHERE pldupldqd = 1), COUNT (WHERE pldupldqd = 2) FROM song GROUP BY rating The idea is to get... 3 different columns counting what it equals. Yes, it's possible, the solution is very easy: SELECT rating, sum(CASE pldupldqd WHEN 0 THEN 1 ELSE 0 END), sum(CASE pldupldqd WHEN 1 THEN 1 ELSE 0 END), sum(CASE pldupldqd WHEN 2 THEN 1 ELSE 0 END), Alternatively, you case use function IF(), instead of CASE. Erm --- www.the-erm.com -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: repercussions of reserved words
Hi! Peter Schoenster wrote: Hi, I installed an app which used option as a field. It worked fine in version 3.23 on my play box. I then moved the app to another box (4.0.15) and when I tried to dump it in (mysql -u x -px database dump_from_other_box) it balked at the use of option. I suspected reserved word and such was confirmed on the mysql site. So I moved the database directory from play box to live box. That worked. All was well. But I worry. Then, I went to the mysql site and read some more and saw a reason for those annoying backticks in phpmyadmin. I see that I could have done the original dump had I put option in backticks. So now I'm a bit confused why I should avoid reserved words (other than to avoid backticks which is enough for me but I'm curious). MySQL stores field names without backticks in FRM file, so it doesn't matter if the field otpion was created under 3.23 using word option without backticks, or under 4.0 using option with backticks. Will awful things happen to me in the future? As you're going to use option in backticks, no, awful things should not happen. Peter -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php temp table question (for mysql)
Larry Brown wrote: Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? You are right. There is a simple workaround though. You can use IF NOT EXISTS when creating your temp table: create temporary table if not exists t1 (a int); Also if it does present a problem with the next script execution trying to create the temp table again, if I drop the temp table at the end of the script will I still have problems if the script is run by two client in tandem? For instance two people connect, both hit the script at about the same time. One script creates the temp table and before it can drop the table the second script tries to create the table. Temporary tables are created under connection scope. There is no problem for two clients to use temporary tables with the same names. Physically, these tables are different. The second client can't see a temporary table created by the first client. Will it see the table created by the other script? Again the use of persistent connections would be a the heart of this I would think. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Almost beating Rushmore -- was: Really slow query (compared with Visual FoxPro)
Héctor, Changing various buffer sizes can improve performance significantly, with key_buffer_size as the first thing to tune. Also, make sure you are using not debugging version of the server. Please also take a look in this section of the documentation for details: http://www.mysql.com/doc/en/Optimising_the_Server.html Héctor Villafuerte D. wrote: Hi guys! Ok, I'm closer to beat Rushmore (VFP optimizer) now! After some reading about MySQL optimization techniques, here is the summary of what I've done: 1. Add a compound index to the table 2. Use EXPLAIN to check out the query (with GROUP BY on multiple fields) 3. Create the summary table And here's the detailed instructions: mysql alter table traf_oper add index (tel, telefb, rutaentran, rutasalien, minutos); Query OK, 5067215 rows affected (5 min 22.36 sec) Records: 5067215 Duplicates: 0 Warnings: 0 mysql explain select tel, telefb, rutaentran, rutasalien, sum(minutos) from traf_oper group by 1, 2, 3, 4; ++-+---+---+---+--+-+--+-+-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows| Extra | ++-+---+---+---+--+-+--+-+-+ | 1 | SIMPLE | traf_oper | index | NULL | tel | 45 | NULL | 5067215 | Using index | ++-+---+---+---+--+-+--+-+-+ 1 row in set (0.03 sec) mysql create table grp_oper select tel, telefb, rutaentran, rutasalien, sum(minutos) as minutos from traf_oper group by 1, 2, 3, 4; Query OK, 3326541 rows affected (33.81 sec) Records: 3326541 Duplicates: 0 Warnings: 0 Adding the times together it would take MySQL like 6 minutes (VFP does it in about 4 minutes). I still haven't tweaked some server variables (read_rnd_buffer_size, sort_buffer_size, max_join_size), but, as always, I'll keep trying :) Thanks in advance for your comments and suggestions, Hector -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Supported data types
Lay, Lay Hoon Tan wrote: Does MySQL support serial (auto-increment a number) and currency types ? 1. You can create an auto-increment field: mysql create table t1 (a int not null primary key auto_increment, b char(10)); Query OK, 0 rows affected (0.02 sec) mysql insert into t1 (b) values ('rec1'),('rec2'),('rec3'); Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql select * from t1; +---+--+ | a | b| +---+--+ | 1 | rec1 | | 2 | rec2 | | 3 | rec3 | +---+--+ 3 rows in set (0.01 sec) 2. There is no special MONEY type in MySQL. But you can use DECIMAL for this purposes. We used DECIMAL(12,2) to store money in an ISP accounting system several some time ago. It worked very fine. Hope this helps. It seems that both are not supported but I would just like to confirm this. Thank you -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-912-856-80-21 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New charset for MySQL
Hi! What is Bengali character set? Does it have a Unicode mapping table like for example this one: ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT Please also send me some links to internet recourses written in Bengali. Regards! Shyamal Banerjee wrote: Dear sir, I want to create a website in my native language. I would like MySQL support for my native character set, which is Bengali. I think MySQL does not support this language. How can I add support for it in MySQL ? Thanks in advance for any reply. Shyamal - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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 limit the cpu usage in MySql
Probably execution with nice will help. Edwin Wang wrote: I want to find a way to limit how much of a system processor (cpu) the mysql server will use, so that I don't run the risk again of having googlebot or other web robots interrupt my other server operations in my computer. Thank you Edwin - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: creating database
This is not possible. Info wrote: sql,query How can i have each users database to be stored in it's home dir ? - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: UNIQUE on blob
Hi! First of all, MEDIUMBLOB type is case-sensitive. I checked this sequence and everything worked as expected. I think you have a mistake in your table. What does SHOW CREATE TABLE table give? Second, there is no needs to check that the value is already presents using SELECT just to avoid an attempt of double key value inserting. It is safe to insert without selecting. After inserting you have just to check that really happened, either record was inserted or error happened. Why do you want to do iy Stefan Kuhn wrote: Hi everybody, I've got a MEDIUMBLOB column in a table, where I want values to be unique. So I made it UNIQUE. When my program wants to enter a value, it first does a select * from table where column =x in order to see if x already exists, if not, it does an insert. Now the interesting point: If there is c1c1 in the column and I want to insert C1C1, the select says, that this is not existing, so the insert is done. Then mySQL complains about double keys. It seems that the UNIQUE comparision is not done case-sensitive in BLOB-columns, which is bad. Does anybody have an idea about how to solve this (I need the column to be case-sensitive). Many thanks Stefan -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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 1044: Access denied for user
It means you don't have enough privileges to access 'mysql' database. You can add these privileges using GRANT command under user 'root' (or under another superuser). Check manual, the section about privileges. anjani.sinha wrote: Hi all, I am getting the error when trying to connect server from my client: ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database 'mysql' any answer? thanks, anjani - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Submitting Form Data
Mark Colvin wrote: I have a php script that executes a query and depending on the results builds a section of a table for each record returned in the query. Each section has some fields and three buttons. My problem is this. When I want to change the data in one particular section, how can I submit the form passing only the data for that particular section? 1. Use a separate form for each field. 2. Use different names in buttons: INPUT TYPE=SUBMIT NAME=field1 VALUE=Submit INPUT TYPE=SUBMIT NAME=field2 VALUE=Submit INPUT TYPE=SUBMIT NAME=field3 VALUE=Submit 3. Use a single form, but fill all it's fields with their previous values SELECTing them from the database before displaying the form. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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 wont start
Hi! You can put this into /etc/my.cnf: [mysqld] user=root This will allow to run mysqld as root. However, consider running it under another account, it is safer. Satish Santhakumar wrote: Hi Guys, MySQL wont start it says 'Security' error cannot start mysql. Read the MySQL manual on security to start the server as a root. What is the problem here?? I cannt seem to figure out it was working fine sometime ago. This is urgent please help. -SS = The only person in the world who is enviable is one who does not envy others __ Satish Santhakumar Graduate Student IIT, Chicago and Computer Programmer University of Chicago. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: need your attn: can mysql support japanese and korean simultaneouslyin same database
Hi! Joel is right. You can store both, however in 3.23.x and 4.0.x mysqld can use rules of the only one charset for things like GROUP BY, ORDER BY, DISTINCT, etc. In upcoming 4.1, it's possible to have fields of different charsets at the same table. So, japanese and korean sorting will be possible even without Unicode, one needs just to create two fields: in korean and japanese charsets. All operartion with korean field will use korean collation rules. Correspindingly, all operation with japanese field will use japanese collation rules. Joel Rees wrote: i am working on a project in which db is mysql and it should support japanese and korean simultaneously I have mysql 3.23.36 running on red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis Kindly tell meif is it possible to make a database support japanese and korean both languages simultaneously I don't really know much, but from what I understand, the answer to your question is probably not. If you want to sort and collate both at the same time, in the same tables, you'll need the Unicode support that is scheduled for ver. 4.1. You can store both at the same time. (You may have some problems with the drivers, but it appears that those problems can be fixed or worked around.) You can also search, if you don't care about missing a few sometimes, or if you can write a little external code to pick up some oddball cases. Or, you might consider keeping the Japanese and Korean data in separate tables on separate servers. From what I understand, that should be possible. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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't start MySQL server
Hi! It seems you still have an old mysqld running. Check this: ps ax | grep mysqld and kill it if it does really present. duo fu wrote: Dear all: I have just removed an old version of mysql and install MySQL3.23.51 (tarball). After installation, I tried to start the server: % bin/safe_mysqld It can't be started. Message stored in file: /mysql/var/hostname.err asking Do you already have another mysqld server running on port: 3306? Aborting. I have tried hours to install it but I just could not succeed. Could anyone kindly help me out? THank you very much for your help! Frank _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Case Insensitivity of queries and record lookup
New binary character set should appear in next release. It provides case-sensitive comparisons. It even doesn't require recompiling mysqld, you need just to put binary.conf file into /share directory of mysql installation, then restart mysqld with --default-character-set=binary argument. If you would like me to send binary.conf file, please let me know. Keith C. Ivey wrote: On 28 Jun 2002, at 14:27, Mark Hennessy wrote: I have noticed after migrating my database from mSQL to MySQL that queries are providing lookup results in a case-insensitive manner. To avoid that, make your CHAR and VARCHAR columns BINARY, or if you only want to make *some* comparisons case-sensitive, use BINARY in your query: http://www.mysql.com/doc/C/H/CHAR.html http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Display Records in Multiple Pages
You can use LIMIT clause: SELECT fields FROM table LIMIT X,25 where X is number of row to start with. You can substitute this number for example in HREF: A HREF=?X=25Page2/a A HREF=?X=50Page3/a A HREF=?X=75Page4/a then your script should take X value and use it to compose the query. Aqua wrote: I have 100 records in mySQL database and I need to display them in my web page using php and html. How to display them in multiple pages? Each page must contain 25 records. Does anyone know how to do it other than create 4 pages and manually list the records there? or maybe point me some reference please. Your help will be much appreciated. Thanks! Aqua - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: default table type
You can select default table type at mysqld startup: mysqld --default-table-type=tabletype Pierre Baridon wrote: how can i change the default table type ? (innodb instead of myisam) thanks, Pierre -- sql,query - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Multiple Network Interface
You can bind mysqld to a specific address using mysqld --bind-address=IP-ADDRESS Nilesh Shah wrote: We are setting up three MySQL server (on separate machines) with one master and two slave servers. All the machines has two network interface. We want to create Private network between three machines only to route replication traffic. Can MySQL use multiple network interface on machine?. Thanks, Nilesh - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Unions
[EMAIL PROTECTED] wrote: Does anyone else feel that lack of support for subqueries is the number 1 deficiency in MySQL? I'm not sure why support for subqueries is being Actually, I am much more eagerly waiting for views and Unicode support that sub-selects, although of course these would be very nice too. Unicode support will be available in MySQL-4.1 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Searching through a MySQL-driven website
Hi! You can try FULLTEXT search, implemented in MySQL, or consider installing specialized Web search engine. Eivind A. Sivertsen wrote: I run a MySQL/PHP-based website. In an attempt to make some search functionality, I search a few specific tables that I find relevant and look in certain fields when performing a search. A query will generally look something like this: SELECT * FROM Books WHERE LongName LIKE '%$kw%' OR ShortName LIKE '%$kw%' When searching through multiple table groups (i.e. Books, Tapes, Furniture(bogus examples)), search results are simply grouped using php and presented in the sequence they were found. I dont find this to perform adequately as the site grows, especially since I have not been able to implement any response relevance measure with this scheme. I have heard this could be accomplished using some temporary tables with MySQLdoes any body know more about this? I will also appreciate responses with suggestions for good search schemes, particulary good resources on the subject (preferrably available on the web) or any other tips and ideas. Best regards, Eivind PS. thanks for a sometimes very interesting list! ;-) - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: force no results
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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 can this Oracle Query converted to MySQL
What us U.UserID? You don't have table U in the table list. Arul wrote: SELECT U.UserID FROM Transaction_Data T, Rfq_Data R ,Company C WHERE T.TransactionID = R.TransactionID AND (R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM Company_Industries CI WHERE CI.CompanyID = C.CompanyID)) -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: encrypt myisam?
Hi! There is a workaround for it using ENCODE and DECODE functions. Insert data in this style: INSERT INTO t VALUES (field) ENCODE('string','password'); Retrive it using decode(): SELECT decode (field,'password') FROM t; Perhaps this helps. Tobias Bengtsson wrote: Hi! I want to store my mysqldatabase encrypted on disk, it contains sensitive data. Is there anybody out there doing this already? Or do I have to rewrite the myisam routines? Or is there another way? Regards, Tobbe -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: SubQueries and Temp Tables
It's hard to give a common suggestion which is suitable for all cases. We need to know the exact queries being executed. Arul wrote: Agreed Ralf... Not all SubQueries can be replaced by Joins.. Thats why we have planned for Temp Tables.. Any ideas on it.. - Original Message - From: Ralf Narozny [EMAIL PROTECTED] To: Arul [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 3:00 PM Subject: Re: SubQueries and Temp Tables Hiho hiho! Which joins could that be? I think most if not all subqueries should be replacable with joins. Greetings Ralf Arul wrote: Hi All I am currently porting our application from Oracle to MySQL. We have some subqueries in oracle which cannot be ported into MySQL.We even tried some joins which didnt work out.. So Could anyone throw some light on Temporary tables.Is this the right way to do it.. Since our main query is dependent on the inner query we thought we could run the inner queryfirst and create a temp table.Then we could have a join between the main table and the inner table. Is this advisable.. Any other better options? -- Ralf Narozny Splendid Internet GmbH Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what permissions do i need to set
Shon Stephens wrote: i have an application that will allow me to rotate mysql table using date variable substition. in other words table=tblname.%m%d%Y if i am using a remote system to host the application, what Host doesn't matter. localhost and remote hosts are processed in the same manner. permissions to i need to give the remote application user so that it can properly select,update,insert records into existing tables, and create new tables as it needs to? grant create,select,insert,update on db.* to 'user'@'host' -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Regarding Store Procedures
MySQL doesn't support stored procedures. They are on TODO and should appear in MySQL-5.0. Pradeep.C.Pangi wrote: Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: Permission denied for download???
What URL did you try? Takacs Istvan wrote: Hi I'd like to download mysql-3.23.51-sun-solaris2.8-sparc.tar.gz from mysql.com, but the server doesn't allow me to get the file. What's wrong with it? Thanks in advance! Regards; Istvan - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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
SQL syntax near 'IDENTIFIED BY'...
Hello! These query produces an SQL syntax error in 3.23.29a-gamma: GRANT ALL PRIVILEGES ON databases.* TO 'foo'@'localhost' IDENTIFIED BY 'bar'; SHOW TABLES FROM databases; Probably this is because of databases is a keyword. However, mysqladmin does allow to create database 'databases'. Is it a bug? Or is that already fixed in later releases? Please honor my address when replying, currently I'm not a subscriber. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More info
Sorry, It was a little mistake in my previous letter. mysqladmin create databases does not output any error messages, however it does not create database databases. However, mysqladmin drop databases produce this: /usr/local/mysql/etc/ access.grant mysqladmin drop databases Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'databases' database [y/N] y mysqladmin: drop of 'databases' failed; error: 'You have an error in your SQL syntax near 'databases' at line 1' Regards. - 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
Problem: MERGE tables for different databases
HEllo! Is it possible to create a merge table for tables from different databases. I wrote this script for database collection: CREATE TABLE dict ( url_id int(11) DEFAULT '0' NOT NULL, word varchar(32) DEFAULT '' NOT NULL, intag int(11) DEFAULT '0' NOT NULL, KEY url_id (url_id), KEY word_url (word) ) TYPE=MERGE UNION=(www.url,dbms.url); MySQL took it without any errors. However, when I try to access MERGE table in collection database, it fails: -- /usr/home/bar mysql collection Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 210 to server version: 3.23.29a-gamma-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql select * from dict; ERROR 1017: Can't find file: 'dict.MRG' (errno: 2) mysql --- I think this may helps in solving: In /usr/local/mysql/var/collection/dict.MRG I can see this: url url I supposed it should be www.url dbms.url Is that a bug? I suggest this to be fixed in future release. I use 3.23.29a-gamma. Please make a copy to me when replying... Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feature suggestion
Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysqld to exchange data between each other. For example, MERGE tables distributed between two machines. Question to authors. How do you think, will it ever be implemented. If so, how soon? Thanks... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php