Re: MySQL question
Have a look at what the error logs say. If that doesn't help, post the command used and error messages/logs (if relevant) to the list. - Original Message - From: MIKE TURNER [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 2:05 Subject: MySQL question I have just installed MySql and when I tried to set the root password and it gives me an error(I don't recall the exact text) but I looked and the daemon isn't running. I tried starting it but still nothing? Did I miss a step? Sorry if this ends up to be a stupid mistake. Hope you can help me. Mike ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help connection erroe
Try connecting to 'localhost' instead unless your web server is different from your mysql server in which case, you'll need to give root permission to connect from 209.198.250.5. If not, try posting some code to the list. It'll make it easier for us to solve your problem. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 16, 2001 15:53 Subject: help connection erroe When am trying to connect to mysql am getting this error Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /var/www/html/accounts/include/useradmin.php on line 144 Unable to select database What is the problem, Please do assist thanks Regards Martin W. Kuria Web Programmer Bsc. Computer Science Kenyaweb.com Ltd www.kenyaweb.com mail.kenyaweb.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I am facing this error [ Urgent ]
This is a very common problem. It is documented in the manual and also in other places as Edna has already mentioned. Your php code has nothing to do with the cause of the problem. Basics: 1. Your server isn't running 2. Your paths to the socket file are incorrect. (Check php and mysql settings) 3. Permissions are incorrect. - Original Message - From: Syed Sumair [EMAIL PROTECTED] To: Edna Walton [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 13, 2001 1:51 Subject: Re: I am facing this error [ Urgent ] Thanks for your replies but my problem is still there this is the php code iam using for connecting to Database: $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); and hosting infos are: Red hat linux mysql-3.23 php 4 From the error message, I'd guess you are using RedHat distribution. If not, ignore this. You must make sure that the directory /var/lib/mysql is owned by mysql and not root, so that mysql can write to it. Also see all the added comments in the relevant subsections of the online manual (link is added to all posts at the end). They are constantly being added to. Hope this helps. Edna At 19:12 11/07/01 -0700, you wrote: What to do do I am facing this error !! Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT INTO ... SET ...
Hi all, A week ago or so, someone on this list had a problem with inserting data. I thought the reason was because they had mixed up the INSERT and UPDATE statements. ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ... However, they said this statement works from the MySQL prompt. I have just found time to try this syntax today and I was amazed to find that it does work in MySQL though it didn't work for Access. In all the years I have worked/studied SQL, not once have I come across the INSERT INTO ... SET ... syntax. My questions are: 1. Is this a valid statement? 2. Is it ANSI standard? 3. Is this a MySQL feature / bug or do other DBs support this? 4. If it is valid, where is it documented? All the SQL books that I've ever come across, do not contain such a syntax. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT INTO ... SET ...
Ok, I must have been blind or something. However the question still remains. Is this an added feature of MySQL and is not part of ANSI standard? I guess it is because I've never come across it before. I have tried searching the manual again on this, especially Ch 5 but found nothing. This is where I would expect it to be mentioned. Also the same goes with this statement INSERT INTO yourtable VALUES (1, 2), (5, 5); I believe this is also not part of ANSI standard! Am I correct? Thanks Hi, From the manual: The col_name=expression syntax is supported in MySQL Version 3.22.10 or later. Section 7.21 INSERT Syntax http://www.mysql.com/doc/I/N/INSERT.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:56 AM To: [EMAIL PROTECTED] Subject: INSERT INTO ... SET ... Hi all, A week ago or so, someone on this list had a problem with inserting data. I thought the reason was because they had mixed up the INSERT and UPDATE statements. ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ... However, they said this statement works from the MySQL prompt. I have just found time to try this syntax today and I was amazed to find that it does work in MySQL though it didn't work for Access. In all the years I have worked/studied SQL, not once have I come across the INSERT INTO ... SET ... syntax. My questions are: 1. Is this a valid statement? 2. Is it ANSI standard? 3. Is this a MySQL feature / bug or do other DBs support this? 4. If it is valid, where is it documented? All the SQL books that I've ever come across, do not contain such a syntax. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help Requested
This is a very common problem and can be found in the archives of this list as well as the mysql documentation. - Original Message - From: Robert Sochor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 14, 2001 2:42 Subject: Help Requested Dear XYZ I am running bsdi 4.2 commercial. My problem is as follows: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any help is greatly appreciated -- Rob Sochor IS Manager [EMAIL PROTECTED] Ie Solutions - RAPS The Recruiting and Applicant Processing System Visit a list of sites powered by the RAPS system: http://www.RAPSystem.com/demo/clients.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: simpify chinese and traditional chinese
Yes, Chinese characters isn't much of a problem. They will be stored in ASCII format unless you are using a Chinese system for your server, which should then display it as Chinese characters. Sorting isn't too much of a problem as long as sorting is done in ASCII order. I have done it this way and so far I have had no word back from the users about there are problems in sorting. I haven't had the need as yet, but I expect text searches would need to use LIKE. Some things to be aware of: 1. If you are using an English OS for the server, you will definitely need a UI running on a Chinese OS in order to insert Chinese characters. 2. Web pages: The correct character set needs to be defined. eg. Big5. You should then end up with ASCII garbage (English OS server) not something like #10346. A number like this is incorrect and will result in other problems in the future. 3. MS programming languages: Be aware that these may deal with Unicode and MySQL isn't quite ready for that. Even then, MS languages may pass it to the database as something other than Unicode. I know this for a fact with VB6. A Chinese character is stored as Unicode in a variable and when it is passed to ODBC, it is passed as a 2 byte Big5. If you get a 2 byte character like '@, $\ or ^ then you will be in trouble. First 2 are easy. Add a \ to the front (ie. \'@) or to the end (ie. $\\). 3rd one is not that easy as you will have ^\. Two characters will need to be converted back to Unicode before being passed but it is most likely that neither ^\ or \ will map correctly. So far, I have only come across the first 2 situations. I have yet to experience simplified in conjunction with traditional Chinese but I'll find out in a month or so. - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: Mark Lo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 14:30 Subject: Re: simpify chinese and traditional chinese Mark Lo wrote: Hi, Is it possible for mysql to store simpify and tranditional chinese. Yes, storing is not problem at all. MySQL can store any data without loss in binary fields. Problem is on sorting, upper-lower conversions and fulltext search. We do not have any chinese sorting as much I know, there is no such things like upper and lower case charactes in chinese languages and fulltext search doesn't work as chinese languages do not use spaces nor any other separator between words :( I am sitting here in Hong Kong and one of my targets is to get MySQL support both traditional and simplified chinese but as far I can see there is a huge technical problems. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me with select query
Best I can come up with is something like 2 words: SELECT c1.id FROM crossref c1, crossref c2 WHERE c1.word='word1' AND c2.word='word2' AND c1.id=c2.id 3 words: SELECT c1.id FROM crossref c1, crossref c2, crossref c3 WHERE c1.word='word1' AND c2.word='word2' AND c3.word='word3' AND c1.id=c2.id AND c1.id=c3.id - Original Message - From: Jaime Teng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 13:03 Subject: help me with select query Hi, I have a table: mysql describe crossref; +---+--+--+-+ | Field | Type | Null | Key | +---+--+--+-+ | word | char(15) | | MUL | | id| int(10) unsigned | | MUL | +---+--+--+-+ +---+--+ | word | id | +---+--+ | tintin| 1604 | | registers | 1604 | | 9207844 | 1604 | | superman | 1621 | | registers | 1621 | | 4479462 | 1621 | | angelo| 1622 | | registers | 1622 | | 6330586 | 1622 | | pforshag | 1662 | | registers | 1662 | | 6344168 | 1662 | | tintin| 1689 | | authenticates | 1689 | +---+--+ How do I combine these: SELECT id FROM crossref WHERE word = 'word1'; SELECT id FROM crossref WHERE word = 'word2'; SELECT id FROM crossref WHERE word = 'word3'; such that I get the intersection of each sets? SELECT id FROM crossref WHERE word = 'word1' or word = 'word2' or word = 'word3'; is not correct because this will list down as well other numbers that does not contain all three words. example: search tintin result = 1604, 1689 search registers result = 1604, 1621, 1622, 1662 search registers, tintin result = 1604 thanks jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Root Login Problem
[root@mail mysql]# mysqladmin -password FalsePass This is not as per documentation. Documentation says --password. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 0:26 Subject: Re: Root Login Problem Neil Barnes [EMAIL PROTECTED]To: [EMAIL PROTECTED] et cc: Subject: Root Login Problem 11.07.01 17:11 Hi everyone. Please see below, I cannot login as the root user in MySQL. Access-Denied ... any ideas anyone? My System = RedHat Linux 7.0 (all latest patches applied) Intel Pentium III MySQL rpm's installed = MySQL-3.23.39-1.i386.rpm MySQL-client-3.23.39-1.i386.rpm MySQL-shared-3.23.39-1.i386.rpm Installed OK no problem. I ran mysql_install_db no problem. Now try to install new root password...as per documentation [root@mail mysql]# mysqladmin -password FalsePass mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Hi Neil, I have the same issue on a completely different OS to yours, WinNT Server 4, using MySQLGUI (or the bare mysql console). Well I can connect as a testuser (eg 'andreas') but there's no way to get in as root. But it's odd that both of us have the problem even though we use completely different OSes. This seems to be a _general_ problem, I guess. Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not incrementing
In what way doesn't it work? Works fine for me. - Original Message - From: Mike Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 5:18 Subject: auto_increment not incrementing Hello, When I submit data it will not submit data into the database unless I put some kind of number in the ID field. This is not supose to be. Here is what my schema looks like. CREATE TABLE Parts( PartNumber INT(6) NOT NULL, QtyOnHand INT(2) NOT NULL, QtyOnOrder INT(2) NOT NULL, DateNextQtyComplete VARCHAR(10) NOT NULL, StatusQtyWorked VARCHAR(10) NOT NULL, ID INT(5) NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID) ); Does anyone know why the auto_increment doesn't work? I'm using mysql Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686 Thanks you --Mike __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root Login Problem
Sorry, I made a mistake it's password not --password ie. [root@mail mysql]# mysqladmin password FalsePass not [root@mail mysql]# mysqladmin -password FalsePass - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 8:48 Subject: Re: Root Login Problem [root@mail mysql]# mysqladmin -password FalsePass This is not as per documentation. Documentation says --password. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 0:26 Subject: Re: Root Login Problem Neil Barnes [EMAIL PROTECTED]To: [EMAIL PROTECTED] et cc: Subject: Root Login Problem 11.07.01 17:11 Hi everyone. Please see below, I cannot login as the root user in MySQL. Access-Denied ... any ideas anyone? My System = RedHat Linux 7.0 (all latest patches applied) Intel Pentium III MySQL rpm's installed = MySQL-3.23.39-1.i386.rpm MySQL-client-3.23.39-1.i386.rpm MySQL-shared-3.23.39-1.i386.rpm Installed OK no problem. I ran mysql_install_db no problem. Now try to install new root password...as per documentation [root@mail mysql]# mysqladmin -password FalsePass mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Hi Neil, I have the same issue on a completely different OS to yours, WinNT Server 4, using MySQLGUI (or the bare mysql console). Well I can connect as a testuser (eg 'andreas') but there's no way to get in as root. But it's odd that both of us have the problem even though we use completely different OSes. This seems to be a _general_ problem, I guess. Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-3.23.35
If you do ps -ef | grep mysql, I think you'll find that the server is already running. - Original Message - From: Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 8:03 Subject: mysql-3.23.35 Hi, I have just installed mysql-3.23.35 on a linux - mandrake 7.2 box. When I try to run it in usr/bin/safe_mysql I get a mysql process already exist. Please tell me why this is. I would Appreciate feed back as soon as possible. MIKE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP!!!!! How to set root password?
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 7:20 Subject: HELP! How to set root password? I've been reading the documentation for the last 3 hours in search for the answer to this question, to no avail. To preserve the little eyesight I have left, I've decided to post it. I've been trying to install mysql-max-3.23.39 on a Linux system (pc-linux-gnu-i686). The daemon runs fine, but how does one *set* the password for root after a fresh installation? The only information I've been able to find is: 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 my.machine.com -p password 'new-password' from the output of mysql_install_db. What does it mean? The usage info for mysqladmin says: -p, --password[=...] Password to use when connecting to server If password is not given it's asked from the tty Does that mean that the word 'password' in ./bin/mysqladmin -u root -p password 'new-password' represents the initial root password? No it isn't. It is a little misleading at first but if you use a password on the command line (not a good idea BTW), then there is no space. eg ./bin/mysqladmin -u root -pA_PASSWORD password 'new-password' But -p is not needed because it is a new installation. Isn't root supposed to start out with no password? YES. see above. And what does 'new-password' refer to? The root password. And, yes, don't put it in quotes. Anyway, if I ignore the fact that it's nonsensical, and I type the above I get: # ./bin/mysqladmin -u root -p password 'new-password' Enter password: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' What is going on? Thanks, KJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need your helps!!!
No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: saving in mysql
This is more like what we want to see and pointing us to which line causes
the error would help even more. But from this, you're mixing up your INSERT
and UPDATE statements for starters. What you have would be correct if you
replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited list
of values enclosed by brackets. Please RTFM.
- Original Message -
From: "Stink" [EMAIL PROTECTED]
To: "Werner Stuerenburg" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 19:31
Subject: Re: Re[4]: saving in mysql
What do you send to MySQL? $query is just a string.
well i send to you only a part of code, here is complete example of it:
[the login stuff]
$zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul',
przemd='$przemd',
przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat',
data='$data', lead='$lead', tresc1='$tresc1', tresc2='$tresc2',
tresc3='$tresc3', tresc4='$tresc4', tresc5='$tresc5', autor='$autor',
dzial='$dzial', standart='$jest'";
$wynik = mysql_query($zapytanie);
if($wynik) echo "centerbArtyku| dodany prawid|owo!/bbr
/center";
else {
echo "centerB|_d przy dodawaniu artyku|u - sprbuj jeszcze
raz.br/center";
}
the data is coming from a form...
MySQL pops out a error message - "unable to save result set in
example.php
on line xxx"
but the data gets put inside the database anyway...
Why should php try to save something into a file? You must tell
it to do so. And if you do, you have bad luck. php runs as
nobody, and nobody should not be able to write to files.
but i do NOT write anything into a file...
the comes from the form and is saved in the database as in the code above.
i do not use any files here...
i must mention that it must be something with system i think. the server
was
run on linux red hat 7, but a week ago it was moved because the firm moved
.
and then it was reinstalled also, admin installed debian instead of red
hat
[i don't know what for anyway, but admin is always admin ;)]. and before
[when red hat was on] there was no such problem, and all scripts ran well
without this error messages. now - i dont know , maybe php is configured
badly ? have no idea...
The problem is not with MySQL, as is obvious.
i think so
You should look for line xxx. Here you will try to write to the
file, which cannot work unless you define the rights accordingly.
You may chmod the rights on the file you want to write to or put
that file into a directory open for nobody.
as i said, i do not use any file...
--
Herzlich
Werner Stuerenburg
stink
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Need your helps!!!
Yes, looks like you're right, which means that the Introduction and Overview chapters of Replication need to be reviewed as it gives the impression that it can't be done. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Rolf Hopkins' [EMAIL PROTECTED]; Simon Green [EMAIL PROTECTED]; 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 18:36 Subject: RE: Need your helps!!! It can be done but there are a lot of problems with keeping the data in both or more data bases in line with each other. But this should be part of the V4 release. Simon -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 11:34 To: Simon Green; 'chen jun'; [EMAIL PROTECTED] Subject: Re: Need your helps!!! No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql problem
Changing your IP address shouldn't affect your MySQL access in that way. I would say you have done something else to cause those errors. You can look at skip grants in the manual. From what you have written, your web pages are accessing the DB as root. That spells D A N G E R. You should create another user with less access. - Original Message - From: Kevin Robertson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:43 Subject: mysql problem I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have access to the databases. I think i have lost access as root. Is there a way to restore the root user password and/or change it to something else manually? I have many websites with many 'access denied' errors. Any help would be appreciated. Thanks, Kevin Robertson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP and Mysql
Well, it's difficult to tell but I would say it would be your SQL statement
but since you didn't provide us with that... shrug
- Original Message -
From: Kevin Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 08, 2001 17:40
Subject: PHP and Mysql
Hi All,
Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39
running on Apache 1.3.20 on Windows 2000 Professional SP!?
br
bWarning/b: Supplied argument is not a valid MySQL result resource in
bd:\program files\apache
group\apache\www.lemonlaineydesign.com\www\top_frame.php/b on line
b68/bbr
And here is the line in my HTML... any ideas what might be wrong? This
works on my Unix box with no problems...
while ($results = mysql_fetch_array($sth)) {
Thanks,
Kevin Smith
Netsmith Limited
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help - Selecting from many to many table.
I would say it is because you need and or in ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3' and not an and. How can a column equal 2 different values at the same time? - Original Message - From: Simon [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 2:08 Subject: Help - Selecting from many to many table. Hello, I am new to SQL and just learning. I have a table of clients and a table of targets. I have a clients_targets table holding the keys for relating. I am having troble trying to select clients that are in more than one target. Eg. Select c.First_Name, ... From clients as c, clients_targets as ct, targets as t Where ct.Fk_Client_Id=c.Id and ct.Fk_Targets_Id=t.Id and ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3' Group By c.Id Thanks in Advance, Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: F IRST TIME USER of MySQL
That's probably because you didn't set up access for root from www.mydomain.com If you have logged into the server through telnet, you shouldn't need the -h option. If you do, it should then be localhost and not yourdomainname. - Original Message - From: Anoop K Gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 22:45 Subject: F IRST TIME USER of MySQL Hi everybody I am still having problem.. please help I am able to connect to my remote mysql server but fail to create, user any database ... I let you know step by step.. what I have done 1. First I have connected to my remote server through Telnet. After becoming root... I had supplied following command... 2. mysql -h mydomainname -u root -p it prompts for password : it is blank so I just pressed enter. and Mysql prompt appeared.. mysql Then I typed 3. mysql use mysql; Result : - ERROR 1045 Access deneid for user [EMAIL PROTECTED] using password : no Can you please help me in this regards? Thanks Anoop Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Relational Database WITHOUT server?
Of course there is no unix versions of Access. Microsoft wouldn't create anything to assist their competitor. If you are setting up a Linux machine, what's wrong with setting it up to run a DB server? MySQL would be quite suitable as it is quite easy to use, allows you to connect from Windows machine using MyODBC and you can display the contents on a web page if you install a web server. You can also get GUIs for it as well. But it doesn't mean you have to rule out other DBs as there are features that aren't yet implemented in MySQL. Have a look through the manual and decide for yourself. - Original Message - From: srf3 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 6:17 Subject: Re: Relational Database WITHOUT server? I needed to add a couple of things to the original posting. What i'm trying to do is have a browser interface for manipulating and viewing the data. The database would be manipulated with cgi on a linux machine. I thought about access, but i don't believe there are api's for creating and manipulating the table definitions? If there is that would be great. Is there a unix version of access i wonder? A relational database that fits in a single file(or more, doesn't matter) and has an odbc driver that attaches to the file(s) that is available on unix? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: saving in mysql
My guess is that you have logging on for php but it has problems saving to it's current location but I'm not psychic so I don't know. (ie. provide the list with some code) - Original Message - From: "Stink" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 7:05 Subject: saving in mysql I've been dealing with this problem for a few days now and I got no idea what's going on: the base is working properly but for one thing - when changing anything in base, i.e. saving new record or creating new tables or dropping tables - anything that involves change in the base - MySQL says: "unable to save result set in example.php on line 30" [for example] but strangest thing is that the record GETS saved/altered/dropped anyway... do you have any idea whats going on ? Thanx in advance Stink - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Syntax question for a beginner..
Well, if you are combining the 2 tables like that into 1, then there is an
easier way without the need for an array.
Make sure you have a unique index on email for tableA and then
INSERT INTO tableA(email) SELECT email FROM tableB
The unique index will stop the duplication while adding values that are in B
but not in A.
- Original Message -
From: { randy } [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 14:05
Subject: Re: Syntax question for a beginner..
Well, I think I got it figured out. I am using PHP, and thought I could
lick
it with just one query...not so. I guess nested selects can be done in
mssql. Anyway, here is what I did...basically:
SELECT tableA.email FROM tableA,tableB WHERE tableA.email = tableB.email;
Loaded that into an array[email]
Looped
DELETE FROM tableA WHERE email LIKE 'array[email]';
Then
SELECT email FROM tableA; # into another array[email]
Then
Looped
INSERT INTO tableB (id, email) VALUES('','array[email]');
That should do it I think
Thanks for the help though...now I know you can't do nested selects :\
- randy
=
r a n d y / sesser at mac.com
From: Rolf Hopkins [EMAIL PROTECTED]
Date: Fri, 6 Jul 2001 13:57:27 +0800
To: { randy } [EMAIL PROTECTED], MySQL [EMAIL PROTECTED]
Subject: Re: Syntax question for a beginner..
Even if sub-selects were available in MySQL (which they're not), that
query
would still not work as it will only select the values that are unique
to
tableA.
What you would be looking at is something like:
SELECT email
FROM tableA
UNION
SELECT email
FROM tableB
But unfortunately, UNION is not available yet either. The next best
thing
that I can think of is to create a temporary table with the email column
having a unique index and first add the contents of tableA and then
tableB.
Finally, you can then retrieve all values from the temporary table which
contains all values from both tableA and tableB, without the duplicates.
- Original Message -
From: { randy } [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:28
Subject: Syntax question for a beginner..
Alright, I am about to pull my hair out.
I have 2 tables. Each have a column 'email' that are unique. Some of
the
records in both tables are duplicates and I want to combine the two
tables
into one with out bringing in the duplicates. So...
I have this statement:
Mysql SELECT email FROM tableA WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but
I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: newbie - connecting to data base with php sql_pconnectstatement
One reason could be the server isn't running. This problem has been documented, please RTFM. - Original Message - From: Roger deBry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 6:11 Subject: newbie - connecting to data base with php sql_pconnectstatement I am trying to connect to a mysql server fom a php script using the php sql_pconnect statement. I have used localhost as the host name, and the userid and password I normally use when connecting from the console. However, when executing the sql_pconnect statement I get an error message that reads Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) . Any ideas on what is wrong. This is my first attempt at this. Please respond via email, as I do not have access to the discussion list through my current isp. Thank you ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL MS VB
Yes, you can run MySQL on a Windows machine and you'll need MyODBC if you're connecting through ODBC. - Original Message - From: Simon Metz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 9:05 Subject: mySQL MS VB I am developing a Visual Basic application requiring a database on a win32 machine running 98SE and wanted to know if mySQL will run on this machine. I would like to avoid using MS SQL server as I will not require stored procedures and this will be running on a laptop for demo purposes. Also, my hosting company has mySQL on my server and I want to know if mySQL is ODBC compliant in the latest version. Thanks Simon Metz check out my website http://www.columbia.edu/~sdm39 coming soon http://www.simonmetz.com --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: update
This is not possible at the moment and the best way I can think of is to separate them into 2 separate queries using the returned value of the select as the input value for the update. - Original Message - From: Paulo Francioli DETRAN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 4:35 Subject: update How do I do to execute a UPDATE using sub query as in the example below? update veiculo2000 set marca = ( select arq2.marca fromveiculo arq2 where veiculo2000.status_veic = '0' or veiculo2000.status_veic = '3' or veiculo2000.status_veic = '6' or veiculo2000.status_veic = '7' and substring(veiculo2000.placa_veic,3,1) ' ' and veiculo2000.placa_veic = arq2.placa_veic and veiculo2000.marca arq2.marca ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Syntax question for a beginner..
Even if sub-selects were available in MySQL (which they're not), that query
would still not work as it will only select the values that are unique to
tableA.
What you would be looking at is something like:
SELECT email
FROM tableA
UNION
SELECT email
FROM tableB
But unfortunately, UNION is not available yet either. The next best thing
that I can think of is to create a temporary table with the email column
having a unique index and first add the contents of tableA and then tableB.
Finally, you can then retrieve all values from the temporary table which
contains all values from both tableA and tableB, without the duplicates.
- Original Message -
From: { randy } [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:28
Subject: Syntax question for a beginner..
Alright, I am about to pull my hair out.
I have 2 tables. Each have a column 'email' that are unique. Some of the
records in both tables are duplicates and I want to combine the two tables
into one with out bringing in the duplicates. So...
I have this statement:
Mysql SELECT email FROM tableA WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
Any help would be appreciated,
- randy
P.S.
Fist time poster, first time lister :)
=
r a n d y / sesser at mac.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Ms-Access vs MySQL
MySQL doesn't support certain features such as foreign keys and sub-selects but may do so in the future. This is documented in the mysql manual. MS Access is not very suitable for networks especially on a large scale. - Original Message - From: Wavyx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 1:19 Subject: Ms-Access vs MySQL Hi, I'm currently looking for a comparison between Access and MySQL. I mean a table with the advantages and inconvenients of both. I found the bench on mysql.com but I need a comparison not only a bench. Thanks for help Wavyx __ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SELECT query
- Original Message - From: Craig Meyers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 3:20 Subject: SELECT query List, Our site is running mysql server version 3.22.32 I'm a power user - not the DBA, so forgive my ignorance. Is it possible to corrupt data with a SELECT query? Very unlikely. Have a look at the logs and see if something else was being performed at around the same time. The connection is made via a shell script: mysql -h servername -u userid -ppassword database QUERY_INPUT SELECT c.id, s.id FROM customers c, simulations s WHERE c.name = 'Customer Name Here' AND s.cust_id = c.id AND s.name = 'Simulation Name Here' QUERY_INPUT During the period I was testing this script, our DBA indicated we lost some data. Is this just a coincidence? I can't see how a benign query could cause such a problem. Thanks. Craig Meyers Senior Engineer Invensys Dynamic Simulation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect
Possibly because you haven't started the server. The manual contains information on this error in more detail. - Original Message - From: MikemickaloBlezien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 6:27 Subject: Can't connect What is the recommended procedure to correct this error: ...Can't connect to local MySQL server through socket '/tmp/mysql.sock'.. We seem to encounter this error quiet often. THX, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forget password in user table and no other user has access privilege to mysql database
Look up skip grants in the manual and in future I recommend the GRANT command. - Original Message - From: harvin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 13:56 Subject: forget password in user table and no other user has access privilege to mysql database hi, i updated the password field using update statement in the command line for the root user. other users in the table don't have any privilege to access the mysql database. when i tried to connect the database i can't able to connect with the new password. the passord i gave was kannan1. what is the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UPDATE/REPLACE command
No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4 first and then update 2. - Original Message - From: Artem Koutchine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 22:43 Subject: UPDATE/REPLACE command Hi! Was UPDATE/REPLACE command implemented? I mean, a command which does update and if it updated to record to match an already existing unique index then the old record is killed and the new stays. Example ( UPPLACE - UPDATE/REPLACE command): table: ids ID (primary key) NAME 1 a 2 b 3 c 4 d UPPLACE ids set id=4, name='z' where id=2; after this table has: 1 a 4 z 3 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
Re: UPDATE/REPLACE command
P.S. You could also UPDATE 4 first with the new value and then DELETE 2. - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Artem Koutchine [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 01, 2001 15:03 Subject: Re: UPDATE/REPLACE command No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4 first and then update 2. - Original Message - From: Artem Koutchine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 22:43 Subject: UPDATE/REPLACE command Hi! Was UPDATE/REPLACE command implemented? I mean, a command which does update and if it updated to record to match an already existing unique index then the old record is killed and the new stays. Example ( UPPLACE - UPDATE/REPLACE command): table: ids ID (primary key) NAME 1 a 2 b 3 c 4 d UPPLACE ids set id=4, name='z' where id=2; after this table has: 1 a 4 z 3 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
Re: Access to Other Databases Thru MySQL
You'll need MyODBC to connect from Access to MySQL. - Original Message - From: Manuel Mesquita [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 0:52 Subject: Access to Other Databases Thru MySQL Dear Sirs, We are new in MySQL. We work basically with Microsoft Access. Please can you give us same info about: To make links, like MSACCESS to other Types of Databases in Linux/Windows, using Java, thru MySQL? Our need is to access to MSACCESS, ORACLE and SQL Databases in java, having the links to those other Databases defined in MySQL, and not by importing the data in those databases to a table in MySQL. In MSACCESS/WINDOWS we can do that using ODBC. In MySQL how can we do it? Best Regards, Manuel Mesquita Rapidata, Lda Email: [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: mysql/php query from 2 tables
- Original Message - From: Felicia [EMAIL PROTECTED] To: mysql post [EMAIL PROTECTED] Sent: Sunday, July 01, 2001 2:06 Subject: mysql/php query from 2 tables im having problems getting results querying two tables but I am not sure of the correct php syntax for the query statement below. It always yields 0 results. $query2 = select * from dir,free where 'dir.inst' = free.inst'; What's the 3 inverted commas in your where claus for? $query2 = select * from dir,free where dir.inst = free.inst; This is what I use in mySQL database but I get 0 results when querying from php. SELECT* FROM dir,free WHERE dir.inst = free.inst Any help would be greatly appreciated. felicia The last of the human freedoms is to choose one's attitudes. -Victor Frankl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange pseudo-coded query
This is way off topic and you should seek an MS Access help list. [Zip Code Distance Extractor] could refer to any number of diff things such as a column in a table, a table name, a field on a form. The ! also has several different meanings and you should be able to find it in help files. - Original Message - From: Thomas J Keller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 01, 2001 3:53 Subject: Strange pseudo-coded query I am working with a commercially supplied database of zipcode numbers and related data. In the documentation, the following pseudo-coded SQL queries are included. I am mystified by two things here: 1) [Zip Code Distance Extractor] -- I have no clue as to what this is referring to 2) the use of the ! operator makes no sense to me in this context help? Thanks in advance... --- included text --- Programming Notes Zip Code Distance Calculator Tables: 1. CPA Firms Table (CPAFIRMS) Fields: 1) First Name 2) Middle Name 3) Last Name 4) Company 5) Address 1 6) Address 2 7) City 8) State 9) Zip Code - 10 digit 10) Delivery Point 11) County 12) Code Number 13) Zip Code - 5 digit 2. Zip Code - Latitude - Longitude Table (ZIP-LAT-LONG) Fields: 1) Zip Code - 5 digit 2) Latitude 3) Longitude 4) City 5) State 6) County Queries: 1. Find Center Zip Code Finds matching Latitude/Longitude from ZIP-LAT-LONG table. SQL CODE: SELECT [ZIP-LAT-LONG].[ZIP CODE], [ZIP-LAT-LONG].LATITUDE, [ZIP-LAT-LONG].LONGITUDE FROM [ZIP-LAT-LONG] WHERE ((([ZIP-LAT-LONG].[ZIP CODE])=[Forms]![Zip Code Distance Extractor]![Zip Code])); 2. Find Distance Calculates Distance from Center Zip Code Query against Zip Codes in the ZIP-LAT-LONG table. SQL CODE: SELECT [ZIP-LAT-LONG].[ZIP CODE], [ZIP-LAT-LONG].LATITUDE, [ZIP-LAT-LONG].LONGITUDE, ([ZIP-LAT-LONG]! [LATITUDE]-[FIND CENTER ZIP CODE]![LATITUDE])*69.1 AS [Distance Lat], (69.1*([ZIP-LAT-LONG]! [LONGITUDE]-[FIND CENTER ZIP CODE]![LONGITUDE])*(Cos([FIND CENTER ZIP CODE]![LATITUDE]/57.3))) AS [Distance Long], ((([Distance Lat]^2)+([Distance Long]^2))^0.5) AS Distance FROM [ZIP-LAT-LONG], [FIND CENTER ZIP CODE]; 3. Find Distance by Radius Limits the results of the Find Distance Query by the radius number. SQL CODE: SELECT [Find Distance].Distance, [CPAFIRM'S].COMPANY, [CPAFIRM'S].FIRST, [CPAFIRM'S].MIDDLE, [CPAFIRM'S].LAST, [CPAFIRM'S].ADDRESS1, [CPAFIRM'S].ADDRESS2, [CPAFIRM'S].CITY, [CPAFIRM'S].STATE, [CPAFIRM'S].ZIPCODE FROM ([Find Distance] INNER JOIN [ZIP-LAT-LONG] ON [Find Distance].[ZIP CODE] = [ZIP-LAT-LONG].[ZIP CODE]) INNER JOIN [CPAFIRM'S] ON [ZIP-LAT-LONG].[ZIP CODE] = [CPAFIRM'S].ZIP5 WHERE ((([Find Distance].Distance)=[Forms]![Zip Code Distance Extractor]![radius])) ORDER BY [Find Distance].Distance; --- end included text --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange pseudo-coded query
- Original Message - From: Thomas J Keller [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 02, 2001 2:49 Subject: Re: Strange pseudo-coded query Rolf Hopkins wrote: This is way off topic and you should seek an MS Access help list. Excuse me. I am working in MySQL. I see no reference whatever to MS Access in my message. How do you figure this is off topic? Because I don't know of any other DB that places square brackets around table names, column names, field names, etc. If you really are working with MySQL and you are using that code with MySQL, then you need to make a lot of changes. For starters, it is not a very good idea to have spaces in your table and column names even though you can. The square brackets need to be removed plus many other changes. [Zip Code Distance Extractor] could refer to any number of diff things such as a column in a table, a table name, a field on a form. I suppose it could. There is no such table or column listed in the documentation that comes with this product. U!! Now I'm confused. Is this code a part of someone else's software you purchased??? If so then maybe I understand. You are trying to MSAccess SQL statements with MySQL. This product was designed for MSAccess or even MSSQL, not MySQL. Sorry, I'm not that familiar with MSSQL. The ! also has several different meanings and you should be able to find it in help files. Help files for what? According to the books I have, the ! means NOT in the context of a SELECT clause. That's exactly what it means and it means that in many programming languages as well but if you read the MSAccess online help, you'll find that it also has other meanings. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error (Index page)
- Original Message - From: help [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 3:55 Subject: Mysql error (Index page) I am getting a few errors on the index page of my site. I am running the page on a windwos 2000 adv server with Mysql and PHP. I have also installed the ODBC module. The errors I am getting are as follows: Warning: MySQL Connection Failed: Access denied for user: 'mark@localhost' (Using password: YES) in C:\sites\docs\index.phtml on line 5 This means that you'll need to fix up the GRANT tables. You'll need to 1. Add a user call mark OR 2. Supply the correct password OR 3. Give the user mark the correct permissions OR ... Once you have fixed this up, you may find that many of the other problems will go away. Warning: Supplied argument is not a valid MySQL-Link resource in C:\sites\docs\index.phtml on line 6 Warning: Supplied argument is not a valid MySQL result resource in C:\sites\docs\index.phtml on line 8 Warning: MySQL Connection Failed: Access denied for user: 'mark@localhost' (Using password: YES) in C:\sites\docs\meta.inc on line 3 Warning: Supplied argument is not a valid MySQL-Link resource in C:\sites\docs\meta.inc on line 4 Warning: Supplied argument is not a valid MySQL result resource in C:\sites\docs\meta.inc on line 7 Warning: Undefined index: login in C:\sites\docs\header.inc on line 4 Warning: Undefined index: login in C:\sites\docs\navigation.inc on line 48 Warning: MySQL Connection Failed: Access denied for user: 'mark@localhost' (Using password: YES) in C:\sites\docs\navigation.inc on line 49 Warning: Supplied argument is not a valid MySQL-Link resource in C:\sites\docs\navigation.inc on line 50 Warning: Supplied argument is not a valid MySQL result resource in C:\sites\docs\navigation.inc on line 52 Warning: Supplied argument is not a valid MySQL result resource in C:\sites\docs\navigation.inc on line 53 Please let me know how to fix these errors please. Thanks __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginners Query
Try logging on as root. - Original Message - From: LinuxTech Inc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 14:16 Subject: Beginners Query hi I am new user to mysql I want to create a new database on my machine where mysql is installed at linux platform I am using CREATE DATABASE name but it is giving me error 1044: Access denied for user: '@localhost' to database 'name' How should I create a new user in it and from the new tables as well. Amol _ Buy Lagaan Yaadein music for 30% less. Avail this special offer at http://shopping.rediff.com/shopping/music/offerrediffmailer.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Copy Record command
Don't know what a COPY RECORD command is but my best guess is that you are looking for a create table with a select clause. - Original Message - From: Klein, Tracy ISTA:EX [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 0:11 Subject: Copy Record command Hello, I cannot find a COPY RECORD command in www.mysql.com - is it to be found under another name? I have a 49 field record I have to create this morning. Ugh. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie
And what is the command you are using to connect? - Original Message - From: Jason Brunk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 7:00 Subject: Newbie hello all, I am kind of new to all the unix OS stuff. Lately i have been doing alot of work in FreeBSD, and i have started playing with mysql. I got it to install and everything, the only problem i am having, is i can't seem to connect from anywhere off the machine, i run the grant privileges on command and it says 0 rows effected. i was wondering if i may be doing something wrong. any help would be appreciated, thanx Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Conversion from Access JOIN syntax to MySQL JOIN syntax...
As it is such a big query, I don't have time to look at it for you but it may be easier if you convert the RIGHT JOINS to LEFT JOINS for starters. The manual does recommend LEFT JOINS, mainly for portability. First part would be something like (leg_activity LEFT JOIN leg_comm_hist ON (leg_comm_hist.leg_activity_id = leg_activity.id) LEFT JOIN leg_version_hist ON leg_version_hist.leg_activity_id = leg_activity.id) - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 2:47 Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax... Yes, I've read the docs on JOIN syntax, and search the list archives for similar information. I have this query: SELECT leg_activity.activity_date, leg_transitions.trans_desc, leg_text.leg_version, body_list.body_name FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_activity ON leg_comm_hist.leg_activity_id = leg_activity.id) ON leg_version_hist.leg_activity_id = leg_activity.id) LEFT JOIN leg_text ON leg_version_hist.leg_text_id = leg_text.id) INNER JOIN leg_transitions ON leg_activity.transition_id = leg_transitions.id) LEFT JOIN body_list ON leg_comm_hist.body_list_id = body_list.id WHERE leg_activity.leg_header_id = 8 That was generated by Access's query designer. It works under Access, but passing to MySQL through ODBC, Access generates four or five queries to do the job. This make it a very long query (1 or 2 seconds), not appropriate for browsing through records. Trying to give this directly to MySQL generates an error: You have an error in your SQL syntax near '(leg_comm_hist RIGHT JOIN leg_activity ON leg_comm_hist.leg_ac' at line 2. I understand JOIN's, at least in concept, but not well enough to construct manually. Is there a tool out there similar to Access's query designer that will design MySQL compatible queries? Are there rules for convert Access queries to MySQL that I should be aware of? Thanks for any help you can give. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create database problem
mysqladmin --help will provide you with a list of switches you can use. If you add -u root to the shell command , perhaps you'll have more success. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 16:37 Subject: create database problem shellmysqladmin create trial mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'trial'' why this happened i only can use test database by default - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: cascade delete's
That requires the use of foreign keys and that's not supported. - Original Message - From: Sibel Toprakkiran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 16:23 Subject: cascade delete's Hi, I wanted only to know, if there is a possibility in mysql for cascading delete's? Because in databases with a lot of tables, it s really difficult to pay attention to all of the dependencies and it would be nice, if there is a possibility for automatically deleting the dependent records. thanks, Sibel. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting mySQL for a user
You can start with the mysql manual. Then there is Paul DuBois book, people say it's supposed to be good. - Original Message - From: WebNomad Inc. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 20, 2001 4:39 Subject: Setting mySQL for a user Hello all, I'm a newbie to the list and mySQL. So please forgive me. I have no idea what I am doing running a server but i'm doing it! I have a client who needs mySQL and have no idea how to do this. I have a cobalt raq4i. Is there a resource for a real beginner like me to go to with step by step instructions or would anyone on the list be able to offer me some suggestions. TIA Best regards, Sham Cobalt RAQ4i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: please help (dumb permissions thing?)
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 9:20 Subject: please help (dumb permissions thing?) Access denied for user: '@localhost' to database 'netsloth'Could not drop database netsloth Don't know what command you used but I would say you need to specify the user. Something like -u root. Otherwise check the user's permission. (i asume drop means to drop 'in' in this case?) I have no idea what you mean by this. The error message is correct as is. In other words, you are trying to delete that database. is what i get back when i try to install the db 'netsloth.dump' from J Greenspan's book and CD. Sorry, haven't heard of this book. please tell this newcomer what he has to do to fix this so i can get on with it... i've been at this for 2 days and am thoroughly stuck. please tell me the most basic user accesses to check. The mysql manual, found at the mysql web site, is the best reference I have. TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied problem
mysqladmin -u root password mysql password is used to change the password. -p is used to log on if a password has already been set. Don't know exactly what you want to do but possibly you're looking for mysqladmin -u root -p password your_new_password If that doesn't work and you don't know the password, look up skip grants in the manual. - Original Message - From: chao cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 17, 2001 3:40 Subject: access denied problem Hi, I just installed Mysql from source for Linux. When I type the following command: mysqladmin -u root password mysql I got this error: mysqladmin:connect to server@localhost' failed error:'access denied for user:'root@localhost'(using password:NO)' Can some tell me how to correct this problem? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Relationships???
If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What's wrong here?
It would help if we knew what the error or problem was?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 13:13
Subject: What's wrong here?
?php
require('common.php');
function DisplayPoll() {
connectdb();
mysql_select_db(pollbooth);
$sql = select choice from choices;
$query = mysql_query($sql);
$num_of_voting_choices = mysql_num_rows($query);
$sql = select choice from votes;
$query = mysql_query($sql);
$number_of_votes = mysql_fetch_array($query);
for ($i = 0; $i $num_of_choices; ++$i) {
$sql = select id from votes where choice='$i';
$query = mysql_query($sql);
$num_of_rows_for_choice = mysql_num_rows($query);
$choice_percentage = $number_of_rows_for_choice / $number_of_votes;
$number_of_pixels_to_print = $choice percentage / 5;
for ($x = 0; $x $number_of_pixels_to_print; ++$x) {
echo(img src=.$color_choice.);
echo( .$choice_percentage.\%);
}
}
}
?
Please help :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What's wrong here?
Well, that isn't much to go on. I suggest you put a few print statements to
find out what's happening and also try the sql statement in the mysql prompt
to see if the sql statement does what it is suppose to. Remember, if you're
printing this in a table, error messages and results may not always be
displayed on the web page. You may have to view source.
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 14:08
Subject: RE: What's wrong here?
Sorry. It doesn't do anything.
Oh and btw, I made it so it DOES call on the function.
It would help if we knew what the error or problem was?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 13:13
Subject: What's wrong here?
?php
require('common.php');
function DisplayPoll() {
connectdb();
mysql_select_db(pollbooth);
$sql = select choice from choices;
$query = mysql_query($sql);
$num_of_voting_choices = mysql_num_rows($query);
$sql = select choice from votes;
$query = mysql_query($sql);
$number_of_votes = mysql_fetch_array($query);
for ($i = 0; $i $num_of_choices; ++$i) {
$sql = select id from votes where choice='$i';
$query = mysql_query($sql);
$num_of_rows_for_choice = mysql_num_rows($query);
$choice_percentage = $number_of_rows_for_choice / $number_of_votes;
$number_of_pixels_to_print = $choice percentage / 5;
for ($x = 0; $x $number_of_pixels_to_print; ++$x) {
echo(img src=.$color_choice.);
echo( .$choice_percentage.\%);
}
}
}
?
Please help :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 on VB
Can connect using MyODBC. - Original Message - From: Andrew [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 13:52 Subject: RE: MySQL on VB I need some help. I would like to know if VB can interface directly with MySQL. If possible, then how shall I go about on it. Thanks. Andrew. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Error
No, you need to add a user to MySQL that is allowed access from that host. See the GRANT statement in the manual. I'm also betting that that is a dynamic IP address in which case you'll probably have to setup a user with access from 192.168.0.% - Original Message - From: Anthony Olugbenga Bamgbose [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 10:45 Subject: mySQLGUI Error I am trying to use MySQL GUI client on W2K to connect to MySQL server running on RedRat Linux 7.1 and I am getting the following error Host '192.168.0.152' is not allowed to connect to this MySQL server. Do I need to change something on my Linux? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pornographer will trade for Help with web based MySql
I'm sure most people on this list aren't interested in your services. You can start by reading the relevant manuals or you could hire a professional to create the db for you. This is a great list for getting help on specific problems provided you've tried to help yourself first. Also, if you do need to ask the list for help and you need to post some code, please ensure that the content is ummm... let's say suitable for children. I mean, this list is for people to get assistance with mysql problems, it is not an adult's only chat room. - Original Message - From: John 'TPG' Smith [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Monday, June 11, 2001 9:13 Subject: Pornographer will trade for Help with web based MySql I am interested in learning MySql and cgi. I want to trade my services for this help. I want to be able to make custom web based applications. I am a pornographer. TPG [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: MySql keeps crashing
You could simulate a crash by deleting the mysql.sock file. If your ISP allows you to access the logs, he may have inadvertently allowed others access to them as well. Are you able to check if the system, especially mysql, is all locked down properly. Correct permission, ownerships, etc.? Only someone with the correct mysql root password could shut it down like that. Are you able to check what cron jobs are running? - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 14:13 Subject: Re: MySql keeps crashing Yes, host server means ISP. I am able to view the logs because he lets me. I agree with you, I think someone else is shutting down the database, but he insists that my perl scripts are causing it to crash. The only proof I have right now is the MySql error log, which lists the normal shutdown messages. These messages occur everytime the database goes down. I need to be able to show him the logs and prove that *I'm* not crashing the database, someone/something is shutting it down. I was just hoping that the MySql developers would see my post and tell me that normal shutdown messages will NOT occur if the database crashes...so I can go back to him and prove he's lying to me. Thanx, Chuck - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Chuck Lucas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 11, 2001 01:55 Subject: Re: MySql keeps crashing This doesn't make much sense to me. By host server you mean your ISP? If so how are you able to view the logs? Are you DB admin or something? By the looks, someone is able to get in and shut it down. This can only happen with admin rights or mysql server wasn't set up correctly in the first place. I can't possibly see how SQL scripts could shutdown the server especially if the server has been properly setup and secured. - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:03 Subject: help: MySql keeps crashing Need a little assistance. I've looked through the current MySql manual, but I can't find any information concerning my questions. My MySql server keeps crashing, or that's what my host server tells me. He claims that my scripts are crashing MySql. However, when I look at the MySql error log, I see messages like this: mysqld started on Fri Jun 8 07:36:34 PDT 2001 /usr/sbin/mysqld: ready for connections 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Fri Jun 8 14:39:45 PDT 2001 My questions are thus: If the server crashes, would it write a normal shutdown message, or is that message indicative of someone/something sending MySql a shutdown signal? Am I even looking in the correct log...should I be looking in the update log, or somewhere else? Here is some other information that may affect your answer: MySql Server version 3.22.21 Running on Cobalt RaQ with the following OS info: Linux 2.0.34 #1 mips glibc-2.0.7-10 Any help you could offer would be greatly appreciated! Chuck [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL error
There are settings that could probably fix the problem then but I would need
to RTFM.
- Original Message -
From: Aldo Spano [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 0:03
Subject: Re: MYSQL error
Ok! thanks.
I tried and with the prompt it seems to work. Effectively i have this
error
often, but sometime it works correctly.
Maybe the packet it's too big?
A.
Scrive Rolf Hopkins [EMAIL PROTECTED]:
You don't have to join the mailing list to send mail to the list. Send
it
to the list anyway and you may get a better response and there may even
be
someone who has come across this exact same problem. If you don't think
it's IMP, are you able to log into the mysql prompt and run that exact
same
query from there?
- Original Message -
From: Aldo Spano [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 21:27
Subject: Re: MYSQL error
Thank you very much for answer. I removed from the list cause I
received
too
much e-mail and basicly i'm not even on-line, so my mailbox becomes
full
in a
white.
IMP is a package wrote in PHP, for the management of mailbox with IMAP
protocoll.
I don't think the problem was IMP, cause, like I wrote you in the
first
email,
with the old version of MYSQL works correctly.
The DB's tables has the right fields, this is the making:
CREATE TABLE active_sessions (
sid varchar(32) NOT NULL,
name varchar(32) NOT NULL,
val text,
changed varchar(14) NOT NULL,
PRIMARY KEY (name, sid),
KEY changed (changed)
);
Seems to be a problem for the socket, or maybe for the thread
definitions.
I tried to change the config file my.cnf and it works in a bad way.
I really apreciate your interesting
Thank you
A.
Scrive Rolf Hopkins [EMAIL PROTECTED]:
Firstly, you should reply to the list as I may not know the answer.
For
starters I don't know IMP so if it is more of an IMP problem, I
can't
help
you.
The only thing I can think of is that your columns aren't defined
properly
to hold your data. For example, without looking at the manual, the
only
2
column types I can think of, that would be suitable for the val
column,
are
text and blob.
- Original Message -
From: Aldo Spano [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 16:53
Subject: Re: MYSQL error
I saw in the log that there is an error with the communication.
This
is a
line
from the log:
010608 4:30:07 Aborted connection 274940 to db: 'horde' user:
'hordemgr'
host:
`localhost' (Got an error reading communication packets)
IMP is wrote with php and for this error in the page appear an
error
like:
Database error (HordeDB): Invalid SQL: insert into active_sessions
(
sid,
name,
val, changed ) values ('62f84000b07f13f8f8da50855c978199',
'HordeSession',
'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdFsnaW1w
J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXSA9IG5ldyBJbXBTZXNzaW9uOyAkR0xPQkFMU1snaW1w
J10tPmRhdGEgPSBhcnJheSgpOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ3NlcnZlciddID0gJ2xv
Y2FsaG9zdCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncG9ydCddID0gJzE0Myc7ICRHTE9CQUxT
WydpbXAnXS0+ZGF0YVsnc2VydnR5cGUnXSA9ICdpbWFwJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRh
Wyd1c2VyJ10gPSAnYWxkbyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncGFzcyddID0gJzRtbTFu
MXN0cjR0MHIzJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWydtYWlsYm94J10gPSAnSU5CT1gnOyAk
R0xPQkFMU1snaW1wJ10tPmRhdGFbJ2tleSddID0gJyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsn
bXNnbCddID0gJzExMTk6MTMyMToxMzM4OjEzNDU6MTM0NjoxMzc2OjEzODA6MTM4OToxMzkyOjEz
OTM6MTM5NToxNDU3OjE0NjM6MTQ4MjoxNDg1OjE1MTE6MTUzNDoxNTU2OjE1NjE6MTU2NDoxNTY1
OjE1Njc6MTYxOToxNjIwOjE2NDU6MTY1MToxNjkwOjE2OTI6MTY5MzoxNzQxOjE3NDk6MTc3Njox
NzkyOjE3OTM6MTgwMzoxODE0OjE4MTc6MTgyMToxODIyOjE4NDE6MTg2NjoxODY4OjE4NzM6MTkz
MzoyMDA1OjIwMzI6MjA2MToyMDc4OjIxNDA6MjE2OToyMTk3OjIyMzc6MjI1ODoyMjY0OjIyNzM6
MjI3NDoyMzI1OjIzNTM6MjM1NjoyMzU3OjIzNTk6MjM2MDoyMzYyOjIzNzM6MjM3NToyMzc3OjIz
Nzg6MjM4NzoyNDIxOjI0MjY6MjQ2NjoyNjE1OjI2NDg6MjY4ODoyNzk5OjI4MDA6MjgwMToyODAy
OjI4MDM6MjgwNCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnZm9sZGVycyddID0gJyc7ICRHTE9C
QUxTWydpbXAnXS0+ZGF0YVsnc29ydGJ5J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0
YVsn
c29ydGRpciddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2RlbGhpZGUnXSA9ICcnOyAk
R0xPQkFMU1snaW1wJ10tPmRhdGFbJ29mZnNldCddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRh
dGFbJ2Zyb21fc2VydmVyJ10gPSAnaXRhbGlhbi5pdCc7IA==',
'20010608105204')
Database error (HordeDB): Session: freeze() failed.
Thanks
Aldo
Scrive Rolf Hopkins [EMAIL PROTECTED]:
What is the error?
- Original Message
Re: Table won't update
Will the update statement work under the mysql prompt?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 8:39
Subject: Table won't update
The table sitesats won't update and shows no errors! (even though there are
two instances of echo(mysql_error()))
html
body
?php require('../common.php');
if (!isset($areview)) {
echo(You must review the site); } else {
if (!isset($apositive)) {
echo(You must review the site); } else {
if (!isset($anegative)) {
echo(You must review the site); } else {
connectdb();
mysql_select_db(xtopsites);
$sql = update sitesats set arate='$arate', areview='$areview',
apositive='$apositive', anegative='$anegative', validated='2' where
id='$id';
$query = mysql_query($sql);
echo(mysql_error());
if (!$query) {
echo(mysql_error());
} else {
echo(Review stored successfully.); }
} } }
?
/body
/html
Any ideas?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Installation problem
What do the mysql error logs say? - Original Message - From: Gerry Tool [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 11:33 Subject: Re: Installation problem No, the daemon isn't running. Gerry Rolf Hopkins wrote: Has it already started? Check with ps -ef | grep mysqld - Original Message - From: Gerry Tool [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 10:38 Subject: Installation problem I have just installed mysql on a RH7.1 system from mysql-3.23.38-pc-linux-gnu-i686.tar.gz using the procedure in the manual. - shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R mysql /usr/local/mysql shell chgrp -R mysql /usr/local/mysql shell bin/safe_mysqld --user=mysql When I try to start the daemon, it immediately stops as shown below: [root@gstpc mysql]# bin/safe_mysqld --user=mysql [1] 1664 [root@gstpc mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data 010611 21:20:10 mysqld ended Any suggestions will be appreciated. Gerry Tool ([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: Password encryption
I used the function password() if that helps but of course you can't decode it. - Original Message - From: Leon Mergen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 22:44 Subject: Re: Password encryption Anyone has any idea how much this encryption method sucks up server load? _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. ICQ: 55677353 - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: Leon Mergen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 08, 2001 9:47 PM Subject: Re: Password encryption Look in the manual about the ENCODE/DECODE functions. j- k- On Friday 08 June 2001 10:28, you wrote: Hello all, I have some questions about password encryption. I want to make some sort of encryption method that disables a human to read the password, but does allow my (php) script to convert the encoded password to a human-readable password, the member originally entered and the member enters in the form (if he or she has the password right) . In other words, I want a string to be encrypted and decrypted, if it's possible in the query. An example: insert into table values (encrypt(secret)); select decrypt(passfield) as pass from table; and here, pass will contain the value of secret. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 encryption
Well, if you're using web pages, I've never thought much of passwords being passed from one page to the next. Too much at risk of being sniffed out each time a page is submitted to the server. I devised a way that creates a random char string which changes each time a user logs on and that gets passed to the next page instead of the password itself. Other than that, I don't think I can be much more help. - Original Message - From: Leon Mergen [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 22:09 Subject: Re: Password encryption Hello Rolf, I need the decoding option, since I need to have a password lookup function... Hmmm... offcourse, I *COULD* completely rewrite it, and instead of lookup up a password, make it so that you can reset your password if you have verified your email address or something. However, I wonder if rewriting this is worth the effort. I mean, I probably will be busy 3 hours with it, to completely rewrite it, and fully test everything. And that is why I wonder if it's worth it, because I also like the option to decode the passwords of my members, if I have the encryption password... But basically, my question is: how great is the performance penalty caused by DECODE(), or is it low enough to forget about it? Because my system checks the password each page a member visits, and a member usually visits around 500 pages/day. So performance is quite important here ;) Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353 - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Leon Mergen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 3:43 PM Subject: Re: Password encryption I used the function password() if that helps but of course you can't decode it. - Original Message - From: Leon Mergen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 22:44 Subject: Re: Password encryption Anyone has any idea how much this encryption method sucks up server load? _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. ICQ: 55677353 - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: Leon Mergen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 08, 2001 9:47 PM Subject: Re: Password encryption Look in the manual about the ENCODE/DECODE functions. j- k- On Friday 08 June 2001 10:28, you wrote: Hello all, I have some questions about password encryption. I want to make some sort of encryption method that disables a human to read the password, but does allow my (php) script to convert the encoded password to a human-readable password, the member originally entered and the member enters in the form (if he or she has the password right) . In other words, I want a string to be encrypted and decrypted, if it's possible in the query. An example: insert into table values (encrypt(secret)); select decrypt(passfield) as pass from table; and here, pass will contain the value of secret. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: simpe select return not all rows - and flush
Have you tried ismchk/myismchk? - Original Message - From: Artem Krsheminsky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 2:01 Subject: simpe select return not all rows - and flush Hi i'm newbie and have the problem - sometimes after some INSERT and also sometimes just from nothing simple SELECT begin work not properly - it returns not all rows in the table that must. in most cases FLUSH TABLES help, but yesterday it won't help - SELECT continue return empty result, until i restart mysql i looked into error log and found next for last case: bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929 010608 21:12:22 bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2077028 010608 21:12:22 bdb: ./fly_db/airports.db: close: 2 blocks left pinned anyway after restart table data looked right and database work fine and nothing for prevoius cases where flush tables worked well i searched throught the mailing lists, but i don't found anything that can help me to understand the problem should i use flush table after every insert ? should i use variable in my.cnf to order mysql flush tables pereodicaly? or something else? also i do not found any help how to understand the error messages from BDB and what to do in this case? thnx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 keeps crashing
This doesn't make much sense to me. By host server you mean your ISP? If so how are you able to view the logs? Are you DB admin or something? By the looks, someone is able to get in and shut it down. This can only happen with admin rights or mysql server wasn't set up correctly in the first place. I can't possibly see how SQL scripts could shutdown the server especially if the server has been properly setup and secured. - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:03 Subject: help: MySql keeps crashing Need a little assistance. I've looked through the current MySql manual, but I can't find any information concerning my questions. My MySql server keeps crashing, or that's what my host server tells me. He claims that my scripts are crashing MySql. However, when I look at the MySql error log, I see messages like this: mysqld started on Fri Jun 8 07:36:34 PDT 2001 /usr/sbin/mysqld: ready for connections 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Fri Jun 8 14:39:45 PDT 2001 My questions are thus: If the server crashes, would it write a normal shutdown message, or is that message indicative of someone/something sending MySql a shutdown signal? Am I even looking in the correct log...should I be looking in the update log, or somewhere else? Here is some other information that may affect your answer: MySql Server version 3.22.21 Running on Cobalt RaQ with the following OS info: Linux 2.0.34 #1 mips glibc-2.0.7-10 Any help you could offer would be greatly appreciated! Chuck [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: Rookie admin needs install help
Strange. I've never had any problems with the RPMs
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 21:59
Subject: Re: Rookie admin needs install help
At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote:
Unix rookie as well?
0 | 0
\__/
Off the top of my head, rpm -i file_name should do it. I usually use
redhat's gui. man rpm will give you more details.
evidently, there's something wrong with the rpm package for linux. the
binary at mysql.com installs fine. also, the binary at sourceforge
doesn't
install properly either.
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: php/mysql question
- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; What you wrote here and what you wrote below are not the same update vusers set name=Adrian D'Costa where id=3; update vusers set name='Adrian D\'Costa' where id=3; will both work. Look up the section on escaping special characters in the mysql manual. ' I get the ' prompt that is waiting for me the close the '. If I try the same statement in mysql command line: update vusers set name=Adrian D'Costa where id=3; Query OK, 0 rows affected (0.01 sec) Rows matched: 1 Changed: 0 Warnings: 0 It works. How do I do the same in php? TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: php/mysql question
- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 17:47 Subject: Re: php/mysql question On Fri, 8 Jun 2001, Rolf Hopkins wrote: - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; What you wrote here and what you wrote below are not the same True. update vusers set name=Adrian D'Costa where id=3; This is at the mysql prompt update vusers set name='Adrian D\'Costa' where id=3; and this is thru the script. Both work at the mysql prompt. But this will not work thru the script. Don't know why. Both should work through the script. What's the exact script and what's the error? will both work. Look up the section on escaping special characters in the mysql manual. Mysql Manual, hmmm I remember seeing that when I was with rh6.0 when I installed rh7.0 no manual. Give me a link to download it. www.mysql.com Don't tell me! You used RH's mysql RPM to install?!?! Ouuccc!!! The bane of many people's problems. If you ever find problems with mysql, get the RPMs from Mysql's website 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: Rookie admin needs install help
Unix rookie as well?
0 | 0
\__/
Off the top of my head, rpm -i file_name should do it. I usually use
redhat's gui. man rpm will give you more details.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 13:20
Subject: Re: Rookie admin needs install help
At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote:
I don't know whether slackware has the RPM software but if it does, use
it.
You won't have these problems then. Otherwise I can only suggest you try
one of the other binaries instead.
i'm also a mysql admin rookie. i couldn't get the rpm file to install and
my linux distribution has the rpm software. however, i was able to install
the tarball.
hth
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 aborting abnormally (rh linux 6.2)
Sure it hasn't already started? Do ps -ef | grep mysqld to find out.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 12:57
Subject: mysql daemon aborting abnormally (rh linux 6.2)
hi gang!
after much hassle, i seem to have successfully installed mysql 3.23.38. i
now have another problem. the mysql daemon is aborting abnormally upon
startup. i typed in the following from bash:
cd /usr/local/mysql
./bin/safe_mysqld
i got the following output:
Starting mysqld daemon with databases from
/usr/local/mysql-3.23.38-pc-linux-gnu-i686/data
010606 22:51:27 mysqld ended
what the f--k? can someone please help me troubleshoot this.
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql server or mysql
This all depends on your needs. If you're looking for speed and reliability, you can't beat MySQL on a unix based system. However, MySQL lacks features such as subselects and foreign keys. Some are still on the way while others will never be implemented. A good place to start would be the mysql manual, especially their todo list. - Original Message - From: Sebastian Murarasu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 14:18 Subject: sql server or mysql Hello! Does anyone know which is the best choice between MS SQL Server and MySQL? Context: - TCP/IP protocol over the network - MS Visual FoxPro (5 or 6) as the front end development tool Please reply on my personal email address if possible ([EMAIL PROTECTED]) Thank you very much! Sebastian Murarasu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please can you help me find the right file to download
There is no full blown graphical version of the database itself. You still need to download the normal version itself and then download a graphical front end for administration. The main software you need can be found at http://www.mysql.com/downloads/mysql-3.23.html and the graphical interface at http://www.mysql.com/downloads/gui-clients.html And sorry, no, I can't tell you how to install it. Well... I can but not as good as what the manual can. - Original Message - From: Stephen Calvert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 22:41 Subject: Please can you help me find the right file to download I am after a version of MySQL with a graphical interface. I don't know which files to download or what to do with them once downloaded. I am keen to try out mysql but I am having difficulty understanding what to do with the downloas I have. Is there any chance you can email me the links to the files along with a brief overview of installing and configuring the software for use on my PC. I am running Winnt 4.0 Server. I would appriciate any help you can give. Best Regards Stephen _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installation problem
Is this a new installation? Then the -p option is not required. -p is only used once you have set the initial password. - Original Message - From: Michela Robustelli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 23:20 Subject: installation problem i've tried to install mysql version 3.23.3 for linux, but I get always the error message if I try to connect to bd: for example /mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' michela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What am I missing?
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cant connect
Well, from the error, one of them is not correct. Since you didn't supply the code you used, my best guess is your host is incorrect. I am guessing you have something other than 'localhost'. If that's not working, '127.0.0.1' may do the trick. If not, check your grant tables again. - Original Message - From: Martin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 5:33 Subject: Cant connect Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92 I am sure that all information is correct as far DB name user name and password any ideals - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pound (£) Symbol and MySQL
- Original Message - From: technical Support [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 4:52 Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. Is this what you get in the database itself? If it is, then I had a similar problem with Chinese characters. I found it to be the incorrect character set defined in the meta tag of the html code. Once I changed it to the correct character set, everything was fine. Perhaps yours is similar. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSERT.
Check out last_insert_id in the manual. - Original Message - From: Jorge Oliveira [EMAIL PROTECTED] To: Mysql@Lists. Mysql. Com [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:43 Subject: INSERT. Hi, I have two tables in my database: #TB1 ID_tb1 (auto-incremented) ID_tb2 name address #TB2 ID_tb2 (auto-incremented) method status I need to run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2. Since #TB2.ID_tb2 is auto incremented, I don't know how to get the same value inserted at #TB1.ID_tb2... Thanks in advance. Best Regards, Jorge Oliveira [EMAIL PROTECTED] - © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP MySQL
How'd you put it into the database in the first place? I'm betting that, if
you look at your database directly (not through a UI), you'll find the data
is stored as lt;IMG
Anyway, wouldn't it be easier just to store foo.gif in the database rather
than the full line?
- Original Message -
From: Michele Santucci [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 14:20
Subject: PHP MySQL
I have a stupid problem with PHP MySQL (I'm a newbie of course):
I push in a text/blob record a string like this:
img src=foo.gif border=0
when I read print this record with PHP (using a simple echo statement ) I
got back the string translated in this way:
lt;IMG SRC=\quot;foo.gif\quot; border=\quot;0\quot;gt;
How can I prevent PHP from doing this translation and giving me back just
what I wrote inside the field?
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: PHP MySQL
- Original Message -
From: Michele Santucci [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 15:33
Subject: Re: PHP MySQL
How'd you put it into the database in the first place? I'm betting
that,
if
you look at your database directly (not through a UI), you'll find the
data
is stored as lt;IMG
No the data was stored in the right way! The problem wasn't here but in
some
code lines around the one I was writing (I was modifing a script made by
someone else).
There was a calling to $row[$k]=htmlentities($row[$k]), that I just
removed
and I got what I was looking for...
Yea! of course, the htmlentities would cause a problem in this case.
Anyway, wouldn't it be easier just to store foo.gif in the database
rather
than the full line?
It could be a good idea but right now I have to improve my skills on
low-level php coding before starting to use advanced features of
php/mysql...
Actually, it's not that much harder. Use an sql statement to get it into a
variable, $foo say, as normal and then use either
1. ?php print(img src=\$foo\ border=\0\) ?
or
2. img src=?php print($foo) ? border=0
...and you'll probably have to do combinations, depending on what you are
doing.
Thnx again to anyone
bye by{t}e[s] TuX!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 Client
Yes there is. Just install the MySQL client in the normal way. When you add users, ensure they can access the server from a remote machine. See the GRANT and REVOKE statements. When they log in, they must specify the address of the MySQL server using the -h option. - Original Message - From: M Srinivas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 12:27 Subject: MySql Client HI, I am new to mySql and I want to set up MySql Client on different PC's and MySql server on one PC so that every one will access the same database. Is there a way to do this. Any one please help me. Thanks and Regards, Srinivas.M My Mail Id : [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.259 / Virus Database: 130 - Release Date: 6/5/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 tool
As far as I am aware, mysqlgui is supposed to do exactly that. - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 23:11 Subject: MySQL tool Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem in migrating from mysql to Oracle
I am pretty sure that Oracle Migration Workbench is an Oracle product, am I correct? In that case you'll probably have to seek out the Oracle community. Hehehe. good luck. Only one thing though. I wouldn't think you'd be able to migrate the mysql database as that is the security database designed specifically for mysql. I very much doubt it would be compatible with Oracle's security system or any other database for that matter. - Original Message - From: Penubothu, Rajani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 3:37 Subject: Problem in migrating from mysql to Oracle Hi, I am Rajani working as a Java Programmer. I was trying to migrate from mysql to oracle and getting some kind of problems. I want to get some kind of help from you and i really appreciate it. Here is my explanation what i am exactly doing :-) I downloaded Oracle Migration Workbench in order to automatically copy the whole database from mysql to oracle. It has a migration wizard for this purpose and i ran it. I was able to create the migration repository successfully. Then i selected the database mysql to migrate to oracle. Then it asked me to provide Source Password and Data Source. I ignored to give password as i didn't set any kind of root password. Data Source i gave is my machine name as that is the one which has the mysql database. Then, it actually should list all the databases i would like to migrate to oracle. Actually in my database server, i have 2 databases.(test and mysql). Here, at this stage, it is only showing test database but not mysql database which i was trying to migrate. What could be the problem ? I would really appreciate any kind of help from you. Thanks. Rajani Email : [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: permissions
And what command did you use to create the user? - Original Message - From: Peter I. Hansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:32 Subject: permissions Hi I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and I want the structure to be like this : 1) user X can connect from '%.xxx.yy' and from 'localhost'. 2) user X can only connect to database X. I can only make one out of two possibillities in 1) work at a time. Can you help me, Please... Peter Hansen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table Creation woes
describe is a reserved word and so is fulltext, I think. - Original Message - From: Matt TrollBoy Wiseman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:52 Subject: Table Creation woes can someone tell me what I'm doing wrong here?I keep getting the error You have an error in your SQL syntax near 'describe text, fulltext text, section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6 and I don't understand why: CREATE TABLE article( id INT (4) DEFAULT '0' NOT NULL AUTO_INCREMENT, title VARCHAR (128) DEFAULT '0', logosmall VARCHAR (128) DEFAULT '0', logolarge VARCHAR (128) DEFAULT '0', describe text, fulltext text, section VARCHAR (32) DEFAULT '0', type VARCHAR (32) DEFAULT '0', PRIMARY KEY(id), UNIQUE(id) ); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rookie admin needs install help
I don't know whether slackware has the RPM software but if it does, use it. You won't have these problems then. Otherwise I can only suggest you try one of the other binaries instead. - Original Message - From: Patrick Malone [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:22 Subject: Rookie admin needs install help This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm MySQL-devel-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-shared-3.23.38-1.i386.rpm Then I used rpm2tgz to convert them to .tgz files, and finally ran installpkg on each of them to do the install. The problem comes when I try to start the MySQL server with safe_mysqld. My machine is named 'patrick'. The command returns: touch: /var/lib/mysql/patrick.err: No such file or directory chown: mysql: invalid user Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory /usr/bin/safe_mysqld: /var/lib/mysql/patrick.err: No such file or directory tee: /var/lib/mysql/patrick.err: No such file or directory 010606 11:30:08 mysqld ended tee: /var/lib/mysql/patrick.err: No such file or directory I have looked, and there doesn't seem to be a /var/lib/mysql directory. Simply creating a blank /var/lib/mysql directory myself seems to generate further errors. Has anyone encountered this before? Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is the error in this sql query
I would say line 2, DEFAULT 0 not DEFAULT '0'. - Original Message - From: Syed sumair [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, June 01, 2001 7:11 Subject: What is the error in this sql query What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID), INDEX(page_ID) ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Have you seen this error message?
Sorry, can't remember exactly as I don't use Windoze but I do know you don't use mysqld.exe on win98. Do a search of the archives for the past few weeks and you'll find your answer. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 20:01 Subject: Have you seen this error message? Hi, When I try to start mysqld.exe under Win98 I get error: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Can anyone help with this? Thanks, Sean . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create username/password with mysqladmin???
Wouldn't it be easier just to log into mysql and use the GRANT REVOKE
commands.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 22:28
Subject: create username/password with mysqladmin???
hello,
i'm running mysql 3.23.38 on linux. how do i create a username and
password with mysqladmin? from which directory do i do this?
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: which the best
I'm not getting into any OS wars here, but just to say I chose a unix based system due Microsoft's poor record with stability. I need something that I can rely on to stay up and running and Windoze doesn't fall into that category. - Original Message - From: Sommai Fongnamthip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 12:33 Subject: which the best Dear, I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: remote DB
If your not the admin of the DB, you'll have to ask the DB's admin for your login and password. If you are the admin, you'll need to RTFM about DB security and the GRANT and REVOKE statements. And no, it's not a good idea to allow connections using the root user to perform anything else other than db administration. - Original Message - From: p w [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 04, 2001 14:40 Subject: remote DB Hello, Can anyone tell me if the MySQL database has a defualt user ID and password? I am trying to access a remote DB with my application, but am experiencing difficulties. This may be because I need correct user access details. Are there such details, and if so, what are they please? Thanks alot. Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! MySQL variables laugh at me
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? - Original Message - From: Luca Accomazzi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 04, 2001 17:02 Subject: Help! MySQL variables laugh at me I've been frying my brain over this problem for the past 24 hours and I'll be very grateful for any hints. I'm trying to recognize when the value for a field is changing value from one record to the next. For an example, look at this: mysql select sezione from faq limit 20; +---+ | sezione | +---+ | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Macintosh | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | +---+ 20 rows in set (0.01 sec) As you see, the field's value is almost always Internet, but it becomes Macintosh in the middle. I'd like to recognize this change (and, later, act on it). I thought I had found the solution by employing a bit of variable magic. And it seemed to work just fine: mysql select sezione, IF(@a=sezione, no, yes) as hasChanged, (@a:=sezione) as newValueForMemory from faq limit 20; +---++---+ | sezione | hasChanged | newValueForMemory | +---++---+ | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Macintosh | yes| Macintosh | | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | +---++---+ 20 rows in set (0.01 sec) I keep a copy of the previous value in a variable, then check that variable against the current value for the field. All is well. BUT, as soon as I tackle my real problem (on a nasty database, complex queries, and the real problem, all hell breaks loose: mysql select ordine, IF(@oldOrdine=ordine, no, yes) as hasChanged, (@oldOrdine:=ordine) as newValueForMemory from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +++---+ | ordine | hasChanged | newValueForMemory | +++---+ | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | no | 3 | +++---+ 13 rows in set (0.10 sec) WHY OH WHY is MySQL behaving like this? I tried a bunch on variations (using two variables, applying a function on the field and ever weirder ones), to no avail. It gets even more unpredictable, as if the variables refused to be set and reset. mysql select @a, ordine, @b:=ordine, @b, IF (@a=@b, 'Very Thin', 'Thin') as divider, @a:=@b from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +--+++--+---++ | @a | ordine | @b:=ordine | @b | divider | @a:=@b | +--+++--+---++ | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very
Re: Help! MySQL variables laugh at me
Ok. This is what I think you are wanting. Have a datetime field or even a datestamp. Before you insert, do a select to find the value of the most recent row that was added then you can calculate what you should insert from there. BTW you should include history incase some else has ideas. - Original Message - From: Luca Accomazzi [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 04, 2001 20:47 Subject: Re: Help! MySQL variables laugh at me I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? Wait wait wait! I see what you mean. What I'm seeing as a loop (rows upon rows of data from the database) is a single query to MySQL. So it's fist selecting, then calculating my variable, then sorting. And in sorting, I see wrong values for my is different from the previous pseudo field. Glact. Is there anything I can do to get the functionality I'm after in any other way? I seem to remember there's a having clause which gets computed in the end? L.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP and MySQL result set navigation
Yep, that's the way you do it. Put it into a 2D array or even better, a
class. That's if you are familiar with OOP.
- Original Message -
From: Marco Bleeker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 04, 2001 6:57
Subject: PHP and MySQL result set navigation
I do something like this, where $result is the result of a mysql_query():
?php
while ($row = mysql_fetch_array($result))
{
if ($row[col] == 1)
{
print_entry($row);
}
}
?
This is to fill one column on screen. Now I would like to do the same for
the second column: if ($row[col] == 2). But the $result pointer has moved
to the end. How to move it back to the start again? reset() won't work,
because it's not an array, just an integer pointing to a MySQL result set.
How to move through this result set using PHP? Or should I just run a
seperate query for each column with a 'where col =' clause? That looks
like
pretty intensive use of computer resources... I could also turn the result
set into a 2D array of rows and work with that. Sounds a bit voluminous as
well...
Thanks, marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
| _`\,_
|__(*)/ (*)Ah, op DIE fiets !
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help plz.
ps -ef | grep mysqld is the command you want to check if the server is running. Can't say for sure what your problem is nor do I know what this ver 9.16 is but I do know that you are running an old version of mysql and I think freebsd as well. Sorry, I use linux so I'm not sure. The latest version of MySQL is 3.23.x and, from the list, freebsd is something like 4.x Try upgrading and you may find your problems will go away. Also do a search of the archive of this list. You may find something there in relation to freebsd. - Original Message - From: mysql novice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 15:29 Subject: help plz. hi, I'm using mysql Ver 9.16 Distrib 3.21.33b, for unknown-freebsd3.0 (i386) and i'm using 'C' program to interface with mysql database, I didn't get any compilation errors, but while executing i receive the following error : File '¡$Pè7' not found (Errcode: 1) Below is my code that gives this error /*** The part where i get the error ***/ conn = my_init(NULL); printf(\n Error : %s\n, my_error(conn) ); /*** End ***/ What w'd be the cause, w'd there be my requirement mysql process missing, how to check the needed process like 'mysqld' and others are running. Plz advice me. Regards. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: root password setting error, can you help?
They do work. Just need to follow instruction a little more closely, though I will agree with, the instructions do trip up many beginners. Remove the -p switch. It is only used if you have already set a password but since you haven't ... Also quotes around new-password aren't required. - Original Message - From: Jean-Philippe Durrios [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 14:21 Subject: root password setting error, can you help? Hi, How do I set the root password after installing MySQL server and client? I followed the after installation instructions,@they don'T work. mysqladmin -p password 'new-password' I don't get it. Thx for helping JP __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unicode
My mysql server is English but I have a chinese/english front end and users type in both Chinese English. - Original Message - From: md [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 21:22 Subject: Unicode Does anybody use mysql with Chinese or other Unicode based language. Any Japanese or Chinese MYSQL users out there? If so, please bounce me back a message. Mark Diener - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem wtih mysql GUI
1. Check that the connection is correct. 2. Check that the mysql server is running and that the socket file exists. 3. Check that the socket file is in the correct place and has the correct permissions. - Original Message - From: D. Veerasamy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 1:48 Subject: problem wtih mysql GUI Dear Sir/ Madam Can you please help me with the GUI client running under linux. I'm having an error message saying: Can't connect to local MySQL server through socket (111) Thanking you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem running old database with 3.23.30-gamma
What if you did try upgrading myism tables? I remember reading something about ism tables not being supported in the future anyway. - Original Message - From: Beverly Baird [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 2:33 Subject: Problem running old database with 3.23.30-gamma Hello, I have a database, called mace, that was collected under 3.21.?? It runs under 3.22.26a It runs under 3.23.28-gamma But what I need it to function with is 3.23.30-gamma When I try to run with 3.23.30-gamma I get the following: % mysql mace Reading table informatin for completino of table and column names You can turn off this feature to get a quicker start up with -A Didn't find any fields in table 'Contact' Didn't find any fields in table 'Craft' Didn't find any fields in table 'CraftActiveSensor' Didn't find any fields in table 'DataType' Didn't find any fields in table 'Environmental' Didn't find any fields in table 'NasSensor' Didn't find any fields in table 'Navigation' Didn't find any fields in table 'NonAcoustic' Didn't find any fields in table 'RawData' Didn't find any fields in table 'Sensor' Didn't find any fields in table 'RawData' Didn't find any fields in table 'Wavetrain' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection is is 637 to server version 3.23.30-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql If I start with a different database and then type mysql use mace; I get the same Didn't find any . . . . messages. If I type show tables; it displays all the tables happily. But queries yield mysql select count(*) from Craft; ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138) At first I thought it was an ISD, ISM / MSD, MSI problem. But the fact that I can install the same database on different machines (sparc and linux) and it works under 3.22. and 3.23. databases makes me think that's not the problem. (I believe the switch to MyISAM was at 3.23?) And it's supposed to be backwards compatible, and seems to be. The machine that is the problem is a linux box running RedHat 6.2. Thanks in advance Beverly Baird Digital System Resources 703-263-2849 [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: ACT2 Conversion
I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From: James McLaughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 4:03 Subject: ACT2 Conversion Has anyone had any luck or seen any HOWTO docs for converting a ACT2 DB to MySQL? We are moving away from prop windows software and into web based DB administration. Any help would be terrific. THanks Kat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help!!!!
The *nix prompt or the DOS prompt, depending on your OS. - Original Message - From: Jeff Davidson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 12:24 Subject: help Where do you enter the commands to install mySQL?? I know it's a stupid question, but please, enlighten me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi!
Well, if you're looking for an exe file, I would say you have downloaded the wrong version. You will need to download the correct version for Windows and read the manual on how to install. If you have other problems, you'll need to be more specific. - Original Message - From: Morgan Sagmo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 18:18 Subject: Hi! I dont understand this. I am trying to make a database...Have not done it before, and I have red about MySQL. I have downloaded mysql-3.23.38, mysqlgui-1.7.5 and fltk. I am not good at this database thing... must say...but what do I do now? I cant find any .exe files? How can I use MySQL? Please help me!!! regards Morgan *** Morgan Sagmo Norwegian University of Science and Technology (NTNU); Faculty of Electrical Engineering and Telecommunications; O.S.Bragstads plass 2E; N-7491 Trondheim;NORWAY Email: [EMAIL PROTECTED] [EMAIL PROTECTED] TLF: 73 59 42 87 FAX: 73 59 42 79 MOB: 91 57 02 37 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, UniData and ODBC question
I've never heard of UniData or Tru64 but if they are unix based, I have heard of a MyODBC for unix systems. Don't know much about it as most of my ODBC experience has been on Windoze platforms. - Original Message - From: Allen Belk [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 21:24 Subject: MySQL, UniData and ODBC question MySQL users, Our department is in the midst of reengineering the way data on our email server (MySQL on Linux) is kept in sync with the data on our administrative server (UniData on Tru64). I am not familiar with ODBC connectivity but from what I have heard and read, it might be our only hope of getting UniData and MySQL to communicate, even if on the most basic level. We have ODBC connectivity to UniData as well as our MySQL database but we need to figure out how to get UniData to access MySQL or vice versa. I was hoping to find a Perl DBI module for UniData but that search has turned up nothing. Any suggestions, comments or small nuggets of wisdom would be GREATLY appreciated. Thanks, Allen Belk | Allen Belk, Systems Administrator | Office of Information Technology | Saint Leo University, Saint Leo, FL | [EMAIL PROTECTED] - (352) 588-8592 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't change password in MySQL Windows version
It's a little difficult solving your problem as you have not provided as with samples of the commands you used, but 1. Check that the user exists in the first place. and 2. Did you use GRANT to set up a user in the first place? Not just insert a user into the tables. - Original Message - From: Ardianto Rustandi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 23:32 Subject: Can't change password in MySQL Windows version Hello all! Can anyone help me why I cannot change a user's password in the Windows version of MySQL (except for the root account)? I keep getting the ERROR 1133: Can't find any matching row in the user table error message everytime I try to change a user's password, both from mysqladmin and from SET PASSWORD command. FYI I'm using version 3.23.28-gamma running on Win98. Thanx in advance! Ardianto Rustandi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: what's the command to list all the tables in the DB
Firstly, you are way off topic. This is a MySQL list, not an Oracle list. Secondly, any good book on SQL in general will tell you how. - Original Message - From: Zhu George-CZZ010 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 4:48 Subject: what's the command to list all the tables in the DB Previously, I used SELECT table_name FROM tabs to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table names in that database (Oracle)? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
