setting root password in mysql
Never am able to gain access to enter in a password for root? It's driving me crazy... Any help Michael Collins thanks for trying! [localhost:/Users/nezi] root# kill -9 1354 [localhost:/Users/nezi] root# kill -9 1371 [localhost:/Users/nezi] root# cd /usr/local [localhost:/usr/local] root# ./bin/safe_mysqld --user=mysql --skip-grant-tables [1] 1388 [localhost:/usr/local] root# Starting mysqld daemon with databases from /usr/local/var [localhost:/usr/local] root# ./bin/mysqladmin -u root password mysql77 ./bin/mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' [localhost:/usr/local] root# ./bin/mysqladmin flush-privileges [localhost:/usr/local] root# ./bin/mysql -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [localhost:/usr/local] root# -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 myODBC
Hi Nikhil Is there any chance for you to provide the ODBC trace generated by ODBC DM / MyODBC ? Thanks in advance Venu -Original Message- From: Nikhil Goyal [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:33 AM To: [EMAIL PROTECTED] Subject: Help with myODBC Hello people, I've a mysql database which is quite large and I needed to create a backup for it, which I can use offline in MS Access or such. I've tried using MyODBC, but one strange problem has come up. Certain fields (defined as TEXT) in my databast have multiple lines in them, separated by CRLF pairs. And when I inport using MyODBC, it only imports the first like of each field. Which means: If the initial database row was field1field2 x1this is line1CRLFthis is line 2 x2somethingCRLFmore the import into access looks like this filed1 field2 x1 this is line1 x2 something does anybody have any suggestions on what I should do? Any help is appreciated Nikhil Goyal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: access dbs to mysql dbs
Export all the tables with data from access to MySQL using MyODBC. Please visit the following link for more details about MyODBC. If you have any questions on this, please send it to [EMAIL PROTECTED] http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC Thank you Venu -Original Message- From: kaab kaoutar [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:19 AM To: [EMAIL PROTECTED] Subject: access dbs to mysql dbs Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REGEXP syntax
Hi, Trying to get to grips with regexp but really want to 1st get a simple expression working with mysql. SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence REGEXP(\^$filterValue;\) The above works for finding matched values, where the number = to $filterValue is in in the 1st part. But I need to do one for the 2nd part and 3rd and 4th etc, where each value is seperated by ; So I may want to search for 6 in the 2nd part, like below:- 1;6 10;6 100;6 1;6;1 10;6;10 100;6;100 I need a regexp that would get all of the above but not any value other than 6 in the 2nd part. Then say I was looking for 6 in the 3rd part:- 1;6;6 10;1;6 100;10;6 100;100;6 1;100;6 10;100;6 Any help would be appreciated. M. -- Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ Home:- hinwickATworsdall.demon.co.ukWEB:- http://www.wizdom.org.uk Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with lock in share mode
I have a table customer like a example, and 2 user making change in this. The firts user make select * from customer where a = 1 lock in share mode; and the second try to update the record where a = 1. In theory the second user can't make any change, but the update is true and change the data. Somebody know what happens or which is my error _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MFC
Hi You need to specify the ip address/host name of the remote system in the DSN creation. In MyODBC Setup screen, 'MySQL host(name or ip) provide the IP ADDRESS or HOST NAME of the remote system. Also, please use [EMAIL PROTECTED], for any MyODBC related queries. Thank you :-Venu -Original Message- From: Mostafa Al-Mallawani [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 7:29 AM To: [EMAIL PROTECTED] Subject: MFC Hi, Im new two this list as well, and I was wondering if anyone know how to connect an MFC application to a remote database? It works fine with my local database but when I come to create a file DSN for the remote one using MyODBC, it wouldnt connect. Any ideas? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
disable the mysql port
Hi, Does anyone know how to disable mysql listening port? Thanks, Michael Lin _ 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
Mysql Error
Hi, I am trying to use the precompiled version of mysql-3.23.37-ibm-4.3.3.0-rs6000. ANd when trying to start the mysqld i get the following error: exec(): 0509-036 Cannot load program ./mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive. I do have zlib installed and it is in the correct place. Has anybody else had this error and have any information it get it to work? ThanX, Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: The old interfering with the young
In the last episode (Jul 27), Anatole said: I had some pre-installed version of MySQL on a Linux machine that I didn't want to use or know how to dispose of properly and then installed a source distribution on the same machine. I've gotten the source distribution installed all right and everything seems to be working smoothly enough, however, I have a lot of defunct mysql files laying around my server that I would like to get rid of (from the pre-installed distribution). Additionally, I have to type the complete path to the new MySQL server, or it will try to connect with the previously installed version. Anyone know how I can get rid of the old files and fix my environment so that my new MySQL distribution is called when I enter mysql, mysqladmin, and the like on the command line? If it was an RPM install, it might have installed into /usr/bin instead of /usr/local/bin. You should be able to remove it with the rpm command. run rpm -qa | grep mysql to list the rpms, and run rpm -e on each one. Otherwise, just remove the old mysql binaries from /usr/bin. -- Dan Nelson [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: [fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)
Hi, I have removed '[EMAIL PROTECTED]'. Matt Alexander Skwar writes: Hi! Could someone please do anything about this? - Forwarded message from Mail Delivery Subsystem [EMAIL PROTECTED] - From: [EMAIL PROTECTED] (Mail Delivery Subsystem) Date: Thu, 26 Jul 2001 19:06:21 +0200 (CEST) Subject: Returned mail: Host unknown (Name server: mailserv: host not found) To: [EMAIL PROTECTED] Envelope-to: [EMAIL PROTECTED] Delivery-date: Thu, 26 Jul 2001 13:05:12 -0400 Auto-Submitted: auto-generated (failure) The original message was received at Thu, 26 Jul 2001 19:06:18 +0200 (CEST) from handi6-212-144-247-017.arcor-ip.net [212.144.247.17] - The following addresses had permanent fatal errors - alex@mailserv - Transcript of session follows - 550 alex@mailserv... Host unknown (Name server: mailserv: host not found) - Original message follows - Return-Path: [EMAIL PROTECTED] Received: from newald.homeip.net (handi6-212-144-247-017.arcor-ip.net [212.144.247.17]) by host2.webprovider.net (8.8.5) id TAA16097; Thu, 26 Jul 2001 19:06:18 +0200 (CEST) Received: from localhost (webserv.home.net [192.168.1.50]) by newald.homeip.net (8.12.0.Beta12/8.12.0.Beta12/8.12.0.Beta12) with ESMTP id f6QH5QQA030877 for alex@mailserv; Thu, 26 Jul 2001 19:05:27 +0200 Received: from 192.41.49.97 [192.41.49.97] by localhost with POP3 (fetchmail-5.8.5) for alex@mailserv (single-drop); Thu, 26 Jul 2001 19:05:27 +0200 (CEST) Received: from web.mysql.com ([EMAIL PROTECTED] [192.58.197.162]) by host2.webprovider.net (8.8.5) id TAA15997; Thu, 26 Jul 2001 19:04:50 +0200 (CEST) Received: (qmail 21256 invoked by uid 7797); 26 Jul 2001 16:48:41 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 21241 invoked from network); 26 Jul 2001 16:48:40 - Date: Thu, 26 Jul 2001 18:51:30 +0200 From: Alexander Skwar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [fwd] Re: Re: mysql and credit cards (from: [EMAIL PROTECTED]) Message-ID: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Mutt/1.3.19i X-Operating-System: An i686 Linux with Kernel v2.4.6-5mdk X-Face: nope X-Sender: [EMAIL PROTECTED] X-UIDL: dff8ef9a96c5fdc1d2c62b07679acea3 database,sql,query,table So sprach =3DBBPeter van Dijk=3DAB am 2001-07-25 um 23:59:48 +0200 : That is only true for a parallel cipher. A non-parallel cipher (like Yep, that's why I said symetrical encryption. Asymetrical enc.'s work like you explained. Alexander Skwar --=20 How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die g=FCnstige Art an Linux Distributionen zu kommen Uptime: 3 days 17 hours 34 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - End forwarded message - PS: sql filter Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 3 days 17 hours 51 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ 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:
RE: Unix passwd file and mysql authentication table
On 26-Jul-2001 sachin shetty wrote: Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table). The password_crypt routine used in MySQL is incompatible with the DES/MD5 crypt used for Unix passwords. Besides, MySQL user-names have nothing to do with Unix login-names. If there is a module that handles this during connection of the mysql client to the server, Maybe once PAM Kerberos become common-place, the user community could submit some patches ? then it saves the risk of sending password across network What makes you think the password goes over the network ? Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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
Unix - Windows migration
Hello, On the project I am working on is a MySQL database generated on Sun/Solaris. If memory serves the MySQL version was 3.2.xx on the Sun. On Windows98 the MySQL version is 3.23.39.1 The Sun datafile cannot be read. The file extension in the tables is .ISD and .ISM for Sun, and .MYD and .MYI on W98 machine. The Sun data was deliverd on a CD, and the box is out of service. The queation is: How do I get the PC version of MySQL to talk to the Solaris version. All help will be greatly appreciated. Dick Davis Skyline Data Systems [EMAIL PROTECTED]
Cobalt raq4 and mysql
Hi all, I'm looking for a beginners resource for working with Mysql on a raq4 linuxbox. Any suggestions? Bye, Patje... Behandel mij met zachtheid, ik ben een overlevende van het vorige millennium! Handle with care, I'm a survivor of the previous millennium! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Format in MySQL
On Thursday 26 July 2001 11:03, Claudemir F. Martins wrote: Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- I suppose, by changing the source code, and reompiling, which would break several other things. Before posting, please check: http://www.mysql.com/manual.php (the manual) Look in the manual for the function called, I believe, FORMAT(). It will change the date around how you want. j- k- -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing mysql
Hi Stefan, Thank You very much for this message to Maggie regarding installation to a Windows 2000 system. I am a neophite and have been lost. I am now partially found!!! My question: Do I need to do anything to the ini file, or is that now done? Am I now good to go? Thanks, Susan - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Maggie Cheang [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 10:23 AM Subject: Re: installing mysql Dear Maggie, http://mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-win.zip has a SETUP.EXE which will install MySQL (database server plus client tools to work with the server) - by default it will install in C:\mysql. After setup, it's easiest to restart Windows. Now, the MySQL server should load. You will find a traffic light symbol in the system tray (lower right corner of your screen). Right click on it, and choose - Win9.x Start the server standalone (for Win 95 / 98) - or WinNT Install the service, then WinNT Start the service (for Win NT or Win 2000) If the traffic light symbol isn't there, you have to start this tool manually: - C:\mysql\bin\winmysqladmin.exe Afterwards, same procedure as above. To connect to the database server, you can use the MySQL Monitor (a command line tool, very good for learning SQL, but make sure you have a good book like Paul Dubois' MySQL, and / or the MySQL manual which is found here after setup: C:\mysql\Docs\manual.html). There is a graphical frontend, too (C:\mysql\bin\MySqlManager.exe). Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Maggie Cheang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 9:31 AM Subject: installing mysql Hi, I have a problem. I have unzip the file with winzip, but I couldn't get it to install. I downloaded both the 3.22 and 3.23 verison, but I still couldn't get it to work as install. my teacher in school told me to install it with winzip and then use mysqladmin to work, but I couldn't get either working. is there something I am missing? thank you so much, and your help is high appreciated :) yours sincerely, Maggie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Correct DISTINCT syntax for MYSQL version 3.22.32
On 26-Jul-2001 Graham Nichols wrote: Hi, I'm using MYSQL version 3.22.32. I have read that from version 3.23.xx COUNT can be used in combination with DISTINCT. However, I have a project deadline which does not give me time to upgrade. I have a small table 'web-stats' consisting of the following fields: IP_address web_date web_time web_referer browser page I am using a PHP script to insert entries into this table as a rudimentary hit counter. My current syntax is select web_date, dayofmonth(web_date) as d, count (IP_address) as c from web_stats group by d order by web_date but what I actually want is to count the unique IP addresses for each date. How can I work around this please? kind regards, Graham Nichols. select web_date, dayofmonth(web_date) as d,IP_address as ip,count(*) as cnt from web_stats group by web_date, ip; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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
timestamp problem
I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type Null Key Default Extra TheDatetimestamp(14) YES NULL Everytime I write a record or edit a record it puts 000 in the TheDate, which of course is not the correct date. Here is the insert command below that I'm using, does anyone have a solution. $query3 = INSERT INTO Quser VALUES('', '$fullname', '$add_novell', '$tot_novell', '$add_cwis', '$tot_cwis', '$add_mail', '$tot_mail', 'TIMESTAMP'); mysql_query($query3); is the TIMESTAMP option where I get the current date from. -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conversion
Ok , Granted I'm really new at this but, I'm starting to feel as though I'm missing something very obvious here. If I have a tect file , say a excell spredsheet saved as a CSV tab delimited, can i import that into MYsql and have it create th eneccesary feild names? if so, how? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I need help constructing a regexp
In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi all, I have a problem, I have some VARCHAR data in a column called Sequence looking like this:- 5;6 12;6 120;6 5;6;1 12;6;12 120;6;105 So there could be anything from 2 to n numbers seperated by ; Each number could be 1 to 3 digits long (eg 5 12 or 121). I have tried various searches like the following but none of them seem fool proof, i.e. they miss data:- # This is for the maximum of 3 sequences searching by the 1st icon SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence LIKE '$filterValue;%_%_' ORDER BY Message; # This is for the maximum of 3 sequences searching by the 2nd icon SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence LIKE '_;$filterValue' OR Sequence LIKE '__;$filterValue' OR Sequence LIKE '%;$filterValue;%' ORDER BY Message; # This is for the maximum of 3 sequences searching by the 3rd icon SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence LIKE '%;%;$filterValue' ORDER BY Message; 'Sequence' is where the numbers to search on are stored. $sqlTable is a variable containing the name of the table. $filterValue is a variable containing the search number. So what rules can I create to work for all examples, though the above examples are for only 3 sequences of ; seperated numbers, there could be upto 6 (though I would prefer a rule to cope with n amount). I am using perl so the OR LIKE part could be created PRE SELECT and then added onto the SELECT statement. So after being advised to do it with regexp I am still stuck:- I got the 1st case working:- SELECT Sequence, Message, id FROM lll.cat1stDictionary WHERE Sequence REGEXP(^66;) But the 2nd sequence search is a problem:- SELECT Sequence, Message, id FROM lll.cat1stDictionary WHERE Sequence REGEXP(^.;66$) OR Sequence REGEXP(^.;66;$) SELECT Sequence, Message, id FROM lll.cat1stDictionary WHERE Sequence REGEXP(^.;66$) and have no idea how to do a 3rd one or nth one. Anyone help? -- Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ Home:- hinwickATworsdall.demon.co.ukWEB:- http://www.wizdom.org.uk Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CREATE SEQUENCE
Date |Thu, 26 Jul 2001 10:12:03 -0700 (PDT) From |Bryan Capitano [EMAIL PROTECTED] Hello! BC Hello, BC Does anybody know what the SQL statement: CREATE SEQUENCE do? BC I cannot find any info on this in the http://www.mysql.com/docs section. BC Thanks, BC Bryan Capitano AFAIK MySQL doesn't support CREATE SEQUENCE. You need to use some other methods. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
[Compiler error for MySQL 3.23.40 - Forte C++ and Solaris X86]
Description: I'm comiling with GNU make and tar, and Forte C++ v6 r2. The compiler is current, as is the Solaris. My configuration line looks like: ./configure --prefix=/usr/local/mysql --with-innodb I'm getting the following errors when running the make command: cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -I./../includ e -I../include -I./.. -I.. -I.. -O -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/utili ties/mysql/v3.23.40/mysql-3.23.40/include -DHAVE_RWLOCK_T -c hash.c -KPIC -DPIC -o hash.o hash.c, line 186: reference to static variable hash_key in inline extern fun ction hash.c, line 226: cannot recover from previous errors cc: acomp failed for hash.c make[2]: *** [hash.lo] Error 1 make[2]: Leaving directory `/usr/local/utilities/mysql/v3.23.40/mysql-3.23.40/li bmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/utilities/mysql/v3.23.40/mysql-3.23.40' make: *** [all-recursive-am] Error 2 When I look at the Compilation info line I see references to gcc. Yet from the command line, if I enter which cc I get /opt/SUNWspro/bin/cc and if I enter which CC I get /opt/SUNWspro/bin/CC. /opt/SUNWspro is the directory that has Forte C++. I look at the Makefile that is generated and I see no reference to gcc. So I don't undetstand why that line shows CC='gcc' and CXX='gcc'. I've run the whole attempt to install under the script command, so I can send the whole session. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: I Can't compile Mysql 3.23.40 on Solaris X86 with Forte compiler. Severity: critical Priority: Category: mysql Class: Release: mysql-3.23.40 (Source distribution) Environment: System: SunOS tiamat 5.8 Generic_108529-09 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/make /opt/SUNWspro/bin/cc Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1584056 Jul 20 19:51 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 24 16:09 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 938940 Jul 20 19:51 /lib/libc.so.1 -rw-r--r-- 1 root bin 1584056 Jul 20 19:51 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 24 16:09 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 938940 Jul 20 19:51 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i86pc-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: The old interfering with the young
Date |Fri, 27 Jul 2001 02:21:17 +0900 From |Anatole [EMAIL PROTECTED] Hello! A Here's my problem: A I had some pre-installed version of MySQL on a Linux machine that I didn't A want to use or know how to dispose of properly and then installed a source A distribution on the same machine. I've gotten the source distribution A installed all right and everything seems to be working smoothly enough, A however, I have a lot of defunct mysql files laying around my server that I A would like to get rid of (from the pre-installed distribution). A Additionally, I have to type the complete path to the new MySQL server, or A it will try to connect with the previously installed version. Anyone know A how I can get rid of the old files and fix my environment so that my new A MySQL distribution is called when I enter mysql, mysqladmin, and the A like on the command line? A TIA, A Anatole Hello. If you use one of modern RH-based linux distribution (it's mean what your linux support RPM packages) just remove mysql packages with 'rpm -e' command. for example: rpm -e mysql mysql-devel mysql-client ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Correct DISTINCT syntax
What I'm trying to achieve is is a srfer visits the site each page visited will be inserted into the database. So, if the surfer visits 5 pages there will be 5 records inserted. Initially, I need to know that this is just ONE hit (one IP), with the next surfer to vist being the second IP. That day would then show 2 hits not five hits for the first surfer plus the pages visited by the second. regards, Graham Previous post shown below - Hi, I'm using MYSQL version 3.22.32. I have read that from version 3.23.xx COUNT can be used in combination with DISTINCT. However, I have a project deadline which does not give me time to upgrade. I have a small table 'web-stats' consisting of the following fields: IP_address web_date web_time web_referer browser page I am using a PHP script to insert entries into this table as a rudimentary hit counter. My current syntax is select web_date, dayofmonth(web_date) as d, count (IP_address) as c from web_stats group by d order by web_date but what I actually want is to count the unique IP addresses for each date. How can I work around this please? kind regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADO + show columns
I'm experiencing some unexpected and undesired behavior attempting to run SHOW COLUMNS FROM TABLE using Delphi via ADO. MDAC: 2.6 RTM MyODBC: 2.50.37 O/S:Windows 98 MySQL: 2.23.24 (Linux) I can run most queries just fine (ie SHOW TABLES, selects, etc.). However any SHOW COLUMNS queries return an error or an empty result set. If I attempt to connect the query to a visual control, the error message, Data provider or other service returned and E_FAIL status. If I just attempt to connect the query and loop through the results, and empty result set is returned. I don't think an empty result set should be possible for a SHOW COLUMNS query. If the table doesn't exist, it will return an error and if the table does exist, there must be at least one column. I've tried several different versions of MDAC/ADO on several different computers, and DESCRIBE, EXPLAIN, and SHOW COLUMNS all exhibit this behavior. Anybody else experience this behavior or have any suggestions? Is this a limitation of accessing MySQL via ADO? query,sql,mysql,homer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Paycheck database Design
I want to log my paychecks in my own database for my own personal use. I am in the design phase: Do I need a table for year to date since this can be calculated automatically? I don't want to have to enter a lot of information when entering the data for each pay period. How many tables are normally used for something like this? Here is what I have so far Table 1: Rarely changes Company: Address: Phone: Employee ID: Table 2: Pay Period: Some sort of formula and auto-populate bi-weekly Rate: rarely change maybe should move up HoursDefault to value Earnings Rate * Hours worked =Earnings so dont need to store: Taxes: (should I make another table here) Federal: //will have to update bi-weekly FED 2: //will have to update bi-weekly FED 3: //will have to update bi-weekly State: //will have to update bi-weekly City:$2.00 every month Deductions: medicalbeforetaxes //will have to update bi-weekly dentalbeforetaxes //will have to update bi-weekly visionbeforetaxes//will have to update bi-weekly 401kbeforetaxes //will have to update bi-weekly Hours worked: Sick: //will have to update bi-weekly Vacation: Holiday Other: Can be calculated automagically(no need for table) YTD Net Gross Total Taxes Total Deductions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 keeps restarting
Hello Everyone.. I just upgraded from MySQL-3.22 (FreeBSD package) to 3.23.40 FBSD binary release. Now everything appears to be running correctly, but the error log tells a different story. Every few seconds MySQL is restarting, and I don't know what to do... But here is what the logs say: 010726 12:10:35 mysqld restarted /usr/local/mysql-3.23.40/bin/mysqld: ready for connections /usr/libexec/ld-elf.so.1: /usr/local/mysql-3.23.40/bin/mysqld: Undefined symbol strtoll 010726 12:10:36 mysqld restarted /usr/local/mysql-3.23.40/bin/mysqld: ready for connections /usr/libexec/ld-elf.so.1: /usr/local/mysql-3.23.40/bin/mysqld: Undefined symbol strtoll 010726 12:10:36 mysqld restarted /usr/local/mysql-3.23.40/bin/mysqld: ready for connections /usr/libexec/ld-elf.so.1: /usr/local/mysql-3.23.40/bin/mysqld: Undefined symbol strtoll 010726 12:10:40 mysqld restarted /usr/local/mysql-3.23.40/bin/mysqld: ready for connections As you can see, it truly is restarting every few seconds... What can do I to fix it, any ideas? Your help is greatly appreciated... :) Thanks in advance, ..rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SUSAN
Warning Could not process message with given Content-Type: multipart/mixed; boundary=7EFA5077_Outlook_Express_message_boundary
Replication without using replication?
In MySQL 3.23.40 there are no more warnings about aborted connections (yay!) and I can see what is actually in the error log. I found a binlog error message even though we do not use replication or the binlog (though this got me thinking that we should use it as it will be replacing the updatelog and has more features). Does anyone know if this is a fluke or something I should be worried about? Thanks! -steve- 010724 14:48:10 mysqld started /usr/local/mysql/bin/mysqld: ready for connections 010724 14:50:40 /usr/local/mysql/bin/mysqld: Binlog closed, cannot RESET MASTER Status information: Current locks: lock: 45cd20dc: read read : 456f8438 (94229:1); lock: 45a8ff64: lock: 452068c4: key_cache status: blocks used: 30857 not flushed: 0 w_requests: 0 writes: 0 r_requests: 7 reads: 5 handler status: read_key:1 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 2 Open tables:2 Open files: 6 Open streams: 0 Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
window me support
Can I use MySQL with Window ME. If so which one?? Thank you, Mary
myvbql dll, help please!
I've got the myvbql DLL for accessing a mySQL database directly from Visual Basic (6), however, after reading the documentation I'm still at a loss as to how to use this file since I've not had much experience with API. If anyone can help me learn how to run a simple mySQL query, displaying the result in a text box, I'd be very appreciative. Thanks in advance, Stephen Sherlock
installing mysql
I'm relatively new to web development and basically don't have a clue on all the intricacies of establishing a localhost development environment. I'm running a Win 98 platform and want to develop using PHP4, Apache, MySql that will support transaction processing. I've found a ton of great information on establishing this dev environment and have successfully installed configured apache php. These process seem to work just fine, I'm able to serve up my PHP scripts no problem. So my next step was to install MySql, All the tutorials I've read make it sound like a piece of cake, however I must be illiterate because MySql is kicking my butt. It's my impression I must be missing the boat somewhere on the configuration aspects of this. I was getting an error innodb_data_file_path not specified so I read some more setup a C:\my.cnf file with a slew of InnoDB options; # mysql config file. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 innodb_data_file_path = ibdata1:20M;ibdata2:20M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=10M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=20M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb ** I got farther along but evidently what I have must not be appropriate because it died with the following: Innobase: Assertion failure in thread 4294132173 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010726 19:30:37 Aborting InnoDB: Warning: shutting down not properly started database 010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Teen Hobos having sex? ..no.. but MAYBE
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Below is the result of your feedback form. It was submitted by ([EMAIL PROTECTED]) on Friday, July 27, 2001 at 05:51:09 --- : Join for free Today. Free Memberships. No Credit Cards Needed. HUGE Celebrity selection from Jennifer Lopez to Britney Spears. Also Specializing Streaming Video, Live sex shows for every desire! This isn't one of those crummy scams where you have touse a credit card! Take a look and you'll see. a href=aol://2000:http://coverme1.devil.ru;Enter Here/a BRBRBRBRBRBRBR You recived this email because you subscribed to a mailing list. If you would like to be removed from this mailing list please a href=mailto:[EMAIL PROTECTED];Click Here!/aBRBRBRBRBRBRBR --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cannot create text fields
If you are trying to create a text field (memo field) then drop the (30). If you are trying to create a 30 chr text field then use varchar(30) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Geoff Martin [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Monday, July 23, 2001 10:31 Subject: Cannot create text fields Using the following Syntax I tried to create a table in mySQL. However each time it returned a mySQL error which I eventually worked out it was because I'd defined a field as text. I am able to define fields as varchar, char, int or float (I've tested for theses so far) but not text or blob. The query was CREATE TABLE products(prod_id int(4),prod_name text(30),prod_detail varchar(255),prod_price float(6)) which returns the error there is an error in the syntax near (30),prod_detail varchar(255),prod_price float(6) I am running on Mac OS X with MySQL 3.23.39 Any of you kind people got an idea why? regards Geoff M - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moved MySQL to new machine.
try to see more detail in INSTALL, it tell us about file and directory permission. If you have more problem with /var/any dir why did not use /statedir=/usr/mysql/data while configure to relocate MySQL data directory insteady use in /var/... Sommai Fongnamthip At 11:47 26/7/2001 -0500, Gerald Clark wrote: 13 is access denied. Your /var/lib/mysql ( Or whatever ) is owned by root, and mysql can not create a new directory. Jeremy wrote: I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following error message: mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno: 13)' And, I think I lost some sequences. I'm using Phorum for a message board. The sequence table was at 2942, but when I try to write a record to it, it changes the sequence back to 1! Is this a MySQL problem, or a problem with Phorum? Any help that you can render would be greatly appreciated. Jeremy -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't stop msqld
$ ps -ax | grep mysqld get the pid of mysql $ kill -9 pid_of_mysql that'll do it. :) Tyler On Thu, 26 Jul 2001 13:24:41 -0500 cjackson [EMAIL PROTECTED] wrote: Hello all, I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server running apache and php. I could start msqld and shut it down. Then I created a password for root. Mysql still starts but I can't stop it as root or any other user. It runs as user mysql which also requires password. Thanks, Jackson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Format in MySQL
Date |Thu, 26 Jul 2001 15:03:59 -0400 From |Claudemir F. Martins [EMAIL PROTECTED] Hello! CFM Hello Friends CFM Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? CFM Thanks CFM Claudemir F. Martins You can use DATE_FORMAT function for change output date format. Read this: http://www.mysql.com/doc/D/a/Date_and_time_functions.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
possible bug in sum() function
We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the query was: select sum(worktime),user from timecard where tcacct=project group by user; the answer was: 8.00user1 14.00 user2 160.00 user 3 Now, where I went to school, this adds up to 184! Suggestions? Submitter-Id: submitter ID Originator:Bruce Ferrell Organization: MySQL support: none Synopsis: incorrect result from sum() function Severity: critical Priority: high Category: mysql Class: Release: mysql-3.23.38 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.20 Distrib 3.23.38, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.38-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 57 days 22 hours 54 sec Threads: 7 Questions: 2503729 Slow queries: 175857 Opens: 11226 Flush tables: 1 Open tables: 64 Queries per second avg: 0.500 Environment: System: Linux romulus.microdisplay.com 2.2.19 #3 Fri Apr 6 10:33:27 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 29 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Format in MySQL
On 26-Jul-2001 Claudemir F. Martins wrote: Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? Check for DATE_FORMAT() in the manual. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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: joining two databases
i have 2 mysql servers, i need to run a query that joins two tables from two databases on the two servers, how can i do this? You can't. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date Format in MySQL
Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? Thanks Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't stop msqld
Date |Thu, 26 Jul 2001 13:24:41 -0500 From |cjackson [EMAIL PROTECTED] Hello! C Hello all, C I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 C server running apache and php. I could start msqld and shut it down. C Then I created a password for root. Mysql still starts but I C can't stop it as root or any other user. It runs as user mysql which also C requires password. Mysql root and system root absolutely different. For stop mysql use /etc/rc.d/init.d/mysqld stop by root. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Uploading files using PHP to database.
yup, i have this same question...it seems to me, unless i'm missing something obvious that you have to create the table and feild names first, then upload the txt file? Is this correct? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 myODBC
Date |Thu, 26 Jul 2001 14:32:48 -0400 From |Nikhil Goyal [EMAIL PROTECTED] Hello! NG Hello people, NG I've a mysql database which is quite large and I needed to create a backup NG for it, which I can use offline in MS Access or such. I've tried using NG MyODBC, but one strange problem has come up. Certain fields (defined as NG TEXT) in my databast have multiple lines in them, separated by CRLF pairs. NG And when I inport using MyODBC, it only imports the first like of each NG field. Which means: NG If the initial database row was NG field1field2 NG x1this is line1CRLFthis is line 2 NG x2somethingCRLFmore NG the import into access looks like this NG filed1 field2 NG x1 this is line1 NG x2 something NG does anybody have any suggestions on what I should do? Any help is NG appreciated NG Nikhil Goyal You need to convert all non-printable symbols to escape sequence before insert. It's can help. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: I need help constructing a search thingy using % _ in LIKE
yes, but then you wouldn't learn. if you don't want to buy Dubois' book, try appendix J of the mySql reference manual, available for free from the mysql site. At 06:06 PM 7/26/01 +0100, you wrote: In message [EMAIL PROTECTED], tj marlin [EMAIL PROTECTED] writes I think it is time for you to learn about regular expressions; page 520 ff of Dubois. (sql, mysql, database - to get past the filter) any chance of an example or full syntax? M. -- Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ Home:- hinwickATworsdall.demon.co.ukWEB:- http://www.wizdom.org.uk Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ tom marlin tjmarlin@nospamsurfree.com My mind wanders a lot; sometimes it leaves completely. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Building MySQL on HPUX with InnoBase support
Jeff, I think some people have built on HP-UX, but I do not remember if they used GCC. What kind of errors do you get from the HP compiler? Regard, Heikki http://www.innodb.com Copied message: .. I have had problems building the MySQL database server when I include support of InnoBase DB files. During the build process I must use the HP/ANSI compilers. This causes an error while building the mach0data.c file in the mach directory in the InnoBase directory structure. Has anyone on HP-UX 11.0.0 been able to build the MySQL server with both Berkeley DB and InnoBase DB support using the HP/ANSI compilers. If so, please give me some direction.Thank YouJeff Hinds ~~~ _ # Jeff D. Hinds - Database Specialist# _ / )# Office of Information Technology #( \ _ / / # 001 Cope Administration Building # \ \ _ ( ( () # _ Murfreesboro, TN 37129 _ # () ) ) ( \ \ \)# / ) ( \ #(/ / / ) ( \ \ \ \_/ / Phone: (615) 898-5719 \ \_/ / / / ) \ / Fax: (615) 898-5720\ / \ /E-Mail: [EMAIL PROTECTED]\ / \ /~\ / [[[|]]] == MIDDLE TENNESSEE STATE UNIVERSITY == [[[|]]] [[[|]]]~[[[|]]] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't stop msqld
Jackson, Check under what process ID mysqld is running, than kill it, like doing: -- # killall mysqld -- On Thu, 26 Jul 2001 13:24:41 -0500 cjackson [EMAIL PROTECTED] wrote: | I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server | running apache and php. I could start msqld and shut it down. | Then I created a password for root. Mysql still starts but I can't stop | it as root or any other user. It runs as user mysql which also | requires password. Cya Antonio [ [EMAIL PROTECTED] | [EMAIL PROTECTED] | [EMAIL PROTECTED] ] [ http://floripa.zoing.net | http://www.zoing.net | http://www.showZ.com.br ] [ ICQ# 9253680 | Floripa | MySQL | PHP | FreeBSD - The Power to Serve ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
not null
I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. 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
Unable to use shortcut keys
Hi, I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am running mySQL using MSDOS-prompt, there is no shortcut key available (all the arrows keys, ctrl+p, etc, don't work, even though doskey was enabled). Thanks in advance. JH
mysql unable to connect
I'm trying to connect to the mysql database and get the error (computer r3holt24en.eng.agilent.com not allowed to connect). Any ideas? mysql is loaded on an HP-UX box at /usr/local/mysql. Where should I look/do? tia (very novice: knows other sql dbms, but not mysql yet) Suu Quan Agilent Technologies Bldg 54, Post P4 (408)553-7155 [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
Bug in GRANT in 3.23.40
Found a bug in 3.23.40 with GRANT: Statement: grant file on db.* to peeps@% identified by password; emits no error message, however when one does a select for that user from the user table, one will find that the user peeps which was dutifully created has NOT been given File_priv - in fact, they have no privileges at all. The same will be found for that user in the db table - no reflection of file_priv access (I think that's because there is no such thing in the db table, iirc). Anyways. I'm just happy to have found a real-live bug in the most recent release. Of course, it's probably already been reported. Oh, and another thing: When doing the statement above, the variation: grant file on db.tablename to peeps@% identified by password; emits an odd error telling me to check the syntax for the grant statement in the documentation. I did, and found no reference to the FILE grant not being able to be applied to only a single table in a single DB. Yes, I know that functionality can be applied for replication via statements in my.cnf, but I'm talking about the operation of the GRANT statement here. Oh well. As a side note...I've found that books written on MySQL are HORRIBLE at accurately describing the exact GRANT statement syntax in all its permutations. For an infuriating instance, see MySQL by Paul DuBois (New Riders) - an otherwise very nice book, a few parts kind of outdated already due to the speed of MySQL development - in all of its examples of GRANT statements, for the TO section of the statement, it never indicates at any time that for a % hostname one *must* put the % in 's. I think I lost a month off my life from the frustration of that little tidbit. Thankfully, the online docs were accurate. Oh well. As mysql progresses, I can see the need for a more thorough collection of paper manuals covering mysql minutia - something like the immense collection of Oracle books, for instance. Oh, I'm sorry, did I scare you all there? :) Scott [EMAIL PROTECTED] S/MIME Cryptographic Signature
Re: up arrow using mysql client on windows
Dear Alan, new Windows distributions of MySQL do have the up arrow (history list), although it is only for the current session (that's better on Linux). If you have an older version, simply start c:/mysql/bin/mysqlc.exe instead of mysql.exe. This one has the history list. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Alan Zaitchik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:52 AM Subject: up arrow using mysql client on windows I know I've seen the solution to this somewhere... Running bin\mysql in a DOS window I find that my up arrow will not recall commands from a command buffer, even when DOSKEY is loaded in the parent DOS window. But I know that on a Linux machine where I used to run mysql I could up arrow through previous commands. Is this feature disabled in Windows? Is there a switch I can throw to enable it? Thanks, and please no heat about not being on Linux... it wasn't my choice... Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moved MySQL to new machine.
Dear Jeremy, have you checked the rights already? Try CHMOD 777 for a test, if you can create databases then, it's only a file rights problem. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Jeremy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:29 AM Subject: Moved MySQL to new machine. I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following error message: mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno: 13)' And, I think I lost some sequences. I'm using Phorum for a message board. The sequence table was at 2942, but when I try to write a record to it, it changes the sequence back to 1! Is this a MySQL problem, or a problem with Phorum? Any help that you can render would be greatly appreciated. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Server creating problem
Dear Selva, ERROR 2002: Can't connect to local MySQL server through socket' /var/lib/mysql/mysql.sock' (2) Wrong file rights. Change /var/lib/mysql/ to 777 for a test, and everything will work. Run the MySQL daemon (server) with user mysql, and change the /var/lib/mysql/ rights to 700 (7 for user mysql). Regards, -- Stefan Hinz Geschaftsfuhrer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Selva Prakash [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 10:14 AM Subject: MySql Server creating problem hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket' /var/lib/mysql/mysql.sock' (2) and when i try to stop the server, i get the mesage failed. what couldbe the problem? -- K.S.Selva Prakash Tachyon Technologies Pvt 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Moving database from windoze to Linux
Good day, I have created a database using MySQL under Windoze and am trying to move the data to MySQL running on Linux. I have exported the data to a res file - can't see how to do a mysqldump in Windoze. I then try and import the file on the Linux machine using LOAD DATA, but end up with either NULL in all the fields except the primary key field or if I use ENCLOSED BY '', I end up with the data enclosed by quotes. How do I do this "properly", please? TIA Glyn Glyn DaviesCirrus-TechVueSouth AfricaTel: +27 11 783 1508www.cirrus.co.za __ "The information contained in this email is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. Cirrus Techvue is not liable for the proper, complete transmission of the information contained in this email, or any delay in its receipt, and does not warrant that the mail is virus-free." - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't stop msqld
Dear Jackson, do not mix up Unix users and MySQL users! Only a MySQL user who has been granted the right SHUTDOWN can shut down the server! (As Unix root, you can as well kill MySQL. But this might harm open tables.) Check for privilege system in the manual. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: cjackson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 8:24 PM Subject: Can't stop msqld Hello all, I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server running apache and php. I could start msqld and shut it down. Then I created a password for root. Mysql still starts but I can't stop it as root or any other user. It runs as user mysql which also requires password. Thanks, Jackson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I can kill it but Can't stop mysqld
Thanks everyone for immediate response to this problem. I can kill the mysql process but I cannot stop it using /etc/rc.d/init.d/mysqld stop. I can start it like this using start but not stop it using stop. All of this is done as system root. So runlevel 3 starts it OK, but runlevel 5 won't stop it on shutdown. This problem arose today when I started tinkering with grant privileges. But doesn't make sense. Jackson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Correct DISTINCT syntax for MYSQL version 3.22.32
Date |Thu, 26 Jul 2001 21:11:20 +0100 From |Graham Nichols [EMAIL PROTECTED] Hello! GN Hi Grigory, GN your query below only runs without error if I leave out the word DISTINCT. SELECT web_date, dayofmonth(web_date) AS d, COUNT(DISTINCT IP_address) AS c FROM web_stats GROUP BY d ORDER BY web_date GN so GN SELECT web_date, dayofmonth(web_date) AS d, COUNT (IP_address) AS c GN FROM web_stats GROUP BY d ORDER BY web_date GN runs OK, but NOT if I include the DISTINCT. I don't know what's wrong. GN regards, Graham You just need to remove whitespace after COUNT. COUNT(DISTINCT IP_adress) work well. COUNT (DISTINCT IP_adress) drop ERROR 1064 ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
DISTINCT problem
Hi, Distinct can only be used with count count(distinct field_name) --- OK for 3.23 NOT for 3.22 from MYSQL version 3.23. I have only version 3.22. How can I get around this please? kind regards, Graham Nichols - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete
Hi, im trying to delete a record from a table where the value of a field must be equal to the value of a field of another table.I know this is wrong but I need to show you what I mean. I think I'm missing a very important select statement to join them...can anyone help me out? Delete from table1 where table1.value = table2.value - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hi, i have a question. I have a Mysql Database with about 50 tables, How many rows could be support this database using mysql Thanks, Dairo _ 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
long query: when to give up
To sum it all up, I am trying to import data from text files into an innobase table (about 12m rows of data that is stored in text files created by doing a select into outfile). First I tried dropping the indexes before doing load data infile, but I found that I didnt have enough table space to recreate the indexes since apperently it makes a copy of the entire table. So I decided to leave the indexes on the empty table and start loading the text files. The first one loaded fine (4gb text file, loaded in 5 hours). I noticed that the cpu usage from 14-20% for the first 4 hours, and then about 45 minutes of 99% cpu usage before it finished. The step that I am on now is importing the largest file (12gb of text) and it has been going for about 26 hours now. The processor had been at 14-20% usage for most of the time and for the last 5 hours or so its been at 99% usage. So I assume if it is following the pattern that accured when I loaded the smaller file, it is finishing up. But like I said, 26 hours have passed already. What if another 5/10/15 hours passes before it finally finishes? What if it is stuck in a loop and is never going to finish? The question is, when do you know when to give up, and when to keep on trucking? I would like to minimize downtime as much as possible (with limited hardware, if i had more disk space it would be much easier!), but so far its been 31 hours total. Does that seem long for importing 16gb of text files into a table with 4 indexes (one primary, one unique, plus two more)? Is there something else going on here or a better method of doing what I need to do? Thanks for any advice you give. ryan in case anyone cares to read more background on what I am trying to do, here it is: I have been using innobase tables with a 64kb page size in order to fit around 30k per row into my table. As many of you know, recently Innobase 39b was released with support for up to 4GB blob support. Naturaly I wanted to upgrade to this code asap so I wouldnt have to worry about keeping my row length under 30k or so. But because my innodb table space was creating with a 64kb page size, I would have to dump the data out of the db to a file of some sort, and then reimport it. This is where the trouble comes in. I decided to split this 15gb table into three different text files using select into outfile. This went without a hitch fairly quickly (12m rows or so). I then deleted the old innodb files, upgraded the server, and recreated the tablespace. So now the time comes to get the data back into the db. Originaly I dropped all the indexes from the table, imported the old data using load data infile (took around 4-5 hours), and started to recreate the indexes. However I found that I didnt have enough table space to recreate an index because it had to make another copy of table (and I dont have enough disk space to increase the size of my table space that much). So that leads me to the story above... imported the data with indexes on the table already. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CREATE SEQUENCE
It's a command used for creating the equvalent of AUTO_INCREMENT columns in other dialects of SQL. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Bryan Capitano [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 7:12 PM To: MySQL Mailing List Subject: CREATE SEQUENCE Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting root password in mysql
Why not try sql to update it: mysql -u root mysql use mysql; mysql update user set password = password('new password') where user = 'root'; mysql flush privileges; mysql exit - Original Message - From: Michael Nezi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:42 PM Subject: setting root password in mysql Never am able to gain access to enter in a password for root? It's driving me crazy... Any help Michael Collins thanks for trying! [localhost:/Users/nezi] root# kill -9 1354 [localhost:/Users/nezi] root# kill -9 1371 [localhost:/Users/nezi] root# cd /usr/local [localhost:/usr/local] root# ./bin/safe_mysqld --user=mysql --skip-grant-tables [1] 1388 [localhost:/usr/local] root# Starting mysqld daemon with databases from /usr/local/var [localhost:/usr/local] root# ./bin/mysqladmin -u root password mysql77 ./bin/mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' [localhost:/usr/local] root# ./bin/mysqladmin flush-privileges [localhost:/usr/local] root# ./bin/mysql -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [localhost:/usr/local] root# -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
can't connect through socket using PHP script
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) What does this error mean? I am trying to authenticate from a php script using the following code... $db=mysql_pconnect(localhost,username,password); The user username is able to login to mysql ata command prompt. Thanks, Jackson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: access dbs to mysql dbs
Have a look at AccessToMysql tools at http://mysql.com kaab kaoutar schrieb am Donnerstag, 26. Juli 2001, 20:18:54: Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: encrypt
Wouldn't that be a problem of your program? MySQL will sotre anything and not care about what it is. You encrypt first, then insert, next retrieve and decrypt. Jason Whitlow schrieb am Mittwoch, 25. Juli 2001, 17:34:05: I hope this is not to stupid. I have looked at how to encrypt strings in my database. I know that you need to use a blob and I think I can figure out how to encrypt from a query or SELECT but how do I encrypt on the INSERT. Thanks for your help Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date Format in MySQL
Claudemir F. Martins schrieb am Donnerstag, 26. Juli 2001, 21:03:59: Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? No. This is the standard format. You can, however, reformat the result sets according to your needs. This format allows easy manipulation of date data in contrast to many of those accustomed to by local cultures. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to ROUND numbers
Your code doesn't make much sense to me, and especially not with respect to the question. I give you some comments below. Arnab (WebMaster) schrieb am Mittwoch, 25. Juli 2001, 09:23:39: How to round the result number after the multiplication, below are the PHP codes, any help greatly appreciated ?php If (@$rcurr ==) @ doesn't make sense here. It is used with functions to suppress error messages. { echo (); This doesn't make any sense at all. If you don't want any out put then don't do anything. If you have a if/else construct without action you can insert a comment like this if(...){ //nothing to do } else{ . } Better: leave that thing alone and write if (!...){ } ? ?php I hope you open your table somwhere. while ( $row = mysql_fetch_array($result) ) { echo(tr); echo(td . $row[Room_Category] . /td); echo(td . $row[Room_Size] . /td); echo(td align='right' . $row[xsp] . /td); echo(td align='right' . $row[xan] . /td); echo(/tr); } echo(/table); You close your table in any case, so you better put that outside your if/else-stuff. ? ?php } else { ? ?php while ( $row = mysql_fetch_array($result) ) { echo(tr); echo(td . $row[Room_Category] . /td); echo(td . $row[Room_Size] . /td); echo(td align='right' . $row[xsp]*$rcurr . /td); echo(td align='right' . $row[xan]*$rcurr . /td); echo(/tr); } echo(/table); } ? Write yourself a function like roundCurr() and then insert roundCurr($row[xan]*$rcurr) instead. To get a hint, how to do that, look at php.net and do a little research. You want to behave your reound function in a certain way, and it can be done very elegantly, as I remember, but I don't remember how and I don't want to do the work for 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting root password in mysql
What version have you installed? I would think on Mac OS X you have 3.23.36? I will give it one last shot. First kill -9 the mysql processes (mysqladmin shutdown does not work on Mac OS), killing safe_mysql first. Add a -p when assigning the password, and I think that the password needs to be in quotes (?): [localhost:/Users/nezi] root# cd /usr/local [localhost:/usr/local] root# ./bin/safe_mysqld --user=mysql --skip-grant-tables [localhost:/usr/local] root# ./bin/mysqladmin -u root -p password mysql77 Enter password: (hit return at this point) [localhost:/usr/local] root# ./bin/mysqladmin flush-privileges [localhost:/usr/local] root# ./bin/mysql -u root -p Enter password: mysql77 You can also try: [localhost:/Users/nezi] root# cd /usr/local [localhost:/usr/local] root# ./bin/safe_mysqld --user=mysql --skip-grant-tables [localhost:/usr/local] root# ./bin/mysql -u root -p Enter password: (hit return at this point) UPDATE user SET Password=PASSWORD(mysql77) WHERE User=root; Exit [localhost:/usr/local] root# ./bin/mysqladmin flush-privileges [localhost:/usr/local] root# ./bin/mysql -u root -p Enter password: mysql77 BTW, if you get an error then there is not point continuing. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
excell text file to mysql table using php admin?
Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name tinytextNo Change Drop Primary Index Unique last_name tinytextNo Change Drop Primary Index Unique email_address tinytextNo Change Drop Primary Index Unique area_code tinytextNo Change Drop Primary Index Unique area tinytextNo Change Drop Primary Index Unique have_picture tinytextNo Change Drop Primary Index Unique about textNo Change Drop Primary Index Unique I want to import data into this table from the csv file from excell. So...i insert textfiles into table , browse to the .txt file on my harddrive, select replace, feilds terminated by \t, feilds escaped by \t , lines terminated by \r, the I hit submit and get Error MySQL said: Query was empty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Please OpenBSD Mysql
/usr/libexec/ld.so loads the dynamic libraries, It goes down a path set by LD_LIBRARY_PATH, get the location where the libary is in and put it in the path, should be that simply. find / -name libpthread.so.14* -print , might help. BTW that was a solaris answer but should be the same on openbsd MJM - Original Message - From: Savage, Elijah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 2:34 PM Subject: Help Please OpenBSD Mysql Has anyone ever seen this error. I have loaded mysql on a sparc running openbsd. I have asked on the opebsd list and searched for days on google and deja. But it seems as if mysql has a problem running on the sparc platform because others have ran in to this eact same problem but have not been provided an answer. Is there anyone here that can help me please. The error pasted below is from when I run safe_mysqld. /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010726 13:24:45 mysqld ended - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unix - Windows migration
Date |Thu, 26 Jul 2001 17:21:05 -0500 From |Dick Davis [EMAIL PROTECTED] Hello! DD Hello, DD On the project I am working on is a MySQL database generated on Sun/Solaris. DD If memory serves the MySQL version was 3.2.xx on the Sun. DD On Windows98 the MySQL version is 3.23.39.1 DD The Sun datafile cannot be read. The file extension in the tables is .ISD and .ISM for Sun, and .MYD and .MYI on W98 machine. DD The Sun data was deliverd on a CD, and the box is out of service. DD The queation is: How do I get the PC version of MySQL to talk to the Solaris version. DD All help will be greatly appreciated. If i right understand your problem you need to read documentation bout 'mysqldump' tool. http://www.mysql.com/doc/m/y/mysqldump.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
Problem with MyODBC
Hi , I'm trying to access database on MySQL server which is on a Unix box from a windows system through odbc. I'm using MyODBC for this purpose. When ever i connect i get the error message access denied for the user. I have inserted the user in the db, user and host tables in mysql database of the Unix box. Can anyone suggest a solution to this problem. Thanks, -Asfar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: The old interfering with the young
You might have had a 'distribution' that was installed via the 'RPM' method. You can see if the RPM packages are installed by typing: rpm -q -a | grep -i mysql If some package appear (as 'mysql-something), remove each one by typing: rpm --erase 'mysql-something' Otherwise, if you've just installed the 'source distribution' and specified a distinct installation area (i.e. /usr/local/mysql), you can try to 'find' the similiar files on your system (and back them up, then remove them), by typing: cd /usr/local/mysql/bin for FILE in * do find /usr -name $FILE -print done Ignore the listing of files that are in YOUR installation area... - Original Message - From: Anatole [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 10:21 AM Subject: The old interfering with the young Here's my problem: I had some pre-installed version of MySQL on a Linux machine that I didn't want to use or know how to dispose of properly and then installed a source distribution on the same machine. I've gotten the source distribution installed all right and everything seems to be working smoothly enough, however, I have a lot of defunct mysql files laying around my server that I would like to get rid of (from the pre-installed distribution). Additionally, I have to type the complete path to the new MySQL server, or it will try to connect with the previously installed version. Anyone know how I can get rid of the old files and fix my environment so that my new MySQL distribution is called when I enter mysql, mysqladmin, and the like on the command line? TIA, Anatole - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cobalt raq4 and mysql
Hi Well there is not a problem running Mysql on most flavours of Unix/Linx. So there are three thing that you can do to learn more about MySQL... One. MySQL.com: this is very good and covers most things and probmes that you would do with MySQL. Two. MySQL by Paul DuBois. Very good book. Three. MySQL training by Polycon. Covers all you would like to know. You mite even get to travel to go on it. Hope this helps PS this e-mail list is good as well. I am always humbled by some of these peoples knowledge... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 July 2001 23:36 To: Mysql (E-mail) Subject: Cobalt raq4 and mysql Hi all, I'm looking for a beginners resource for working with Mysql on a raq4 linuxbox. Any suggestions? Bye, Patje... Behandel mij met zachtheid, ik ben een overlevende van het vorige millennium! Handle with care, I'm a survivor of the previous millennium! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unix - Windows migration
Hi, I think datafile-compatibilty was introduced in 3.23.xx . To get these old files imported, I would set up a tiny solaris or linux machine ( I think there is a free solaris version for PC) then install the (exactly!) same version (download from mysql.com) as on your old machine. Then run mysql, connect and import the data to the old machine. Greetings, Ansgar -Ursprüngliche Nachricht- Von: Dick Davis [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Donnerstag, 26. Juli 2001 23:21 Betreff: Unix - Windows migration Hello, On the project I am working on is a MySQL database generated on Sun/Solaris. If memory serves the MySQL version was 3.2.xx on the Sun. On Windows98 the MySQL version is 3.23.39.1 The Sun datafile cannot be read. The file extension in the tables is .ISD and .ISM for Sun, and .MYD and .MYI on W98 machine. The Sun data was deliverd on a CD, and the box is out of service. The queation is: How do I get the PC version of MySQL to talk to the Solaris version. All help will be greatly appreciated. Dick Davis Skyline Data Systems [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: installing mysql
I dunt know MySQL's ini file. However, you have to copy a file my-example.cnf from your MySQL root directory to C:\ and then rename it as my.cnf. Then edit the file C:\my.cnf . You modify paths in it by the Escape format like E:\\MySQL\\ . save it. open a new command prompt and change to your MySQL bin directory, run mysqld-nt-max in another command prompt and change to your MySQL bin directory, run mysql. you can connect MySQL server. Any other problem, you can refer manual.html in your MySQL/docs directory. There is a section Installation in Windows. Then find your version. - Original Message - From: sjs [EMAIL PROTECTED] To: Stefan Hinz [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 27, 2001 7:23 AM Subject: Re: installing mysql Hi Stefan, Thank You very much for this message to Maggie regarding installation to a Windows 2000 system. I am a neophite and have been lost. I am now partially found!!! My question: Do I need to do anything to the ini file, or is that now done? Am I now good to go? Thanks, Susan - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Maggie Cheang [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 10:23 AM Subject: Re: installing mysql Dear Maggie, http://mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-win.zip has a SETUP.EXE which will install MySQL (database server plus client tools to work with the server) - by default it will install in C:\mysql. After setup, it's easiest to restart Windows. Now, the MySQL server should load. You will find a traffic light symbol in the system tray (lower right corner of your screen). Right click on it, and choose - Win9.x Start the server standalone (for Win 95 / 98) - or WinNT Install the service, then WinNT Start the service (for Win NT or Win 2000) If the traffic light symbol isn't there, you have to start this tool manually: - C:\mysql\bin\winmysqladmin.exe Afterwards, same procedure as above. To connect to the database server, you can use the MySQL Monitor (a command line tool, very good for learning SQL, but make sure you have a good book like Paul Dubois' MySQL, and / or the MySQL manual which is found here after setup: C:\mysql\Docs\manual.html). There is a graphical frontend, too (C:\mysql\bin\MySqlManager.exe). Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Maggie Cheang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 9:31 AM Subject: installing mysql Hi, I have a problem. I have unzip the file with winzip, but I couldn't get it to install. I downloaded both the 3.22 and 3.23 verison, but I still couldn't get it to work as install. my teacher in school told me to install it with winzip and then use mysqladmin to work, but I couldn't get either working. is there something I am missing? thank you so much, and your help is high appreciated :) yours sincerely, Maggie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
iso-8859-2 to UTF-8
Hi I really like mysql feature when I can create conversion table for client and server. Does anyone have made such patch for iso-8859-2 (latin2) and UTF-8? I need this and don't have too much time (my project deadline) to develop it myself. Regards Daniel a e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26 074 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp problem
Kory, Since your fieldtype for TheDate is timestamp(14), you don't need a function to insert a timestamp there. In fact, what you're doing now is inserting the text TIMESTAMP into a date field, which results in '' Instead of 'TIMESTAMP', use NULL -- and don't put quotation marks around it!! By inserting 'nothing' into your TheDate field, MySQL is allowed to update the timestamp. Regards, Sebastiaan J.A. Kamp - Original Message - From: Kory Wheatley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 1:17 AM Subject: timestamp problem I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type Null Key Default Extra TheDatetimestamp(14) YES NULL Everytime I write a record or edit a record it puts 000 in the TheDate, which of course is not the correct date. Here is the insert command below that I'm using, does anyone have a solution. $query3 = INSERT INTO Quser VALUES('', '$fullname', '$add_novell', '$tot_novell', '$add_cwis', '$tot_cwis', '$add_mail', '$tot_mail', 'TIMESTAMP'); mysql_query($query3); is the TIMESTAMP option where I get the current date from. -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: possible bug in sum() function
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 5:31 AM Subject: possible bug in sum() function select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the query was: select sum(worktime),user from timecard where tcacct=project group by user; the answer was: 8.00user1 14.00 user2 160.00 user 3 Now, where I went to school, this adds up to 184! Try another school perhaps? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: not null
create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. You have to give the type of the column after the name first (int, varchar etc..) -- Sebastiaan Smit | email: [EMAIL PROTECTED] | web:www.echelon.nl ECHELON consultancy and software development | phone: +31 (0)53 48 36 585 PO Box 545, 7500AM Enschede, The Netherlands | fax: +31 (0)53 43 36 222 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlBUG
Dear I did install MySQL on win95 which is simple. But got stuck when installing on SunSolaris (On PentiumII) at shellmake install given page 56 chapter 4 of MySQL manual. Please advise me what to do next. Waiting for your reply. With Best Regards Sohail Aziz Quidwai
Re: timestamp problem
Omit the value for timestamp. mysql will do all by itself. Kory Wheatley schrieb am Freitag, 27. Juli 2001, 01:17:22: I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type Null Key Default Extra TheDatetimestamp(14) YES NULL Everytime I write a record or edit a record it puts 000 in the TheDate, which of course is not the correct date. Here is the insert command below that I'm using, does anyone have a solution. $query3 = INSERT INTO Quser VALUES('', '$fullname', '$add_novell', '$tot_novell', '$add_cwis', '$tot_cwis', '$add_mail', '$tot_mail', 'TIMESTAMP'); mysql_query($query3); is the TIMESTAMP option where I get the current date from. -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: not null
Hm you need to define what kind of column you want... like integer, text, varchar, enum etc etc something like: create table tablename (ID int not null auto_increment, something varchar(255) not null, ...) I would strongly recommend to read the manual! You find it at www.mysql.com There are many examples for all queries. - Nessi - At 05:47 27/07/01 , you wrote: I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. 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
Re: MySQLGUI 1.7.x crashes on Windows
[EMAIL PROTECTED] writes: Hi, I'm a little bit new here, so I don't know this has been asked before. Anyway..MySQLGUI 1.7.4 and 1.7.5 (Win32) both crash if you select Administration-Set Password: The statement in 0x77f74d8a points to memory in 0x1fe1 ... This shouldn't happen. What am I doing wrong here? Regards Andreas Eibach ITM GmbH HI! I have tested your case and I was not able to repeat it. I have also tested another reported which stated that MySQLGUI crashed on Create table and on Create database. All worked just fine for me. However, it is possible that it is a consequence of utilising MySQL user with some specific privileges. So, in order to help me, all these reports should be amended with the output from SHOW GRANTS FOR ... user with which those misbehaviours occured. Thanks in advance. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: excell text file to mysql table using php admin?
Heres the text file i'm trying to upload, btw... Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name tinytextNo Change Drop Primary Index Unique last_name tinytextNo Change Drop Primary Index Unique email_address tinytextNo Change Drop Primary Index Unique area_code tinytextNo Change Drop Primary Index Unique area tinytextNo Change Drop Primary Index Unique have_picture tinytextNo Change Drop Primary Index Unique about textNo Change Drop Primary Index Unique I want to import data into this table from the csv file from excell. So...i insert textfiles into table , browse to the .txt file on my harddrive, select replace, feilds terminated by \t, feilds escaped by \t , lines terminated by \r, the I hit submit and get Error MySQL said: Query was empty 1;9805;JEANNIE;ANDERSON;[EMAIL PROTECTED];AR;Arlington;1;Jeannie AndersonPrudential Network Realty2771-7 Monument Rd.Jackso 2;1904;BILL;BACALIS;[EMAIL PROTECTED];AR;Arlington;0;Bill BacalisWhen 3;10730;CHERYL;BISTRICKY;[EMAIL PROTECTED];AR;Arlington;0; 4;1890;JULIA;BLANTON;[EMAIL PROTECTED];AR;Arlington;0; Julia Blanton Education Graduate New Hanover High School, Wilmington, NC Community College, Ala 5;9311;BOB;DANGOIA;[EMAIL PROTECTED];AR;Arlington;1;Bob Dangoia, CSP, CSA IIBus 6;3516;JOANNE;DOHERTY;[EMAIL PROTECTED];AR;Arlington;1;JoAnne Doherty, ABR, CRS, GRIFocused on ServiceLicensed Broker 7;1945;CONNIE;GLENN;[EMAIL PROTECTED];AR;Arlington;0;Connie Glenn Education BS in History, Ed. - Trevecca Nazarene Univeristy, Nashville, TN Graduate F.C.C.J. - Real Estate Licensing 8;8217;JEANNE;IMHOFF;[EMAIL PROTECTED];AR;Arlington;1;Jeanne ImhoffPrudential Network Realty ExperienceFlorida Real Estate Broker's license obtained in October 1998 Affiliated with the highly successful Arlington branch of Prudential Network Realty as a full time co 9;11460;PAMELA;KREMSER;[EMAIL PROTECTED];AR;Arlington;0; 10;;JENNIFER;LIND;[EMAIL PROTECTED];AR;Arlington;0; 11;11354;YVETTE;MCCOY;[EMAIL PROTECTED];AR;Arlington;1;Yvette McCoyYou may reach me at:[EMAIL PROTECTED] Office: 904-641-0048 Cell: 904-568-6657 Voice Mail: 904-565-1677 ext. 829 Fax: 904-296-0846The Prudential Network Realty Northeast Florida Real Estate's A Joy With Yvette 12;11480;CINDY;McEWAN;[EMAIL PROTECTED];AR;Arlington;0;Cynthia E 13;10721;KIM;MCMILLEN;[EMAIL PROTECTED];AR;Arlington;1;Kim McMillenvisit my website at: www.kimmcmillen.com 14;;DEB;MOULIN;[EMAIL PROTECTED];AR;Arlington;0; 15;1894;MARGIE;RASEY;[EMAIL PROTECTED];AR;Arlington;1;Margie Rasey- Realtor/Associateyou may reach me at : [EMAIL PROTECTED] Office: (904) 641-0048Home: (904) 363-6434 Fax: (904) 565-1233 Mobile: (904) 655-6209Pager: (904) 499-4682 The Prudential Network Realty 2771 16;1895;CONNIE;SHELFER;[EMAIL PROTECTED];AR;Arlington;1;Connie Shelfer Certified Relocation SpecialistExperience 23 years - Realtor in JacksonvilleProfessional Affiliations Mem 17;1885;DOT;SNEAD;[EMAIL PROTECTED];AR;Arlington;0;Dot Snead Dot Snead Education Business College Graduate Realtor - BrokerExperience over 20 years in 18;7546;BARBARA;SPARKS;[EMAIL PROTECTED];AR;Arlington;0;Barbara Sparks Education AT T Southern Bell Management Real Estate Salesperson license 1993 Real Estate Broker license 1995 Mort 19;10703;BILLY;SPILKER;[EMAIL PROTECTED];AR;Arlington;1;Billy SpilkerBilly Spilker - Realtor WEB page - www.BillySpilker.com e-mail - [EMAIL PROTECTED] office phone : 904-565-1377 ext 824 V.M. : 9004-318-7804 Fax : 904-565-1 20;1882;CHRISTINE;STANLEY;[EMAIL PROTECTED];AR;Arlington;1;Christine Stanley 21;;JENNY;THIGPEN;[EMAIL PROTECTED];AR;Arlington;0; 22;1897;MURLE;WESTER;[EMAIL PROTECTED];AR;Arlington;0; 23;5771;MURIEL;THORNE;[EMAIL PROTECTED];AR;Arlington;0; 24;11343;MARY;WESTER;[EMAIL PROTECTED];AR;Arlington;0; 25;8362;FLO;BLISS;[EMAIL PROTECTED];AV;Avondale;1;Flo BlissYour Hometown ProfessionalProfessional Experience:Experience 5 years of Real Estate experience 18 years of professional Marketing/Public Relations expertise Member of Na 26;9281;GREG;BOWEN;GREG [EMAIL PROTECTED];AV;Avondale;1; 27;11529;KEITH;COMBS;KEITH [EMAIL PROTECTED];AV;Avondale;0; 28;7043;CARMEN;EDWARDS;[EMAIL PROTECTED];AV;Avondale;1;Carmen Burton-Edw 29;5143;RIC;GOODMAN;[EMAIL PROTECTED];AV;Avondale;1;Ric Good 30;7772;ANN;HAYMAN;[EMAIL PROTECTED];AV;Avondale;1;Ann M Hayman- CRB, GRI, Re 31;8754;JACKIE;HERRING;[EMAIL PROTECTED];AV;Avondale;1;Jackie Herring, Realtor [EMAIL PROTECTED] Education: University of Florida G 32;10199;KATHERYN;HOLIDAY;KATHERYN [EMAIL PROTECTED];AV;Avondale;0; 33;10932;DOUG;HOLT;DOUG [EMAIL PROTECTED];AV;Avondale;1;Douglas Holt, Realtor [EMAIL PROTECTED]: Florida Institute of Real Estate Brass Tacks Prudential 34;6921;TIM;LOCKE;TIM [EMAIL PROTECTED];AV;Avondale;0;
Re: Multiple Tables
Rafal Jank writes: So in release 4.0 there will be multitable updates, not only deletes? -- _/_/ _/_/_/ - Rafa³ Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- Yes, that is right. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: not null
You must specify a datatype: create table table_name ( Column_Name integer not null ); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Fri, 27 July 2001 06:48 To: [EMAIL PROTECTED] Subject: not null I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. 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
Re: Unix passwd file and mysql authentication table
Don Read wrote: On 26-Jul-2001 sachin shetty wrote: Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table). The password_crypt routine used in MySQL is incompatible with the DES/MD5 crypt used for Unix passwords. Besides, MySQL user-names have nothing to do with Unix login-names. Isnt' the idea of DES crypt to be a standard method of encryption? Why would mysql's DES crypt be different then Unix? It would seem weird that Perl crypt, PHP crypt and Unix crypt are all the same, but mysql crypt is different, what's the point of having it at all then? And mysql user names do have nothing to do with the names in /etc/password, but administrators *could* make then the same if they choose. If there is a module that handles this during connection of the mysql client to the server, Maybe once PAM Kerberos become common-place, the user community could submit some patches ? then it saves the risk of sending password across network What makes you think the password goes over the network ? Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: possible bug in sum() function
[EMAIL PROTECTED] wrote: We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the query was: select sum(worktime),user from timecard where tcacct=project group by user; the answer was: 8.00user1 14.00 user2 160.00 user 3 Now, where I went to school, this adds up to 184! Suggestions? Pick a better school? -- Gerald L. Clark [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: not null
[EMAIL PROTECTED] wrote: I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. Thank you. You also need a column type. -- Gerald L. Clark [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: possible bug in sum() function
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote: We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the query was: select sum(worktime),user from timecard where tcacct=project group by user; the answer was: 8.00user1 14.00 user2 160.00 user 3 Now, where I went to school, this adds up to 184! Suggestions? Checked your math with an calculator? I get : 8 + 14 + 160 = 182 Halldor mysql, select, database, table, 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: disable the mysql port
You can add : skip-networking : to your my.cnf file. You will only be able to connect to the database server from localhost then. -- Jason On 7/26/01 5:21 PM, Michael Lin was heard saying: Hi, Does anyone know how to disable mysql listening port? Thanks, Michael Lin _ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I can kill it but Can't stop mysqld
On Thu, 26 Jul 2001, cjackson wrote: Thanks everyone for immediate response to this problem. I can kill the mysql process but I cannot stop it using /etc/rc.d/init.d/mysqld stop. I can start it like this using start but not stop it using stop. All of this is done as system root. So runlevel 3 starts it OK, but runlevel 5 won't stop it on shutdown. This problem arose today when I started tinkering with grant privileges. But doesn't make sense. Jackson try : mysqladmin -u root shutdown -p Halldor mysql, query, database, select - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing mysql
Hi! You are obviously running a 3.23.38 binary. Sorry, the executable mysqld.exe was in that version accidentally compiled with __NT__ defined, which means that mysqld.exe does not work on Win 98. Use mysqld-max.exe from the same distribution, or download 3.23.39 from www.mysql.com. InnoDB does not create directories. I assume you have created c:\ibdata and c:\iblogs yourself? If InnoDB already created some files to those directories, remove them, and start mysqld-max.exe again. I personally run in Windows from the command line: C:...mysqld-max --console which may be the easiest choice for a new user. Regards, Heikki http://www.innodb.com . I'm relatively new to web development and basically don't have a clue on all the intricacies of establishing a localhost development environment. I'm running a Win 98 platform and want to develop using PHP4, Apache, MySql that will support transaction processing. I've found a ton of great information on establishing this dev environment and have successfully installed configured apache php. These process seem to work just fine, I'm able to serve up my PHP scripts no problem. So my next step was to install MySql, All the tutorials I've read make it sound like a piece of cake, however I must be illiterate because MySql is kicking my butt. It's my impression I must be missing the boat somewhere on the configuration aspects of this. I was getting an error innodb_data_file_path not specified so I read some more setup a C:\my.cnf file with a slew of InnoDB options; # mysql config file. # # One can use all long options that the program supports. # Run the program with --help to get a list of availableoptions # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 innodb_data_file_path = ibdata1:20M;ibdata2:20M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=10M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=20M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you move the MySQLdistribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb ** I got farther along but evidently what I have must not be appropriate because it died with the following: Innobase: Assertion failure in thread 4294132173 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11.Aborting! 010726 19:30:37 Aborting InnoDB: Warning: shutting down not properly started database 010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to use shortcut keys
You mean within mysql? That's a program, doskey won't do anything inside that program. Oh junhui schrieb am Freitag, 27. Juli 2001, 06:49:05: Hi, I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am running mySQL using MSDOS-prompt, there is no shortcut key available (all the arrows keys, ctrl+p, etc, don't work, even though doskey was enabled). Thanks in advance. JH -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: not null
Example: CREATE TABLE rassen ( id smallint(5) unsigned NOT NULL auto_increment, bezeichnung varchar(50) NOT NULL, kurz varchar(25) NOT NULL, total smallint(5) unsigned DEFAULT '0' NOT NULL, totalDeck tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY id (id, bezeichnung), KEY kurz (kurz), KEY totalDeck (totalDeck) ); [EMAIL PROTECTED] schrieb am Freitag, 27. Juli 2001, 06:47:50: I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving database from windoze to Linux
try to use mysqlfront ( http://www.mysqlfront.de ), a windows GUI for mysql i've tried it and it works like a charm you can export table structure in a .sql format and then dump data into a csv file and use the same utlity to import the files into your linux machine; regards; At 08:00 27/07/01, you wrote: Good day, I have created a database using MySQL under Windoze and am trying to move the data to MySQL running on Linux. I have exported the data to a res file - can't see how to do a mysqldump in Windoze. I then try and import the file on the Linux machine using LOAD DATA, but end up with either NULL in all the fields except the primary key field or if I use ENCLOSED BY '', I end up with the data enclosed by quotes. How do I do this properly, please? TIA Glyn Glyn Davies Cirrus-TechVue South Africa Tel: +27 11 783 1508 www.cirrus.co.za __ The information contained in this email is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. Cirrus Techvue is not liable for the proper, complete transmission of the information contained in this email, or any delay in its receipt, and does not warrant that the mail is virus-free. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Lost connection
Date |Thu, 26 Jul 2001 19:11:21 -0700 From |Hannes Niedner [EMAIL PROTECTED] Hello! HN I just checked upon the following query which was already running for 3+ HN hours. The sequence field is a non-indexed text field (is for once only HN join). mysql create table genpept_sequence_protein HN - select sequence_id, genpept_20010726_113345.* from sequence_protein, HN - genpept_20010726_113345 HN - where sequence_protein.sequence=genpept_20010726_113345.sequence HN - order by sequence_id; HN ERROR 2013: Lost connection to MySQL server during query HN Although I got this error message the table was created. My question is, is HN the table complete? In short words - nobody knows. You must check it. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: not null
Date |Fri, 27 Jul 2001 00:47:50 EDT From |[EMAIL PROTECTED] Hello! C I am having trouble setting a column attribute to not null. Below is the C statement I am using: C create table table_name ( C Column_Name not null C ); C If this is not the correct way to do it, can someone please help me...this is C my first mysql database. You need to specify what type of data will be stored in Column_Name column. Look here: http://www.mysql.com/doc/C/o/Column_types.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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