Re: turn $2000.00 into $1600.00 in 14 days
Thanks, I`ll try it out. - Original Message - From: "Aaron Williams" [EMAIL PROTECTED] To: "Siim Einfeldt aka Itpunk" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 10:55 PM Subject: Re: turn $2000.00 into $1600.00 in 14 days At 10:25 PM +0200 2/2/01, Siim Einfeldt aka Itpunk wrote: I get an awful lot of spam to my private email as well, I could filter them, but does anyone know what is the best way to actually get to know where and from who the email has come from (as the from addresses lie 99% of the cases)? I personally use spamcop (www.spamcop.net). Just copy and paste the message with full headers into the form on the page, submit, and it parse out the headers to find out where it came from. It will ask you if you wish to send a notice to the contacts of those domains, which you can do by just clicking a button. I work for an ISP, and SpamCop is quite effective. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale Dial-Upwww.megapop.net =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [CGI] Gas Prices
Germany: 0,99 US$ per litre - Thats expensive, too. gOoD rIdE! Andy Dingfelder -Ursprngliche Nachricht- Von: Fbio Ottolini [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 2. Februar 2001 23:00 An: [EMAIL PROTECTED] Betreff: Re: [CGI] Gas Prices Brazil: US$0,825/litre - That's really expensive!!! BR, Fbio Ottolini - Original Message - From: "Solomon Sokolovsky" [EMAIL PROTECTED] To: "Marko Sarunac" [EMAIL PROTECTED]; "Redvers Davies" [EMAIL PROTECTED] Cc: "mySQL Mailing List" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 10:19 PM Subject: RE: [CGI] Gas Prices Here in Australia 90 cents (AUSD)per litre thats about 58 cents USD. We consider this very expensive! -Original Message- From: Marko Sarunac [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:55 AM To: Redvers Davies Cc: mySQL Mailing List Subject: Re: [CGI] Gas Prices And i thought 72.9 Cents (Canadian) per litre was expensive :( Redvers Davies [EMAIL PROTECTED] on 02/01/2001 09:03:19 AM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] (Ray Ray), [EMAIL PROTECTED] (mySQL Mailing List), [EMAIL PROTECTED] (Jeff Hunt), [EMAIL PROTECTED] (Ed Holmes), [EMAIL PROTECTED] (Chris Goehrig), [EMAIL PROTECTED] (CGI Mailing List), [EMAIL PROTECTED] (Bill Turay), [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] (bcc: Marko Sarunac/ISM-BC) Subject: Re: [CGI] Gas Prices By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BETWEEN problem?
Maybe you should try SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN (0.7*63000) and (1.3*63000) ; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 3:53 AM Subject: BETWEEN problem? Can anyone explain the following results to me? I am trying to find all values +/- 30% from a number... value is declared as: | value | int(10) unsigned Note that 1.3*63000 is 81900... The first two are apparently correct: mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 1.3*63000 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.10 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 81900 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.08 sec) These next two should give the same result, but... mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 81900 ; +--+ | count(*) | +--+ | 47 | +--+ 1 row in set (0.08 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 1.3*63000 ; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.08 sec) 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
Re: Update
Use CONCAT - Original Message - From: Sanjeev Adhyapak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 6:42 AM Subject: Update Dear Sir, I want to update one table. situation is like this. i have a table with 3 columns. tablename - sample Fields no - integer str1 - varchar(100) str2 - varchar(100) Now i want to update the table contents like str1 = str1 + str2 for all the records. I used the update statement like this update sample set str1 = str1 + str2; But is resulted in 0 value in the field str1. Can anybody suggest the way to do it. Thank you, sanjeev. _ 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: From Windows access to MySQL on Linux
On Sat, 3 Feb 2001, Kiky wrote: Dear all, I have to work wih PHP on Win 98/Win 2K, but I have to access MySQL on Linux. At the first time, I was trying to use ASP and using ODBC to access MySQL on Linux, but the problem is that installing additional components, even for MySQL driver - ODBC is not allowed by our company policy. My question is that : is it possible to have a direct access to MySQL on Linux, if I use PHP on Windows ? Yes, you can add a mysql user that has access to mysql server from the windows host and use this user to create the connection. Direct access I mean here is : the same access support if I put PHP and MySQL both on Linux (no ODBC needed, etc). Any help would be very much appreciated. Sincerely, Helen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: From Windows access to MySQL on Linux
Thank you for your reply :-)
Yes, you can add a mysql user that has access to mysql server from the
windows host and use this user to create the connection.
## Is it possible to do this in PHP under Windows, without installing
any
mysql driver for ODBC, or any other additional installation ?
Can I just do the same way of connection to mysql database, just like
the one
I use in PHP under Linux ?
mysql_connect("127.0.0.1", "root", "");
mysql_select_db("my_database")
Thank you,
Helen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie - quoute question
Hi, i'm very new working with MYSQL, i have a problem with the type VARCHAR for plantnames, - MYSQL use single qoutes for a field - i have a plantdatabase, to use the correct spelling latin names cultivar names are wirting between qoutes Example: - For MYSQL i have to use this (I think) for the field Name VARCHAR (150) : 'Acer platanoides Globosum' ; - for a good use of plantnames i need this: Name VARCHAR (150) : 'Acer platanoides 'Globosum' ' ; ...it seems that doesn't work quit well for MYSQL:) Any idea if there is possebility to work arround this? Groetjes, Rudi Van Overloop, [EMAIL PROTECTED] Belgium - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help :- To Upload a local Database.
Hello !! I'm trying to upload my database that's build locally on Win ME machine to a remote Linux server . I'm using Ace-Ftp to upload my normal files. But i couldn't seem to find the data files to which i can upload my database thro' Ace-Ftp . I've heard that uploading the database needs to done thro' Telnet . I'm least aware of this application . Could anyone pls throw light on any applications which allows to upload the database in GUI format ? Or the method using Telnet ? Preferably the former . Any help would be greatly appreciated . Thank You Regards Donald
Update Question
How can i do an update a column in a table width the fields of another table i would like to do the folowing query: UPDATE enc_oper set estado = "N", quant_prod = 1 * opera.quantidade whe re encomenda = 20010004580 and posicao = 1 and opera.codigo = enc_prod.opera; But i dont know how to get the value from table opera. Can someone help 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: BETWEEN problem?
Maybe you should try SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN (0.7*63000) and (1.3*63000) ; Hmm -- I thought, yes! But... mysql select count(*) from bench where year = 95 and - value between (0.7*63000) and (1.3*63000); +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.08 sec) I can, of course use the non-BETWEEN syntax, though this problem would steer me away from BETWEEN from now on... Thanks - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 3:53 AM Subject: BETWEEN problem? Can anyone explain the following results to me? I am trying to find all values +/- 30% from a number... value is declared as: | value | int(10) unsigned Note that 1.3*63000 is 81900... The first two are apparently correct: mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 1.3*63000 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.10 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 81900 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.08 sec) These next two should give the same result, but... mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 81900 ; +--+ | count(*) | +--+ | 47 | +--+ 1 row in set (0.08 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 1.3*63000 ; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.08 sec) 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
bug? in OPTIMIZE TABLE command
Description:
If I use a table containing AUTO_INCREMENT field, and I have there
a 0 value, OPTIMIZE TABLE will fail.
How-To-Repeat:
CREATE TABLE test(
ID DECIMAL(5,0) NOT NULL AUTO_INCREMENT,
text CHAR(20) NOT NULL,
PRIMARY KEY(ID)); // or INDEX(ID))
INSERT INTO test(text) VALUES('sample');
UPDATE test SET ID=0 WHERE ID=1;
INSERT INTO test(text) VALUES('sample-2');
SELECT * FROM test;
ID text
-
0 sample
1 sample-2
OPTIMIZE TABLE; //ERROR: 1062
If I used INDEX(ID) not PRIMARY KEY(ID), OPTIMIZE TABLE doesn't
fail, but data will be corrupted:
SELECT * FROM test;
ID text
-
1 sample !!
1 sample-2!!
Fix:
I don't use optimize table, but PLEASE don't make inpossible to
insert 0 value to an AUTO_INCREMENT field!
Submitter-Id: submitter ID
Originator:Nemeth Istvan
Organization: JAK
organization of PR author (multiple lines)
MySQL support: none
Synopsis: problem with OPTIMIZE TABLE
Severity: non-critical
Priority: medium
Category: mysql
Class: sw-bug
Release:mysql-3.22.32 (Source distribution)
Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i586
TCX Datakonsult AB, by Monty
Server version 3.22.32-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 51 days 7 hours 33 min 43 sec
Threads: 1 Questions: 16086 Slow queries: 11 Opens: 104 Flush tables: 4 Open
tables: 13
Environment:
AMD K6-2 450, 192M RAM, 30G HDD, Debian Linux 2.2
System: Linux linux 2.2.17 #3 Tue Dec 5 16:13:05 CET 2000 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 2220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
Configure command: ./configure --enable-shared --without-readline --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info
--includedir=/usr/include --mandir=/usr/share/man
Perl: This is perl, version 5.005_03 built for i386-linux
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Syntax list
At 10:09 PM +0200 2/2/01, Ciprian wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* Anybody knows where I can find a list with all SQL syntax -es. Eventually explained. Thanks If you mean the SQL statements supported by MySQL, the MySQL Reference Manual is a good source. If you're looking for something that covers SQL in general, try "SQL-99 Complete, Really" (Gulutzan and Pelzer). If you mean something else, please be more specific. -- Paul DuBois, [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
Web Interface
I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Web Interface
Webmin is robust and it gives a good database interface... You can customize it to only perform Database Administration Check www.webmin.com Regards Claudio -Mensaje original- De: John Williams [mailto:[EMAIL PROTECTED]] Enviado el: Saturday, February 03, 2001 4:44 PM Para: [EMAIL PROTECTED] Asunto: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Web Interface
http://www.php.net/ http://httpd.apache.org/ John Williams wrote: I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Web Interface
Webmin www.webmin.com -Original Message- From: John Williams [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 03, 2001 1:44 PM To: [EMAIL PROTECTED] Subject: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Web Interface
You might want to try the php-nuke 'construction kit'. Looks good (www.wageningen.org was build using this, take a look) - Original Message - From: "John Williams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 8:44 PM Subject: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.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
Problem with Match / Against and multi-table join
I am trying to write a query using the fulltext and match and I've run into a problem.
I'm new to MySQL, so this question might have already been asked, but I just can't
seem to find it.
I'm using the fulltext capabilities to do a query. The query requires joins with four
different tables. The problem that I've run into is once I add the fourth table, the
match column no longer has any value -- it's always zero. I'm running version 3.23.32
on a Windows 2000 server machine.
Query 1: Works as expected
select message.thread_id, message.forum_id, message.user_id, message.created, match
message.body against ('test') as score,
thread.thread_title, user.username
from message,thread,user
where message.thread_id = thread.thread_id
and message.user_id=user.user_id
order by score desc limit 10
Query 2: Returns rows (the joins are working), but match column is zero for every
record.
The only difference is the addition of the forum table (adding forum.title as a
column, and adding a join condition in the where clause)
select message.thread_id, message.forum_id, message.user_id, message.created, match
message.body against ('test') as score,
thread.thread_title, user.username, forum.title
from message,thread,user,forum
where message.forum_id = forum.forum_id
and message.thread_id = thread.thread_id
and message.user_id=user.user_id
order by score desc limit 10
Am I missing the point with all this? Should I be doing a match...limit x into a
temporary table and then do my join against that?
I would appreciate any help anyone can offer.
Load Data question
Hello, what is the correct syntax forignore? I have a table with columsn already put in, and primary key has 0 as value. When I do "load data infil 'file.txt'... it gives a duplicate error. Documentation says to use 'ignore'. But I can't get it to work. What is the *correct* syntax to load a file with columns to *overwrite* what I have in a table? It would make life easier as all the 'gui' software is either confusing, in another language, or doesn't work. Thanks
Need join order help
Background info: One main table with basic entry info joined to other tables with additional info about the entry. The additional info about the entry is based on the entry type and is located in single other table (which other table depends on the entry type). - table LOG_LOG (this is the main table that is joined to other tables.) Fields Type Null Key LOG_IDbigint(20)PRIauto_increment LOGGED_DATEdatetime yes ENTRY_DATE datetime yes CREW_POSITIONvarchar(10)yes LOGGER varchar(5) yes TBL_NAME varchar(255) REMARKS text yes Keys PRIMARYUnique Field = LOG_ID LOG_LOGField = LOG_ID - table SAT_GEN (this is one of the tables that has more information about that type of entry) Fields Type Null Key SAT_GEN_ID int(11)PRIauto_increment LOGID bigint(20)Unique SAT_GEN_FLTvarchar(10)yes Keys PRIMARYUnique Field = SAT_GEN_ID SAT_GENField = SAT_ID LOGID Unique Field = LOGID - table SAT_CMD (this is another table that has more information about this type of entry) Fields Type Null Key SAT_CMD_ID int(11) PRIauto_increment LOGID bigint(20) Unique SAT_CMD_FLTvarchar(10) yes SAT_CMD_CMD varchar(255) yes SAT_CMD_Tvarchar(8) yes SAT_CMD_Vvarchar(8) yes SAT_CMD_GO char(1) yes Keys PRIMARY Unique Field = SAT_CMD_ID SAT_CMD_IDUnique Field = SAT_CMD_ID LOGID Unique Field = LOGID Now, to get the data and display it correctly I use a select to get all the data (it will be limited by date range) and display it correctly. Since each entry can be of a different type I first check the value of the TBL_NAME field and then know what type of entry it is so I can look at the correct field names and display it correctly. Finaly the problem. The SQL select below puts the joins in the wrong order. SELECT LOG_LOG.LOG_ID, LOG_LOG.ENTRY_DATE, CONCAT(DATE_FORMAT(LOG_LOG.ENTRY_DATE,'%Y'),':',DATE_FORMAT(LOG_LOG.ENTRY_DATE,'%j')) AS ENTRY_JULIAN, DATE_FORMAT(LOG_LOG.ENTRY_DATE,'%T') AS ENTRY_TIME, LOG_LOG.CREW_POSITION, LOG_LOG.LOGGER, LOG_LOG.TBL_NAME, LOG_LOG.REMARKS, SAT_GEN.LOGID, SAT_GEN.SAT_GEN_FLT, SAT_CMD.LOGID, SAT_CMD.SAT_CMD_FLT, SAT_CMD.SAT_CMD_CMD, SAT_CMD.SAT_CMD_T, SAT_CMD.SAT_CMD_V, SAT_CMD.SAT_CMD_GO FROM LOG_LOG, SAT_GEN, SAT_CMD WHERE LOG_LOG.LOG_ID=SAT_GEN.LOGID AND LOG_LOG.LOG_ID=SAT_CMD.LOGID; This is the EXPLAIN output for the select statement. LOG_LOG should be the first table as it is the main table that all others are joined to. table type possible_keys key key_len ref rows Extra SAT_CMD ALL LOGID NULL NULL NULL 8 LOG_LOG eq_ref PRIMARY,LOG_LOG PRIMARY 8 SAT_CMD.LOGID 1 SAT_GEN eq_ref LOGID LOGID 8 LOG_LOG.LOG_ID 1 I can't figure out how to force the correct join order to get all entries in LOG_LOG and matching entries in the other two tables (there will be many more tables later). I tried various STRAIT_JOIN syntaxes but everything I tried gives me an error. Question: How do I use STRAIT_JOIN to force the correct order? Bigger Question: Am I using a reasonable method of accomplishing this task in the first place i.e. is there a better schema? (this will be a web-based intranet application. Thanks and sorry about the lenght of the question. Chuck Murison
BIG! bug in replication
Description: As i wrote before, there's a bug with the replication in mysql. If the server is once stopped, it will not read properly the informations stored in master.info. The IP-number is in this case 0. Mysqld will then write the error-message to the log-file AND will not stop writing it! The log-file was in my case 2.7 GB big and my machine stopped working properly. After deleting this big file and deleting(more important) the master.info file, the mysqld(started over of course) is working well, but replication is not working. In my opinion a very big bug. Sorry for my english How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.27-beta (Source distribution) Environment: System: Linux hb 2.2.14 #5 Tue May 23 11:14:03 MEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 4061504 Mar 11 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19182842 Mar 11 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mar 11 2000 /usr/lib/libc.so -rw-r--r-- 1 root root 2058488 Mar 11 2000 /usr/lib/libc-client.a lrwxrwxrwx 1 root root 20 May 18 2000 /usr/lib/libc-client.so - ./libc-client.so.4.7 -rwxr-xr-x 1 root root 721492 Mar 11 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure Perl: This is perl, version 5.005_03 built for i586-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: Intersection of two lists
In the last episode (Feb 01), Jeff Sorenson said:
Does anyone know of an elegant way to determine, within a query, whether
two arbitrary lists have common element?
I am quite fond of queries using "in", e.g: select * from A where 23 in
(A.list) - where A.list is a comma-separated list of numbers in a
varchar(255) field.
Now I need something like: select * from A where (23,43,21,52,74) in
(A.list) to work - but it doesn't.
...
I suppose what I'm looking for is the equivolent of an "intersection"
operation between two sets. But I can't use MySql sets because they are
bit fields that allow only 64 members. Does anyone know a more efficient
or elegant way to do this with MySQL?
You should be able to create a UDF set_intersect() function that takes
two comma-delimited strings and returns a list of the common
elements. Then you could do
WHERE set_intersect("23,43,21,52,74", A.list) != ""
--
Dan Nelson
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP does not work after upgrading MySQL to 3.23.32
I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fábio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 does not work after upgrading MySQL to 3.23.32
Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fbio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: From Windows access to MySQL on Linux
At 10:15 PM +0700 2/3/01, Kiky wrote:
Thank you for your reply :-)
Yes, you can add a mysql user that has access to mysql server from the
windows host and use this user to create the connection.
## Is it possible to do this in PHP under Windows, without installing
any
mysql driver for ODBC, or any other additional installation ?
Can I just do the same way of connection to mysql database, just like
the one
I use in PHP under Linux ?
mysql_connect("127.0.0.1", "root", "");
mysql_select_db("my_database")
Just replace '127.0.0.1' (a.k.a. 'localhost') with the database
server's ip address or name. Some things you have to be sure of to do
this:
(1) The database server machine's mysql wasn't started with
--skip-networking (I'm pretty sure that's the parameter); if it was,
MySQL won't be listening to the internet at all, and will need to be
restarted without that parameter.
(2) Make sure the server's permission tables will allow access from
your web server - see the GRANT command;
(3) Make sure the database server isn't behind a firewall or
something that restricts internet access to the MySQL port (normally
3306)
If all these conditions are met, your the database server can be
anywhere. Keep in mind, though, that if your query returns a large
number of results, response will be limited by the speed of the
network(s) between the two machines.
- steve
Thank you,
Helen
--
+--- "They've got a cherry pie there, that'll kill ya" --+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+-- FBI Special Agent Dale Cooper ---+
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP does not work after upgrading MySQL to 3.23.32
Sorry but I'm not a Linux specialist... I think WE are going to need the help of others. :) Anyway... Now you gave enough details to get help. BR, Fábio Ottolini - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fábio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fábio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 does not work after upgrading MySQL to 3.23.32
On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fbio Ottolini wrote: Sorry but I'm not a Linux specialist... I think WE are going to need the help of others. :) Anyway... Now you gave enough details to get help. Tim, I suggest you look for a new file called libmysqlclient.so (maybe in another location) and symlink libmysqlclient.so.6 against it. After that run 'ldconfig' and try to restart apache. Greetings, - Rop Slijkerman BR, Fbio Ottolini - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 does not work after upgrading MySQL to 3.23.32
Hey Rop, wist je wel dat ik het was (Tim van Rockingstone). wat toevallig dat je zat mee te kijken. (beetje laat of niet?) bedankt voor de tip. Tim Samshuijzen. (Sorry for the Dutch everyone) At 02:49 4-2-2001 +0100, you wrote: On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fbio Ottolini wrote: Sorry but I'm not a Linux specialist... I think WE are going to need the help of others. :) Anyway... Now you gave enough details to get help. Tim, I suggest you look for a new file called libmysqlclient.so (maybe in another location) and symlink libmysqlclient.so.6 against it. After that run 'ldconfig' and try to restart apache. Greetings, - Rop Slijkerman BR, Fbio Ottolini - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 does not work after upgrading MySQL to 3.23.32
The mysql version compiled into your web server uses shared libraries and your current version (upgrade) apparently is a statically linked version. Recompile your web server/php/mysql executable with consistent use of libraries i.e. either static or shared. I hope this helps... Pat... - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 7:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fbio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP does not work after upgrading MySQL to 3.23.32
I have no experience with recompiling libraries (I know this must sound dumb). I am a bit desperate, so I tried some other things. So I solved it by copying ./lib/mysql/libmysqlclient.so.6 from version 3.22.32 to the same path in version 3.23.32. I then restarted httpd. I don't know how dangerous this is, but it works! I will keep it this way untill someone here can recompile the libraries. Thanks! Tim Samshuijzen At 21:02 3-2-2001 -0500, you wrote: The mysql version compiled into your web server uses shared libraries and your current version (upgrade) apparently is a statically linked version. Recompile your web server/php/mysql executable with consistent use of libraries i.e. either static or shared. I hope this helps... Pat... - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 7:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fbio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL NT Service Question
Hello all. We are currently using MS Access for a multi-user application (4-5 clients). We sent out a system to a customer with NT Service enabled in anticipation of switching over to MySQL. We noticed that when activity on the MS database got heavy (if you can call 3 clients heavy activity) that our application that was talking to it would hang alot. It's a small network using TCP/IP over NetBEUI with a Win2K Box in the back with 128 MB RAM/PIII 666 MHz. When I un-installed the MySQL NT Service (3.23 Gamma) the problem disapeared. Any Ideas (other than stop using MS Access)? Lee Jenkins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 does not work after upgrading MySQL to 3.23.32
Uhhh... You probably need to either recompile Apache and or PHP with your new version of MySQL. Copying the old library over the new one is going to cause problems. I have no experience with recompiling libraries (I know this must sound dumb). I am a bit desperate, so I tried some other things. So I solved it by copying ./lib/mysql/libmysqlclient.so.6 from version 3.22.32 to the same path in version 3.23.32. I then restarted httpd. I don't know how dangerous this is, but it works! I will keep it this way untill someone here can recompile the libraries. Thanks! Tim Samshuijzen At 21:02 3-2-2001 -0500, you wrote: The mysql version compiled into your web server uses shared libraries and your current version (upgrade) apparently is a statically linked version. Recompile your web server/php/mysql executable with consistent use of libraries i.e. either static or shared. I hope this helps... Pat... - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 7:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fábio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fábio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Web Interface
Thanks to everyone who replied. I got a lot of people who said I should either use phpMyAdmin or webadmin. It turns out that neither will quite do what I need it to, and I just wanted to try to get any other suggestions. In particular, the former doesn't allow one to put any kind of good security on the pages s.t. a user needs a password to do things, w/o a good deal of recoding. The latter requires root access on a server, which I don't have. Does anyone have any other suggestions? Thanks again, John On 3 Feb 2001, at 19:44, John Williams wrote: I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.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
when does inserting become too much of an overhead?
Hi there, I am considering porting a MS-SQLServer database to MySQL. After reading some of the documentation, I am concerned about inserts. I run a sports prediction website, where players submit their predictions for a competition. When a player submits their predictions, this is generally 10 inserts into each of 3 different tables. It is not feasible to store these inserts in a pool and execute them later - they must be done so that the player receives confirmation that their predictions were submitted straight away - their predictions must also be submitted by a certain time so the time they submitted them must be accurate. The website generally gets busy on a friday afternoon as that is when most people want to submit their predictions. Hence I need the database to be able to inserts thousands of records per second - how much would MySQL be able to handle? Another problem I foresee is that this table is also used for people to view the predictions of other users. So a common query is something like "SELECT tip FROM UserTippingInfo WHERE userid = x AND matchnumber = y". Would I be best to keep the in the one table or should I create a View on the table or a copy of the table to query? thx for your help Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: binary data
Hi okie heres a snippet of my php code:
the code below takes a file uploaded from the web with $file as declared filename on
the form.
if ($file_size0) { //check whether the file is not empty
$data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and
add neccessary quotes
$SQL="Insert into Files (Filename,Filetype,Filesize,data) values
('$file_name','$file_type','$file_size','$data')"; //SQL commands to insert into table
named 'FILES'
$result = mysql_query ($SQL)
or die ("ERROR Uploading File:".mysql_errno().": ".mysql_error()."BR$SQL");
}
okie hope that helps!
Teddy
"Robert C. Paulsen Jr." wrote:
On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
I have the scripts in php to do this if u want.
Yes, that would help! thanks.
"Robert C. Paulsen Jr." wrote:
How can I put binary data into a MySQL database?
I assume the data type is blob, but I don't see how I can
use SQL syntax to insert anything but text data. I would
like to include various binary files (tar files, zip files,
image files, etc.).
--
Robert Paulsen [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
