solaris 2.6 stubborn compile problems solved
PEBCAK: I found two self-referencing symbolic links in /usr/lib. I don't know how they got there, but removing them let the compile continue. Thanks all who tried to help me. -- fil krohnengold network systems administrator american museum of natural history [EMAIL PROTECTED] (mysql,database - post me) --- End of Forwarded Message - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Column Names
MySQL's Documentation: A name may start with any character that is legal in a name. In particular, a name may start with a number (this differs from many other database systems!). However, a name cannot consist only of numbers. MyQuestion: Why can't a column name be just a number? For example: CREATE TABLE Odorants( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, odorant VARCHAR(30) NOT NULL, row TINYINT UNSIGNED NOT NULL, 1 DOUBLE(4,20), 2 DOUBLE(4,20), 3 DOUBLE(4,20), 4 DOUBLE(4,20), 5 DOUBLE(4,20), 6 DOUBLE(4,20), 7 DOUBLE(4,20), 8 DOUBLE(4,20), 9 DOUBLE(4,20), 10 DOUBLE(4,20), 11 DOUBLE(4,20), 12 DOUBLE(4,20), 13 DOUBLE(4,20), 14 DOUBLE(4,20), 15 DOUBLE(4,20), 16 DOUBLE(4,20), 17 DOUBLE(4,20), 18 DOUBLE(4,20), 19 DOUBLE(4,20), 20 DOUBLE(4,20), 21 DOUBLE(4,20), 22 DOUBLE(4,20), 23 DOUBLE(4,20), 24 DOUBLE(4,20), 25 DOUBLE(4,20), 26 DOUBLE(4,20), 27 DOUBLE(4,20), 28 DOUBLE(4,20), 29 DOUBLE(4,20), 30 DOUBLE(4,20), 31 DOUBLE(4,20), 32 DOUBLE(4,20), 33 DOUBLE(4,20), 34 DOUBLE(4,20), 35 DOUBLE(4,20), 36 DOUBLE(4,20), 37 DOUBLE(4,20), 38 DOUBLE(4,20), 39 DOUBLE(4,20), 40 DOUBLE(4,20), 41 DOUBLE(4,20), 42 DOUBLE(4,20), 43 DOUBLE(4,20), 44 DOUBLE(4,20), PRIMARY KEY (id), UNIQUE UC_id (id)); ERROR 1064: You have an error in your SQL syntax near '1 DOUBLE(4,20), 2 DOUBLE(4,20), 3 DOUBLE(4,20), 4 DOUBLE(4,20), 5 DOUBLE(4,' at line 5 Other: Any thoughts or suggestions are welcomed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Column Names
What would SELECT 42 FROM SOME_TABLE return? column name 42 or the numerical value 42 ? M -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 08:23 To: MySQL Subject: Column Names MySQL's Documentation: A name may start with any character that is legal in a name. In particular, a name may start with a number (this differs from many other database systems!). However, a name cannot consist only of numbers. MyQuestion: Why can't a column name be just a number? For example: CREATE TABLE Odorants( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, odorant VARCHAR(30) NOT NULL, row TINYINT UNSIGNED NOT NULL, 1 DOUBLE(4,20), 2 DOUBLE(4,20), 3 DOUBLE(4,20), 4 DOUBLE(4,20), 5 DOUBLE(4,20), 6 DOUBLE(4,20), 7 DOUBLE(4,20), 8 DOUBLE(4,20), 9 DOUBLE(4,20), 10 DOUBLE(4,20), 11 DOUBLE(4,20), 12 DOUBLE(4,20), 13 DOUBLE(4,20), 14 DOUBLE(4,20), 15 DOUBLE(4,20), 16 DOUBLE(4,20), 17 DOUBLE(4,20), 18 DOUBLE(4,20), 19 DOUBLE(4,20), 20 DOUBLE(4,20), 21 DOUBLE(4,20), 22 DOUBLE(4,20), 23 DOUBLE(4,20), 24 DOUBLE(4,20), 25 DOUBLE(4,20), 26 DOUBLE(4,20), 27 DOUBLE(4,20), 28 DOUBLE(4,20), 29 DOUBLE(4,20), 30 DOUBLE(4,20), 31 DOUBLE(4,20), 32 DOUBLE(4,20), 33 DOUBLE(4,20), 34 DOUBLE(4,20), 35 DOUBLE(4,20), 36 DOUBLE(4,20), 37 DOUBLE(4,20), 38 DOUBLE(4,20), 39 DOUBLE(4,20), 40 DOUBLE(4,20), 41 DOUBLE(4,20), 42 DOUBLE(4,20), 43 DOUBLE(4,20), 44 DOUBLE(4,20), PRIMARY KEY (id), UNIQUE UC_id (id)); ERROR 1064: You have an error in your SQL syntax near '1 DOUBLE(4,20), 2 DOUBLE(4,20), 3 DOUBLE(4,20), 4 DOUBLE(4,20), 5 DOUBLE(4,' at line 5 Other: Any thoughts or suggestions are welcomed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOCK TABLES issue
I'll try posting this again, because nobody has replied to it. To put the problem more succinctly: I think there is a flaw in the mysql LOCK statement semantics, because if I use LOCK then all tables that are accessed while the LOCK is active must be locked for READ or WRITE access (or insert, but that doesn't help me). This is done I think to protect the application writer against accidently not getting locks that are required. What is needed is an explicit way to allow a particular table to participate while the LOCK statement is active, but without locking it. I've suggested that LOCK ... table NOLOCK would be an appropriate addition to the LOCK statement for these semantics--it allows a table to be explicitly left unlocked. More details are available in my original post, which is included here. I would appreciate comments on this. (If there's a better place to post this, can someone let me know that, too?). Thanks, Bob Bob Sidebotham wrote: I have an application with fairly typical locking requirements: 99% of the requests are read-only (with an exception that I will specify). Update requests are relatively rare. There's a half-dozen tables, and since the inter-relationships are a little complex. I found it easiest, given the performance constraints of my application, to simply lock ALL the tables for READ for the read requests, and to lock ALL of them for WRITE in the case of an update. I think this is a fine, time-tested, conservative locking strategy. It basically can't fail, and gives me adequate performance for my needs. I have ONE table which records access counts/times for each user for individual objects in the system. This table needs to be updated on every access. This table can be updated correctly without obtaining any locks. It is subject to being read at unpredictable times during any of the read-only requests. Since the access table can be read during any of the read-only requests, and since it can be read at any time during the transaction, I have to obtain at least a READ lock for this table along with the other locks (even though I don't really need a read-lock) because MySQL insists that if any tables are locked, then every table you wish to access must also be locked (I assume this feature is intended as a reasonable precaution against accidently forgetting to lock a table that must participate in a transaction). Unfortunately, to update this table I have to either upgrade to a WRITE lock or drop the lock altogether. It's obvious that upgrading to a WRITE lock will cause all my read-only operations to pileup on the WRITE lock. It's also possible for me to drop all the locks (and record the accesses at the very end of the transaction). Less obvious, but I think true, is that this *also* causes serialization, because MySQL must implicitly require all the READ locks on the table to be dropped before allowing me to update it (is this true? If it isn't true, it should be!). I cannot, by the way, use READ LOCAL because I want to use both UPDATE and REPLACE on the table. So I seem to be caught between a LOCK and a hard place, so to speak. What I would like to see would be something like: LOCK TABLES t1 READ, t2 READ, t3 NOLOCK; The semantics of this would be to explicitly recognize that t3 does not need to be locked and can therefore be read or written after this LOCK TABLES request (as opposed to any table that is not mentioned which cannot be read or written). NOLOCK would, of course, be incompatible with READ or WRITE locks, but would be compatible with other NOLOCK locks or with no lock at all, for both read and write operations. If anyone can suggest another way to do this, I'd appreciate it. Otherwise, is there any reaction to this proposal? Does anyone think this is useful functionality? Thanks, Bob Sidebotham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
add secs to datetime
I have datetime and I want to add a number or seconds to it. That number can be greater than 60, it can actually be greater than the equivalent of a years in seconds. How do I add these seconds to the value of a datetime field through an update with MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC problems with file DSN
Hello, Can anybody here help me. I have a MySQL server running on Linux to which I wish to connect from a machine running NT. This is fine normally using MyODBC. However the following scenario does not work. The DSN is a file DSN on another NT box and is accessed using UNC e.g. //machine/file.dsn The MyODBC driver is only on the machine with the DSN not the machine requiring the access. Should this approach work, as it seems to be fine with other databases Thanks in advance John Lodge John Lodge Software Engineer Redwood Technologies Limited T +[44] (0)1344 304 344 F +[44] (0)1344 304 345 M +[44] (0)794 122 1422 E [EMAIL PROTECTED] W www.redwoodtech.com Email Disclaimer The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the limitations of Redwood Technologies Limited's standard terms and conditions of contract. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
When will PREPARE be available?
I see that PREPARE is on a TODO list for MYSQL. Does anyone know if or when it might be available (or if it is high priority). I'm having to parse SQL statements myself to extract column and table names and then match columns to tables to get column information. PREPARE would mean that MYSQL would do this for me (this is really where this sort of processing belongs). Any information 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: user / pwd access to db driven website
Why don't you forget about the automated subscription service and use the phone or email to get the money in. Once you have your 5-10+ subscriptions up and running then you can upgrade properly and then get your shopping cart or whatever. Presumably you'll also want to use a different userID/password per user and track what they are doing so you'll need a completely new set of infrastructure tables and the backend code to maintain them. Another idea if your technical skills aren't yet upto the job would be to put the data onto CD and just send that out to the early customers; the data doesn't sound that volatile and web delivery may not be the best way. All the above would also give you a much earlier idea of whether this will be a success or not. Very few sites that ask for money for information are a success and if just five subscribers will bank roll you a new platform then your prices are clearly not a couple of pence per access. Good luck, Tony - Original Message - From: Investor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 5:49 PM Subject: user / pwd access to db driven website HI all, I would be extremely appreciative with solution suggestions to the problem I am having. I really could use some help right now !! I am trying to get a database driven website up and running that has some amount of security on it (which i intend to make progresively better). It needs user/pwd access to a database of info, after a subscription fee is paid. Currently I am having trouble setting up the basic structure. By the way this is a starup company, and only 5- 10 subscriptions would fund much better software / hardware / server for the site. So my goal is to set up something inexpensive to get those 5 or so subscriptions. Attempt No. 1: I setup a test site ( virtual hosting I think it is called) that utilizes perl ms access. It works oK except I didn't get the user/pwd thing working. It has pwd protected directories - however they told me queries will not work with the pwd protected directory insalled. Technical support is very slow in responding. And I didn't figure out how to provide the needed security mentioned above. Currently I have been reading about mysql and just installed it on windows 98. I am open to changing over to linux based systems. However I would like to create the tempory site to get a few subsciptions prior to forking out the funds. So finally now that you guys know my situation can you please make some suggestions as to how to get the temporary site up ( to get 5 subscriptions or so) and I think I coudl painfully, over time, work on a site that could handle much more. Information: The database would be text only, less than 1 GB ! Right now I think it is at 5 MB but will increase. I am familar with perl 5.6 and ms access. Budget: Shoe string budget for now. :) I would greatly appreciate assistance I am sure many of you dealt with this type of situation before. = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: add secs to datetime
* Kodrik I have datetime and I want to add a number or seconds to it. That number can be greater than 60, it can actually be greater than the equivalent of a years in seconds. How do I add these seconds to the value of a datetime field through an update with MySQL? update table set datefield=datefield + INTERVAL 1 SECOND; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Join Query Help
Hi, The better way of storage is to normalize it. Hope this way it will help you out. SQL DESC EVENTS Name Null?Type - EVENTIDNUMBER(2) EVENTPART NUMBER(2) ARTISTID NUMBER(2) SQL DESC ARTISTS Name Null?Type - ARTISTID NUMBER(2) ARTISTNAME VARCHAR2(20) SQL SELECT * FROM EVENTS; EVENTID EVENTPART ARTISTID -- -- -- 1 1 1 1 2 2 1 2 3 1 3 4 1 4 5 ABOVE THE SAME EVENT HAS FOUR PARTS. PART1: ARTIST 1 PART2: ARTIST 2,3 PART3: ARTIST 4 PART4: ARTIST 5 SQL SELECT * FROM ARTISTS; ARTISTID ARTISTNAME -- 1 A 2 B 3 C 4 D 5 E SQL SELECT A.EVENTID,A.EVENTPART,A.ARTISTID,B.ARTISTNAME FROM EVENTS A,ARTISTS B 2 WHERE A.ARTISTID=B.ARTISTID; EVENTID EVENTPART ARTISTID ARTISTNAME -- -- -- - 1 1 1 A 1 2 2 B 1 2 3 C 1 3 4 D 1 4 5 E The rest is to retrieve the artists of each part of the event. This way we can identify the events, parts and also the names of the artists. I don't think u ll be using mysql as GUI. The retrieval and display from the result set can be done comfortably through any programming language. Hope this would help you. Thanks, Rama Raju -Original Message- From: udayashankarl_n [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 9:38 AM To: Etienne; [EMAIL PROTECTED] Subject: RE: Join Query Help Hi, The below mentioned query, select eventartists.eaDnID,djnames.dnName,eventartists.eaDn2ID from eventartists,djnames where djnames.dnID = eventartists.eaDnID; gives the following result. +++-+ | eaDnID | dnName | eaDn2ID | +++-+ | 1 | dj a |NULL | | 2 | dj b | 3 | | 4 | dj d |NULL | | 5 | dj e |NULL | +++-+ 4 rows in set (0.00 sec) with which we can come to know that dj b is performing with one other artist and whose ID is 3. -Original Message- From: Etienne [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 9:14 AM To: [EMAIL PROTECTED] Subject: Join Query Help Hello, I'm back to the list after two weeks off. I have a little problem, the email may seem long but it's clearly explained step by step what I've done... I have a table that have artists playing at events. It's called eventartists. One artist can play alone, or with another artist. Because the number of artists playing together is limited (3 max) I don't want to build another table for them since I have plenty of links like this. mysql create table eventartists( - eaEvtID smallint unsigned not null, - eaDnID smallint unsigned not null, - eaDn2ID smallint unsigned, - unique index(eaEvtID,eaDnID,eaDn2ID), - unique index(eaDnID, eaEvtID), - unique index(eaDn2ID, eaEvtID)); Query OK, 0 rows affected (0.02 sec) Then I have my artists table called djnames with some info mysql create table djnames( - dnID smallint unsigned not null auto_increment, - dnName varchar(20) not null, - primary key(dnID)); Query OK, 0 rows affected (0.02 sec) then let's insert some fake data... let's fill some djs first: mysql insert into djnames(dnName) values(dj a); Query OK, 1 row affected (0.01 sec) mysql insert into djnames(dnName) values(dj b); Query OK, 1 row affected (0.00 sec) mysql insert into djnames(dnName) values(dj c); Query OK, 1 row affected (0.00 sec) mysql insert into djnames(dnName) values(dj d); Query OK, 1 row affected (0.00 sec) mysql insert into djnames(dnName) values(dj e); Query OK, 1 row affected (0.01 sec) then let's say event #1 has dj a, djb playing with dj c and dj d and e playing alone. mysql insert into eventartists(eaEvtID,eaDnID) values(1,1); Query OK, 1 row affected (0.00 sec) mysql insert into eventartists(eaEvtID,eaDnID) values(1,4); Query OK, 1 row affected (0.00 sec) mysql insert into eventartists(eaEvtID,eaDnID) values(1,5); Query OK, 1 row affected (0.00 sec) mysql insert into eventartists(eaEvtID,eaDnID,eaDn2ID) values(1,2,3); Query OK, 1 row affected (0.00 sec) mysql select eaDnID,eaDn2ID
RE: LOCK TABLES issue
You are using InnoDB or MyISAM??? If u r going for InnoDB, Refer to InnoDB Engine manual for the version 3.23.47 at www.innodb.com. Here you details of different LOCK types. You can select the appropriate lock type at row level for different possibilities. Hope this works!! Cheers :) Rama Raju -Original Message- From: Bob Sidebotham [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 2:00 PM To: [EMAIL PROTECTED] Subject: Re: LOCK TABLES issue I'll try posting this again, because nobody has replied to it. To put the problem more succinctly: I think there is a flaw in the mysql LOCK statement semantics, because if I use LOCK then all tables that are accessed while the LOCK is active must be locked for READ or WRITE access (or insert, but that doesn't help me). This is done I think to protect the application writer against accidently not getting locks that are required. What is needed is an explicit way to allow a particular table to participate while the LOCK statement is active, but without locking it. I've suggested that LOCK ... table NOLOCK would be an appropriate addition to the LOCK statement for these semantics--it allows a table to be explicitly left unlocked. More details are available in my original post, which is included here. I would appreciate comments on this. (If there's a better place to post this, can someone let me know that, too?). Thanks, Bob Bob Sidebotham wrote: I have an application with fairly typical locking requirements: 99% of the requests are read-only (with an exception that I will specify). Update requests are relatively rare. There's a half-dozen tables, and since the inter-relationships are a little complex. I found it easiest, given the performance constraints of my application, to simply lock ALL the tables for READ for the read requests, and to lock ALL of them for WRITE in the case of an update. I think this is a fine, time-tested, conservative locking strategy. It basically can't fail, and gives me adequate performance for my needs. I have ONE table which records access counts/times for each user for individual objects in the system. This table needs to be updated on every access. This table can be updated correctly without obtaining any locks. It is subject to being read at unpredictable times during any of the read-only requests. Since the access table can be read during any of the read-only requests, and since it can be read at any time during the transaction, I have to obtain at least a READ lock for this table along with the other locks (even though I don't really need a read-lock) because MySQL insists that if any tables are locked, then every table you wish to access must also be locked (I assume this feature is intended as a reasonable precaution against accidently forgetting to lock a table that must participate in a transaction). Unfortunately, to update this table I have to either upgrade to a WRITE lock or drop the lock altogether. It's obvious that upgrading to a WRITE lock will cause all my read-only operations to pileup on the WRITE lock. It's also possible for me to drop all the locks (and record the accesses at the very end of the transaction). Less obvious, but I think true, is that this *also* causes serialization, because MySQL must implicitly require all the READ locks on the table to be dropped before allowing me to update it (is this true? If it isn't true, it should be!). I cannot, by the way, use READ LOCAL because I want to use both UPDATE and REPLACE on the table. So I seem to be caught between a LOCK and a hard place, so to speak. What I would like to see would be something like: LOCK TABLES t1 READ, t2 READ, t3 NOLOCK; The semantics of this would be to explicitly recognize that t3 does not need to be locked and can therefore be read or written after this LOCK TABLES request (as opposed to any table that is not mentioned which cannot be read or written). NOLOCK would, of course, be incompatible with READ or WRITE locks, but would be compatible with other NOLOCK locks or with no lock at all, for both read and write operations. If anyone can suggest another way to do this, I'd appreciate it. Otherwise, is there any reaction to this proposal? Does anyone think this is useful functionality? Thanks, Bob Sidebotham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
prozess accounting
Hello, I cannot guarantee somehow an individual user the whole computing time used up. Have mysql anything prozess accounting? Or other restrictions of CPU Time - User account? The problem is: one user had 100 (and more) prozesses to run, an other user starts queries and he can get no more computing time for his queries. Thanks, -- Helmut - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: add secs to datetime
On Monday 07 January 2002 01:13 am, Roger Baklund wrote: * Kodrik I have datetime and I want to add a number or seconds to it. That number can be greater than 60, it can actually be greater than the equivalent of a years in seconds. How do I add these seconds to the value of a datetime field through an update with MySQL? update table set datefield=datefield + INTERVAL 1 SECOND; I thought SECOND was limited to 59 and if you entered more it ignored it. Glad to see I was wrong :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: prozess accounting
You can set MySQL questions to low priority if this Is what you need but you would have to ask the user to do this. As MySQL is so fast and can run 1000 threads plus your user should not slow any thing down. The other thing to look at is run a copy of MySQL for each user! Hope this helps Simon -Original Message- From: Helmut Fahrion [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 09:46 To: [EMAIL PROTECTED] Subject: prozess accounting Hello, I cannot guarantee somehow an individual user the whole computing time used up. Have mysql anything prozess accounting? Or other restrictions of CPU Time - User account? The problem is: one user had 100 (and more) prozesses to run, an other user starts queries and he can get no more computing time for his queries. Thanks, -- Helmut - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Swapped out mysqld on linux 2.4.17-rc2 with INSERT DELAYED data
Hi, I'm using INSERT DELAYED to insert about 120GB of data into mysql from mysqldumpped data from remote server. After the weekend I've found such output from our perl script (after was dumped let's say 60GB): Just dumping Mthermoautotrophicum.orf Just dumping Mthermoautotrophicum.orf_data Just dumping Mthermoautotrophicum.pfam Just dumping Mthermoautotrophicum.pfam_data ERROR 1135 at line 30: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug Failed to dump Mthermoautotrophicum.pfam_data Just dumping Mthermoautotrophicum.pirkw ERROR 1135 at line 46: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug Failed to dump Mthermoautotrophicum.pirkw Just dumping Mthermoautotrophicum.prd ERROR 1135 at line 31: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug Failed to dump Mthermoautotrophicum.prd [...] DBI-connect failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug at /home/bioadmin/bin/dump_tables.pl line 252 FATAL ERROR: Unable to connect to jerboas: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug at /home/bioadmin/bin/dump_tables.pl line 252. Can't call method func without a package or object reference at /home/bioadmin/bin/dump_tables.pl line 254. shell$ The machine is linux 2.4.17-rc2 running /usr/local/mysql/bin/mysql Ver 11.15 Distrib 3.23.42, for pc-linux-gnu (i686). The machine runs SMP kernel on 2 Intel Pentium III processor box with 1GB of memory. I rerun our script to continue dumps and managed to dump about 60 tables, and then same problem: arrose Just dumping Mycoplasma_genitalium_G37.cogs_data ERROR 1135 at line 30: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug Failed to dump Mycoplasma_genitalium_G37.cogs_data shell$ mysqladmin extended-status +--++ | Variable_name| Value | +--++ | Aborted_clients | 196| | Aborted_connects | 23 | | Bytes_received | 1584472794 | | Bytes_sent | 1311517| | Connections | 11826 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 0 | | Created_tmp_files| 0 | | Delayed_insert_threads | 4089 | | Delayed_writes | 78047350 | | Delayed_errors | 3591775| | Flush_commands | 1 | | Handler_delete | 0 | | Handler_read_first | 1 | | Handler_read_key | 0 | | Handler_read_next| 2 | | Handler_read_prev| 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next| 418| | Handler_update | 0 | | Handler_write| 85799969 | | Key_blocks_used | 249376 | | Key_read_requests| 2092226517 | | Key_reads| 21218 | | Key_write_requests | 542944973 | | Key_writes | 10606554 | | Max_used_connections | 4 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 4318 | | Open_files | 28192 | | Open_streams | 0 | | Opened_tables| 10989 | | Questions| 25236 | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 0 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 949| | Sort_merge_passes| 0 | | Sort_range | 0 | | Sort_rows| 0 | | Sort_scan| 0 | | Table_locks_immediate| 10247 | | Table_locks_waited | 0 | | Threads_cached | 3 | | Threads_created | 16 | | Threads_connected| 4090 | | Threads_running | 1 | | Uptime | 1445845| +--++ shell$ mysqladmin processlist gives me: | 11711 | DELAYED | localhost | Mthermoautotrophicum | |Delayed_insert | 981| Waiting on cond | scop2 | | 11713 | DELAYED | localhost | Mthermoautotrophicum | |Delayed_insert |
How to start the server
Newbee! Loaded binaries (not RPM or Package) on RH Linux7.2. How to start the MySQL server manually and how to configure it (ie port on which it is running). Not finding the proper documentation page on 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
URGENT
HI!!! I am trying to execute the following query, in which i am tring to insert data from the table testtable into the same table testtable. insert into testtable(col1,col2) select col1.col2 from testtable; This query does not execute and generatethe following error:- Not Unique table/alias: 'testtable' Please do reply This is urgent Thanks Amit Lonkar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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: How to start the server
Start by /usr/local/mysql/bin/safe_mysqld --user=mysql after scripts/mysql_install_db of cores to configure (port etc.) edit /etc/my.cnf Simon -Original Message- From: R.C.Nougain [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 10:03 To: [EMAIL PROTECTED] Subject: How to start the server Newbee! Loaded binaries (not RPM or Package) on RH Linux7.2. How to start the MySQL server manually and how to configure it (ie port on which it is running). Not finding the proper documentation page on 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: URGENT
You cold use temp tables? Simon -Original Message- From: amit lonkar [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 10:08 To: [EMAIL PROTECTED] Subject: URGENT HI!!! I am trying to execute the following query, in which i am tring to insert data from the table testtable into the same table testtable. insert into testtable(col1,col2) select col1.col2 from testtable; This query does not execute and generatethe following error:- Not Unique table/alias: 'testtable' Please do reply This is urgent Thanks Amit Lonkar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to run commands written in a file
I have sql commands written in a file. How to run this file at sql prompt so that commands executed thru this batch file. Something similar to Oracles sql @/mydir/mysql.sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 run commands written in a file
In the script file add the first statement as 'use db_name;' Mysql/binmysql file_name.sql Thanks, Rama Raju -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 4:01 PM To: [EMAIL PROTECTED] Subject: How to run commands written in a file I have sql commands written in a file. How to run this file at sql prompt so that commands executed thru this batch file. Something similar to Oracles sql @/mydir/mysql.sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to run commands written in a file
* D Bamud I have sql commands written in a file. How to run this file at sql prompt so that commands executed thru this batch file. Something similar to Oracles sql @/mydir/mysql.sql mysql source myfile.sql or mysql \. myfile.sql -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC problems with file DSN
Hello, Can anybody here help me. I have a MySQL server running on Linux to which I wish to connect from a machine running NT. This is fine normally using MyODBC. However the following scenario does not work. The DSN is a file DSN on another NT box and is accessed using UNC e.g. //machine/file.dsn The MyODBC driver is only on the machine with the DSN not the machine requiring the access. Should this approach work, as it seems to be fine with other databases Thanks in advance John Lodge John Lodge Software Engineer Redwood Technologies Limited T +[44] (0)1344 304 344 F +[44] (0)1344 304 345 M +[44] (0)794 122 1422 E [EMAIL PROTECTED] W www.redwoodtech.com Email Disclaimer The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the limitations of Redwood Technologies Limited's standard terms and conditions of contract. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C-API Query
Hi, I have written the following code using C-API and would like to retrieve the info from MYSQL. But it gives me error messages. Please let me know where iam going wrong. the code and error messages are : #include stdio.h #include mysql/mysql.h main() { int sel; MYSQL *mysql=NULL; mysql_init(mysql); if(mysql == NULL) { printf(\n MySQL unable to intialise\n); exit(-1); } mysql_real_connect(mysql,23.22.2.2,user,pwd,db_name,0,NULL,0); sel = mysql_query(mysql, select e-no,ename from employee); printf(sel %d\n,sel); } produces the following error messages. /tmp/ccPhnnJk.o: In function `main': /tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init' /tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect' /tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_query' collect2: ld returned 1 exit status Regards Uday - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL optimizer and OR - bug or misconcept?
Description: When WHERE clause contains OR mysql don't any keys and don't perorm validity check even. USE KEY directive does not change this. How-To-Repeat: create table t ( a int unsigned, b int unsigned, key(a), key(b)); insert about 2000 random rows select count(*) from t; 2048 1. Check for exisiting values: mysql explain select a,b from t where b = 9258279; +---+--+---+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+---+--++ | t | ref | b | b| 5 | const | 48 | where used | mysql explain select a,b from t where b = 7973452; | t | ref | b | b| 5 | const | 69 | where used | mysql explain select a,b from t where a = 9258279 or b = 7973452; | t | ALL | a,b | NULL |NULL | NULL | 2048 | where used | mysql explain select a,b from t use key (a) where a = 9258279 or b = 7973452; | t | ALL | a,b | NULL |NULL | NULL | 2048 | where used | 2. Check for impossible (negative) values: mysql explain select a,b from t where a = -20; | t | ref | a | a| 5 | const |1 | where used | mysql explain select a,b from t where a = -20 or b = -10; | t | ALL | a,b | NULL |NULL | NULL | 2048 | where used | mysql explain select a,b from t use key (a) where a = -20 or b = -10; | t | ALL | a,b | NULL |NULL | NULL | 2048 | where used | Regardless of index schema - i used simplest example. For 1. I can agree that optimizer can decide to scan all table under certain conditions, but for 2. I think range checks must always apply. Negative values for unsigned, IS NULL for column defined not null and so on. mysql alter table t modify a int unsigned not null; mysql explain select a,b from t where a is null or b = -10; | t | ALL | a,b | NULL |NULL | NULL | 2048 | where used | In this case optimizer must notice primary key can't be null so (a is null) can be skipped from where clause Tested with several 3.23.x versions, 4.00, 4.0.1 Fix: Workaround in 4.x - Use UNION select ... from t where a = 'x' union select ... where b = x; mysql explain select a,b from t where a = -20 union select a,b from t where b = -10; | t | ref | a | a| 5 | const |1 | where used | | t | ref | b | b| 5 | const |1 | where used | Workaround in 3.23.x - Use temporary table mysql create temporary table tmp select a,b from t where a = -20; mysql insert into tmp select a,b from t where b = -10; mysql select * from tmp; 0 rows mysql drop table tmp; lock/unlock table may be added. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crashreport: mysql-3.23.46 - crash when entering passwords
I can report a major crash, when entering passwords and mail it to the list as written in the file mysqlbug. If you are interested please read the following lines and the .crash.log (perhaps you can give me a hint what could have been wrong): I am working with an Apple PowerBook G3 with MacOS X 10.1.2. When installing mysql the first time successful ([hlutz:/usr/local/mysql] hlutz% sudo ./scripts/mysql_install_db) there were provided some hints during processing this procedure: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h hlutz -p password 'new-password' In the instructions of Marc Liyanage (www.entropy.ch/software/macosx/mysql/) is written: mysqladmin -u root password new_password_here First I tried Marcs instructions: [hlutz:/usr/local/mysql] hlutz% mysqladmin -u root password abc12345 - no system alert Second I tried to do the 2nd line method of the provided hints (written above) for the user hlutz: I used the same password: [hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -h hlutz -p password abc12345 - Crash This are the lines before the crash: [hlutz:/usr/local/mysql] hlutz% mysqladmin -u root password abc12345 [hlutz:/usr/local/mysql] hlutz% mysqladmin -u root -h hlutz -p password abc12345 Enter password: Bus error (- see mysqladmin.crash.log) [hlutz:/usr/local/mysql] hlutz% This is the mysqladmin.crash.log: Date/Time: 2002-01-06 17:58:41 +0100 OS Version: 10.1.2 (Build 5P48) Host: hlutz Command:mysqladmin PID:500 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x Thread 0 Crashed: #0 0x70003b30 in memmove #1 0x8ef0 in 0x8ef0 #2 0x2628 in 0x2628 #3 0x2464 in 0x2464 #4 0x1f50 in 0x1f50 #5 0x1d80 in 0x1d80 PPC Thread State: srr0: 0x70003b30 srr1: 0xd030vrsave: 0x xer: 0x2010 lr: 0x8ef0 ctr: 0x70003a00 mq: 0x r0: 0x0004 r1: 0xb430 r2: 0xb544 r3: 0xb540 r4: 0x0004 r5: 0x r6: 0x r7: 0x0004 r8: 0x70029770 r9: 0x00021400 r10: 0x000211a0 r11: 0x00016d8c r12: 0x70003a00 r13: 0x87859393 r14: 0xc24bc195 r15: 0x87859393 r16: 0xc24bc195 r17: 0x r18: 0x0cea r19: 0xb478 r20: 0x r21: 0x000212c0 r22: 0x r23: 0x000212b0 r24: 0x r25: 0x000212c0 r26: 0xbc32 r27: 0xb898 r28: 0xb898 r29: 0x00016ce0 r30: 0x0003 r31: 0x8b90 ** Kind regards Helmuth -- Helmuth Lutz Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql, innodb, linux problems
Prabhu, 4.0.x is the development version. 3.23.xx is better tested. But 4.0.1 looks good now that it has been out a couple of weeks. Upgrading to 4.0.1 is another possibility. Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com At 11:55 AM 1/7/02 +0530, you wrote: Hi Heikki, There is 4.xx version available. why upgrade to 3.xx version? -- Prabhu On Fri, 4 Jan 2002, Heikki Tuuri wrote: Date: Fri, 4 Jan 2002 16:55:29 +0200 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Mysql, innodb, linux problems Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 differents processes, on the same table) I got deadlock = My processes went down (after the timeout I had set) and if I try an interactive request on the table (like select count(*) from ... I never got the answer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment
Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: auto_increment
Manish, If you manually insert a record with a value of 100 in the auto_increment field, then it will work from then on. If there is a way to create the table telling the value to start at 100, then I don't know what it is. Hope this is a help John Lodge -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 12:25 PM To: mysql Subject: auto_increment Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: auto_increment
hi. yes it is possible. 1. Create an new column which has an auto_increment option 2. Insert the first dataset manually as followed: INSERT INTO test (auto, char) VALUES ('100', 'Hello World!') 3. From there on your auto column will count starting from 100, 101, 102, ... Greeting - Daniel Backhausen --- N2MEDIA web- multimediadesign http://www.N2media.de - mailto:[EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: Gesendet: Montag, 7. Januar 2002 13:25 Betreff: auto_increment Return-path: [EMAIL PROTECTED] Envelope-to: [EMAIL PROTECTED] Delivery-date: Mon, 07 Jan 2002 13:24:17 +0100 Received: from [192.58.197.162] (helo=web.mysql.com) by mxng03.kundenserver.de with smtp (Exim 3.22 #2) id 16NYp5-0002jj-00 for [EMAIL PROTECTED]; Mon, 07 Jan 2002 13:24:15 +0100 Received: (qmail 2142 invoked by uid 7797); 7 Jan 2002 12:17: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 2128 invoked from network); 7 Jan 2002 12:17:40 - Message-ID: 00f101c19776$4ca52130$0e64a8c0@mmehta From: Manish Mehta [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Subject: auto_increment Date: Mon, 7 Jan 2002 17:54:48 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=x-user-defined Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-MDRemoteIP: 192.168.100.14 X-Return-Path: [EMAIL PROTECTED] X-MDaemon-Deliver-To: [EMAIL PROTECTED] Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Password reset.
I just installed mysql under my new linux system. I did a test command of ./mysqladmin -u root password new-password thus setting the root users password to new-password this appeared to work. I now want to change the root users password now that I have the syntax correct. I do a ./mysqladmin -u root -p password test1 this should set the password to test1 correct ? I get this error ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' can anyone explain why this is happening so that I can better understand how this command is working. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
Which is the **best, easy, compact** book available on MySQL. Delhi India. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
variable descriptions missing in the documentation
I would need those to finish the on-line help in my mystatus and myvars moodss modules for the 4.0.1 server. Please let me know if this is not the right place to post this. in SHOW STATUS: Com_ha_close Com_ha_open Com_ha_read Com_show_binlogs Qcache_queries_in_cache Qcache_inserts Qcache_hits Qcache_not_cached Qcache_free_memory Qcache_free_blocks Qcache_total_blocks Rpl_status in SHOW VARIABLES: have_gemini have_isam have_symlink log_long_queries low_priority_updates rpl_recovery_rank slave_net_timeout sql_mode transaction_isolation innodb_force_recovery innodb_thread_concurrency innodb_fast_shutdown I also take this opportunity to wish a very successful new year to the MySQL team. Best regards, -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C-API Query
Hello, I have corrected the code as I would have written it. Also are you sure the file mysql.h is where you think it is? #include stdio.h #include mysql/mysql.h main() { int sel; MYSQL mysql=NULL; MYSQL *connection; MYSQL_RES *result; mysql_init(mysql); if(mysql == NULL) { printf(\n MySQL unable to intialise\n); exit(-1); } connection=mysql_real_connect(mysql,23.22.2.2,user,pwd,db_name,0,NU LL,0); sel = mysql_query(connection, select e-no,ename from employee); printf(sel %d\n,sel); } John Lodge -Original Message- From: udayashankarl_n [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 11:51 AM To: [EMAIL PROTECTED] Subject: C-API Query Hi, I have written the following code using C-API and would like to retrieve the info from MYSQL. But it gives me error messages. Please let me know where iam going wrong. the code and error messages are : #include stdio.h #include mysql/mysql.h main() { int sel; MYSQL *mysql=NULL; mysql_init(mysql); if(mysql == NULL) { printf(\n MySQL unable to intialise\n); exit(-1); } mysql_real_connect(mysql,23.22.2.2,user,pwd,db_name,0,NULL,0); sel = mysql_query(mysql, select e-no,ename from employee); printf(sel %d\n,sel); } produces the following error messages. /tmp/ccPhnnJk.o: In function `main': /tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init' /tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect' /tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_query' collect2: ld returned 1 exit status Regards Uday - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Book
MySQL by Paul DuBois www.newriders.com ISBN 0-7357-0921-1 This book is easy to use. It gets it right when it commes to newuser V olduser. Its not that compact but it is to the pont. Simon PS you also helps on the list some times.. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 13:04 To: [EMAIL PROTECTED] Subject: MySQL Book Which is the **best, easy, compact** book available on MySQL. Delhi India. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql Gui connecting to remote server problem
Hi, my laptop is running windows 2000 and is called jaguar. I have mysql running on a linux server called jordan. when I fire up mysqlui and tell it to connec to jordan as root I get prompted for a password. I enter the password (that I have tested and is correct) and it say at the bottom of the gui Host 'jaguar.no-dns.co.uk' is not allowed to connect to this MySQL server how can I fix this. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
creating users ??? I must be blind.
Hi, the manual referes to creating users using mysqladmin and mysqlaccess, I have looked at these commands and cannot see how I can create mysql users. Am I missing something that is staring me in the face ? Thanks, Matt. (slowing getting the hang of what is going on now) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C-API Query
Hi, [..] produces the following error messages. /tmp/ccPhnnJk.o: In function `main': /tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init' /tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect' /tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_query' collect2: ld returned 1 exit status [..] I would think that the error message is from ld (the linker). So, it's not a fault in your code per se, but rather the arguments to the linker. Have you stated to include the mysql library? Using gcc it could be something like: -L/usr/local/lib/mysql -lmysqlclient. -- Aigars DISCLAIMER: Internet communications are not secure and therefore Defcom does not accept legal responsibility for the contents or accuracy of this message. The views and opinions contained in the message are solely those of the author and do not necessarily represent those of Defcom unless otherwise specifically stated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
MySql mSQL O'Reilly press isbn 1-56592-434-7 -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: MySQL Book Which is the **best, easy, compact** book available on MySQL. Delhi India. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: creating users ??? I must be blind.
look for 'GRANT SYNTAX' in the manual. Regards M -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 13:16 To: MySql List Subject: creating users ??? I must be blind. Hi, the manual referes to creating users using mysqladmin and mysqlaccess, I have looked at these commands and cannot see how I can create mysql users. Am I missing something that is staring me in the face ? Thanks, Matt. (slowing getting the hang of what is going on now) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Password reset.
Initially you will have had no password, so setting root's password to 'test1' would be done with: mysqladmin -u root password test1 To change this password to test2 use: mysqladmin -u root -ptest1 password test2 Regards M -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 12:59 To: [EMAIL PROTECTED] Subject: Password reset. I just installed mysql under my new linux system. I did a test command of ./mysqladmin -u root password new-password thus setting the root users password to new-password this appeared to work. I now want to change the root users password now that I have the syntax correct. I do a ./mysqladmin -u root -p password test1 this should set the password to test1 correct ? I get this error ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' can anyone explain why this is happening so that I can better understand how this command is working. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
hey folks!
I'm a newbie in DB administration. Could somebody tell me what do I need to start a web-based project for book listing, mail lists etc, all retrieved from a database updated by LAN users and listed on a web page? Thanks in advance! Viorel C - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TEMPORARY TABLES
I´ve just another question, I couldn´t get the info from the manual, I suppose that´s because I don´t know other basics on Mysql .. :-( I´ve been using the temporary table, and it works well, but, I can only display the results set just once in my script, is that normal? I´ve been trying to paginate the result but when I try to show the second page it seems to be empty. thanks in advance if there are too many simultaneous connections which create several temporary tables is it posible to knock down the server? thanks in advance No, server will not be knocked down by many tables opened, provided your OS has sufficient number of file descriptors to handle. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fulltext truncate
I've read the TODO list regarding the fulltext search and noticed that it doesn't include any more options for truncating. I'm in need of a database which supports pre-truncating - masking would be great too :) It would be great if my favourite database would get full pre-truncation :) Q: Will pre-truncation in fulltext queries be available later in MySQL 4.x? Regards/TheGad __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hey folks!
Me... I would use MySQL (as it if very fast, and never brakes) I also like PHP as it just fits in with MySQL so well! Simon -Original Message- From: Viorel C [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 23:52 To: [EMAIL PROTECTED] Subject: hey folks! I'm a newbie in DB administration. Could somebody tell me what do I need to start a web-based project for book listing, mail lists etc, all retrieved from a database updated by LAN users and listed on a web page? Thanks in advance! Viorel C - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
text mining under mysql
Dear All, I wonder whether one can use the full text indexes in mysql to find out what words in a document are likely to be relevant key words. I've several thousand text documents in a table with a full text index, and I can search for documents corresponding to some given keywords using the 'match against' functions. But what I'm realy looking for is that mysql tells me about the say the top 10 relevant keywords of each of the document satisfying some relevance cutoff. This should be possible because mysql knows about all words of all my documents which could be used to score the overall relevance of a word with repsect to all documents. So if a document 'X' about databases mentiones 'mysql' three times and the majority of all other documents does not contain the word 'mysql', the word 'mysql' is likely to have some relevance in document 'X'. I'd be nice to have a command like this: select keywords(10.0) from MyDocs where DocId = 666; '10.0' is some kind of relevance cutoff, and the output could someing like this: mysql fulltext database fast ... [ hm, don't know if it's a problem that function that works on a single column and row produces a multiple row output ... ] I'm happy for any suggestions on how to extract the ranked most relevant keywords per document using the existing functionality from mysql 4.0. Thanks for help, Arne -- Arne Mueller Biomolecular Modelling Laboratory Imperial Cancer Research Fund 44 Lincoln's Inn Fields London WC2A 3PX, U.K. phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 email : [EMAIL PROTECTED] | http://www.bmm.icnet.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: TEMPORARY TABLES
If you are using php, the function you want is mysql_data_seek($result,0) to reset the result set. John Lodge -Original Message- From: Walter D. Funk [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: TEMPORARY TABLES Ive just another question, I couldnt get the info from the manual, I suppose thats because I dont know other basics on Mysql .. :-( Ive been using the temporary table, and it works well, but, I can only display the results set just once in my script, is that normal? Ive been trying to paginate the result but when I try to show the second page it seems to be empty. thanks in advance if there are too many simultaneous connections which create several temporary tables is it posible to knock down the server? thanks in advance No, server will not be knocked down by many tables opened, provided your OS has sufficient number of file descriptors to handle. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hey folks!
-Original Message- From: Viorel C [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 23:52 To: [EMAIL PROTECTED] Subject: hey folks! I'm a newbie in DB administration. Could somebody tell me what do I need to start a web-based project for book listing, mail lists etc, all retrieved from a database updated by LAN users and listed on a web page? Hoo boy, tall order. First off, if you're totally new, go get a book on database design. There are several out there, I think the mysql page even has links to a few. Read, understand. Understand the concept of breaking tables apart - normalization. Once you have your database layout designed, pick a 'web enabled' language - such as PHP3, PHP4 or Perl. PHP and Perl both have 'native' access to MySQL databases - I personally like the Perl DBI because of its portableness. I can write code using the DBI, and it will work against different database engines simply by changing one line. Use a tool like mysqlfront or similar to toss some starting data into the database (or even use the mysql sql monitor). Write your code and test. Be sure to prepare any text that is going into the database so that 's and so on entered by the user get handled properly. Getting data out of the db will be the easy part. Designing the interface to put it in and search it will probably be harder. -- Sapere aude My mind not only wanders, it sometimes leaves completely. Never attribute to malice that which can be adequately explained by stupidity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
howto: Rebuild a FullText index
I have changed a fulltext variable ft_min_word_len from the default 4 to 1, and the manual says to rebuild my fulltext indexes once again. I verified that this variable changed with SHOW VARIABLES and it did change. I have tried optimize table, analyze table, repair table which all finished without errors and very quickly, but When I try a new simple query I can see that the index was not rebuilt. I search for the word '+the*' which shows up in about every record. I didn't get any records back earlier because my ft_min_word_len was too high. but I still do not get any records. Does anyone know what I am doing wrong? -- _ Jason Kushmaul, Software Engineer WirelessDeveloper.com Suite 200 2875 Northwind Drive East Lansing, MI 48823 [EMAIL PROTECTED] (517)337-2701 ext. 205 Become a Member Today!! http://www.WirelessDeveloper.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: Select with dbi perl??? Help please!
Sascha Kettner wrote: Hi! I have the following script to be executed via post from a web-form; the var. Pin, msisd and knd are given by the form but however, the script is not working. I always get no results as if there are no matches, but this isnt right! This is regardless which entries i submit with the form! Any ideas to fix the problem? Thanks a lot in advance Regards Sascha Kettner #!/usr/bin/perl use DBI(); # # Get form Data # # parse_form; # Script Variables # $input{knd} = ; $input{pin} = ; $input{msisdn} = ; # What to do on submit # dojob; ## # Lets have a look at the db # ## sub dojob { # Now retrieve data from the table. my $dbh = DBI-connect(DBI:mysql:database=prepaid;host=localhost, root, sascha28, {'RaiseError' = 1}); my $sth = $dbh-prepare(SELECT * FROM pins WHERE pin LIKE '$input{pin}' OR msisdn LIKE '$input{msisdn}' OR knd LIKE '$input{knd}'); print EOF; Content-type: text/html '$input(pin)' is a literal string. The single quote will prevent it from being evaluated. Use the $dhb-quote() function to quote and assign your variable to another, and then use that variable in your query without the single quotes. my $pin=$dbh-quote($input{pin}; my $sth = $dbh-prepare(SELECT * FROM pins WHERE pin LIKE $pin ... html !--# Include Virtual=/blank.html-- head titleMAKEPINS/title meta http-equiv=refresh content=10;url=https:/index.html /head body h1 align=centerSuche Ausgeführt/h1hrbrbr /body /html EOF $sth-execute(); while (my $ref = $sth-fetchrow_hashref()) { print Eintrag gefunden: pin = $ref-{'pin'}, msisdn = $ref-{'msisdn'}\n, knd = $ref-{'knd'}\n\n; } $sth-finish(); # Disconnect from the database. $dbh-disconnect(); exit; } ## # Get form data function # ## sub parse_form { read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'}); if (length($buffer) 5) { $buffer = $ENV{QUERY_STRING}; } @pairs = split(//, $buffer); foreach $pair (@pairs) { ($name, $value) = split(/=/, $pair); $value =~ tr/+/ /; $value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack(C, hex($1))/eg; $input{$name} = $value; } } ### # The end # ### - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Neede MySQL query Equivalent.
Hi, Could somebody please help me with the following. I want an equivalent for: select afield from atable where max(index) = index; I tried this, and that works, but it seems to me that there is a better (cleaner) way to accomplish the same. select afield from atable order by index desc limit1; regards, Erwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 set CD as autorun
This is not a MySQL question. You should take it to a Linux list. The answer, I think, is You don't. SankaraNarayanan Mahadevan wrote: Hi, I have developed an application in PHP/MySQL in Linux environment. I need to burn it in a CD and give it to the client. I need to do one thing - that is when the client insert that CD automatically my setup should run. How to do that...? what sort of coding i need to do ..? is it that i need to code in linux..? thanks... __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installing Static MySQLGUI on Solaris 7
Your question is too vague to answer. What operating system and hardware are you running. Which file did you download? What EXACTLY was the error message? EDA Peach wrote: Hi, Wondering if anyone might be able to help me with a slight problem. I downloaded the static version of the mysqlgui and I can't seem to get it working. I gunzip and try to execute and it complains that it can't find a library of some sort. I looked at the readme file in the source distribution and it says that I need to unpack it. Do I need a GNU version of unpack or should I be doing something? Please advise. Thanks. Regards, Eda __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql daemon monitoring
Hi Fred, You might want to look into www.netsaint.org . The mysql plugin is in the contrib directory, you can add functions like restart, althougth safe_mysqld should restart the daemon itself. best of luck, Ken - Original Message - From: Fred Taurus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 3:03 PM Subject: Mysql daemon monitoring Hello , I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface thanks in advance @+ Fred mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, C API
Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? If yes, look at the 'hostname'.err file and send its contents to me. Or, if you run mysqld from the command prompt, capture what mysqld prints to the command prompt window. If mysqld does not crash, then the problem is probably some client/server issue. Regards, Heikki ... Hello I am using MySql 3.23.47 on Linux (2.2.17-14smp) and InnoDB I do Intensive test (=Insert + Update + Select) using C API and running the processes on the same machine. Every thing work fine, BUT, some time to time I got some Lost connection to MySQL ... (errno = 2013) The query concerned is a small select (only 1 field) on a small table (6 fields) (the max_allowed_packet is set to 16M ) Has anybody encountred a similar problem ? Is there a relation with the net_read_timeout (set to 30) Thank you -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/CC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: facing problem with NOT NULL fields
I am inserting user details from a file. The file has users seperated by commas(,) example of file manjeet,tom,tim,,john,alexander Using perl script i am reading the file and seperating user info at commas and inserting into database. Now my problem is that i don't want to insert the fourth user which is blank. my table definitions are same as in previous mail. How should i avoid of not inserting data which is not defined in between commas. I can do that in script. Is there anyway of doing it database level. Also let me know how do you define NULL in strings. Thanks Manjeet -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 7:20 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: facing problem with NOT NULL fields Manjeet writes: I created table using following syntax, create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According to me this statement should give error and not work. But still it inserts null values in to the table. When the same insert statement is run again, it gives error 1062. Plz... suggest how to see that my table does not have any NULL value and should i acheive this. Or is this a bug. Thanks Manjeet This worked as expected. MySQL inserted the empty string in both columns. You can not insert it again as there is a primary key on one column. -- 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
root user: required to exist after initial setup?
Hi All, New to mySql. I've setup ok, running ok, read thru the privilege system docs. My question is about the user root: is it absolutely necessary to keep this user or is it ok to delete the root user (after setting up an equivalent super-user under another name)? Thanks, Jeff __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: root user: required to exist after initial setup?
Hi Jeff As long as you have a user that has access to all of MySQL and can enter from root on the systems, what you call it is not important. Infact it is a good thing to change the root user name for security. Simon -Original Message- From: Jeff Corliss [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:40 To: [EMAIL PROTECTED] Subject: root user: required to exist after initial setup? Hi All, New to mySql. I've setup ok, running ok, read thru the privilege system docs. My question is about the user root: is it absolutely necessary to keep this user or is it ok to delete the root user (after setting up an equivalent super-user under another name)? Thanks, Jeff __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: facing problem with NOT NULL fields
* Manjeet I am inserting user details from a file. The file has users seperated by commas(,) example of file manjeet,tom,tim,,john,alexander Using perl script i am reading the file and seperating user info at commas and inserting into database. Now my problem is that i don't want to insert the fourth user which is blank. Then don't... ;) my table definitions are same as in previous mail. How should i avoid of not inserting data which is not defined in between commas. I can do that in script. Yes, and you should. Is there anyway of doing it database level. No, I don't think so. (Some trickery with triggers could have been done, if only mysql supported triggers...) Also let me know how do you define NULL in strings. Not sure if I understand what you mean... to put NULL in a string field: update table set stringfield=NULL; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI
I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: variable descriptions missing in the documentation
Jean-Luc, for InnoDB variables look at section 2 of http://www.innodb.com/ibman.html Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB . I would need those to finish the on-line help in my mystatus and myvars moodss modules for the 4.0.1 server. Please let me know if this is not the right place to post this. in SHOW STATUS: Com_ha_close Com_ha_open Com_ha_read Com_show_binlogs Qcache_queries_in_cache Qcache_inserts Qcache_hits Qcache_not_cached Qcache_free_memory Qcache_free_blocks Qcache_total_blocks Rpl_status in SHOW VARIABLES: have_gemini have_isam have_symlink log_long_queries low_priority_updates rpl_recovery_rank slave_net_timeout sql_mode transaction_isolation innodb_force_recovery innodb_thread_concurrency innodb_fast_shutdown I also take this opportunity to wish a very successful new year to the MySQL team. Best regards, -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLgui fails
After a long day of trying and reading all sorts of manuals and faqs and newsgroups I still can't create tables with the mySQLgui (1.7.5.2 windows) running in win 2000 pro standalone feature I can read the test database (empty of course)and the users dbase in neither of them I'm able of creating new tables What am I doing wrong? tnx for helping this NB - - - Roel Van den Bergh - Interieurarchitect email: [EMAIL PROTECTED] http://www.planetinterior.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: MySQLGUI
I am having the same problem. My laptop jaguar is not allowed to connect to my server (jordan) I get jaguar is not allowed. I think it is something to do with granting user root from jaguar to root@jordan ??? I am trying to figure out what is going on ? If you read back I posted a couple of hours back this question. -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:42 To: MySQL Subject: MySQLGUI I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Audit - Log
Hi, I've installed MySql on a RedHat box and configured log-bin. Everything is running OK. My question is, if a user does any insert, delete or update, can I see which user (username) has performed that action? Where can I log this information and retrieve it later, for auditing purposes? Thanks Frederico 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: connect to two databases?
If you have rights to access other database then simply type databasename.table Bye I want to select from two databases at one time, like use forum select from users a, auth.users b where a.name = b.name The databases are running on the same mysql server. Do I have to make identical users / passwords for the databases, or can one script connect to two databases using different credentials? There will actually be a few scripts using different databases that all need to access that auth database Hi thanks, I do have the rights - I am talking about scripts, so the forum database would be accessed by a user myforum with pass forumsecret. Would I have to add access rights to the other database so that the same user myforum can access it, or is there a better way. I am sort of thinking about giving these scripts read-only access to the extra database (which is actually system authentification) and implementing a separate update job running on the database machine that would not be accessible from the outside in case one of the scripts needs to make changes Regards W. Hamann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Audit - Log
Yes you can.. We have a log called mysql.log that has user@IP/domain and then the question. All you need to do is edit my.cnf to make shore it is on. We keep all the logs can just gunzip them up.all you need is a perl script to get the data back out. Simon -Original Message- From: Frederico Martins [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 16:17 To: '[EMAIL PROTECTED]' Subject: Audit - Log Hi, I've installed MySql on a RedHat box and configured log-bin. Everything is running OK. My question is, if a user does any insert, delete or update, can I see which user (username) has performed that action? Where can I log this information and retrieve it later, for auditing purposes? Thanks Frederico 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
just got this through whats going on ???
I never sent a mail to unsubscribe ??? have I been booted from the list or what ?? Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] ql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 23497 invoked from network); 7 Jan 2002 16:10:53 - Received: from mhoro.cc.columbia.edu (@128.59.59.155) by www.mysql.com with SMTP; 7 Jan 2002 16:10:53 - Received: (from www@localhost) by mhoro.cc.columbia.edu (8.9.3/8.9.3) id LAA04140 for [EMAIL PROTECTED]; Mon, 7 Jan 2002 11:16:43 -0500 (EST) To: [EMAIL PROTECTED] Subject: unsubscribe please Message-ID: [EMAIL PROTECTED] Date: Mon, 07 Jan 2002 11:16:38 -0500 (EST) From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit User-Agent: IMP/PHP IMAP webmail program 2.2.0-pre13 X-Originating-IP: 168.108.118.24 unsubscribe please - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: text mining under mysql
On Mon, 7 Jan 2002, Arne Mueller wrote: I wonder whether one can use the full text indexes in mysql to find out what words in a document are likely to be relevant key words. . . . I'd be nice to have a command like this: select keywords(10.0) from MyDocs where DocId = 666; . . . Isn't function MATCH what you want? Example from the manual: mysql SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t; +--+---++ | a| b | x | +--+---++ | MySQL has now support| for full-text search | 0.3834 | | Full-text indexes| are called collections| 0.3834 | | Only MyISAM tables | support collections | 0.7668 | | Function MATCH ... AGAINST() | is used to do a search| 0 | | Full-text search in MySQL| implements vector space model | 0 | +--+---++ 5 rows in set (0.00 sec) The function MATCH matches a natural language query AGAINST a text collection (which is simply the columns that are covered by a FULLTEXT index). For every row in a table it returns relevance - a similarity measure between the text in that row (in the columns that are part of the collection) and the query. When it is used in a WHERE clause (see example above) the rows returned are automatically sorted with relevance decreasing. -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
You need to create a user with login privileges from any location. GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'apassword' WITH GRANT OPTION; AND, as is appended to each post, Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) AND, this answer was posted yesterday in response to an identical question, if you read back. hth, Doug if you read back, this answer was posted yesterday On Mon, 7 Jan 2002 16:01:27 -, Matthew Darcy wrote: I am having the same problem. My laptop jaguar is not allowed to connect to my server (jordan) I get jaguar is not allowed. I think it is something to do with granting user root from jaguar to root@jordan ??? I am trying to figure out what is going on ? If you read back I posted a couple of hours back this question. -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:42 To: MySQL Subject: MySQLGUI I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just got this through whats going on ???
The unsubscribe request came from [EMAIL PROTECTED] according to the headers. I'd bet this was an accident. The same thing happened to me a while back. If you'll look at the bottom of my reply, you'll notice that *my* unsubscribe info is included. (Usually, I cut that section out of my replies now.) I imagine someone wanted off the list but didn't look closely enough at the directions at the bottom of a message from you. Michael On Mon, 7 Jan 2002, Matthew Darcy wrote: I never sent a mail to unsubscribe ??? have I been booted from the list or what ?? CUT --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 23497 invoked from network); 7 Jan 2002 16:10:53 - Received: from mhoro.cc.columbia.edu (@128.59.59.155) by www.mysql.com with SMTP; 7 Jan 2002 16:10:53 - Received: (from www@localhost) by mhoro.cc.columbia.edu (8.9.3/8.9.3) id LAA04140 for [EMAIL PROTECTED]; Mon, 7 Jan 2002 11:16:43 -0500 (EST) To: [EMAIL PROTECTED] Subject: unsubscribe please Message-ID: [EMAIL PROTECTED] Date: Mon, 07 Jan 2002 11:16:38 -0500 (EST) From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit User-Agent: IMP/PHP IMAP webmail program 2.2.0-pre13 X-Originating-IP: 168.108.118.24 unsubscribe please - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
apologies, I don't have the space to keep all mails as this group puts out a 100+ messages a day I glance through them and if they are not relevant I delete them unless I know I'll need them in the future. -Original Message- From: Doug Thompson [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 16:31 To: [EMAIL PROTECTED]; MySQL; Vernon A Webb Subject: RE: MySQLGUI You need to create a user with login privileges from any location. GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'apassword' WITH GRANT OPTION; AND, as is appended to each post, Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) AND, this answer was posted yesterday in response to an identical question, if you read back. hth, Doug if you read back, this answer was posted yesterday On Mon, 7 Jan 2002 16:01:27 -, Matthew Darcy wrote: I am having the same problem. My laptop jaguar is not allowed to connect to my server (jordan) I get jaguar is not allowed. I think it is something to do with granting user root from jaguar to root@jordan ??? I am trying to figure out what is going on ? If you read back I posted a couple of hours back this question. -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:42 To: MySQL Subject: MySQLGUI I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db problem
I am running mysql on windows 98 could not get the mysql_install_db to work. Anyone familar with this problem or know a way around? I checked the folder 'scripts' but did not see mysql_install_db in there ??? thanks in advance = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
MySql mSQL O'Reilly press isbn 1-56592-434-7 is probably the worst book about mysql. Please note that the O'Reilly book was originally suppose to be about msql but near the end of the project they noticed that mysql was gaining popularity on msql so they threw in some information on mysql. Unfortunately it was too little, too late and didn't go through a proper review cycle. The second edition of the O'Reilly book is exclusively mysql and O'Reilly has acknowledged the problems with the first book. The 2nd edition should be out sometime soon with a new title. The best reference book on MySQL is still MySQL by Paul Dubois. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection problem
Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Errors with version 3.22.23b-log
My ISP has version 3.22.23b-log installed on my hosting service machine, and I have repeatedly encountered problems importing tables to the database that have indexes that are not given a default value or that are not specifically stated to be NOT NULL. Others using the same programs have said they have no problem importing those same tables to their databases, so I'm wondering if it has to do with something that the hosting service has configured improperly or what. I'd appreciate any help to get this resolved. Thanks. RW Wood = Visit Greater Grace in Argentina - http://www.every-nation.com/Argentina/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dummie question
Hello list, The problem: I have two mysql-servers A and B with the same Database DB. Sometimes, I would like to make a snapshot of DB from A and then synchronize DB on B with this snapshot. OK, logical dump on A, destroy DB on B and import would work, but this ain't elegant, or? Is there a better way? Can I manage to keep DB on B running while importing, but also to be sure, that the synchronization is exact? Greetings -- Jochen Witte [EMAIL PROTECTED] PGP fingerprint = 2F92 97EA BB67 E49A EE79 AD55 2FE7 DF05 EA9A 3A32 Keyserver = www.keyserver.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection problem
No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Random Select Statement??
I'm trying to create a select statement that will go into a table find the number of rows in the table then select a single random row and return it. I am using Java/mySQL with the mm.mysql JDBC drivers. I've been playing around with the following statement but it doesn't seem to like the MAX(user_id) in the middle of it. Can anyone advise me on the correct way to execute this? Thanks in advance! SELECT ROUND((MAX(user_id)-1)*RAND()+1) from people; David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Mysql connection problem
Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Neede MySQL query Equivalent.
Hi Erwin Try Select afield from atable where index=(select max(index) from atable); []s Paulo Botelho - Original Message - From: Erwin Hogeweg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 07, 2002 12:47 PM Subject: Neede MySQL query Equivalent. Hi, Could somebody please help me with the following. I want an equivalent for: select afield from atable where max(index) = index; I tried this, and that works, but it seems to me that there is a better (cleaner) way to accomplish the same. select afield from atable order by index desc limit1; regards, Erwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Merge problem !
I am using mysql 3.23.39 on Linux Redhat 7.1... I use the following queries, CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); INSERT INTO t1 (message) VALUES (Testing),(table),(t1); INSERT INTO t2 (message) VALUES (Testing),(table),(t2); CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a)) TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST; It gives an error, SQL suntax error at INSERT_METHOD=LAST. when I remove the INSERT_METHOD=LAST property, it works fine...Is it that this property is not supported in 3.23.39 ??? Is there any work around... Waiting for ur reply !! __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db problem
Have you verified that the mysql internal data bases don't exist? If you are running a Win binary, they should already exist. I don't even think mysql_install_db is part of the Win dist. It is a shell script used in UNIX installations. ~rob Sent: Monday, January 07, 2002 11:38 AM To: [EMAIL PROTECTED] Subject: mysql_install_db problem I am running mysql on windows 98 could not get the mysql_install_db to work. Anyone familar with this problem or know a way around? I checked the folder 'scripts' but did not see mysql_install_db in there ??? thanks in advance = Regards, Investorclb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: root user: required to exist after initial setup?
--- Simon Green [EMAIL PROTECTED] wrote: Hi Jeff As long as you have a user that has access to all of MySQL and can enter from root on the systems, what you call it is not important. Infact it is a good thing to change the root user name for security. Simon Thanks for the response - the extra security was exactly what I had in mind. :) __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. I found that MySQL by Michael Kofler (Apress, ISBN 1-893115-57-7) was a rather good and informative book. Cheers, Markus -- Markus Lervik UNIX-administrator with a kungfoo grip Vaasa City Library - Regional Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie needs serious help!
I'm running RedHat Linux 7.0 (2.2.16-22) with MySQL 3.23.32... It's been working perfectly until suddenly this morning at 1:40AM it stopped responding. I restarted the whole system, and still nothing. It says Running with the PIDs when I do a mysqld status and when I do a mysqld start it returns OK. However, when I try to go to a PHP page using MySQL, it times out. If I do a mysqld stop, the program seems to freeze (and can, apparently, only be cured by a kill -9). I tried using a -log and got the .err with only: ~ ./mysqld, Version: 3.23.32-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument ~ If anyone has ANY ideas of what to try, or if I need to supply more information, or if I need to ask somewhere else, please let me know! Many thanks, -Mike Cermak HelpOnThe.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Got error 127 when reading table
Hi, I have another example of this strange behaviour. I've managed to dump most of the table and then after certain row got the error 127. This machine is linux 2.2.17 in this particular example operating on table close to the 2GB limit. mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) I'm running following command: From my copy script I got: /usr/local/mysql/bin/mysqldump: Error 1030: Got error 127 from table handler when dumping table 'intragenome_data' at row: 5585 When checking the table on the target host, where I thought would be empty table, it appeared that the table in fine and contains first 5585 rows and contains data as expected. mysql describe intragenome_data; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | id | int(11) | | PRI | 0 | | | contig_data_id | int(11) | | MUL | 0 | | | contig_data_code | varchar(100) | | MUL | | | | code | varchar(100) | | MUL | | | | descr| varchar(255) | YES | MUL | NULL| | | dat | longtext | YES | | NULL| | | created | varchar(100) | | | | | +--+--+--+-+-+---+ 7 rows in set (0.02 sec) mysql Then I checked the table on source host (from which I got the sql dump data) the logfile and table itself: 011209 05:48:19 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 011210 14:47:02 Warning: Found 24646 of 0 rows when repairing './Burkholderia_pseudomallei_K96243/known3d_data' 011211 13:09:28 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:09:59 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:27 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:32 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:32 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:32 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data 011211 13:15:43 read_const: Got error 127 when reading table ./Listeria_monocytogenes_EGD/orf_data 011211 13:16:03 read_const: Got error 127 when reading table ./Listeria_monocytogenes_EGD/orf_data 011213 11:37:32 read_const: Got error 127 when reading table ./Saccharomyces_cerevisiae/funcat_data 011213 11:41:40 read_const: Got error 127 when reading table ./Saccharomyces_cerevisiae/funcat_data 011213 19:14:13 read_const: Got error 127 when reading table ./Agrobacterium_tumefaciens_C58_pAT/blast_data 011213 19:23:21 read_const: Got error 127 when reading table ./Agrobacterium_tumefaciens_C58_pAT/blast_data 011219 16:47:28 read_const: Got error 127 when reading table ./Spombe/blast_data 020102 19:50:28 read_const: Got error 127 when reading table ./Pasteurella_multocida_PM70/blast_data 020103 15:32:09 read_const: Got error 127 when reading table ./Agrobacterium_tumefaciens_C58_pAT/funcat_data 020104 16:39:01 Warning: Found 5585 of 5586 rows when repairing './Arabidopsis_thaliana/intragenome_data' ---^ yes, I already had this problems with this table 2 days ago and ran REPAIR on it. No-one should modify the table, no-one should even run myisampack/myisamchk/flush-tables commands, so this time I'm rather sure only mysqld is involved. 020107 12:12:33 read_const: Got error 127 when reading table ./Arabidopsis_thaliana/intragenome_data kulan$ mysql Arabidopsis_thaliana Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 97806 to server version: 3.23.44-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql check table intragenome_data; +---+---+--+---+ | Table | Op| Msg_type | Msg_text || +---+---+--+---+ | Arabidopsis_thaliana.intragenome_data | check | warning | Table is marked as |crashed| | Arabidopsis_thaliana.intragenome_data | check | error| Size of datafile is: |2147483647 Should be: 2152589024 | | Arabidopsis_thaliana.intragenome_data | check | error| Corrupt || +---+---+--+---+ 3 rows in
RE: Newbie needs serious help!
try restarting port mapper on the linux box. also make sure swap is not almost used as sockets uses tmp to swap out tcp requests. -Original Message- From: Michael J. Cermak, Jr. [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 19:36 To: [EMAIL PROTECTED] Subject: Newbie needs serious help! I'm running RedHat Linux 7.0 (2.2.16-22) with MySQL 3.23.32... It's been working perfectly until suddenly this morning at 1:40AM it stopped responding. I restarted the whole system, and still nothing. It says Running with the PIDs when I do a mysqld status and when I do a mysqld start it returns OK. However, when I try to go to a PHP page using MySQL, it times out. If I do a mysqld stop, the program seems to freeze (and can, apparently, only be cured by a kill -9). I tried using a -log and got the .err with only: ~ ./mysqld, Version: 3.23.32-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument ~ If anyone has ANY ideas of what to try, or if I need to supply more information, or if I need to ask somewhere else, please let me know! Many thanks, -Mike Cermak HelpOnThe.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Count() does not count correctly?
Hello MySQL-users ! Houston, I've got a problem here. I'm running the following query from a PHP-Script: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM years LEFT JOIN games ON years.year = games.release_year GROUP BY years.year ORDER BY gamecount DESC, yearlist This query should do the following: Every year from years.year should be returned along with the number of games that have been released in that year sorted by the gamecount. years.year and games.release_year both do NOT contain NULL. The problem is the following: Years in which no games were released are returned with a gamecount of 1. Why that??? All other years with games released in it are getting the correct gamecount. Please help me. Greetings from Germany, Jens Mildner. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count() does not count correctly?
Jens, You need to select on the games on the left, to ensure that you don't end up with years on the left with no corresponding game records. Try this: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM games LEFT JOIN years ON games.release_year = years.year GROUP BY years.year ORDER BY gamecount DESC, yearlist Or just simply SELECT release_year AS yearlist, count(release_year) AS gamecount FROM games GROUP BY release_year ORDER BY gamecount DESC, yearlist (Not tested here, sorry ...) Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Jens Mildner [mailto:[EMAIL PROTECTED]] Sent: Monday, 07 January, 2002 15:08 To: [EMAIL PROTECTED] Subject: Count() does not count correctly? Hello MySQL-users ! Houston, I've got a problem here. I'm running the following query from a PHP-Script: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM years LEFT JOIN games ON years.year = games.release_year GROUP BY years.year ORDER BY gamecount DESC, yearlist This query should do the following: Every year from years.year should be returned along with the number of games that have been released in that year sorted by the gamecount. years.year and games.release_year both do NOT contain NULL. The problem is the following: Years in which no games were released are returned with a gamecount of 1. Why that??? All other years with games released in it are getting the correct gamecount. Please help me. Greetings from Germany, Jens Mildner. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count() does not count correctly?
Jens Mildner wrote: Hello MySQL-users ! Houston, I've got a problem here. I'm running the following query from a PHP-Script: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM years LEFT JOIN games ON years.year = games.release_year GROUP BY years.year ORDER BY gamecount DESC, yearlist This query should do the following: Every year from years.year should be returned along with the number of games that have been released in that year sorted by the gamecount. years.year and games.release_year both do NOT contain NULL. The problem is the following: Years in which no games were released are returned with a gamecount of 1. Why that??? All other years with games released in it are getting the correct gamecount. Please help me. Greetings from Germany, Jens Mildner. Either don't use a left join, or add WHERE games.release_year IS NOT NULL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count() does not count correctly?
From: Jens Mildner [EMAIL PROTECTED] Every year from years.year should be returned along with the number of games that have been released in that year... Years in which no games were released are returned with a gamecount of 1. This is a side effect of the JOIN syntax. Try this: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM years, games WHERE years.year = games.release_year GROUP BY years.year ORDER BY gamecount DESC, yearlist --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hey folks!
On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote: I'm a newbie in DB administration. Could somebody tell me what do I need to start a web-based project for book listing, mail lists etc, all retrieved from a database updated by LAN users and listed on a web page? Go for www.freshmeat.net, and look for pre-built stuff. Telling you 'what you need', with no information, is an excercise in futility... Good luck. Thanks in advance! Viorel C -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLd Crash
Hi, Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused mysqld to reset. This is while using 3.23.40 on Solaris 2.6 What additional information should I provide to help address this problem? From: Quentin Bennett To: [EMAIL PROTECTED] Subject: [Mysql crash] Description: Crash with full /tmp How-To-Repeat: Fill up /tmp and allow mysqld to continue running Fix: Don't fill up /tmp Submitter-Id: submitter ID Originator:Mercury Admin Organization: Infinity Solutions MySQL support: [none at the moment Synopsis: mysqld crash on full /tmp Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-solaris2.6 on i386 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.40-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 min 51 sec Threads: 29 Questions: 5332 Slow queries: 1 Opens: 42 Flush tables: 1 Open tables: 36 Queries per second avg: 10.041 Environment: machine, os, target, libraries (multiple lines) System: SunOS AKLDB 5.8 Generic_108529-03 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLd Crash
Try the -q option to mysqldump so it doesn't buffer up the whole thing. Quentin Bennett wrote: Hi, Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused mysqld to reset. This is while using 3.23.40 on Solaris 2.6 What additional information should I provide to help address this problem? From: Quentin Bennett To: [EMAIL PROTECTED] Subject: [Mysql crash] Description: Crash with full /tmp How-To-Repeat: Fill up /tmp and allow mysqld to continue running Fix: Don't fill up /tmp Submitter-Id:submitter ID Originator: Mercury Admin Organization: Infinity Solutions MySQL support: [none at the moment Synopsis:mysqld crash on full /tmp Severity:critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-solaris2.6 on i386 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 version3.23.40-log Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 min 51 sec Threads: 29 Questions: 5332 Slow queries: 1 Opens: 42 Flush tables: 1 Open tables: 36 Queries per second avg: 10.041 Environment: machine, os, target, libraries (multiple lines) System: SunOS AKLDB 5.8 Generic_108529-03 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /lib/libc.so - ../libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /usr/lib/libc.so - ../libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
money datatype
I'm porting a MS-SQL system to a Solaris machine running Mysql. In the MS-SQL there is a datatype of money what would be the proper datatype in mysql to use as a replacement for this? Keith - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Make fails building innodb - btr_search_check_guess
Hi! Please upgrade to 3.23.47. Many bugs have been fixed since .41. This is a bug in gcc-2.95.3, at least in some builds of the compiler. Fix: edit mysql/innobase/btr/btr0sea.c and replace UNIV_INLINE about on line 455 (in MySQL-3.23.47) of the file by static Or download a ready binary from www.mysql.com Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ... Description: Make failed with the following errors: gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-i mplicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../innobase/usr/libusr.a ../innobase/odbc/libodbc.a ../innobase/srv/libsrv.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval .a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/libut.a -lrt ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../innobase/btr/libbtr.a(btr0sea.o): In function `btr_search_guess_on_hash': btr0sea.o(.text+0x173a): undefined reference to `btr_search_check_guess' collect2: ld returned 1 exit statusmake[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-3.23.47/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.47/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.47' make: *** [all-recursive-am] Error 2 Configure command used: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla gs=-all-static --with-innodb --with-raid --localstatedir=/array/mysql/var Remmoving config.cache and running make clean, then rerunning above ./configure without --with-innodb results in a succesful make. How-To-Repeat: Busts every make when --with-innodb usedFix: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto_Increment and the DELETE Statement
I don't know if this is a bug or a feature. Just an observation concerning creating MYISAM tables with auto_increment. CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000; INSERT INTO mytable VALUES(NULL); INSERT INTO mytable VALUES(NULL); these above INSERTS create entries as expected: myval=9000, myval=9001 DELETE FROM mytable; INSERT INTO mytable VALUES(NULL); this INSERT creates myval=1, instead of the 9000 or 9002 that I would expect. However: CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000; INSERT INTO mytable VALUES(NULL); INSERT INTO mytable VALUES(NULL); DELETE FROM mytable WHERE myval0; INSERT INTO mytable VALUES(NULL); this INSERT creates an entry in the table: myval=9001, which is preferred. Question: upon deleting all entries from a table with DELETE FROM mytable, should the next auto_incremented value be 1 or the initial auto_increment value specified in the CREATE statement (in this case 9000)? 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
RE: auto_increment
You can also set the auto_increment start value in the CREATE table: CREATE TABLE mytable ( myval int auto_increment) AUTO_INCREMENT=100; Note that the AUTO_INCREMENT=100 is set outside of the fields' definitions. However, when you delete all records with DELETE FROM mytable, the counter will be reset to 1. So that INSERT INTO mystable VALUES(NULL) will cause myval to be initialized to 1, instead of 100. If you DELETE FROM mytable WHERE myval0 which should delete all records, and you insert with INSERT INTO mystable VALUES(NULL), then myval will be set to 100. -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:25 AM To: mysql Subject: auto_increment Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ORDBMS concepts with MYSQL...
Hi, I'm starting a reporting application project and I want to use mysql as the backend to store the data... The only problem is my data I'm grabbing the information off a message bus and each object has an undefined number of field=value pairs... does anyone know of documentation or websites that give useful examples or tips on best practices regarding how to design you mySQL tables to handle this sort of requirements I guess it's ORDBMS concepts but I'm wondering if anyone has seen examples specifically implemented on mySQL Thanks, Ray Jenkins Technical Architect Riversoft Inc. 678-852-8873 www.riversoft.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