Need Help and more info's
Dear Adminers, I'm want to migrate database from MS-SQL Server 7.0 to MySQL Server. But i've some problem when implementing that systems. My system give to the user to connect about more than 200.000 connections on one time, but when i try only approx. 150, the MySQL stopping connection on 99 connections, can't more. I'm also already set variables for max_connections=20, but after the server is running, i'm see on variables tab max_connections = 16384. Is somebody can resolve and helping me ?. Servers: MySQL-MAX-NT 3.2.49 RAM: 1 Gb Proc: iP4 1 Gb TIA. - 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: foreign key constraint to itself
Lisa, - Original Message - From: Lisa Tong [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, May 14, 2002 5:29 AM Subject: foreign key constraint to itself Hi, I am just wondering can I create foreign key constraint to itself in mySQL innodb (the mySQL 3.23.50 release)? Let's say we have a table: test_table_01 (id integer, pid integer) type = innodb. Can I create a foreign key on pid and reference to test_table_01 (id)? yes, you must first create the table with the appropriate indexes, and after that use ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY ... to add the self-referential foreign key constraint. Note the following bug fix in 3.23.51: May 2, 2002: If you add self-referential foreign key constraints with ON DELETE CASCADE to tables and a row deletion causes InnoDB to attempt the deletion of the same row twice because of a cascading delete, then you will get an assertion failure in row0ins.c line 511. Fixed in 3.23.51. Thanks, Lisa Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
tcp/ip default port ??
what is the TCP/IP default port for MySQL ?? _ Téléchargez MSN Explorer gratuitement à l'adresse http://explorer.msn.fr/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
What uses more resources
Hi all, I have different scripts which use Mysql databases. Now is my question; Is it better to have different databases for the different scripts or should I use 1 database for all the scripts? The scripts aren't used a lot. Thanks, Dennis - 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: Emebedded MySQL Engine Client Server Engine
Hi, If i understaned well, you make reference to an multi-tier application ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 1:45 AM Subject: Re: Emebedded MySQL Engine Client Server Engine Hi, Is it possible to run both of these on one server? It would be good to get rid of all the IPC for the local application but still be able to hit the database from remote without needing any special protocol. Has anyone tried it? Any data issues with mysql? Thanks in advance Regards Nirmal Prasad R. - 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: sql question
Calculating a connectivity matrix from this sort of data is not what the relational database is best designed to do, but it's a common problem - it applies to family tree databases, used-on lists and so on. (What you're actually wanting to do, if I remember the jargon correctly from school, is calculate (part of) the transitive closure of a sparse connectivity matrix.) I've done this many times, and never found any alternative to running a query round in a loop, once for each generation, and stopping when two consecutive iterations of the loop produce no new data. How slow is slow? With proper indexes and so on the whole thing should surely be under a second? (Of course if you've got more than four or five levels it could be your organisation structure that's broken:-).) Tim Ward Brett Ward Limited - www.brettward.co.uk -Original Message- From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 15:53 To: Mysql (E-mail) Subject: sql question I have an sql question. I have a table that holds user information that includes their id and who they report to. user - id (int) supervisor (int) This heirarchy goes several levels deep. Without changing the db structure, what is my easiest way to determine if user x is a supervisor for user y? User x may not be the immediate supervisor, but may be a supervisor or his supervisor, etc. I can do it with PHP by gettign the supervisor, then getting the supervisor's supervisor, etc, but this is slow. Any other ideas will be very much appreciated! Thanks, Scott - 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: Windows 2000 MySQL login
Apologies if this is a duplicate posting. My last message bounced, I can't figure out why. Jay I created another user on My PC to try out your suggestion and all was revealed (I think). The problem appeared to lie with the MySQL ODBC driver. I created a user DSN in the ODBC control panel for the new user. Two of the TDX ODBC configuration dialogue boxes asked for a username and a password. If these are filled in, that user becomes the default user and the driver supplies both the password and user ID if none is entered at log in time. So, I removed the login details from the driver configuration and now all seems OK. I know a user DSN is only visible to one user on one machine but I still can't see why these configuration boxes are present at all. (They are also present on the System DSN setup screen) Thanks for the help John Morrison --- In article 001001c1f836$0c64f570$8102a8c0@niigziuo4ohhdt, Jay Blanchard wrote: From: Jay Blanchard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Windows 2000 MySQL login Date: Fri, 10 May 2002 10:19:15 -0500 [snip] My VB application has a log-in screen with two fields, userID and userPassword. When these are correctly filled in, MySQL logs me in and the application opens. But, I can also log in (as myself) if I leave both fields blank. And the plot thickens when considering the following VB code snippet. If this code is run 'as is' then I log in. If the commented code is restored I am thrown out. But the code appears not to change anything. This doesn't make sense. [/snip] Can you go to another computer where someone else is logged in to the network, or can you log in to the network as someone else and try this? Is your login username/password for the network the same as MySQL? Jay - 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
Unicod problems
Hi I'm currently developing on a system that we will launch on a int'l scale using MySQL as a small client database (30 MB). We are currently examine FoxPro and MySQL. I understand that MySQL doesn't support Unicode and one solution is to encode strings with UTF-8 before storing in MySQL, but doesn't that gives me a problem when searching on text fields? Anyone have a suggestion? How much space do you need for an UTF-8 encode string/char ? -- Svend Erik Høst Jørgensen mailto:[EMAIL PROTECTED] Pallas Informatik A/S http://www.pallas.dk Allerød Stationsvej 2D Tel.: +45 48 10 24 10 DK-3450 Allerød Fax.: +45 48 10 24 01 - 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
reg installation
hi, i have a problem in accessing the MySQL. it denies access when i try to change to the mysql database. it tells Access denied for user:'@localhost' to database 'mysql'. I didnt setup any user or password .the server is running on the root. pls give me neccessary suggestions to overcome this . regards, radhika __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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: tcp/ip default port ??
* Raph mysql what is the TCP/IP default port for MySQL ?? 3306 -- Roger 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
Re: reg installation
Hi, Try ... mysql -u root -h your_IP_host Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: radhika gopalan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 11:41 AM Subject: reg installation hi, i have a problem in accessing the MySQL. it denies access when i try to change to the mysql database. it tells Access denied for user:'@localhost' to database 'mysql'. I didnt setup any user or password .the server is running on the root. pls give me neccessary suggestions to overcome this . regards, radhika __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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
--- InnoDB for Win
Hi? all Can i use InnoDB tables in MySQL Max for Win9x ? Thanks... -- Best regards, maxim mailto:[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
Is InnoDB 64bit clean?
Hi. I am trying to install MySQL-3.23.49 with BDB and InnoDB under Solaris 8 using the Forte Compiler 6.2 in 64bit mode. I succeed the compilation and installation procedure, but when I try to start the mysql server I receive following logs in my err-file: 020514 10:12:01 mysqld started InnoDB: The first specified data file /var/lib/mysql-3.23.49/ibdata1 did not exist: InnoDB: a new database to be created! 020514 10:12:01 InnoDB: Setting file /var/lib/mysql-3.23.49/ibdata1 size to 400 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile2 size to 5 MB InnoDB: Database physically writes the file full: wait... And after waiting one hour I decided this can't be correct. :-) When I install the whole thing in 32bit-mode everything is ok! When I install MySQL with BDB (without InnoDB) in 64bit-mode everything is ok! So I wonder where the problem is... Is InnoDB not 64bit clean? Anyone else saw this problem? Greetings, ++ralph P.S.: The same happens when using 3.23.50! _ 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
Re: Re: Adding new users
Todd, Monday, May 13, 2002, 7:18:11 PM, you wrote: TC Where is the user table? Table 'user' is located in database 'mysql'. It's one of the table that MySQL uses for user identification. Some more details about user identification and privilege system in MySQL you can find at: http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/P/r/Privileges_provided.html http://www.mysql.com/doc/C/o/Connection_access.html http://www.mysql.com/doc/R/e/Request_access.html TC Can it be viewed? Sure. mysql USE mysql mysql SELECT * FROM user; TC How can I tell what is in it with TC mysqladmin? No way. TC Todd -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Re: Can't RESTORE TABLE...
Ritu, Tuesday, May 14, 2002, 7:10:33 AM, you wrote: RS i'm taking the backup of PERSON table in /tmp dirafter the backup RS PERSON.frm and PERSON.MYD are present in /tmp...but when i try to restore RS them with the name RS, the error comes up You can't restore with another name. RESTORE TABLE table_name is looking for a files table_name.* in your dir, can't find them and as a result gives you error. So, you can restore table only with the same name. If you want to rename table use RENAME TABLE statement. RS Ritu -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: tcp/ip default port ??
Raph, Tuesday, May 14, 2002, 10:36:05 AM, you wrote: Rm what is the TCP/IP default port for MySQL ?? Default port number is 3306. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: OUTFILE and DESCRIBE
Rutledge, Monday, May 13, 2002, 6:25:42 PM, you wrote: Reoen Sorry to bother the list with the mundane, but I have searched the Reoen entire MySQL manual and can't find the answer. Is there a way to output Reoen the table description (using DESCRIBE) into an OUTFILE like you can for Reoen SELECT query statements? Thanks! Aaron 1. You can use mysqldump with --no-data option mysqldump --no-data database_name table_name /tmp/structure.sql This way gives you dump file with table structure. Afterward you can re-create table using dump file. 2. Use MySQL in batch mode mysql database_name -e desc table_name /tmp/desc.sql In this case you get output of the DESCRIBE statement in the file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: SQL syntax question
Graham, Monday, May 13, 2002, 8:45:09 PM, you wrote: GN I have a directory of professional magicians, consisting of a MySQL table GN like GN this: GN +-++-+ GN | artist | area| magic | GN +-++-+ GN | Joe Bloggs | AZ*IN*TX | childrens | GN +-++-+ GN | Fred Smith | All | close-up | GN +-++-+ GN A surfer will select an area and then the type of magic they require via a GN php/HTML form. So to locate a performer who does magic for children in Texas GN I use GN SELECT * FROM artist WHERE (area LIKE '%$area%' OR area = 'All') AND magic GN LIKE '%$magic%' GN (where $area and $magic are variables passed from PHP). GN However, this does not give the desired result, it just returns any perfomer GN who does magic for children. What am I doing wrong please? I've tried GN several other syntax combinations without success. What are the values of your php variables? Are you sure that they are correct? GN kind regards, GN Graham Nichols. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Help with UPDATE and SET with two tables
Andrew, Tuesday, May 14, 2002, 12:43:31 AM, you wrote: AL I have a database with several tables. I want to update a field in that AL table with a field contained in another table. I have a unique key to use AL for a WHERE clause. AL This is easy to do with various procedural languages (Business Basic, for AL one) but I don't find much info in MySQL documentation for doing this, other AL than the UPDATE command (which produces an error, see below). I want to open AL a file, read a record, retrieve another record based on a key value in the AL previously read record, change the values appropriately, and then write the AL updated record back out. ? AL I have been successful at running a SELECT like this: AL connect database; AL SELECT A.*,B.Registrant from A INNER JOIN B USING (Cultivar); AL This gives me a listing to the screen that looks like it worked. Now I'd AL like to update the table A with what comes from table B (for the field called AL Registrant, present in both tables). AL UPDATE A SET A.Registrant=B.Registrant WHERE A.Cultivar=B.Cultivar; AL When I execute this statement, I get an error that it can't find the second AL table in the database but I know it is there--I can access, browse, update AL records in that table, etc. AL It seems like this should be a common thing to want to do but a gentleman AL yesterday on the SuSE list said that this may not be possible with MySQL. MySQL doesn't currently have multi-table updates. You can do SELECT statement first and then using another language organize an update cicle, f.e.: UPDATE A SET A.Registrant='$Registrant' WHERE A.Cultivar='$Cultivar'; $Registrant and $Cultivar are some values from the result of the SELECT query. Or you can use solution that is described for DELETE in the manual: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html AL If not, can I write the Query results of the SELECT statement out to a new AL table and delete the original table? Yes, you can use CREATE ... SELECT statement. AL TIA for any help. AL Andrew Lietzow -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: RE: Backing up/Creating new database
PR, Monday, May 13, 2002, 8:28:20 PM, you wrote: P Thnaks . I tried several variation and they are giving me sql syntax P error: :) mysqldump is not an SQL command, it's a program for database backup. So, you should run it from DOS prompt, f.e. if MySQL is located in C:\mysql, it would be: C:\mysql\bin\mysqldump --no-data database_name C:\tmp1.sql P Mysqldump --no-data database XXX tmp.sql; P I also tried mysqldump --no-data database c:\tmp1.sql P What is the proper syntax? I also get message outfile disabled? As to your question about restoring database you should create database with CREATE DATABASE statement or with mysqladmin and then mysql your_database C:\tmp1.sql P Thanks P Paul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: RE: Password=password('mypassword')
Tewfic, Monday, May 13, 2002, 4:55:35 PM, you wrote: TK Hello, thanks for the suggestions so far but... TK mysql select * from access where UserID='myusername' and Password = TK password('mypassword'); TK Empty set (0.00 sec) Check if your data is correct. It should work. TK mysql select * from access where UserID='myusername' and TK password('mypassword'); TK returns correct result... TK mysql select * from access where UserID='myusername' and TK password('wrongpassword'); TK returns correct result (same result as returned in the previous select) Yes, because password('some_value') gives you TRUE in WHERE clause. TK which brings me to the realization that: TK select * from access where UserID='myusername' and password('mypassword'); TK does not work! it's not checking for the correct password TK Any and all help will be greatly appreciated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: reg installation
radhika, Tuesday, May 14, 2002, 11:41:04 AM, you wrote: rg i have a problem in accessing the MySQL. it denies rg access when i try to change to the mysql database. rg it tells Access denied for user:'@localhost' to rg database 'mysql'. rg I didnt setup any user or password .the server is rg running on the root. You should connect to the MySQL server as a root, too. mysql -uroot Then you get access to the database mysql. Your anonymous user, that is defined as ''(empty string) doesn't have access to the database mysql. rg pls give me neccessary suggestions to overcome this . rg regards, rg radhika -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
how to put passwords for different dbs
Dear sir, Iam created mysql databases with : mysqladmin create database. I was successfull. I created different databases now I want give different password for each database.Is it possible.If so how it was? Waiting for your replay, regards = naveed abdul Software Engineer IndiaCompuMaster Ltd., __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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: --- InnoDB for Win
maxim wrote: Hi? all Can i use InnoDB tables in MySQL Max for Win9x ? Thanks... Hi Maxim, Yes, if you use the -max version, you can. -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - 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 Sorting
Hi, I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns with Russian entries doesn't work properly. Is there an easy way to resolve this and sort rows by Russian alphabet? Vyacheslav - 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
AIX RS6000 installation problem
Hi, I am having a problem running the binary installation for RS6000. I am installing MySQL in AIX 4.3.3 on RS6000 machine. (I had successfully installed MySQL in Linux PC using binary installation, and having C applications running without problem.) I tar everything in /mysql directory then under /mysql/mysql, I try to run the script for GRANT command, I got the following errors: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-130 Symbol resolution failed for mysqld because: 0509-136 Symbol stpcpy (number 137) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 138) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcpy (number 179) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol strcat (number 180) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 182) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 183) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Installation of grant tables failed! I check the /usr/lib/libz.a, there is shr.o inside and in /usr/lib/libc.a, there is shr.o too. I don't understand what is the problem. then I try to skip the script and start the MySQL deamon by typing ./bin/safe_mysqld then I got the following errors, (similar) # ./bin/safe_mysqld exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. chown: 3002-131 mysql is an unknown username. Starting mysqld daemon with databases from /mysql/mysql-3.23.49-ibm-aix4.3.3.0-r s6000/data 020514 19:22:43 mysqld ended do anyone have suggestion for me? what should I check for? thankx Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-test-run errors
all passed up to rpl01: At line 6: query 'slave stop' failed: 1199: This operation requires a running slave, configure slave and do SLAVE START home/mysql/bin/mysqltest: At line 6: query 'load data infile' ../../std_data/words.dat' into table t1' filed: 1085: The file ../../std_data/words.dat' must be in the database directory or be readable by all real 0.08 user 0.02 sys 0.00 Aboring. To continue, re-rum with '--force' Ending Tests Shutting-down MySQL daemon Help please! Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL AIX RS6000 installation problem
Sending again, don't know why cannot send, sorry if duplicated Hi, I am having a problem running the binary installation for RS6000. I am installing MySQL in AIX 4.3.3 on RS6000 machine. (I had successfully installed MySQL in Linux PC using binary installation, and having C applications running without problem.) I tar everything in /mysql directory then under /mysql/mysql, I try to run the script for GRANT command, I got the following errors: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-130 Symbol resolution failed for mysqld because: 0509-136 Symbol stpcpy (number 137) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 138) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcpy (number 179) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol strcat (number 180) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 182) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 183) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Installation of grant tables failed! I check the /usr/lib/libz.a, there is shr.o inside and in /usr/lib/libc.a, there is shr.o too. I don't understand what is the problem. then I try to skip the script and start the MySQL deamon by typing ./bin/safe_mysqld then I got the following errors, (similar) # ./bin/safe_mysqld exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. chown: 3002-131 mysql is an unknown username. Starting mysqld daemon with databases from /mysql/mysql-3.23.49-ibm-aix4.3.3.0-r s6000/data 020514 19:22:43 mysqld ended do anyone have suggestion for me? what should I check for? thankx Borus - 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 in mysqldump when using numeric table names
Hello all, When testing some of our Perl/DBI code, we made a couple of tables with numeric names (e.g. test.1 test.2 etc), because the code we're making has to be able to handle them correctly. It does, w/o any problem, but mysqldump doesn't: I get a message mysqldump: Got error: 1064: You have an error in your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK TABLES while dumping test.1. The syntax for mysqldump is: mysqldump --quick --lock-tables --add-drop-table --user=root test mysqldump Ver 8.14 Distrib 3.23.41, for redhat-linux-gnu (i386) If you have any questions, don't hesitate to ask - I'm on the list and will be watching this thread. Thanx! Ronald - 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 while start mysql service
Hi, I get the follwoing error while starting myssql service. If anybody can help that would be great. Thanks in Advance. Priyesh -- D:\mysql\binnet start mysql The MySql service is starting. The MySql service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. - 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
FW: RE: Project Time
[snip] Do you know if freshmeat is only online certain times of the day/week? I have tried from several different servers of ours to get to it, but it always gives me the Cannot find server message. [/snip] Ooops, my mistake. http://www.freshmeat.net ...typing without thinking again! Jay 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
Re: Is InnoDB 64bit clean?
Ralph, InnoDB works on 64-bit Linux Compaq-Alpha when compiled with gcc. Some suggestions: - have you set the FILE_OFFSET_BITS etc. CFLAGS required for 64-bit file offset addressing? - try to run inside a debugger and look where InnoDB gets stuck. - try compiling with gcc-2.95. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Ralph Mengen [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, May 14, 2002 12:44 PM Subject: Is InnoDB 64bit clean? Hi. I am trying to install MySQL-3.23.49 with BDB and InnoDB under Solaris 8 using the Forte Compiler 6.2 in 64bit mode. I succeed the compilation and installation procedure, but when I try to start the mysql server I receive following logs in my err-file: 020514 10:12:01 mysqld started InnoDB: The first specified data file /var/lib/mysql-3.23.49/ibdata1 did not exist: InnoDB: a new database to be created! 020514 10:12:01 InnoDB: Setting file /var/lib/mysql-3.23.49/ibdata1 size to 400 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 020514 10:12:07 InnoDB: Log file /var/lib/mysql-3.23.49/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql-3.23.49/ib_logfile2 size to 5 MB InnoDB: Database physically writes the file full: wait... And after waiting one hour I decided this can't be correct. :-) When I install the whole thing in 32bit-mode everything is ok! When I install MySQL with BDB (without InnoDB) in 64bit-mode everything is ok! So I wonder where the problem is... Is InnoDB not 64bit clean? Anyone else saw this problem? Greetings, ++ralph P.S.: The same happens when using 3.23.50! _ 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 - 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 while start mysql service
Have you considered using perror? Try perror 10 67. - Original Message - From: Priyesh Panchmatia [EMAIL PROTECTED] Date: Tue, 14 May 2002 20:20:45 +0800 To: [EMAIL PROTECTED] Subject: error while start mysql service Hi, I get the follwoing error while starting myssql service. If anybody can help that would be great. Thanks in Advance. Priyesh -- D:\mysql\binnet start mysql The MySql service is starting. The MySql service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. - 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 -- Powered by Outblaze - 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
Row Locking issue in 3.23.x
Hi. As far as I know, MySQL doesn't suport row-locking, only table locking is available. But I figured table locking for sessions table of CGI::Session::MySQL would be quite inefficient, for there might be millions of rows and hundreds of them could be active at any time. So what do you guys think of locking a specific row with a semaphore file and what conventions should the locker and/or the table should follow? - 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: Row Locking issue in 3.23.x
use InnoDB which does support row-locking (MySQL-Max) -Original Message- From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 9:23 AM To: [EMAIL PROTECTED]; MySQL Maling list Subject: Row Locking issue in 3.23.x Hi. As far as I know, MySQL doesn't suport row-locking, only table locking is available. But I figured table locking for sessions table of CGI::Session::MySQL would be quite inefficient, for there might be millions of rows and hundreds of them could be active at any time. So what do you guys think of locking a specific row with a semaphore file and what conventions should the locker and/or the table should follow? - 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
Encrypting with PASSWORD() function
Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data is there a workaround to deal with this, either than storing in a separeted table the original password string (not encrypted), or shall i simply not use this function ? thanks in advance to any suggestion Walter - 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
diffrent amount of datasets with mysql man perl
Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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 put passwords for different dbs
naveed, Tuesday, May 14, 2002, 2:14:48 PM, you wrote: na Iam created mysql databases with : na mysqladmin create database. I was successfull. na I created different databases now I want give na different password for each database.Is it possible.If na so how it was? na Waiting for your replay, Sure, for example: GRANT ALL ON database1.* to 'user'@'host' IDENTIFIED BY 'password1' GRANT ALL ON database2.* to 'user'@'host' IDENTIFIED BY 'password2' Look at: http://www.mysql.com/doc/G/R/GRANT.html na regards na naveed abdul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: error while start mysql service
Priyesh, Tuesday, May 14, 2002, 3:20:45 PM, you wrote: PP I get the follwoing error while starting myssql service. PP If anybody can help that would be great. PP D:\mysql\binnet start mysql PP The MySql service is starting. PP The MySql service could not be started. PP A system error has occurred. PP System error 1067 has occurred. PP The process terminated unexpectedly. There are some possible causes of error: - wrong configuration of my.cnf(my.ini) file Rename my.ini(my.cnf) file and try to start again. If start was successful, the problem is with with settings. - problems with the \share directory or errmsg.sys files - something wrong with grant tables... Look in your mysql.err file - is there any error message? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: SQL Sorting
support, Tuesday, May 14, 2002, 2:41:35 PM, you wrote: s I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns s with Russian entries doesn't work properly. Is there an easy way to resolve s this and sort rows by Russian alphabet? Set up default-character-set=koi8_ru in my.cnf(my.ini) file or with '--default-character-set' option of mysqld. s Vyacheslav -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
limitation in mysql
Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? - 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 put passwords for different dbs
At 4:14 -0700 5/14/02, naveed abdul wrote: Dear sir, Iam created mysql databases with : mysqladmin create database. I was successfull. I created different databases now I want give different password for each database.Is it possible.If so how it was? Waiting for your replay, Passwords are associated with MySQL user accounts, not with databases. If you want per-database passwords, you'll need to associate a single user account with each database, then connect as a given user to access the corresponding database. regards = naveed abdul Software Engineer IndiaCompuMaster Ltd., - 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 in mysqldump when using numeric table names
At 14:11 +0200 5/14/02, Ronald Landheer wrote: Hello all, When testing some of our Perl/DBI code, we made a couple of tables with numeric names (e.g. test.1 test.2 etc), because the code we're making has to be able to handle them correctly. It does, w/o any problem, but mysqldump doesn't: I get a message mysqldump: Got error: 1064: You have an error in your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK TABLES while dumping test.1. The syntax for mysqldump is: mysqldump --quick --lock-tables --add-drop-table --user=root test You also need the --quote-names option to tell mysqldump to quote the table names as `1`, `2`, etc. mysqldump Ver 8.14 Distrib 3.23.41, for redhat-linux-gnu (i386) If you have any questions, don't hesitate to ask - I'm on the list and will be watching this thread. Thanx! Ronald - 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: Encrypting with PASSWORD() function
Hi Walter My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data The purpose of the encrypted password is not to be able to decrypt it, so that the people who have access to the database couldn't use the user's password for any purposes. To deal with the forgotten passwords, you take all the basic steps to ensure that the user is the one, and create a random string for the user, then apply PASSWORD() on the random password and save it. Then you send the same random string for the user himself. So then, he will use that newly created password to access his account (and chage it to some more friendly one if you provide such functionality) -- sherzodr - 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: Encrypting with PASSWORD() function
Hi Walter, Walter D. Funk wrote: Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data You always (since you have privileges) can change the password of a user. So, forget the password is not a big problem. is there a workaround to deal with this, either than storing in a separeted table the original password string (not encrypted), or shall i simply not use this function ? thanks in advance to any suggestion Walter - 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 -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - 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: Encrypting with PASSWORD() function
At 10:59 -0300 5/14/02, Walter D. Funk wrote: Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data That is correct. PASSWORD() (and ENCRYPT()) perform non-reversible encryption. is there a workaround to deal with this, either than storing in a separeted table the original password string (not encrypted), or shall i simply not use this function ? thanks in advance to any suggestion Walter You can use ENCODE() and DECODE() to perform reversible encryption. As of MySQL 4.0.0, if the server is compiled with SSL support, you can use DES_ENCRYPT() and DES_DECRYPT(). - 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: Stupid - I just can't get it (NOT IN or NOT EXISTS)
On Monday 13 May 2002 17:49, John Doe wrote: Simle query request: I want to display the ID for everyone in a table who is NOT in a second table. so this is what I have come up with SELECT student.SID, student.firstName FROM student WHERE student.SID NOT IN (SELECT msoccerroster.SID FROM msoccerroster) Well, MySQL does not support sub-selects, but you can left join the tables: SELECT student.SID, student.firstName FROM student LEFT JOIN msoccerroster ON msoccerroster.SID = student.SID WHERE msoccerroster.SID IS NULL that should work fine. It comes up with an error 1064: SQL syntax near '(SELECT msoccerroster.SID FROM msoccerroster)' please help J -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: limitation in mysql
[snip] Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? [/snip] You are limited by disk space, RAM, and processing power. There are no AFIAK physical limitations to MySQL itself. Jay - 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: Encrypting with PASSWORD() function
* Walter D. Funk I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data is there a workaround to deal with this, either than storing in a separeted table the original password string (not encrypted), or shall i simply not use this function ? If a user forgets his password, simply create a new one. -- Roger 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
Re: diffrent amount of datasets with mysql man perl
Hi, thanks for the fast replies, It was a database problem. I compared two tables wich were not syncronised and therefor didnt have the same amount of datasets. Thanks sake. Samier.Kesou@bfa-berli An: [EMAIL PROTECTED] n.de Kopie: Thema:diffrent amount of datasets with mysql man perl 14.05.02 15:55 Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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: limitation in mysql
Hey, Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? Question has been asked many times. Check the lists. Answer : no, only limited by drive space. EG - 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: limitation in mysql
* Inbal Ovadia Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? The number of rows in a table is normally limited by the type of the primary key. A TINYINT can only hold 256 values, thus you can only have 256 rows in a table with a TINYINT primary key. The 'normal' (?) datatype for a primary key is INT, a 32 bit integer. This datatype can hold 4294967295 different values, but you will probably not be able to create this number of rows because of OS limitations. A table can also be created without a primary key, then the number of rows is only limited by the OS file size limit. There are a couple of options to get around the OS file size limits: using MERGE tables (merging multiple identical structured tables) or InnoDb tables (multiple table spaces.) The number of tables is limited by the OS only, roughly speaking we can say that you can have as many tables as the OS can have files... :) -- Roger 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
Re: Encrypting with PASSWORD() function
Walter, Tuesday, May 14, 2002, 4:59:15 PM, you wrote: WDF I am trying Mysql Password() function, to encrypt password in a a WDF user/password WDF table, WDF it works fine both ways; it is to say, when I submit a login WDF (user/password) WDF combination it fetches the pair ok. WDF My question is, as I read in the documentation, that the process is WDF irreversible, how can I deal with the fact WDF that a user can forget his password, if I will not be able to retrieve the WDF original string, because what i can see is the encrypted data WDF is there a workaround to deal with this, either than storing in a separeted WDF table the original password string (not encrypted), or shall i simply not WDF use this function ? What about using another functions for encrypting password and user name, f.e. ENCODE()/DECODE() or DES_ENCRYPT()/DES_DECRYPT()? Look at: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html WDF thanks in advance to any suggestion WDF Walter -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Error in mysqldump when using numeric table names
Ronald, Tuesday, May 14, 2002, 3:11:16 PM, you wrote: RL When testing some of our Perl/DBI code, we made a couple of tables with RL numeric names (e.g. test.1 test.2 etc), because the code we're making has to RL be able to handle them correctly. It does, w/o any problem, but mysqldump RL doesn't: I get a message mysqldump: Got error: 1064: You have an error in RL your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK RL TABLES while dumping test.1. RL The syntax for mysqldump is: RL mysqldump --quick --lock-tables --add-drop-table --user=root test RL mysqldump Ver 8.14 Distrib 3.23.41, for redhat-linux-gnu (i386) RL If you have any questions, don't hesitate to ask - I'm on the list and will RL be watching this thread. Names can't consist only of digits! There is a mention about it in our manual: http://www.mysql.com/doc/L/e/Legal_names.html RL Thanx! RL Ronald -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: How do i add an attachment
On Sat, 11 May 2002, yimdjo francis wrote: I have a mailing list in Mysql database working very well; How do I add an ATTACHMENT(files of any type) to emails going to the addresses in the mailing list stored in the database? Hi, adding an attachment means changing the header and adding boundaries and Content-type headers. It's not that easy. You have to adhere to the MIME standard. man metamail and man metasend gets you started. Get RFC2045 from the web and follow the guideline. You will probably have to read messages from one table, add the attachments and store the messages to another table, where your maillist program gets them. Thomas - 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: MySQL Locales
You mean inserting the entries in Greek?? I would say install phpMyAdmin, and insert the entries thru your browser when the browser encoding is Greek ... Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:46 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales Yes, Just add default-character-set=greek line in your /etc/my.cnf (or whereever the global server specificationa are read) . Gurhan Thanks a lot for your prompt reply...Could you please advice me as well how am I going to insert them given that the default language for my machine is English? Thanks, George -Original Message- From: GEORGE KONSTANTINOY LEKEAS [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:07 PM To: [EMAIL PROTECTED] Subject: MySQL Locales Hi All, I am running MySQL on Unix and Linux and I would like to know whether different locales are supported. I am interested, more specifically, in developing a database which is going to be populated with Greek names, so I am after any support provided for Greek locale. Could you please give me any pointers for that? I look forward to hearing from you soon. Thanks in advance. George __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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 __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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: NOW()
You may SELECT the current value and write it back explicitely when UPDATEing the table. Then it stays as it was. Thomas On Mon, 13 May 2002, Jeff Kilbride wrote: The first timestamp field in any table is always updated when the row changes: http://www.mysql.com/doc/D/A/DATETIME.html If you don't want this behavior, use a date or datetime field instead. --jeff - Original Message - From: Damnish [EMAIL PROTECTED] To: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED]; MYSQL [EMAIL PROTECTED] Sent: Monday, May 13, 2002 9:13 AM Subject: Re: NOW() curdate() - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Sunday, May 12, 2002 12:34 AM Subject: NOW() Hi, I have a table with a timestamp field called dtins. When i insert a row to the table, the value of this field is setted to NOW() just for the inserted the record. My problem is when i update some record, its dtinst value is change again, without a ask to :( How can i avoid this? Is there another function that i can use to get the current datetime? Thank u very much, Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql,query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus Database: 199 - Release Date: 7/5/2002 - 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: limitation in mysql
Actually there is a maximum table limit , for MyISAM tables .. and that is 8 million terabytes, if you can ever reach that : The limitations in MySQL is limited by the OS limits... See: http://www.mysql.com/doc/T/a/Table_size.html Gurhan -Original Message- From: Inbal Ovadia [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: limitation in mysql Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? - 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: RE: MySQL Locales
That's a good idea, but if you have something like 2000 entries it can be a lifetime typing one by one...that's why I would like to do it through a script...Does phpmyadmin supports scripts? George - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 4:33 PM Subject: RE: RE: MySQL Locales You mean inserting the entries in Greek?? I would say install phpMyAdmin, and insert the entries thru your browser when the browser encoding is Greek ... Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:46 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales Yes, Just add default-character-set=greek line in your /etc/my.cnf (or whereever the global server specificationa are read) . Gurhan Thanks a lot for your prompt reply...Could you please advice me as well how am I going to insert them given that the default language for my machine is English? Thanks, George -Original Message- From: GEORGE KONSTANTINOY LEKEAS [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:07 PM To: [EMAIL PROTECTED] Subject: MySQL Locales Hi All, I am running MySQL on Unix and Linux and I would like to know whether different locales are supported. I am interested, more specifically, in developing a database which is going to be populated with Greek names, so I am after any support provided for Greek locale. Could you please give me any pointers for that? I look forward to hearing from you soon. Thanks in advance. George __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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 __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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: RE: MySQL Locales
Yes you can.. http://www.phpmyadmin.net/documentation/#intro Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 11:51 AM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales That's a good idea, but if you have something like 2000 entries it can be a lifetime typing one by one...that's why I would like to do it through a script...Does phpmyadmin supports scripts? George - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 4:33 PM Subject: RE: RE: MySQL Locales You mean inserting the entries in Greek?? I would say install phpMyAdmin, and insert the entries thru your browser when the browser encoding is Greek ... Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:46 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales Yes, Just add default-character-set=greek line in your /etc/my.cnf (or whereever the global server specificationa are read) . Gurhan Thanks a lot for your prompt reply...Could you please advice me as well how am I going to insert them given that the default language for my machine is English? Thanks, George -Original Message- From: GEORGE KONSTANTINOY LEKEAS [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:07 PM To: [EMAIL PROTECTED] Subject: MySQL Locales Hi All, I am running MySQL on Unix and Linux and I would like to know whether different locales are supported. I am interested, more specifically, in developing a database which is going to be populated with Greek names, so I am after any support provided for Greek locale. Could you please give me any pointers for that? I look forward to hearing from you soon. Thanks in advance. George __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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 __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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: Emebedded MySQL Engine Client Server Engine
Hi Nirmal, Now i understand what you wish to do. MySQL daemon don't use libmysql.This library is for client. I think you have at least 2 option : 1.Devices work off line with RDBMS and half duplex communication (from devices to DataBase). - but this devices must do an output into ASCII file, to be imported after in mysql database using LOAD DATA.This can be a script handled by crontab, for example. 2.Devices work on line with RDBMS and full duplex communication: - this solution expect to write an server application (which use libmysql-in this library are all functions you need for connecting,querying,retrieve data ...) for this devices but client for the mysql daemon and which must organize data outputted from devices to put in the mysql table.(This is 3-tier application) In this cases ,i think , you can use one machine for both:devices and mysql daemon.REASON : you don't handle very large data. It happens i have already done a similarly application but using solution no. 2. It's work (non-stop,over 1 year) very good and it's very safe.MySQL server(Linux version) it's very stable and the libmysql (Linux and Windows) is a quite success. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making UPDATE return the no. of rows matched
I'm having some trouble with this issue...I'm using perl DBI and mysql for a customer addressbook. I know MySQL won't needlessly update a row if nothing's changed, but since I'm using $rc = $sth-rows; as an indicator of success, customers will get stuck if they decide they don't want to change anything and they click update (shopper can't move forward until some success indicator is sent) . MySQL sends back 0 for rows affected. I could fake it for UPDATE queries and return successful even though no rows were matched, but then what if there really was a problem? The address wouldn't be updated, but the customer would think it was. I know I can send back rows matched by setting the CLIENT_FOUND_ROWS flag, but then does that mean $sth-rows will return rows matched instead of rows affected for every query in my script (i have several different actions in my script whose success is keyed off of $sth-rows.) I can't find much information on how to set CLIENT_FOUND_ROWS and how to set the flag and use the info. Any help is appreciated! (paul d - BTW, I LOVE MySQL and Perl for the Web, it's my bible. thanks for writing such a great book) Thanks, Rory On Thu, 2002-03-14 at 09:51, Paul DuBois wrote: At 10:41 +0100 3/14/02, Rune Steinseth wrote: Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really updated, not the rows matched of an UPDATE. This causes problems. Is there an easy way to get MySQL always return the number of rows matched in an UPDATE? There's a flag you can set to control this when connecting to the MySQL server, if you're using the C API or the Perl DBI API. I don't think there's an option for this in Java, at least if you're using the MM.MySQL driver. It seems to set the CLIENT_FOUND_ROWS flag unconditionally. I guess you could change the source and recompile. Regards, Rune Steinseth __ Sjekk snørapporter... fra 500 ski-destinasjoner i Europa på http://no.snow.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
BDB wrapped transaction id's
Hi! Robert == Robert Cross [EMAIL PROTECTED] writes: Robert Anyone seen a message like: Robert 020509 0:05:30 bdb: txn_begin: transaction ID wrapped. Exit the database environment Robert and restart the application as if application failure had occurred Robert Now for the important followup question - what does this mean, and how do I stop it Robert happening again? This means something went awfully wrong inside the bdb handler. Unfortunately the only way to get this fixed is if you can do a repeatable case where this happens on a clean database :( Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: Making UPDATE return the no. of rows matched [from Perl]
At 11:35 -0500 5/14/02, rory oconnor wrote: I'm having some trouble with this issue...I'm using perl DBI and mysql for a customer addressbook. I know MySQL won't needlessly update a row if nothing's changed, but since I'm using $rc = $sth-rows; as an indicator of success, customers will get stuck if they decide they don't want to change anything and they click update (shopper can't move forward until some success indicator is sent) . MySQL sends back 0 for rows affected. I could fake it for UPDATE queries and return successful even though no rows were matched, but then what if there really was a problem? The address wouldn't be updated, but the customer would think it was. If there is an error $DBI::err or $dbh-err() will contain a non-empty error message. That may be enough for you to disambiguate whether a zero row count means no rows changed or an error occurred. I know I can send back rows matched by setting the CLIENT_FOUND_ROWS flag, but then does that mean $sth-rows will return rows matched instead of rows affected for every query in my script (i have several different actions in my script whose success is keyed off of $sth-rows.) I can't find much information on how to set CLIENT_FOUND_ROWS and how to set the flag and use the info. Any help is appreciated! (paul d - BTW, I LOVE MySQL and Perl for the Web, it's my bible. thanks for writing such a great book) Thanks. Since you have the bible (thanks for writing that with a little b), the answer to your question's in a footnote on page 37. :-) Basically, just add ;mysql_client_found_rows=1 to the end of your DSN string. Thanks, Rory On Thu, 2002-03-14 at 09:51, Paul DuBois wrote: At 10:41 +0100 3/14/02, Rune Steinseth wrote: Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really updated, not the rows matched of an UPDATE. This causes problems. Is there an easy way to get MySQL always return the number of rows matched in an UPDATE? There's a flag you can set to control this when connecting to the MySQL server, if you're using the C API or the Perl DBI API. I don't think there's an option for this in Java, at least if you're using the MM.MySQL driver. It seems to set the CLIENT_FOUND_ROWS flag unconditionally. I guess you could change the source and recompile. Regards, Rune Steinseth __ Sjekk snørapporter... fra 500 ski-destinasjoner i Europa på http://no.snow.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
source code
Can i download the source code for MySQL? - 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
foreign key constraint to itself
Hi, I am just wondering can I create foreign key constraint to itself in mySQL innodb (the mySQL 3.23.50 release)? Let's say we have a table: test_table_01 (id integer, pid integer) type = innodb. Can I create a foreign key on pid and reference to test_table_01 (id)? Thanks, Lisa - 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: Emebedded MySQL Engine Client Server Engine
Hi Nirmal, Now i am a little confused from you. We discuss about how some devices(not Personal Computers) is possible to have a communication with MySQL? ... or... ...replication,data redundancy it's a different kind of items than we talk about. You can run two different servers pointing to the same data dir ... only the processes of MySQL server or an MySQL client application . then mysqld has no hangup if multiple processes use the same file. ... if are MySQL processes. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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
shutting down mysql
I looked through the documentation, and I see how to start the dbase/server, but how do I stop it.. Just kill the mysql daemon? Thanks Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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 slow (again)
Hi, I have changed my query but it is so slow :( Please, help me! Thank u very much! Edilson. - Query - SELECT a.idemail, a.fklastresp FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c LEFT JOIN wmkt_email_sent d ON a.idemail=d.fkemail WHERE d.fkemail IS NULL AND c.bActive AND c.fkmaillist IN (2) AND a.idemail=b.fkemail AND c.fkclient=b.idclient ORDER BY fklastresp LIMIT 1000 - Tables structures - Table,Create Table wmkt_email,CREATE TABLE `wmkt_email` ( `idemail` int(11) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `fklastresp` int(11) NOT NULL default '0', PRIMARY KEY (`idemail`), UNIQUE KEY `ixEmail` (`email`) ) TYPE=MyISAM Table,Create Table wmkt_client,CREATE TABLE `wmkt_client` ( `idclient` int(11) NOT NULL auto_increment, `realname` varchar(80) NOT NULL default '', `fkemail` int(11) NOT NULL default '0', `dtInsert` datetime default NULL, `dtLastUp` datetime default NULL, `fkuser` int(11) NOT NULL default '1', PRIMARY KEY (`idclient`), KEY `ixFkemail` (`fkemail`) ) TYPE=MyISAM - Table,Create Table wmkt_maillist_client,CREATE TABLE `wmkt_maillist_client` ( `fkmaillist` int(11) NOT NULL default '0', `fkclient` int(11) NOT NULL default '0', `dtInsert` datetime default NULL, `bActive` tinyint(4) NOT NULL default '1', KEY `ixEmailList` (`fkmaillist`,`fkclient`) ) TYPE=MyISAM - Table,Create Table wmkt_email_sent,CREATE TABLE `wmkt_email_sent` ( `idemailsent` int(11) NOT NULL auto_increment, `fkpbl` int(11) NOT NULL default '0', `fkemail` int(11) NOT NULL default '0', `dtSend` datetime default NULL, `nResult` int(11) NOT NULL default '0', `dtLastUp` datetime default NULL, `nMachine` int(11) NOT NULL default '0', PRIMARY KEY (`idemailsent`), UNIQUE KEY `ixUEmailPbl` (`fkemail`,`fkpbl`), KEY `ixnMacPbl` (`nMachine`,`fkpbl`,`fkemail`) ) TYPE=MyISAM - 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: source code
yes, http://www.mysql.com/downloads Amy Zediak wrote: Can i download the source code for MySQL? - 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc. - 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: shutting down mysql
mysqladmin [...] shutdown http://www.mysql.com/doc/m/y/mysqladmin.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: shutting down mysql I looked through the documentation, and I see how to start the dbase/server, but how do I stop it.. Just kill the mysql daemon? Thanks Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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
Mysql 4.0
Has anyone installed the mysql 4.0 HP-UX binary (10.20) on an 11.00 box? If so did it work okay...? What about builing from the source on 11.00? Any big issues I should be aware of? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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 for search on mysql database
* Aman Raheja I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user searches for Rim Torus, I am though. But how to allow results if the search is Jerry Classy, saying Any should match and have both second and third rows returned? You should split the user input in your script, and then check for each of the words. Your resulting query could be something like this: SELECT * FROM Author WHERE (name LIKE '%Jerry%') OR (name LIKE '%Classy%') If your Match All search is supposed to find row 3 when searching for Roan Classy, you can use the same mechanism, except you use AND instead of OR. Another 'trick of the trade' is to remove commas and other special characters, so that even a search for Classy, Roan would find the third row. Beware that these methods (LIKE '%...) makes the use of indexes impossible, and your query may get slow if the table is big (like 10+ rows). -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Emebedded MySQL Engine Client Server Engine
Hi Nirmal, If i understand well you make reference at MySQL files.In this case the client application cannot access this file directly , only by MySQL daemon using the libmysql library and not by embedded library.In my opinion i find that is VERY DANGEROUS It seems is not to be very sophisticated files format but i am sure that exists a lot of technics to manipulate data from this file. Look a little at libmyisam ... I didn't experimented some like this but you have the freedom to try. My friends said about me that i have a rich imagination but you went over with your imagination. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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
query for search on mysql database
Hi All I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user searches for Rim Torus, I am though. But how to allow results if the search is Jerry Classy, saying Any should match and have both second and third rows returned? Help is appreciated. Thanks Aman _ 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: query for search on mysql database
I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has first='$first' OR last='$last' OR). BUT, when I search using any field (or simply click my submit button) it returns ALL records in the database. Where is my SQL flawed? SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' OR (first LIKE '$first%') OR (last LIKE '$last%') OR (email LIKE '$email%') OR (phone LIKE '$phone%') OR (message LIKE '$message%') OR (time LIKE '$time%') ORDER BY id DESC; Mike - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Aman Raheja [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 2:47 PM Subject: RE: query for search on mysql database * Aman Raheja I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user searches for Rim Torus, I am though. But how to allow results if the search is Jerry Classy, saying Any should match and have both second and third rows returned? You should split the user input in your script, and then check for each of the words. Your resulting query could be something like this: SELECT * FROM Author WHERE (name LIKE '%Jerry%') OR (name LIKE '%Classy%') If your Match All search is supposed to find row 3 when searching for Roan Classy, you can use the same mechanism, except you use AND instead of OR. Another 'trick of the trade' is to remove commas and other special characters, so that even a search for Classy, Roan would find the third row. Beware that these methods (LIKE '%...) makes the use of indexes impossible, and your query may get slow if the table is big (like 10+ rows). -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 for search on mysql database
* MikeParton I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has first='$first' OR last='$last' OR). BUT, when I search using any field (or simply click my submit button) it returns ALL records in the database. Where is my SQL flawed? SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' OR (first LIKE '$first%') OR (last LIKE '$last%') OR (email LIKE '$email%') OR (phone LIKE '$phone%') OR (message LIKE '$message%') OR (time LIKE '$time%') ORDER BY id DESC; If any of your $-variables are empty, the criteria will be ... LIKE '%', and this will match all rows, and return all rows, because you use OR. Change it to AND, and it should work as expected. If OR is what you want, you should only check the fields where the user actually have entered something... but you should probably use AND... If a user enters a first name and a single letter in the last field, he would probably expect to get persons with the entered first name and a last name starting with the provided letter, not all persons with that first name and all persons with a last name starting with the single letter. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query slow (again)
Hi, Try this... Do an alter and create indexes on the following fields of your tables: -wmkt_email_sent.fkemail -wmkt_client.fkemail -wmkt_maillist_client.fkclient ... and i think it's a good idea if you create indexes on the primary keys of each table.It's redundant but have some effect. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 8:31 PM Subject: Query slow (again) Hi, I have changed my query but it is so slow :( Please, help me! Thank u very much! Edilson. - Query - SELECT a.idemail, a.fklastresp FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c LEFT JOIN wmkt_email_sent d ON a.idemail=d.fkemail WHERE d.fkemail IS NULL AND c.bActive AND c.fkmaillist IN (2) AND a.idemail=b.fkemail AND c.fkclient=b.idclient ORDER BY fklastresp LIMIT 1000 - Tables structures - Table,Create Table wmkt_email,CREATE TABLE `wmkt_email` ( `idemail` int(11) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `fklastresp` int(11) NOT NULL default '0', PRIMARY KEY (`idemail`), UNIQUE KEY `ixEmail` (`email`) ) TYPE=MyISAM Table,Create Table wmkt_client,CREATE TABLE `wmkt_client` ( `idclient` int(11) NOT NULL auto_increment, `realname` varchar(80) NOT NULL default '', `fkemail` int(11) NOT NULL default '0', `dtInsert` datetime default NULL, `dtLastUp` datetime default NULL, `fkuser` int(11) NOT NULL default '1', PRIMARY KEY (`idclient`), KEY `ixFkemail` (`fkemail`) ) TYPE=MyISAM - Table,Create Table wmkt_maillist_client,CREATE TABLE `wmkt_maillist_client` ( `fkmaillist` int(11) NOT NULL default '0', `fkclient` int(11) NOT NULL default '0', `dtInsert` datetime default NULL, `bActive` tinyint(4) NOT NULL default '1', KEY `ixEmailList` (`fkmaillist`,`fkclient`) ) TYPE=MyISAM - Table,Create Table wmkt_email_sent,CREATE TABLE `wmkt_email_sent` ( `idemailsent` int(11) NOT NULL auto_increment, `fkpbl` int(11) NOT NULL default '0', `fkemail` int(11) NOT NULL default '0', `dtSend` datetime default NULL, `nResult` int(11) NOT NULL default '0', `dtLastUp` datetime default NULL, `nMachine` int(11) NOT NULL default '0', PRIMARY KEY (`idemailsent`), UNIQUE KEY `ixUEmailPbl` (`fkemail`,`fkpbl`), KEY `ixnMacPbl` (`nMachine`,`fkpbl`,`fkemail`) ) TYPE=MyISAM - 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: Help with UPDATE and SET with two tables
On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote: If not, can I write the Query results of the SELECT statement out to a new table and delete the original table? Yes, you can use CREATE ... SELECT statement. Thank you for the reply, Egor. Here is what I have tried since your reply but it doesn't like my syntax connect hostas; CREATE TABLE hostas_01 (UNIQUE(Cultivar)) SELECT LML.ML_ID LML.Cultivar LML.Reg_Status LML.Section LML.Class LML.ML_ITG_ID LML.Reference AHS.Registrant FROM LML INNER JOIN AHS USING (Cultivar); To look at the actual data, go here http://dev.hostahaven.com/cgi-bin/mysqlman/mysql.cgi use host = localhost User = hostas Password = hostas (I hope I have the security high enough that nobody will steal my hostas!) Select the hostas database. You'll see the LML table and the AHS table. What I want to do is move the value for Registrant in the AHS table to Registrant in the LML table (using Cultivar at the record key). If I can do that with a JOIN statement WITHIN the mySQLMan package, I don't know how, and unfortunately, I have not been able to get the phpMyAdmin to load So, that is where I am. I'm trying to avoid exporting to a spreadsheet or another language -- I want to do this all within MySQL, if possible... That's my problem. TIA for any help... -- Andrew Lietzow The ACL Group, Inc. - 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 table setup question.
Subject: A table setup question. From: al butler [EMAIL PROTECTED] === I have the MySQL book and I am trying to come to terms on how to setup a column that is based on another one. Let me try and explain. Each row has a string (unique) and indexed. This string is catergorized by anothe column defined as a SET , let's call it 1,2,3,4,5,6. From my readings this seems to be effiecient than having it classified as a VARCHAR and is also readable. It's treated as an int and can be indexed faster and more effecient. But for item 6 in the SET, you can have up to 20+ categories. This sub-category I have defined as another SET and it's named something like sub6. Now the SET can have other subcategories, so right now I would add another column for each SET that needs a sub-category. Kind of ugly. Let's recap: col1 string (VARCHAR) 64 col2 category (SET) 1,2,3,4,5,6 col3 subcategory of col2 6)SET A,B,C,D,E,F,G,H A set can have 64 items. I don't forsee col2 to ever reach this. I can forsee col3 possibly having 64 sub-categories of col2. My question. Is this the best I can do for a sub-category? Any suggestions? Regards Al - 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
RAND and MySQL version!
Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL, and Linux, but when I run it on the other server, I get sql error. SELECT ID,Headlines,IsActive FROM DATABASE WHERE IsActive=1 ORDER BY RAND() LIMIT 1 Can anyone please tell me if it's the version of MySQL causing this problem or something else? Is there anyway to get around this, without upgrading MySQL? Thanks so much, Soheil - 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 1114
I'm trying to create an index on a large-ish table. It runs for about 10 minutes and then I get: ERROR 1114: The table '#sql-3584_4' is full I've started mysqld with --big-tables and even set SQL_BIG_TABLES=1; for good luck but it still keeps erroring out. Anybody got any ideas? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.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: query for search on mysql database
I want an OR test. If someone searches on last name and enters nothing in the other fields, I want to find the record(s). Similarly, if they enter a first name and no other data, I want to find the record(s). The part I realize I am missing is to first test to see which fields have been filled in. Need some pointers on how to start that. Thanks! Mike - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MikeParton [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 3:49 PM Subject: RE: query for search on mysql database * MikeParton I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has first='$first' OR last='$last' OR). BUT, when I search using any field (or simply click my submit button) it returns ALL records in the database. Where is my SQL flawed? SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' OR (first LIKE '$first%') OR (last LIKE '$last%') OR (email LIKE '$email%') OR (phone LIKE '$phone%') OR (message LIKE '$message%') OR (time LIKE '$time%') ORDER BY id DESC; If any of your $-variables are empty, the criteria will be ... LIKE '%', and this will match all rows, and return all rows, because you use OR. Change it to AND, and it should work as expected. If OR is what you want, you should only check the fields where the user actually have entered something... but you should probably use AND... If a user enters a first name and a single letter in the last field, he would probably expect to get persons with the entered first name and a last name starting with the provided letter, not all persons with that first name and all persons with a last name starting with the single letter. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RAND and MySQL version!
At 13:26 -0700 5/14/02, Soheil Shaghaghi wrote: Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL, and Linux, but when I run it on the other server, I get sql error. SELECT ID,Headlines,IsActive FROM DATABASE WHERE IsActive=1 ORDER BY RAND() LIMIT 1 Can anyone please tell me if it's the version of MySQL causing this problem or something else? Yes. Expressions in the ORDER BY clause are not supported prior to 3.23.2. Is there anyway to get around this, without upgrading MySQL? SELECT ID*0+RAND() AS r, ID, Headlines, ... ORDER BY r LIMIT 1; Thanks so much, Soheil - 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: RAND and MySQL version!
You can't do ORDER BY RAND() prior to version 3.23... On your 3.22.32 version do something like: SELECT column_name*0+RAND() AS rnd FROM table_name WHERE IsActive=1 ORDER BY rnd LIMIT 1; Gurhan -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:26 PM To: [EMAIL PROTECTED] Subject: RAND and MySQL version! Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL, and Linux, but when I run it on the other server, I get sql error. SELECT ID,Headlines,IsActive FROM DATABASE WHERE IsActive=1 ORDER BY RAND() LIMIT 1 Can anyone please tell me if it's the version of MySQL causing this problem or something else? Is there anyway to get around this, without upgrading MySQL? Thanks so much, Soheil - 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 1114
Found it, it was INNODB running out of space. (Can we get better error messages here?) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:24 PM To: [EMAIL PROTECTED] Subject: Error 1114 I'm trying to create an index on a large-ish table. It runs for about 10 minutes and then I get: ERROR 1114: The table '#sql-3584_4' is full I've started mysqld with --big-tables and even set SQL_BIG_TABLES=1; for good luck but it still keeps erroring out. Anybody got any ideas? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.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: query for search on mysql database
I guess what might help is to explain that the form fields are on a page with method=POST action=results.php The sql I provided originally is in results.php and I use the superglobal $_POST to pull the variables from the form field. I want the query results to be based on the variables which, in turn, are based on the user input from the original page. I redid my query substituting AND for OR and it failed to return any records. ??? Thanks! Mike - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 4:51 PM Subject: Re: query for search on mysql database I think that was what roger is saying. If you simply change the OR's to AND's your searchwill work as you want it to. For example some one looks for a person by the last name of Smith.so all the other fields will be blank and your statement would look like: SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' AND ((first LIKE '%') AND (last LIKE 'Smith%') AND (email LIKE '%') AND (phone LIKE '%') AND (message LIKE '%') AND (time LIKE '%')) ORDER BY id DESC; This will return anything that has a last name of smith. The only thing I question now is the ID value. Will you let people use partial ids or must they know the entire string/number. Also if you want to use only the entire ID you could simply have a statement like: SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' as I'm guessing your id is the primary key. I want an OR test. If someone searches on last name and enters nothing in the other fields, I want to find the record(s). Similarly, if they enter a first name and no other data, I want to find the record(s). The part I realize I am missing is to first test to see which fields have been filled in. Need some pointers on how to start that. Thanks! Mike - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MikeParton [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 3:49 PM Subject: RE: query for search on mysql database * MikeParton I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has first='$first' OR last='$last' OR). BUT, when I search using any field (or simply click my submit button) it returns ALL records in the database. Where is my SQL flawed? SELECT id, first, last, email, phone, message, time FROM visitors WHERE id='$id' OR (first LIKE '$first%') OR (last LIKE '$last%') OR (email LIKE '$email%') OR (phone LIKE '$phone%') OR (message LIKE '$message%') OR (time LIKE '$time%') ORDER BY id DESC; If any of your $-variables are empty, the criteria will be ... LIKE '%', and this will match all rows, and return all rows, because you use OR. Change it to AND, and it should work as expected. If OR is what you want, you should only check the fields where the user actually have entered something... but you should probably use AND... If a user enters a first name and a single letter in the last field, he would probably expect to get persons with the entered first name and a last name starting with the provided letter, not all persons with that first name and all persons with a last name starting with the single letter. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e- mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql- unsubscribe- [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: A table setup question.
* al butler [EMAIL PROTECTED] I have the MySQL book and I am trying to come to terms on how to setup a column that is based on another one. Let me try and explain. Each row has a string (unique) and indexed. This string is catergorized by anothe column defined as a SET , let's call it 1,2,3,4,5,6. From my readings this seems to be effiecient than having it classified as a VARCHAR and is also readable. It's treated as an int and can be indexed faster and more effecient. Correct. But for item 6 in the SET, you can have up to 20+ categories. This sub-category I have defined as another SET and it's named something like sub6. Now the SET can have other subcategories, so right now I would add another column for each SET that needs a sub-category. Kind of ugly. Yes... :) Let's recap: col1 string (VARCHAR) 64 col2 category (SET) 1,2,3,4,5,6 col3 subcategory of col2 6)SET A,B,C,D,E,F,G,H A set can have 64 items. I don't forsee col2 to ever reach this. I can forsee col3 possibly having 64 sub-categories of col2. My question. Is this the best I can do for a sub-category? Any suggestions? One word: normalize Add an INT primary key, (keep the UNIQUE constraint on col1) and add a second table for col3 and potential future sub categories. This table should also have an INT primary key. Then add a third table to connect the two, with two INT fields, and a compound primary key, containing both INT fields. Also, add an index for the second field of the primary key[1]. These two fields are foreign keys, and 'points to' the keys of your main data table and the category table. This way, you will keep up the speed of your queries, but, just as important, you will have a clean design wich scales well, without the need for repeatedly doing changes to the db schema. [1] If the primary key is (data_id,category_id), it will be very slow to do a search for all occurrences of data items for one category without an extra index on category_id, and if it is (category_id,data_id) it will be slow to list all categories of an data item without an index on data_id. If you don't need one or the other, you can drop this index, just make sure you put the right id first in the primary key. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: query for search on mysql database
* MikeParton I guess what might help is to explain that the form fields are on a page with method=POST action=results.php The sql I provided originally is in results.php and I use the superglobal $_POST to pull the variables from the form field. I want the query results to be based on the variables which, in turn, are based on the user input from the original page. I redid my query substituting AND for OR and it failed to return any records. Did you remove id='$id' from the WHERE clause? You probably should. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL load problems - gcc-2.96?
Mike Robinson [EMAIL PROTECTED] writes: Thanks for your note. You wrote: There are known problems with gcc-2.96 which comes with RH 7.2 distribution. There is disclaimer about it at www.mysql.com/downloads/mysql-3.23.html as you noticed. There is much reading on the GCC 2.96 issue. There seems to be two paths of dicussion. I mention them here with all due respect. The first path is the one I subscribed too when I first got bit on the hindside by this. Basically, the gcc people forked 2.95.2 and it became 2.96. Only, it really wasn't 2.96. The version number 2.96 wasn't actually a version number, rather, the _codename_ for the development branch. I found this whole statement ludicrous. At this point, I figured it was a huge GCC problem that RedHat got sucked into. That sorry excuse for an official statement can be found here: http://gcc.gnu.org/gcc-2.96.html There is no official RedHat position that I can find. I did find this though: http://www.bero.org/gcc296.html does a good job of it, so we decided not to fuel more flamewars. FWIW, reproducible testcases are good... all complex software products have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in interaction with oneanother (e.g. timing/locking issues), so reproducible testcases are a necessity. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Problem with DDL
I don't think quoted identifiers are supported in 3.22.x. --jeff - Original Message - From: Steve Edberg [EMAIL PROTECTED] To: Elliot L. Tobin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 13, 2002 3:42 PM Subject: Re: Problem with DDL 'when' is a reserved word: http://www.mysql.com/doc/R/e/Reserved_words.html I don't think MySQL is using it yet, but it's probably forbidden by the ANSI SQL standard. If you really want to use it as a column name, I think you can quote it - CREATE TABLE news(..., 'when' timestamp, ) - but it's probably best to pick another name that's not in the reserved list. -steve At 4:22 PM -0400 5/13/02, Elliot L. Tobin wrote: I pulled this DDL from a MySQL server and am trying to load it into a MySQL server runinng 3.22.49, but I get errors with the DDL. CREATE table news ( id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment, subject varchar(80), when timestamp(14), body text, who smallint(5) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); ERROR 1064 at line 3: You have an error in your SQL syntax near 'when timestamp(14), body text, who smallint(5) unsigned DEFAULT '0' NOT NULL' at line 4 -- Any help is appreciated.. Please email me directly.. -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | If only life would imitate toys. | | - Ted Raimi, March 2002 | | - http://www.whoosh.org/issue67/friends67a.html#raimi | ++ - 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: Best book on MySQL
Hi Mike, What did you think of Firebird vs. MySQL? I haven't seen any comparisons by people who have used both. Thanks, --jeff - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 7:25 PM Subject: Re: Best book on MySQL I ported several applications from Firebird 1.0 to MySQL 4. The main things I ran into was little SQL Syntax differences, Stored procedures, and Triggers... mike Paul DuBois wrote: At 13:40 -0700 5/11/02, Jeff Kilbride wrote: MySQL Paul DuBois New Riders Plus, he's here on the list answering questions... :) That's true. However, I should mention that the book doesn't say anything about InterBase. :-) --jeff - Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 8:43 AM Subject: Best book on MySQL I need to convert a PHP app from using Interbase to using MySQL. What is the best book? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
LINK2001, I need help
I desperately need to find a solution to this problem: Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary. my.ini File: [mysqld] basedir=D:/mysql datadir=D:/mysql/data 1.-On prompt: D:\mysql\binmysqld-nt --install the current server installed: ... (sucessfull) D:\mysql\binNET START mysql El servicio de mysql se ha iniciado con exito (sucessfull) D:\mysql\binmysqlshow -u root mysql Database: mysql ... (sucessfull) D:\mysql\binmysql test Welcome to teh mysqlserver (sucessfull) 2.- My c file is: #include winsock.h #if defined(_WIN32) || defined(_WIN64) #include windows.h #endif #include mysql\mysql.h main (){ MYSQL * db; db=mysql_init(0); mysql_real_connect(db,localhost, 0,0, test, 0, 0, 0); mysql_close(db); } .- The output: Compiling... prueba.c Linking... prueba.obj : error LNK2001: unresolved external symbol _mysql_close@4 prueba.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32 prueba.obj : error LNK2001: unresolved external symbol _mysql_init@4 Debug/mysql.exe : fatal error LNK1120: 3 unresolved externals Error executing link.exe. mysql.exe - 4 error(s), 0 warning(s) thanks. migu - 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
Performance Tuning?
Where can I find some info on mysql performance tuning? _ Devon Harding System Administrator Gilat Latin America 954-858-1600 [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
LINK2001, I need help
I desperately need to find a solution to this problem: Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary. my.ini File: [mysqld] basedir=D:/mysql datadir=D:/mysql/data 1.-On prompt: D:\mysql\binmysqld-nt --install the current server installed: ... (sucessfull) D:\mysql\binNET START mysql El servicio de mysql se ha iniciado con exito (sucessfull) D:\mysql\binmysqlshow -u root mysql Database: mysql ... (sucessfull) D:\mysql\binmysql test Welcome to teh mysqlserver (sucessfull) 2.- My c file is: #include winsock.h #if defined(_WIN32) || defined(_WIN64) #include windows.h #endif #include mysql\mysql.h main (){ MYSQL * db; db=mysql_init(0); mysql_real_connect(db,localhost, 0,0, test, 0, 0, 0); mysql_close(db); } 4.- The output: Compiling... prueba.c Linking... prueba.obj : error LNK2001: unresolved external symbol _mysql_close@4 prueba.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32 prueba.obj : error LNK2001: unresolved external symbol _mysql_init@4 Debug/mysql.exe : fatal error LNK1120: 3 unresolved externals Error executing link.exe. mysql.exe - 4 error(s), 0 warning(s) thanks. migu - 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
builidng mysql-4.0.1-alpha
Hi all, I am attempting to build mysql-4.0.1-alpha on an HP-UX 11.00 box because the binary I installed worked, but I couldnet connect to the database by typing in a password at the prompt, I had to actually pass it on the command line. I figured there might be a few other odd behaviors that would show themselves later... I did a configure, and then a make, and it errored out when it was compiling rltty.c, which deals with reading information from the terminal... (Sounds familliar) I was advised to reconfigure with --without-readline (which will use the system supplied readline instead of mysql's readline). I did this and I got further. Now when I do a make, it is erroring on the following in libmysql.c some info.. using gcc version 3.0.1 using gmake version 3.79.1 Here is the errors it is returning libmysql.c: In function `read_user_name': libmysql.c:524: warning: assignment makes pointer from integer without a cast libmysql.c:526: warning: assignment makes pointer from integer without a cast libmysql.c:527: dereferencing pointer to incomplete type libmysql.c:528: warning: assignment makes pointer from integer without a cast libmysql.c:528: warning: assignment makes pointer from integer without a cast libmysql.c:529: warning: assignment makes pointer from integer without a cast libmysql.c: In function `mysql_once_init': libmysql.c:1344: warning: assignment makes pointer from integer without a cast libmysql.c:1357: warning: assignment makes pointer from integer without a cast libmysql.c: In function `mysql_real_connect': libmysql.c:1505: warning: assignment makes pointer from integer without a cast *** Error exit code Here is the out of mysqlbug, taken from the binary instance I had built and still have on the system, it is not running or active.. Everything is the same, except I built with gnu make... Release:mysql-3.23.49 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: HP-UX u3p1util B.11.00 U 9000/800 164951547 unlimited-user license Some paths: /usr/bin/perl /usr/bin/make /opt/gcc/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.1/specs Configured with: ./configure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfigured) ./configure : (reconfigured) ./configure Thread model: single gcc version 3.0.1 Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: lrwxr-xr-x 1 root sys 8 Jul 31 2001 /lib/libc.0 - ./libc.1 -r-xr-xr-x 1 binbin1867776 May 2 2001 /lib/libc.1 -r-xr-xr-x 1 binbin1552384 Mar 30 2001 /lib/libc.2 -r--r--r-- 1 binbin2176124 Mar 30 2001 /lib/libc.a lrwxr-xr-x 1 root sys 15 Jul 31 2001 /lib/libc.sl - /usr/lib/libc.2 lrwxr-xr-x 1 root sys 8 Jul 31 2001 /usr/lib/libc.0 - ./libc.1 -r-xr-xr-x 1 binbin1867776 May 2 2001 /usr/lib/libc.1 -r-xr-xr-x 1 binbin1552384 Mar 30 2001 /usr/lib/libc.2 -r--r--r-- 1 binbin2176124 Mar 30 2001 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Jul 31 2001 /usr/lib/libc.sl - /usr/lib/libc.2 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --with-pthread --with-named-thread-libs=-ldce --with-lib-ccflags=-fpic --disable-shared The only thing I can think of, is I think HP has a problem with some code that uses geteuid and seteuid. I remember reading something along those lines...?? Anyone have any clues? Thanks, Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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
Large tables on FreeBSD
Hello, I need to create a table that is around 15 GB on a FreeBSD 4.5RELEASE system. I compiled mysql-3.23.49 without any extraneous flags such as (--disable-largefile) I use mysqlimport to import the table from a flatfile which is about 9GB. I watch the .MYD file grow to about 4.2 GB and stop with this error from mysqlimport. mysqlimport: Error: Can't open file: 'temp.MYD'. (errno: 144) mysqlimport: Error: The table 'temp' is full, when using table: temp I've tried starting safe_mysqld with the --big-tables option, and that doesn't help. Ovanes __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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
MySQL database files
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? Augey - 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 load problems - gcc-2.96?
[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: FWIW, reproducible testcases are good... all complex software products have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in interaction with oneanother (e.g. timing/locking issues), so reproducible testcases are a necessity. FWIW, it might be worth trying to rebuild the rpms with --disable-assembler. The assembler has had problems in the past in conjuction with compiler optimizations. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Massive Research Data
Some background... We have Objects r1, r2 ... r1600 Which each have (~1600) regions d1, d2 ... d500 Which each have (~500) datapoints So, roughly we have around 786,000 datapoints on a given object. Typically, we might take 15 or so regions and take data from each of their datapoints (~7500) at ~1300 steps or environmental variations. So, each test will generate about 9.75M floats. A curve can be extracted from the 1300 steps (floats) for each datapoint. We then run these tests hundreds of times a day - sometimes on different objects, sometimes on the same ojbects (so you can analyse the curves through time) We have to date stored this raw data within compressed text files indexed by MySQL. However, as you can imagine, querying this data is a pain. We have to ask MySQL for all of the tests of a given object, then analyse the files to extract the appropriate curves - often opening up 100s of datafiles. The question is whether anyone has any more intelligent ways of storing this data within MySQL without busting MySQLs file size limits, or reasonable CPU/RAM contraints. Storing the data raw in rows doesn't seem like the most sane technique. Nor does throwing it into a char for each datapoint. What I'm looking for is a _lossless_ technique to store the curves within the database for each datapoint (we need to be able to extract and analyse data for each datapoint). My guess is that someone out there is doing scientific analysis similar to this using MySQL as their backend. The environment is RD so queries will be fairly limited. We obviously don't want queries to take down the DB server, but, at the same time this isn't the backend data to Yahoo! serving millions of requests every minute. Thanks! Seth - 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