Re: How to get it in ONE query?
Hi, No, you can't get both in one query. Anyway, you probably want to see how many results would be returned in the first place, before deciding on sensible LIMIT clause parameters. And you may want to add an ORDER BY clause to your second query, so that you can rely on the order in which the results are returned. If speed is the reason for your worries, why not add an index on 'price'? Jan michalm wrote: I need to get information about number of all rows produced by query 1) and information produced by limited query 2). I can do this in these 2 queries. |---| |How to get it in ONE query?| |---| 1) mysql SELECT count(*) FROM t_what WHERE price25; +--+ | count(*) | +--+ | 25 | +--+ 1 row in set (0.00 sec) 2) mysql SELECT what_oid, what_pl_name FROM t_what WHERE price25 LIMIT 0,10; +--+--+ | what_oid | what_pl_name | +--+--+ |1 | Misja| |2 | System | |3 | Clueless | |4 | Fortepian| |5 | Sebastian| |6 | Carrington | |7 | Casablanca | |8 | Dziwne dni | |9 | Wyliczanka | | 10 | Mozarella| +--+--+ 10 rows in set (0.02 sec) Michael Mierzejewskimailto:[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
Pb with configure
Description: checking return type of sprintf... configure: error: can not run test program while cross compiling How-To-Repeat: just launch ./configure Fix: ? Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: ATCHIK MySQL support: none Synopsis: checking return type of sprintf... configure: error: can not run test program while cross compiling Severity: critical Priority: high Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Environment: System: SunOS Solstice 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1610172 Mar 31 08:09 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 10 08:33 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Mar 31 08:09 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1610172 Mar 31 08:09 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 10 08:33 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1015768 Mar 31 08:09 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory - -with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berk eley-db --with-innobase Perl: This is perl, version 5.005_03 built for sun4-solaris Michel AVERSENG 05 31 34 77 05 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hi is there anyone on the list fron Pune, India who can lend me a MySql CD for a while. my installation is not taking off.. Thanks Mihir Telephone: 020 5281296
version
How can I replace MySql 3.22.xx with MySql 3.23.34. Uninstall 3.22.xx ? Thx. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl MySQL Interface
let perl -MCPAN -e shell be your friend i /mysql/ will show you all the mysql stuff or i /dbi/ even On Thursday 12 April 2001 01:16, Chris Becker wrote: go to perl.com - click CPAN and look for DBI and DBD, and look for docs on how to install a perl module. You need to install DBI first, then DBD... hope this helps. Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === -Original Message- From: Brian Cassidy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 3:59 PM To: [EMAIL PROTECTED] Subject: Perl MySQL Interface I have installed MySQL 3.23 on RedHat 7 using the rpms. Installing the bench rpm gives "MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.36-1". I can't seem to locate any version of this dbi which will install. I see that mysql.com has a perl dbd module for MySQL but that is not an rpm. Is that what I need? If so, how do I install it? --- Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: client problems
On Tue, 10 Apr 2001, Erik Kabo wrote: Date: Tue, 10 Apr 2001 18:37:17 -0400 From: Erik Kabo [EMAIL PROTECTED] Reply-To: Erik Kabo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: client problems Hi, I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I installed it, the server appears to be working fine, but there is no client software. I try running "mysql" at the command prompt, but I get a command not found error. I tried the GUI on your download page, but it just stalls at the splash screen when I try to run it. Can you tell me where to get a client that works? Thanks, Erik [EMAIL PROTECTED] I needed to install MySQL rpm AND MySQL-client rpm in Mandrake 7.1 jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Having a big problem in libmysqlclient.a with apache and php
On 11 Apr 2001, at 18:07, Mohamed Ould wrote: apache "make" abort with these errors: usr/local/mysql/lib/libmysqlclient.a(my_compress.o ): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress. o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Erreur 1 make[2]: Look at what "make" is telling you Mohamed. During the linking stage of the make process the linker (ld) cannot find references to either uncompress or compress. This means that gcc, which calls the linker, cannot find zlib. This can be due to either: - Missing library, or - Misconfigured library search path (unlikely) Normally zlib lives in /usr/lib. Check to see if you have a number of files like: libz.a libz.so libz.so.1 libz.so.1.1.3 libzvt.a libzvt.so libzvt.so.2 libzvt.so.2.2.3 (ls /usr/lib/libz*) If not, find them and stick them there. Check also that /etc/ld.so.conf contains /usr/lib as a library search path. You can also run ldconfig -p | less to see what search paths are configured. Sometimes RPM doesn't work too well. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, NT 4.0 WS, and Access 2000
In your odbc setup did you give the host name that you defined on the linux box? Adrian On Wed, 11 Apr 2001, Fenn Rider wrote: I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting to a MySQL db running on a linux box. When I try to connect, I get a dialoge that says: ODBC -- call failed. [TCX][MyODBC]Host '' is not allowed to connect to this MySQL server (#1130). I have set up the host and user in the sql db in question (tried blank and substantive passwords). The error message makes me think that it the value for 'host' is not getting sent or something. Anyone else run into this? Fenn Rider Network Manager BridgePath, Inc 1663 Mission Street, 5th Floor San Francisco, CA 94103 Ph: 415-946-6003 Fax: 415-946-6001 [EMAIL PROTECTED] http://www.bridgepath.com/ co-opetition -n. competitors working collaboratively The BridgePath Exchange helps staffing firms work together (co-opetition) to reduce unfilled job orders and unplaced candidates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I Need your help
On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote: Good morning, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word1%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement INTERSECT select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word2%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement Thank you. Is this an late April Fool's prank? Why not use OR with the (M.Mot like 'wordX%') phrases? AFAIK there is no INTERSECT verb in MySQL. Is there? David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connect/pconnect performance
Hi. I use persistent connections opened from php scripts. For what I read in the manual, when a client try to connect to the same server, same database , same user, same password, if a persistent connection is already open, it should use that mysql link, never open another persistent connection. From my office, I execute the php script a couple of times from 2 or 3 different computers and this is what I get running mysqladmin: +--++---+--+-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info | +--++---+--+-+--+---+--+ | 1929 | delfos | localhost | delfos_hotel | Sleep | 221 | | | | 1931 | delfos | localhost | delfos_hotel | Sleep | 13 | | | | 1932 | delfos | localhost | delfos_hotel | Sleep | 46 | | | | 1934 | delfos | localhost | delfos_hotel | Sleep | 32 | | | | 1937 | delfos | localhost | delfos_hotel | Sleep | 159 | | | | 1939 | delfos | localhost | delfos_hotel | Sleep | 23 | | | | 1941 | delfos | localhost | delfos_hotel | Sleep | 55 | | | | 1942 | delfos | localhost | delfos_hotel | Sleep | 50 | | | | 1947 | root | localhost | | Query | 0| | show processlist | +--++---+--+-+--+---+--+ I have 9 more databases which are used the same way, so, I have generally 80 mysqld processes running in my poor little pentium processor, each one of them uses the 4.1% of my RAM. How can I solve this problem?? (without using no persistent connections). I'm using RedHat Linux 6.2 mysql: /usr/local/mysql/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.32 Protocol version10 Connection Localhost via UNIX socket httpd: Server version: Apache/1.3.14 (Unix) Server built: Nov 8 2000 11:11:59 Server compiled with -D EAPI -D HAVE_MMAP -D HAVE_SHMGET -D USE_SHMGET_SCOREBOARD -D USE_MMAP_FILES -D USE_FCNTL_SERIALIZED_ACCEPT -D HTTPD_ROOT="/usr/local/apache" -D SUEXEC_BIN="/usr/local/apache/bin/suexec" -D DEFAULT_PIDLOG="logs/httpd.pid" -D DEFAULT_SCOREBOARD="logs/httpd.scoreboard" -D DEFAULT_LOCKFILE="logs/httpd.lock" -D DEFAULT_XFERLOG="logs/access_log" -D DEFAULT_ERRORLOG="logs/error_log" -D TYPES_CONFIG_FILE="conf/mime.types" -D SERVER_CONFIG_FILE="conf/httpd.conf" -D ACCESS_CONFIG_FILE="conf/access.conf" -D RESOURCE_CONFIG_FILE="conf/srm.conf" php PHP Version 4.0.4 Build Date Jan 29 2001 Configure Command './configure' '--with-mysql=/usr/local/mysql' '--with-apxs=/usr/local/apache/bin/apxs' Server API Apache Virtual Directory Support disabled ZEND_DEBUG disabled Thread Safety disabled php-mysql: Active Persistent Links 8 Active Links 8 Client API version 3.22.32 Thanks in advance. Sam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 and PHP issue
I want to be able to change menu items on the fly instead of having to modify
the html code manually. Some of the menu item links change a lot or I need to
add additional menus. Keeping the menus in a database allows me to edit/change
the menu items easily from the web page
Thanks
Rolf Hopkins wrote:
This doesn't look easy and I don't have time to sit down and think about it
but I'll give a couple of suggestions.
1. An ORDER BY clause may help. When you go through the list, you will then
need to detect a change in "menu level".
2. Why do the menu items need to be in a database anyway? Just have
"static" menus in your web pages. There are a number of ways to bring up
menu items, as you described, using javascript:
- Original Message -
From: "David" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 8:59
Subject: MySQL and PHP issue
I tried posting this in the PHP newsgroup but received no response so
thought I would try here since issue involves MySQL
I am trying to make a simple HTML menu system with data stored in a
MySQL database.. I am having problems displaying menu links under the
correct submenu from a loop.
I have a database with two tables. One table holds menu and sub menu
headings and
the other table holds the contents of each submenu (the actual menu
links and
names). I need to display the menu title and then the sub menu title
from table 1 and
then display the submenu contents or links from table 2 and then display
the next set
of links under the correct submenu
Example output would look like this:
Say person clicks on Admin menu which is already displayed then the
networking
submenu heading will display along with the submenu links:
Example: Admin(main menu title from db
table 1)
Networking(submenu title , from
db table 1
ping(Link to ping
from db table 2)
traceroute (Link to ping from
db table 2)
nsloopup etc
I don't know how to go about outputing the links under the correct
submenu. The
main menu is no problem. I am thinking I would need a loop within a
loop.
The query I use: $query = "SELECT * FROM menutable, elementstable WHERE
menutable.menutable_id = elementstable.menuid AND menutable.mainmenu =
'Admin' ";
$result = mysql_db_query("menus", $query);
This loop simply assigns variables and prints out all output under the
main menu
called Admin. The problem is how do I display
while ($r = mysql_fetch_array($result)) {
// start menu table (table holds main menu/sub menu headings
$menutable_id = $r["menutable_id"];
$menunumber = $r["menunumber"];
$mainmenu = $r["mainmenu"];
$submenu = $r["submenu"];
// start elements table (table that holds the links and names of each
link)
// element_id references menu table
$element_id = $r["element_id"];
$element = $r["element"];
$url = $r["url"];
$menuid = $r["menuid"];
// next display data this is wrong cause it displays 1 submenu and 1
link looping
?
TD? echo "$submenu"; ?/TD
TDa href="? echo "$url"; ? " ? echo "$element"; ?/a /TD
?
// this doesn't work
if ($menutable_id == $menuid) {
?
TD? echo "equal $submenu"; ?/TD
?
// print "both equal";
//
// $b = $a;
}
?
Notes:
Loop de loop:
// outer loop display submenus (when submenu changes display next set
of elements
or links from inner loop) if submenu changes then display next set of
menu links for
that submenu
// inner loop display elements or links for that submenu until sub menu
changes
MySQL and PHP4 latest using Linux OS
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
col_name(length) index and INNOBASE problem
Bonjour,
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many, the result is
the same :
insert into test values('A','ABCDEF');
I check that the row is in the table :
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
I check the indexes in the table :
mysql show index from test;
+---++--+--+--+---+-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
|Cardinality | Sub_part | Packed | Comment |
+---++--+--+--+---+-+--++-+
| test | 0 | PRIMARY |1 | symbole | A |
|NULL | NULL | NULL | |
| test | 1 | id_lib |1 | libelle | A |
|NULL |1 | NULL | |
+---++--+--+--+---+-+--++-+
2 rows in set (0.00 sec)
But here is the problem :
mysql select * from test where libelle like 'A%';
Empty set (0.00 sec)
mysql select * from test where libelle like 'a%';
Empty set (0.00 sec)
This bug does not occur with a MyISAM table.
We use Myslq-3.23.26 with latest Solaris patch from Heikki, under
Solaris 2.8 and SPARC 4 CPU.
Regards,
Alex.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
change default delimiter
Hi, Can somebody help me, with changing the default delimiters of MySQL. For Example I want to change the single quotes that enclose a string in an INSERT statement to #. How can it be done. Thanks in advance. Shambhu kumar Singh. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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
Insert Problem in C API
Hi, I am running a query using C APIs to insert a large text item into a MySQL table. The query is as follows sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. Help is urgently required. Thanks in advance. Shambhu kumar Singh. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: mysql uses 99% cpu under freebsd 4.3
Jeremy Zawodny writes:
On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote:
This seems to be a problem with threads on FreeBSD, although on
which side, yet remains to be seen.
It seems to appear that it is surfacing not just under heavy load,
but when there are many threads running. Many means more then 300 or
400.
The bug that I had we reproducible with only two client threads. It
just required a fair amount of data to reproduce the problem in a
short amount of time.
Also, if you end up at a dead end and need the help of a FreeBSD
internals guru, let me know. We happen to have a few of them on
staff.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951
Thanks for your offer !!
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problem in C API
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser and the data after the quote is ignored resulting in an error. use: /* unsigned int mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned int length) */ mysql_real_escape_string(ms, szQuery, mydata, strlen(mydata)); then: sprintf(szQuery, "INSERT INTO mytable(mycol) VALUES '%s'", szQuery); as stated from: http://www.mysql.com/doc/m/y/mysql_real_escape_string.html -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 and PHP issue
On 11 Apr 2001, at 18:59, David wrote: I tried posting this in the PHP newsgroup but received no response so thought I would try here since issue involves MySQL The easiest solution is to use lists, eg: ul liAdmin/li ul liNetworking/li ul liping litraceroute liecho /ul /ul /ul rather than table data cells and amend your code to o/p the list tags, eg. UL LI? echo "$submenu"; ?/LI UL LI a href="? echo "$url"; ? " ? echo "$element";? /a /LI etc David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Having a big problem in libmysqlclient.a with apache and php
David Beech a crit : On 11 Apr 2001, at 18:07, Mohamed Ould wrote: apache "make" abort with these errors: usr/local/mysql/lib/libmysqlclient.a(my_compress.o ): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress. o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Erreur 1 make[2]: Look at what "make" is telling you Mohamed. During the linking stage of the make process the linker (ld) cannot find references to either uncompress or compress. This means that gcc, which calls the linker, cannot find zlib. This can be due to either: - Missing library, or - Misconfigured library search path (unlikely) Normally zlib lives in /usr/lib. Check to see if you have a number of files like: libz.a libz.so libz.so.1 libz.so.1.1.3 libzvt.a libzvt.so libzvt.so.2 libzvt.so.2.2.3 (ls /usr/lib/libz*) If not, find them and stick them there. Check also that /etc/ld.so.conf contains /usr/lib as a library search path. You can also run ldconfig -p | less to see what search paths are configured. Sometimes RPM doesn't work too well. David Your remarques seem to be all satisfiyed, but I still not found where is the error: 1) Here are the result of "ls -al /usr/lib/libz*": -rwxr-xr-x1 root root63084 ao 17 2000 /usr/lib/libz.a lrwxrwxrwx1 root root 13 avr 5 17:41 /usr/lib/libz.so - libz.so.1.1.3 lrwxrwxrwx1 root root 13 avr 5 17:29 /usr/lib/libz.so.1 - libz.so.1.1.3 -rwxr-xr-x1 root root58940 ao 17 2000 /usr/lib/libz.so.1.1.3 -rw-r--r--1 root root85774 ao 24 2000 /usr/lib/libzvt.a lrwxrwxrwx1 root root 15 avr 5 17:32 /usr/lib/libzvt.so - libzvt.so.2.2.7 lrwxrwxrwx1 root root 15 avr 5 17:32 /usr/lib/libzvt.so.2 - libzvt.so.2.2.7 -rwxr-xr-x1 root root92075 ao 24 2000 /usr/lib/libzvt.so.2.2.7 2) /etc/ld.so.conf contains is: /usr/X11R6/lib /usr/lib /usr/kerberos/lib /usr/lib/qt-2.2.0/lib /usr/lib/qt-1.45/lib 3) The result of "ldconfig -p" is (please excuse the longuer of this, but I don't have the choice!): libglut.so.3 (libc6) = /usr/lib/libglut.so.3 libglut.so (libc6) = /usr/lib/libglut.so libglib.so (libc6) = /usr/lib/libglib.so libglib-1.2.so.0 (libc6) = /usr/lib/libglib-1.2.so.0 libglade.so.0 (libc6) = /usr/lib/libglade.so.0 libglade.so (libc6) = /usr/lib/libglade.so libglade-gnome.so.0 (libc6) = /usr/lib/libglade-gnome.so.0 libglade-gnome.so (libc6) = /usr/lib/libglade-gnome.so libgif.so.4.1.0 (libc6) = /usr/lib/libgif.so.4.1.0 libgif.so.4 (libc6) = /usr/lib/libgif.so.4 libgif.so.3.1.0 (libc6) = /usr/lib/libgif.so.3.1.0 libgif.so.3 (libc6) = /usr/lib/libgif.so.3 libgif.so (libc6) = /usr/lib/libgif.so libghttp.so.1 (libc6) = /usr/lib/libghttp.so.1 libghttp.so (libc6) = /usr/lib/libghttp.so libgen_util_applet.so.0 (libc6) = /usr/lib/libgen_util_applet.so.0 libgen_util_applet.so (libc6) = /usr/lib/libgen_util_applet.so libgdkcardimage.so.0 (libc6) = /usr/lib/libgdkcardimage.so.0 libgdkcardimage.so (libc6) = /usr/lib/libgdkcardimage.so libgdk_pixbuf.so.2 (libc6) = /usr/lib/libgdk_pixbuf.so.2 libgdk_pixbuf.so (libc6) = /usr/lib/libgdk_pixbuf.so libgdk_imlib.so.1 (libc6) = /usr/lib/libgdk_imlib.so.1 libgdk_imlib.so (libc6) = /usr/lib/libgdk_imlib.so libgdk.so (libc6) = /usr/lib/libgdk.so libgdk-1.2.so.0 (libc6) = /usr/lib/libgdk-1.2.so.0 libgdbm.so.2 (libc6) = /usr/lib/libgdbm.so.2 libgdbm.so (libc6) = /usr/lib/libgdbm.so libgd.so.1.8 (libc6) = /usr/lib/libgd.so.1.8 libgd.so (libc6) = /usr/lib/libgd.so libg++.so.2.7.2 (libc6) = /usr/lib/libg++.so.2.7.2 libform.so.5 (libc6) = /usr/lib/libform.so.5 libform.so.4 (libc6) = /usr/lib/libform.so.4 libform.so (libc6) = /usr/lib/libform.so libfish_applet.so.0 (libc6) = /usr/lib/libfish_applet.so.0 libfish_applet.so (libc6) = /usr/lib/libfish_applet.so libe2p.so.2 (libc6) = /lib/libe2p.so.2 libext2fs.so.2 (libc6) = /lib/libext2fs.so.2 libexpect5.31.so (libc6) = /usr/lib/libexpect5.31.so libesddsp.so.0 (libc6) = /usr/lib/libesddsp.so.0 libesddsp.so (libc6) = /usr/lib/libesddsp.so libesd.so.0 (libc6) = /usr/lib/libesd.so.0 libesd.so (libc6) = /usr/lib/libesd.so libdyn.so.1 (libc6) = /usr/kerberos/lib/libdyn.so.1 libdyn.so (libc6) = /usr/kerberos/lib/libdyn.so libdpstk.so.1 (libc6) = /usr/X11R6/lib/libdpstk.so.1 libdps.so.1 (libc6) = /usr/X11R6/lib/libdps.so.1 libdl.so.2 (libc6) = /lib/libdl.so.2 libdl.so (libc6) = /usr/lib/libdl.so libdes425.so.3 (libc6) = /usr/kerberos/lib/libdes425.so.3 libdes425.so (libc6) = /usr/kerberos/lib/libdes425.so libdb1.so (libc6) = /usr/lib/libdb1.so libdb.so.3 (libc6) = /usr/lib/libdb.so.3 libdb.so.2 (libc6) = /usr/lib/libdb.so.2 libdb-3.1.so (libc6) =
Re: PATCH2: REGEXP in select only works with short expressions onAlpha
Thanks for the patch and the rapid response :)
My application has been running with this patch for 15 hours now - and has
done over 2 million regexp matches without problems :)
Stephen
On Wed, 11 Apr 2001, Michael Widenius wrote:
"Stephen" == Stephen Beynon [EMAIL PROTECTED] writes:
Stephen On Tue, 10 Apr 2001, Michael Widenius wrote:
cut
Stephen Thankyou for the patch - it certainly improves the situation (and fixes
Stephen the test case I gave) but I seem to have found another problem with regexp
Stephen :(
Stephen The following test case results in the mysql server taking 100% CPU and
Stephen not returning. Unfortunatly I have not been able to isolate a simpler
Stephen regular expression that causes the problem yet. I will try again
Stephen tommorow.
cut
No need for that!
Here is a tested patch for this:
= regex/engine.c 1.2 vs edited =
*** /tmp/engine.c-1.2-28594 Wed Aug 30 22:42:05 2000
--- edited/regex/engine.c Wed Apr 11 19:04:46 2001
***
*** 828,834
register sopno pc;
register onestate here; /* note, macros know this name */
register sopno look;
! register int i;
for (pc = start, INIT(here, pc); pc != stop; pc++, INC(here)) {
s = g-strip[pc];
--- 828,834
register sopno pc;
register onestate here; /* note, macros know this name */
register sopno look;
! register onestate i;/* Changed from int by Monty */
for (pc = start, INIT(here, pc); pc != stop; pc++, INC(here)) {
s = g-strip[pc];
Regards,
Monty
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: col_name(length) index and INNOBASE problem
At 12:30 12/04/2001 +0200, BAUMEISTER Alexandre wrote:
Hi,
Maybe this issue is relative at your compiled version or platform
because I wasn't be able to repeat:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\binmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql create table test (
- symbole char(20) not null primary key,
- libelle char(100) not null,
- index id_lib (libelle(1))
- ) TYPE=INNOBASE;
Query OK, 0 rows affected (0.06 sec)
mysql insert into test values('A','ABCDEF');
Query OK, 1 row affected (0.03 sec)
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
mysql show index from test;
+---++--+--+-+---+--
---+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardi
nality | Sub_part | Packed | Comment |
+---++--+--+-+---+--
---+--++-+
| test | 0 | PRIMARY |1 | symbole | A |
NULL | NULL | NULL | |
| test | 1 | id_lib |1 | libelle | A |
NULL |1 | NULL | |
+---++--+--+-+---+--
---+--++-+
2 rows in set (0.00 sec)
mysql select * from test where libelle like 'A%';
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
mysql select * from test where libelle like 'a%';
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.02 sec)
mysql
Regards,
Miguel
Bonjour,
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many, the result is
the same :
insert into test values('A','ABCDEF');
I check that the row is in the table :
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
I check the indexes in the table :
mysql show index from test;
+---++--+--+--+---+-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Comment |
+---++--+--+--+---+-+--++-+
| test | 0 | PRIMARY |1 | symbole |
A |NULL | NULL | NULL | |
| test | 1 | id_lib |1 | libelle |
A |NULL |1 | NULL | |
+---++--+--+--+---+-+--++-+
2 rows in set (0.00 sec)
But here is the problem :
mysql select * from test where libelle like 'A%';
Empty set (0.00 sec)
mysql select * from test where libelle like 'a%';
Empty set (0.00 sec)
This bug does not occur with a MyISAM table.
We use Myslq-3.23.26 with latest Solaris patch from Heikki, under
Solaris 2.8 and SPARC 4 CPU.
Regards,
Alex.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
__ ___ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil
___/ Development Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Weird Index usage n 3.23.36
Artem Koutchine writes: Hi! I have notice a very weird index selection when execution a query in 3.23.36. Here is an example: The table is: mysql describe words; ++--+--+-+ -+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+ -+---+ | id | int(10) unsigned | | PRI | 0 | | | word_i | char(50) | | MUL | | | | product_id | int(10) unsigned | | MUL | 0 | | | position | smallint(5) unsigned | | MUL | 0 | | | sys_mdate | datetime | | | -00-00 00:00:00 | | | sys_cdate | datetime | | | -00-00 00:00:00 | | | sys_csite | char(10) | | | | | | sys_msite | char(10) | | MUL | | | | sys_cp | int(11) | | | 0 | | | sys_mp | int(11) | | | 0 | | | sys_del| tinyint(4) | | MUL | 0 | | ++--+--+-+ -+---+ 11 rows in set (0.00 sec) It is used to index descriptions and names and other text data for products and they quickly search for a product by specified keyword. The indexes are: +---+++--+ -+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---+++--+ -+---+-+--++-+ | words | 0 | PRIMARY|1 | id | A | 17848 | NULL | NULL | | | words | 1 | i_words_word_i |1 | word_i | A |4462 | NULL | NULL | | | words | 1 | i_words_product_id |1 | product_id | A |1622 | NULL | NULL | | | words | 1 | i_words_position |1 | position | A | 64 | NULL | NULL | | | words | 1 | i_words_sysupd |1 | sys_msite | A | 1 | NULL | NULL | | | words | 1 | i_words_sysupd |2 | sys_mdate | A | 189 | NULL | NULL | | | words | 1 | i_words_qqq|1 | id | A | 17848 | NULL | NULL | | | words | 1 | i_words_qqq|2 | word_i | A | 17848 | NULL | NULL | | | words | 1 | i_words_qqq|3 | product_id | A | 17848 | NULL | NULL | | | words | 1 | i_words_qqq|4 | sys_del | A | 17848 | NULL | NULL | | | words | 1 | i_words_www|1 | product_id | A |1622 | NULL | NULL | | | words | 1 | i_words_www|2 | sys_del | A |1622 | NULL | NULL | | | words | 1 | i_words_eee|1 | word_i | A |4462 | NULL | NULL | | | words | 1 | i_words_eee|2 | sys_del | A |4462 | NULL | NULL | | | words | 1 | i_words_rrr|1 | sys_del | A | 1 | NULL | NULL | | | words | 1 | i_words_rrr|2 | product_id | A |1622 | NULL | NULL | | | words | 1 | i_words_sys_del|1 | sys_del | A | 1 | NULL | NULL | | +---+++--+ -+---+-+--++-+ 17 rows in set (0.00 sec) It looks like overkill but this is only for the testing perpose, so i can see why MySQL will choose. Now i want to find a product which contains both 'AMD' and 'DURON'. I do a select where I join the table with itself. mysql explain SELECT - w0.product_id - FROM - words AS w0 LEFT JOIN words AS w1 ON w1.product_id = w0.product_id AND w1.sys_del = 0 - WHERE - w0.sys_del=0 AND (w0.word_i LIKE 'amd%' AND w1.word_i LIKE 'duron%') and w1.product_id=w0.product_id - ; +---+---+- --+-+-+--- +--++ | table | type | possible_keys | key | key_len | ref | rows | Extra |
col_name(length) index and INNOBASE problem
Bonjour,
Sorry I mistyped the version of Mysql with which we have the bug.
It's Mysql-3.23.36 with patch correcting Solaris and other non Linux
Unix problem.
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many, the result is
the same :
insert into test values('A','ABCDEF');
I check that the row is in the table :
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
I check the indexes in the table :
mysql show index from test;
+---++--+--+--+---+-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed |
Comment |
+---++--+--+--+---+-+--++-+
| test | 0 | PRIMARY |1 | symbole | A |
NULL | NULL | NULL |
| test | 1 | id_lib |1 | libelle | A |
NULL |1 | NULL |
+---++--+--+--+---+-+--++-+
2 rows in set (0.00 sec)
But here is the problem :
mysql select * from test where libelle like 'A%';
Empty set (0.00 sec)
mysql select * from test where libelle like 'a%';
Empty set (0.00 sec)
This bug does not occur with a MyISAM table.
We use Myslq-3.23.26 with latest Solaris patch from Heikki, under
Solaris 2.8 and SPARC 4 CPU.
Regards,
Alex.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mass upload
Hello--- I am wondering if anyone has done anything that resembles the following: I need to take a flat file (currently in excell) and upload it into a MYSQL database via the web using PHP. This will happen every week so what is the best way to do this drop the table then re-create it with the info. from the file or append the data? Any ideas would be appreciated Khris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Root password forgotten in MySQL
Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep
Re: col_name(length) index and INNOBASE problem
Hi!
Innobase does not support partial-field indexes. We have to block their
usage in the SQL parser. Miguel's query on Win NT perhaps worked because the
optimizer there chose another access path and did not use the partial-field
index.
But thank you Alex, we have to block them in the parser, and I will
update the Innobase online manual immediately.
Regards,
Heikki
At 12:30 PM 4/12/01 +0200, you wrote:
Bonjour,
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many, the result is
the same :
insert into test values('A','ABCDEF');
I check that the row is in the table :
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00 sec)
I check the indexes in the table :
mysql show index from test;
+---++--+--+--+---+
-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Comment |
+---++--+--+--+---+
-+--++-+
| test | 0 | PRIMARY |1 | symbole | A |
NULL | NULL | NULL | |
| test | 1 | id_lib |1 | libelle | A |
NULL |1 | NULL | |
+---++--+--+--+---+
-+--++-+
2 rows in set (0.00 sec)
But here is the problem :
mysql select * from test where libelle like 'A%';
Empty set (0.00 sec)
mysql select * from test where libelle like 'a%';
Empty set (0.00 sec)
This bug does not occur with a MyISAM table.
We use Myslq-3.23.26 with latest Solaris patch from Heikki, under
Solaris 2.8 and SPARC 4 CPU.
Regards,
Alex.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 developer
I would like to know what experience need for development in MySql project, I read the istructions on the site but it say to send my software, so I want ask: What languages are required ? What kind of experience ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: more on the install problem
Well, where IS the socket? If it is not where mysqladmin is looking, then you should add to /etc/my.cnf: [client] socket=/tmp/mysql.sock Substituting the correct full path/name for the socket. Make sure /etc/my.cnf is world readable. Mike Millner wrote: I've narrowed it down some. I'm not finding the answer in archives. From the manual I found these commands: shell mysqladmin version shell mysqladmin variables shell mysqladmin -h `hostname` version variables shell mysqladmin -h `hostname` --port=3306 version shell mysqladmin -h 'ip for your host' version shell mysqladmin --socket=/tmp/mysql.sock version All these work except the first two. I tried changing the permission on /tmp to mysql:mysql for owner and group I don't know what else to do. Its like mysqladmin can't find the path to /tmp if I don't provide the full path. Please, any hints :) Thanks, Mike Hello, I just installed mysql 3.23.36 on a Debian Potato system. I know your going to tell me to read the manual. I have been and will continue. Any help would be greatly appreciated. Thanks, Mike I have (at least) two problems When I do a ps-ef | grep mysqld: root 19004 25880 0 20:04 pts/100:00:00 sh /usr/local/mysql/bin/safe_mysqld --user =mysql mysql19024 19004 0 20:04 pts/100:00:00 /usr/local/mysql/libexec/mysqld --basedir= /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr /local/mysql/v ar/mail.mikeshome.com.pid --skip-locking mysql19026 19024 0 20:04 pts/100:00:00 /usr/local/mysql/libexec/mysqld --basedir= /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr /local/mysql/v ar/mail.mikeshome.com.pid --skip-locking mysql19027 19026 0 20:04 pts/100:00:00 /usr/local/mysql/libexec/mysqld --basedir= /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr /local/mysql/v ar/mail.mikeshome.com.pid --skip-locking root 19104 25880 0 20:40 pts/100:00:00 grep mysqld The server appears to be running. I'm new to mysql but that looks like running. If I do a :/usr/local/mysql# /usr/bin/mysqladmin version /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' ( 111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Two other people have had this exact same problem in the last 24hrs. Please lookup the archive of the list to find your answer to this one. If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' If this is a fresh installation, root currently has no password. mysqladmin -u root will suffice. Also there is no space between -p and your password when you do finally get around to changing it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 forgotten in MySQL
It is in the manual. Sandeep Pachpande wrote: Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE - MYSQL recovery/reliability under powerfail conditions
Hi We are evaluating various RDBMS for use on within an airborne server (Embedded NT4.0) environment. This environment does not have reliable power. Aircraft are powered cycled without regard for delicate OS environments etc. Here in south Arlington, Va., the power also cycles without regard for delicate OS environments. Is it impossible to install some sort of UPS, along with software that shuts everything down gracefully when the power goes off? This will also protect against less obvious problems. My dial-up connection is lot more reliable when my equipment is hooked up to a UPS. We like MySql because it is fairly lightweight (regards processor/mem requirements not capabilities) and fast. Availability of source code is also re-assuring - given the long product lifecycles within the avionics business. Assume that we are not suffering from any file corruption due to problems with NTFS under powerfail conditions. Whether we use a table type which supports transactions or not has anyone experienced problems under powerfail, and if they have could it be automatically corrected within a reasonable time by the table repair utilities. I am worried about internal indices (Btrees etc) requiring a complete rebuild, and taking an unacceptable amount of time. Roughly half the crashes I've experienced have resulted in corrupted tables. I've always been able to repair them with the mysamchk utility. I plan to test before making any commitments but forwarned is forarmed as they say. Other DB's on the eval list are Interbase 6.0, MSQL7, various realtime embedded. Thanks Regards Norman Burkies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root password forgotten in MySQL
Now I want to create new database for same but i forgot my root mysql password. Take a look at the manual. It's there, so USE it. You can also find the answer in this lists archive. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 forgotten in MySQL
At 15:13 12.04.2001, Sandeep Pachpande wrote: Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep I think you can restart the server with --skip-grant-tables and change the password then. regards Sven Huster Senior IT Systems Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: col_name(length) index and INNOBASE problem
Heikki, Could you please tell me (and add in the manual perhaps) if this is a planned enhancement or not and if it's planned, if it will be added in a long or a short delay. Thanks, Alex. HT Innobase does not support partial-field indexes. We have to block their HT usage in the SQL parser. Miguel's query on Win NT perhaps worked because the HT optimizer there chose another access path and did not use the partial-field HT index. HT But thank you Alex, we have to block them in the parser, and I will HT update the Innobase online manual immediately. HT Regards, HT Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: just a question
I know that there is some way to give the DOS window a scrollbar, somewhere in it's properties maybeI can't remember, in which case you can view what races past your eyes Scott At 11:08 PM 4/11/01, you wrote: Using ver 8.18 dist 3.23.36 on win98se. It unzipped just fine, installed and starts mysqld-opt in the background at startup. The nice GUI is a green traffic light in the system tray, but it frequently disappears, and seems to hang if I attempt to restart it. I don't know how to restart it, and I am reading through the manual, as well as helpful links to tutorials, but it is going slow. When I run mysqladmin -help, my DOS window is too small to display the information at the beginning, and there's no option to display a page at a time (like /p). I created a table using jdbc (driver from mark mathews), but can't do much else yet. Help me know, please, how to get back the traffic light, why I crash it so often, and where I can get more help for running on win98. I can run a web server (OrionServer) just fine on my machine, but there's a line in the manual saying win98 doesn't support running mysqld as a service. - pablo alonso - ventura, california - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mass upload
At Thursday 4/12/01 08:56 AM, [EMAIL PROTECTED] wrote: I need to take a flat file (currently in excell) and upload it into a MYSQL database via the web using PHP. This will happen every week so what is the best way to do this drop the table then re-create it with the info. from the file or append the data? Khristopher, Sounds like either you design a means of doing weekly updates of new data only, what you mean by 'append' I think? Or else get yourself an ever increasing upload containing more and more old stuff that just grows and grows. The way to make this work as an update process is to create a unique key for every record added to the database from the excell source file. An easy way to do this is to use the Unix time function which returns time in seconds. Of course you'll likely need to add some program logic so as not to get duplicate keys, but this is easy to do. Marty Face 2 Interface Web Solutions Content Management Made SIMPL(tm) http://face2interface.com/Home/SIMPL.shtml - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 forgotten in MySQL
http://www.mysql.com/doc/R/e/Resetting_permissions.html - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Sandeep Pachpande" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 9:13 AM Subject: Root password forgotten in MySQL Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to loada 28MB LONGTEXT data?
Hi everyone; I have some problem in load a 28 MB LONGTEXT data into mysql database using "LOAD DATA INFILE ...". At the beginning, server returns me the error message as below: ERROR 1030: Got error 139 from table handler I tried the same command again, then I got another error message: ERROR 1062: Duplicate entry 'Chr1_A_thaliana' for key 1 But, there is no entries in the table. Could you give me any suggestion? Thank you in advance. Wei Zhu _ 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
Problem installing binary on AIX 4.3.1.0
From: [EMAIL PROTECTED] Date: Thu, 12 Apr 2001 17:12:06 +0200 To: [EMAIL PROTECTED] Hi there, Although I am using AIX4.3.1, I tried to install the binary version (which is built for AIX4.3.3). Most of the time, it does not make any difference, but when I run: scripts/mysql_install_db I get: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. WARNING: The host 'centaure' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. Installation of grant tables failed! Obviously, there is an archive file missing (library). Any advice for that ? Building from the source distribution on an AIX machine is not that straightforward, so I would prefer to use the binary distribution. Any advice appreciated, Olivier. MySQL support: none Synopsis: Problem installing binary on AIX 4.3.1.0 Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.36 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: AIX centaure 3 4 002004917500 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/rs6000-ibm-aix4.3.1.0/2.7.2/specs gcc version 2.7.2 Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many ' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Oct 08 1971 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Oct 08 1971 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_03 built for aix Olivier Hislaire MSG International Email: [EMAIL PROTECTED] 97 Avenue de Tervuren Phone: +32 (0)2 735.91.59 Ext. 55 1040 Brussels Fax: +32 (0)2 732.12.19 Belgium http://www.msg-i.com
FW: MySQL Module Installation Failure
I accidentally forgot the attachment, sorry... -Original Message- From: Jaffe, Peter S. To: '[EMAIL PROTECTED]' Sent: 4/12/2001 8:34 AM Subject: MySQL Module Installation Failure To anyone basically familiar with MySQL: I know nothing about MySQL, and have been instructed to install it on a RedHat 7.1 Linux system. I went through installing MySQL server, client, and development RPMs and that worked fine. Now I skipped the installation of the DataDumper module (because it's already included in my version of PERL, 5.6.0), then installed DBI (which gave a few warnings but no errors), and then I tried installing the Msql-MySQL modules... then I started getting errors. The "perl Makefile.pl" step seems to go ok, but then the "make" step gives me errors that I've attached in error_make.txt. Could someone help me? -Peter Jaffe SAIC, Energy Solutions Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
root password
I do something wrong i testing to use dbtools to manage mysql, and i wanna to do change something but i miss. I delete user root :-( i think, now on my database don't have user root .. but i have a lot of data that i need in this database, Anyone can help my to create user root on this database HELP me.! tee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: unusable mysqlshow and mysqldum under 3.23.36
Hi, we are using an older mysql-version from binary (debian) install - without problems. Now we want to use this newer versionm because of replication- and new table-format-features (myisam). All Tables are in Format myisam. Not Database (test, mysql, our own database) is visible via mysqldump or mysqlshow after upgrading to 3.23.36. I'm logged in as user root - I can use mysql-client to select rows from every Table in every database. Our apps works without errors an can connect to the new database. Only mysqldump and mysqlshow behave this strange. OS ist Linux debian 2.2 / Kernel 2.4.1. Maybe there are some problems in the paths for config files etc. P.ex. how can I tell mysqld to use /var/run/mysql/my.sock or how can I be sure, that /etc/mysql/my.cnf is used as global config file. Because of easy lifetime administration I try to stay within the rules of debian for placing files. Mny Tks for help Martin -Ursprngliche Nachricht- Von: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 12. April 2001 03:53 An: Martin Bringe; [EMAIL PROTECTED] Betreff: Re: unusable mysqlshow and mysqldum under 3.23.36 Without seeing the actual command you are using, the best I can do is guess. Perhaps you're not using password, specifying a user or maybe your database is empty. However, this is probably not the case as you should have gotten other errors. Have you tried a sanity check on the database? - Original Message - From: "Martin Bringe" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 4:36 Subject: unusable mysqlshow and mysqldum under 3.23.36 Hi, we compile and install from tarball source mysql 3.23.36. mysql-server seems to work but if I try mysqldump or mysqlshow, I only get version banner from mysqld. mysqldump is important for dayly saving the database on tape, so we can't live withoit it. Strange behavour: If I use a wrong db-name mysqlshow/dump throw an error. If I use an existing db, I get an empty answer. What's wrong? Thanks for any suggestions Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Having a big problem in libmysqlclient.a with apache and php
I had a problem like this when I put together my Apache/PHP/mySQL server
(now keep in mind I didn't use RPM's, I built all from source). Anyway,
there's a line in the Makefile under apache-x.x.x/src that begins with
LIBS1=. At the end of the line, you will probably have to add "-lz"
(that's space then minus then l and z). Then do the make again (I think
it's the make step).
Tom
--
#!/usr/bin/perl -w # 526-byte qrpff, Keith Winstein and Marc Horowitz
[EMAIL PROTECTED] # MPEG 2 PS VOB file on stdin - descrambled output
on stdout # arguments: title key bytes in least to most-significant order
$_='while(read+STDIN,$_,2048){$a=29;$c=142;if((@a=unx"C*",$_)[20]48){$h=5;
$_=unxb24,join"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$/;$d=
unxV,xb25,$_;$b=73;$e=256|(ord$b[4])9|ord$b[3];$d=$d8^($f=($t=255)($d
12^$d4^$d^$d/8))17,$e=$e8^($t($g=($q=$e147^$e)^$q*8^$q6))9
,$_=(map{$_%16or$t^=$c^=($m=(11,10,116,100,11,122,20,100)[$_/16%8])110;$t
^=(72,@z=(64,72,$a^=12*($_%16-2?0:$m17)),$b^=$_%64?12:0,@z)[$_%8]}(16..271))
[$_]^(($h=8)+=$f+(~$g$t))for@a[128..$#a]}print+x"C*",@a}';s/x/pack+/g;eval
On Thu, 12 Apr 2001, Mohamed Ould wrote:
David Beech a crit :
On 11 Apr 2001, at 18:07, Mohamed Ould wrote:
apache "make" abort with these errors:
usr/local/mysql/lib/libmysqlclient.a(my_compress.o
): In function `my_uncompress':
my_compress.o(.text+0x9a): undefined reference to
`uncompress'
/usr/local/mysql/lib/libmysqlclient.a(my_compress.
o): In function `my_compress_alloc':
my_compress.o(.text+0x12a): undefined reference to
`compress' collect2: ld returned 1 exit status
make[2]: *** [target_static] Erreur 1 make[2]:
Look at what "make" is telling you Mohamed. During the
linking stage of the make process the linker (ld) cannot
find references to either uncompress or compress. This
means that gcc, which calls the linker, cannot find zlib.
This can be due to either:
- Missing library, or
- Misconfigured library search path (unlikely)
Normally zlib lives in /usr/lib. Check to see if you have a
number of files like:
libz.a libz.so libz.so.1 libz.so.1.1.3 libzvt.a libzvt.so
libzvt.so.2 libzvt.so.2.2.3
(ls /usr/lib/libz*)
If not, find them and stick them there. Check also that
/etc/ld.so.conf contains /usr/lib as a library search path.
You can also run
ldconfig -p | less
to see what search paths are configured.
Sometimes RPM doesn't work too well.
David
Your remarques seem to be all satisfiyed, but I still not found where is the error:
1) Here are the result of "ls -al /usr/lib/libz*":
-rwxr-xr-x1 root root63084 ao 17 2000 /usr/lib/libz.a
lrwxrwxrwx1 root root 13 avr 5 17:41 /usr/lib/libz.so -
libz.so.1.1.3
lrwxrwxrwx1 root root 13 avr 5 17:29 /usr/lib/libz.so.1 -
libz.so.1.1.3
-rwxr-xr-x1 root root58940 ao 17 2000 /usr/lib/libz.so.1.1.3
-rw-r--r--1 root root85774 ao 24 2000 /usr/lib/libzvt.a
lrwxrwxrwx1 root root 15 avr 5 17:32 /usr/lib/libzvt.so -
libzvt.so.2.2.7
lrwxrwxrwx1 root root 15 avr 5 17:32 /usr/lib/libzvt.so.2 -
libzvt.so.2.2.7
-rwxr-xr-x1 root root92075 ao 24 2000 /usr/lib/libzvt.so.2.2.7
2) /etc/ld.so.conf contains is:
/usr/X11R6/lib
/usr/lib
/usr/kerberos/lib
/usr/lib/qt-2.2.0/lib
/usr/lib/qt-1.45/lib
3) The result of "ldconfig -p" is (please excuse the longuer of this, but I don't
have
the choice!):
libglut.so.3 (libc6) = /usr/lib/libglut.so.3
libglut.so (libc6) = /usr/lib/libglut.so
libglib.so (libc6) = /usr/lib/libglib.so
libglib-1.2.so.0 (libc6) = /usr/lib/libglib-1.2.so.0
libglade.so.0 (libc6) = /usr/lib/libglade.so.0
libglade.so (libc6) = /usr/lib/libglade.so
libglade-gnome.so.0 (libc6) = /usr/lib/libglade-gnome.so.0
libglade-gnome.so (libc6) = /usr/lib/libglade-gnome.so
libgif.so.4.1.0 (libc6) = /usr/lib/libgif.so.4.1.0
libgif.so.4 (libc6) = /usr/lib/libgif.so.4
libgif.so.3.1.0 (libc6) = /usr/lib/libgif.so.3.1.0
libgif.so.3 (libc6) = /usr/lib/libgif.so.3
libgif.so (libc6) = /usr/lib/libgif.so
libghttp.so.1 (libc6) = /usr/lib/libghttp.so.1
libghttp.so (libc6) = /usr/lib/libghttp.so
libgen_util_applet.so.0 (libc6) = /usr/lib/libgen_util_applet.so.0
libgen_util_applet.so (libc6) = /usr/lib/libgen_util_applet.so
libgdkcardimage.so.0 (libc6) = /usr/lib/libgdkcardimage.so.0
libgdkcardimage.so (libc6) = /usr/lib/libgdkcardimage.so
libgdk_pixbuf.so.2 (libc6) = /usr/lib/libgdk_pixbuf.so.2
libgdk_pixbuf.so (libc6) = /usr/lib/libgdk_pixbuf.so
libgdk_imlib.so.1 (libc6) = /usr/lib/libgdk_imlib.so.1
libgdk_imlib.so (libc6) = /usr/lib/libgdk_imlib.so
libgdk.so (libc6) = /usr/lib/libgdk.so
libgdk-1.2.so.0 (libc6) = /usr/lib/libgdk-1.2.so.0
libgdbm.so.2 (libc6) = /usr/lib/libgdbm.so.2
libgdbm.so (libc6) = /usr/lib/libgdbm.so
Weird Index usage n 3.23.36
Hi! "Artem" == Artem Koutchine [EMAIL PROTECTED] writes: Artem Hi! Artem I have notice a very weird index selection when execution a query Artem in 3.23.36. Artem Here is an example: Artem The table is: cut Artem Now i want to find a product which contains both 'AMD' and 'DURON'. I Artem do a select where I join Artem the table with itself. mysql explain SELECT - w0.product_id - FROM - words AS w0 LEFT JOIN words AS w1 ON w1.product_id = Artem w0.product_id AND w1.sys_del = 0 - WHERE - w0.sys_del=0 AND (w0.word_i LIKE 'amd%' AND w1.word_i Artem LIKE 'duron%') and w1.product_id=w0.product_id - ; Artem +---+---+- Artem --+-+-+--- Artem +--++ Artem | table | type | possible_keys Artem | key | key_len | ref | rows | Extra | Artem +---+---+- Artem --+-+-+--- Artem +--++ Artem | w0| range | Artem i_words_word_i,i_words_product_id,i_words_www,i_words_eee,i_words_rrr, Artem i_words_sys_del | i_words_eee | 51 | NULL | 25 | where Artem used | Artem | w1| ref | Artem i_words_product_id,i_words_www,i_words_rrr,i_words_sys_del Artem | i_words_sys_del | 1 | const | 10 | where used | Artem +---+---+- Artem --+-+-+--- Artem +--++ Artem 2 rows in set (0.01 sec) Artem As you see it uses two indexes: i_word_eee for keyword match and Artem i_word_sys_del for the join. However Artem it is clear, that using i_words_www or i_words_rrr is a lot better. Artem Executing the query above takes Artem 8-9 seconds. Artem Now drop the index which mysql wants to use mysql alter table words drop index i_words_sys_del; cut Artem +---+---+- Artem --++-+---+ Artem --++ Artem | table | type | possible_keys Artem | key| key_len | ref | rows | Extra | Artem +---+---+- Artem --++-+---+ Artem --++ Artem | w0| range | Artem i_words_word_i,i_words_product_id,i_words_www,i_words_eee,i_words_rrr Artem | i_words_eee| 51 | NULL | 25 | where used | Artem | w1| ref | i_words_product_id,i_words_www,i_words_rrr Artem | i_words_product_id | 4 | w0.product_id | 11 | where used | Artem +---+---+- Artem --++-+---+ Artem --++ Artem 2 rows in set (0.01 sec) Artem AhA! Now it uses i_word_rrr ! cut Artem So, why Mysql chooses the wrong index? If you look close at the explain, you will see the reason: When using 'i_words_sys_del' MySQL guesses that there will be about 10 matching rows for each row in w0. When using 'i_words_product_id' MySQL guesses that there will be about 11 matching rows for each row in w0. Because of this MySQL desides to use the first index. The reason is that MySQL by default hasn't enough information about the key distribution to be able to always knows which index is the best to use and it has to do an 'educated guess' in cases where you are comparing keys with something that isn't a constant. Simple fix: Run optimize table on the words table and try again. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB recovery error
We had a crash of MySQL this morning for some reason. (Why who knows!) The real problem was it would not restart until the log.* files were deleted. It looks like it was trying to perform a recovery on a dropped database. The server would not start. This is not cool! We dropped the test database this morning, when the mysqld crashs it normally restarts itself (safe_mysqld), but because of the BDB errors it would not start. remove the BDB logs and it starts fine. Any ideas/comments? Ken Here is the tuvok.icarz.com error log snippet: cut 010412 11:15:39 Aborted connection 11994 to db: 'brtest' user: 'brtest' host: ` netb-155.icarz.com' (Got an error reading communication packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010412 12:07:19 mysqld restarted 010412 12:07:43 bdb: Recovery function for LSN 52 3669440 failed 010412 12:07:43 bdb: warning: ./test/acc.db: No such file or directory 010412 12:07:43 bdb: warning: ./test/cofile.db: No such file or directory mysqld in free(): warning: chunk is already free. 010412 12:07:43 Can't init databases 010412 12:07:43 mysqld ended - Ken Menzel ICQ# 9325188 www.icarz.com [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
Incredibly Stuck on Errcode 2 File not found in mysqlimport
Hi I'm incredibly stuck. I've been through the lists over and over, and manual is silent on this detail, and have found no solution. The Unix remote host fails to find the text file to import from my pc, Win2000. The TABLE is created already. The text file is fine. I've done this via "load data infile" on localserver on my pc in MySQL no problem. This is syntax I've tried: command prompt $mysqlimport -u -p -h x --local DBNAME [problem part not finding try1.txt] "Errcode: 2 file try1.txt not found for table try1" Where do I place the text file on my pc for remote host to find it? How do I tell it where to go? The try1.txt is sitting on my pc, in d drive. Please can anyone help, and make my Easter? Cheers, Lucy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
http://www.mysql.com/doc/R/e/Resetting_permissions.html - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Mr.Mongkol Phitaksuksanti" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 9:21 AM Subject: root password I do something wrong i testing to use dbtools to manage mysql, and i wanna to do change something but i miss. I delete user root :-( i think, now on my database don't have user root .. but i have a lot of data that i need in this database, Anyone can help my to create user root on this database HELP me.! tee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4) I want to return all the fields where ID = 1 and 3 and 4 I should get three rows back. JZ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Oops!!
"Scott Dunn" [EMAIL PROTECTED] wrote: I accidentally crashed 1 of my tables. So I deleted everything in the table and tried to reload the data into the table and now I get this error: Query OK, 1 row affected (0.02 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 5 I have a total of 1901 records in this txt file. I puts the first record in and forgets the rest. What are some things that I can look for to see what is wrong. Could it be that I made all fields not null and there are some empty? If you need more info just ask!!! Why not send the output of the following to the list: DESCRIBE table_name_here; SHOW INDEX FROM table_name_here; First 5 records from the text file. Command being used to import from the text file. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select
select * from blah where fieldname in (1,3,4) On Thu, 12 Apr 2001, Jim Zarvis wrote: What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4) I want to return all the fields where ID = 1 and 3 and 4 I should get three rows back. JZ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
"Jim Zarvis" [EMAIL PROTECTED] wrote: What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4) I want to return all the fields where ID = 1 and 3 and 4 SELECT * FROM table_name WHERE field_name IN (1,2,3); See the online manual for more details. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: BDB recovery error
On Thursday 12 April 2001 10:49, Ken Menzel wrote: We had a crash of MySQL this morning for some reason. (Why who knows!) The real problem was it would not restart until the log.* files were deleted. It looks like it was trying to perform a recovery on a dropped database. The server would not start. This is not cool! We dropped the test database this morning, when the mysqld crashs it normally restarts itself (safe_mysqld), but because of the BDB errors it would not start. remove the BDB logs and it starts fine. Any ideas/comments? Ken Here is the tuvok.icarz.com error log snippet: cut 010412 11:15:39 Aborted connection 11994 to db: 'brtest' user: 'brtest' host: ` netb-155.icarz.com' (Got an error reading communication packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010412 12:07:19 mysqld restarted 010412 12:07:43 bdb: Recovery function for LSN 52 3669440 failed 010412 12:07:43 bdb: warning: ./test/acc.db: No such file or directory 010412 12:07:43 bdb: warning: ./test/cofile.db: No such file or directory mysqld in free(): warning: chunk is already free. 010412 12:07:43 Can't init databases 010412 12:07:43 mysqld ended Looks like you found two bugs at once. The first one is that someone mysqld segfaults, probably a bug in processing some query or possibly some OS issue, but there is not much we can tell at this point - the only way to track it down would be if you had full logging enabled and saved the last few queries before the crash, and took a full snapshot of the database at the time of the crash. Second bug is that BDB could not recover after the crash - I hope you have backed up the logs before you deleted them - we will need them to debug the problem. If you still have them, upload them to ftp://support.mysql.com/pub/mysql/secret/ -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
by the way, that's not a functional example...i was using array syntax, but
this won't work if you try to use it as is...it should be a 'list' or else
contain an even number of elements...not that it's relevant, but i hate
posting code that's inoperable...
-Original Message-
From: Gonzalez, Kristopher
Sent: Thursday, April 12, 2001 1:05 PM
To: '[EMAIL PROTECTED]'
Subject:RE: Select
depends upon the language you're interfacing with...
for instance, in tcl (my lang of choice), your select would look
like the following:
array set myarray {1 2 3 4 5}
set sql "SELECT * FROM tablename WHERE id IN ([join [array get
$myarray] ,]);
the thing that you have to do is make sure your array elements are
seperated by a comma (notice the join syntax...again, you'll have to tailor
this to whatver lang you're using)
-Original Message-
From: Jim Zarvis [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 1:02 PM
To: Gonzalez, Kristopher
Subject:RE: Select
-Original Message-
From: Gonzalez, Kristopher
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Select
select * from tablename where id in (1, 3, 4)
does this mean that I can do this:
select * from tablename where id in
($myarray)
?
The array is dynamically generated, and I
won't know it's values until run time...
Re: oops!!! Here's the output
mysql describe main; ++--+--+-+-+---+ -+ | Field | Type | Null | Key | Default | Extra | Privileges | ++--+--+-+-+---+ -+ | commondata | varchar(30) | YES | | NULL| | select,insert,update,references | | id | int(10) unsigned | | PRI | 0 | | select,insert,update,references | | fpipart| varchar(100) | YES | | NULL| | select,insert,update,references | | description| varchar(100) | YES | | NULL| | select,insert,update,references | | documentfile | varchar(200) | YES | | NULL| | select,insert,update,references | | pumps | varchar(200) | YES | | NULL| | select,insert,update,references | | pumptype | int(10) unsigned | YES | | NULL| | select,insert,update,references | | maxflow| int(10) unsigned | YES | | NULL| | select,insert,update,references | | flowtype | varchar(200) | | | | | select,insert,update,references | | maxpressure| int(10) unsigned | YES | | NULL| | select,insert,update,references | | maxhead| int(10) unsigned | YES | | NULL| | select,insert,update,references | | field1 | int(10) unsigned | YES | | NULL| | select,insert,update,references | | mzxsyspressure | int(10) unsigned | YES | | NULL| | select,insert,update,references | | maxtemp| int(10) unsigned | YES | | NULL| | select,insert,update,references | | speed | int(10) unsigned | YES | | NULL| | select,insert,update,references | | applicationservice | int(10) unsigned | YES | | NULL| | select,insert,update,references | | valves | int(10) unsigned | YES | | NULL| | select,insert,update,references | | pipesize | int(10) unsigned | YES | | NULL| | select,insert,update,references | | orificesize| int(10) unsigned | YES | | NULL| | select,insert,update,references | | minimum| int(10) unsigned | YES | | NULL| | select,insert,update,references | | opacinertgas | int(10) unsigned | YES | | NULL| | select,insert,update,references | | opacinertwater | int(10) unsigned | YES | | NULL| | select,insert,update,references | | opaclightoil | int(10) unsigned | YES | | NULL| | select,insert,update,references | | opdcinertgas | int(10) unsigned | | | 0 | | select,insert,update,references | | opdcinertwater | int(10) unsigned | | | 0 | | select,insert,update,references | | opdclightoil | int(10) unsigned | | | 0 | | select,insert,update,references | | maxfluidtempac | int(10) unsigned | | | 0 | | select,insert,update,references | | maxfluidtempdc | int(10) unsigned | | | 0 | | select,insert,update,references | | bodymatl | varchar(100) | | | | | select,insert,update,references | | seatingmatl| varchar(100) | | | | | select,insert,update,references | | qtyorder | int(10) unsigned | | | 0 | | select,insert,update,references | | docexists | varchar(100) | | | | | select,insert,update,references | | price | varchar(50) | | | | | select,insert,update,references | | userprice | varchar(50) | | | | | select,insert,update,references | | pricetext | varchar(50) | | | | | select,insert,update,references | | ordernotes | varchar(100) | | | | | select,insert,update,references | | websiteinfo| varchar(100) | | | | | select,insert,update,references | | rfe1 | varchar(100) | | | | | select,insert,update,references | | rfe2 | varchar(100) | | | | | select,insert,update,references | | rfeval1| varchar(100) | | | | | select,insert,update,references | | rfeval2| varchar(100) | | | | | select,insert,update,references | | weight | int(10) unsigned | | | 0 | | select,insert,update,references | | oemtext| varchar(100) | | | | | select,insert,update,references |
Is this a bug?
At the first of the month (no changes made to the database; this script is just running SELECT statements at present) the number of rows returned by this query dropped noticeably. Is this a bug, is my query just fubar'd, or...? SELECT account.username AS account_username, customers.username AS customers_username, account.accout_no, account.email, customers.last_mod FROM account LEFT JOIN customers ON account.username = customers.username WHERE (customers.username IS NULL OR customers.username LIKE \"%_expired\") OR (customers.last_mod = current_date() - 14 AND customers.access_status = 'D') ORDER BY last_mod"; The number of rows returned: 4/10 253 4/9 247 4/8 243 4/7 241 4/6 234 4/5 226 4/4 221 4/3 216 4/2 207 4/1 197 3/31 333 3/30 312 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: Is this a bug?
you try to select the march 87. 2001 ;) read the manual about date/time conversion and math: mysql select current_date(), current_date()-0, current_date()-14; | current_date() | current_date()-0 | current_date()-14 | | 2001-04-12 | 20010412 | 20010398 | 1 row in set (0.00 sec) gl - Original Message - From: "Chris Harshman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 8:32 PM Subject: Is this a bug? At the first of the month (no changes made to the database; this script is just running SELECT statements at present) the number of rows returned by this query dropped noticeably. Is this a bug, is my query just fubar'd, or...? SELECT account.username AS account_username, customers.username AS customers_username, account.accout_no, account.email, customers.last_mod FROM account LEFT JOIN customers ON account.username = customers.username WHERE (customers.username IS NULL OR customers.username LIKE \"%_expired\") OR (customers.last_mod = current_date() - 14 AND customers.access_status = 'D') ORDER BY last_mod"; The number of rows returned: 4/10 253 4/9 247 4/8 243 4/7 241 4/6 234 4/5 226 4/4 221 4/3 216 4/2 207 4/1 197 3/31 333 3/30 312 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
Linux MySQL issues
Hello there list! I'm having some trouble with my web server running Apache and MySQL. I'm accessing the DB through the latest DBI:DBD and Perl. I was running 2.22.32 quite successfully for about a year until usage starting becoming a problem. I upgraded to 2.23.36 and the problem stayed the same. Basically, the server will cruise along at 50 queries a second without problems. Top's load level hovers between 2.xx and 3.xx, so it's not overly loaded. When the number of users increases until we hit about 100 queries per second, I get a kernel panic. It claims that it was unable to handle a kernel paging request and I've got to do a hard reboot. All I'm running on the server is Apache, Perl and MySQL. It's an SMP P-III 550x2 with 512MB ECC SDRAM. The memory usage is very low. It never goes above 160MB used -- even at the point when the kernel dies. I've replaced the memory and motherboard -- suspecting either a bad chip or bad memory controller, but it had no affect. When the number of queries reaches 100/sec my load level in top reaches between 10.xx and 12.xx, so there's a lot of stuff being done on the server, certainly. I was just writing to see if i was simply over-processing the server. The site doesn't seem slow per-sec, it's definately tolerable. And we only reach these conditions during extreme peak times of the day, so I don't really want to replicate my DB and send the non-updating queries to another system if I don't have to. My question is: Is it possible that these kernel faults are the result of process context-switching in Linux? If so, would an update from the 2.2.12smp kernel to 2.2.16smp help? or maybe 2.4 -- although I don't trust it for production. What about HDD corruption (I'm not page swapping as a result of low memory) Is it possible that all of the crashing has corrupted the HD and now everything is just hosed? In which case a re-install of Linux using the same kernel should fix the problem. I'm just trying to decide what my best option is to solve the problem. Re-install the OS, run Solaris instead of Linux, find a non-crashing MySQL version, get faster processors, replicate the DB, etc.. I guess I could also move to a PHP or JSP solution, as Perl may be causing the problem. But seeing as my CPU's able to route 100 queries per second to MySQL, I think they're being processed fast enough, just not reliably. Sorry about the open ended post. I really don't want to start an OS war or anything. I'm just trying to figure out if the kernel fault is due to a MySQL problem, an OS problem or a hardware problem. I hope I can get some good feedback to direct my next move. Thanks so much Mike InsideCorner.com
Re: adding columns to my database
ALTER TABLE tablename ADD COLUMN column_name creation clause; On 4/12/01 12:04 PM, "Dean MacIsaac Jr." [EMAIL PROTECTED] wrote: I'm just not understanding what I'm reading in Ch. 7. I created a table, in my database, now I just want to add 2 more varchar columns to it. I tried following along with the manual, but, I'm not seeing it, and I get errors every time in telnet. If someone would be so kind as to help me, I appreciate it. Sincerely, Dean MacIsaac Webmaster www.starabilias.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: mysql uses 99% cpu under freebsd 4.3
Hi, I have had some various similar things happen with other apps since upgrading to Fbsd4.2stable What I have learnt to do first before anything else is, reboot and load a SINGLE CPU compiled kernel to determine at what/where the bug may be. I had a/still occasionally get a constant waiting in KDE explorers but never get this during a single CPU test. Have had lots of mysql threads gobbling resources, too lazy to test, plus it was an early mysql (have not updated it from ports) since it has only done this twice since February (when we updated from 3.4 to 4.2). Probably doesn't help you all but I am watching this news thread eagerly. M. -- He came from Econet - Oh no, I've run out of underpants :( Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
privilege problem
I am not sure I am encoutering the following problem when I try to access the database? java.sql.SQLException: Server configuration denies access to data source java.sql.SQLException: Server configuration denies access to data source My java program defines: user and a password and when I connect to the DB, I use user and password, but for some reason, I get SQL Exception - Server configuration denies access to data source. Thank you very much for your help, Leon __ Do You Yahoo!? Get email at your own domain with 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
commit/rollback?
Hello, Let's say I have a file which contains the following lines: insert into table_1 values (1,2,3); insert into table_2 values (4,5,6); It's called from the command line with mysql -u root -ppassword db_name file; I would like to undo the first operation on table_1 in case the second query (on table_2) returns an error. I believe this could be done by using commit/rollback if I used BDB tables. But I'm using MyISAM. Any hints how could I make this? Thanks, Jochen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB recovery error
Hi Sasha, Looks like you found two bugs at once. The first one is that someone mysqld segfaults, probably a bug in processing some query or possibly some OS issue, but there is not much we can tell at this point - the only way to track it down would be if you had full logging enabled and saved the last few queries Yes, full logging was enabled. before the crash, and took a full snapshot of the database at the time of the crash. No I did not take a snapshot. (sorry didn't think of it). Second bug is that BDB could not recover after the crash - I hope you have backed up the logs before you deleted them - we will need them to debug the problem. If you still have them, upload them to ftp://support.mysql.com/pub/mysql/secret/ Unfortunately being in a hurry to get the daemon running again I deleted the files. I will attempt to reproduce the problem on an unused server. I think it should be easy to recreate, just drop a database after you have something for it in the log.xx file then after the db is gone, stop and restart the server. I'll try to come up with a simple test case tomorrow. Thanks Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: adding columns to my database
Billy, and friends, Always helpful info: What have you tried, and what errors are you getting? alter table web_guests add column (p1 varchar(15), p2 varchar(15)); Error 1064 You have an error in your sql syntax near '(p1 varchar(15), p2 varchar(15))' at line 1 TIA, Dean MacIsaac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is this a bug?
This is one of the things I'd like to see changed in mysql someday. Date math has never worked well because it represents dates as numbers -- sort of. What I'd like to have is the capability to do is -- select datetimefield2 - datetimefield1 as timediff which would save a lot of hassle over the current solution of -- select unix_timestamp(datetimefield2) - unix_timestamp(datetimefield1) as timediff It just seems a little more intuitive than the DATE_ set of functions. Ren Tegel [EMAIL PROTECTED] wrote: you try to select the march 87. 2001 ;) read the manual about date/time conversion and math: mysql select current_date(), current_date()-0, current_date()-14; | current_date() | current_date()-0 | current_date()-14 | | 2001-04-12 | 20010412 | 20010398 | 1 row in set (0.00 sec) gl - Original Message - From: "Chris Harshman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 8:32 PM Subject: Is this a bug? At the first of the month (no changes made to the database; this script is just running SELECT statements at present) the number of rows returned by this query dropped noticeably. Is this a bug, is my query just fubar'd, or...? SELECT account.username AS account_username, customers.username AS customers_username, account.accout_no, account.email, customers.last_mod FROM account LEFT JOIN customers ON account.username = customers.username WHERE (customers.username IS NULL OR customers.username LIKE \"%_expired\") OR (customers.last_mod = current_date() - 14 AND customers.access_status = 'D') ORDER BY last_mod"; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: commit/rollback?
You can't with MyISAM and executing from shell prompt. Either alter the table type to BDB or Innobase If you stick with MyISAM you can use a higher level language (perl,php) to check the return value of each insert and handle the flow accordingly. If the 2nd insert fails, you'll have to complement the first insert with a delete. regards, thalis On Thu, 12 Apr 2001, Jochen Mielke wrote: Hello, Let's say I have a file which contains the following lines: insert into table_1 values (1,2,3); insert into table_2 values (4,5,6); It's called from the command line with mysql -u root -ppassword db_name file; I would like to undo the first operation on table_1 in case the second query (on table_2) returns an error. I believe this could be done by using commit/rollback if I used BDB tables. But I'm using MyISAM. Any hints how could I make this? Thanks, Jochen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssh connection between web server and mysql]
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote: On the client I do a ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306 then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname and I get an encrypted connection. ( thats what tcpdump shows me) ! Lovely ! But after a few tens of minutes, no more connection, and mysql times out. Is the SSH connection idle or active when you see the timeouts? (I've had this working between a Linux master and FreeBSD slave before.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: time and date
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! Either add a timestamp column to your table, and in your insert statements OMIT this column so that it will be set to the current time. But in your update statements, you've got to take care of this column, so add something like "UPDATE TBL SET TimestampCol = TimestampCol". This will set the value of the timestamp column to the old value. Not doing this will set it to the then current time. Or add a datetime column and set it to the current time when INSERT'ing with "INSERT INTO TBL SET DatetimeCol = NOW()" Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die gnstige Art an Linux Distributionen zu kommen Uptime: 23 hours 38 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ms frontpage
Hi, I want connect mysql databse with ms front page 200. How? What do i? Thanks.
Mysql and Perl DBI
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-13.tar.gz. Can any one help Gordon [gordon@fido gordon]$ cd Msql-Mysql-modules-1.2213 [gordon@fido Msql-Mysql-modules-1.2213]$ perl Makefile.PL Which drivers do you want to install? 1)MySQL only 2)mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] 1 Do you want to install the MysqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [n] Where is your MySQL installed? Please tell me the directory that contains the subdir 'include'. [/usr] Which database should I use for testing the MySQL drivers? [test] On which host is database test running (hostname, ip address or host:port) [localhost] User name for connecting to database test? [undef] Password for connecting to database test? [undef] Creating files for MySQL Checking if your kit is complete... Looks good Using DBI 1.14 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [gordon@fido Msql-Mysql-modules-1.2213]$ make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/Msql-Mysql-modules mkdir blib/lib/auto mkdir blib/lib/auto/Msql-Mysql-modules mkdir blib/man1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \ -I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \ -e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm" /usr/bin/pod2text mysql/lib/DBD/mysql.pm README make[1]: Entering directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir ../blib/lib/DBD mkdir ../blib/arch/auto/DBD mkdir ../blib/arch/auto/DBD/mysql mkdir ../blib/lib/auto/DBD mkdir ../blib/lib/auto/DBD/mysql mkdir ../blib/man3 cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm cp lib/Mysql.pm ../blib/lib/Mysql.pm gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYSQL dbdimp.c /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI/Driver.xst mysql.xsi /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 /usr/lib/perl5/5.6.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.0/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.96" gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -L/usr/lib/gcc-lib/i386-redhat-linux/2.96 -lgcc chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Manifying ../blib/man3/DBD::mysql.3pm Manifying ../blib/man3/Bundle::DBD::mysql.3pm Manifying ../blib/man3/Mysql.3pm make[1]: Leaving directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir blib/script cp dbimon blib/script/dbimon /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -MExtUtils::MakeMaker -e "MY-fixin(shift)" blib/script/dbimon Manifying blib/man1/dbimon.1 *** ERROR: unterminated C... at line 1426 in file dbimon *** ERROR: unterminated C... at line 1450 in file dbimon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB recovery error
On Thursday 12 April 2001 14:03, Ken Menzel wrote: Hi Sasha, Looks like you found two bugs at once. The first one is that someone mysqld segfaults, probably a bug in processing some query or possibly some OS issue, but there is not much we can tell at this point - the only way to track it down would be if you had full logging enabled and saved the last few queries Yes, full logging was enabled. before the crash, and took a full snapshot of the database at the time of the crash. No I did not take a snapshot. (sorry didn't think of it). Second bug is that BDB could not recover after the crash - I hope you have backed up the logs before you deleted them - we will need them to debug the problem. If you still have them, upload them to ftp://support.mysql.com/pub/mysql/secret/ Unfortunately being in a hurry to get the daemon running again I deleted the files. I will attempt to reproduce the problem on an unused server. I think it should be easy to recreate, just drop a database after you have something for it in the log.xx file then after the db is gone, stop and restart the server. I'll try to come up with a simple test case tomorrow. In the mean time, we will try to re-produce it ourselves. Monty might even be able to tell right away what is wrong by just looking at the error messages and the code. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to loada 28MB LONGTEXT data?
# perror 139 Error code 139: Unknown error: 19 139 = Too big row (= 16 M) This means the 28MB row you tried loading is bigger than the max allowed packet size. You might want to change the max_allowed_packet variable (ie -O max_allowed_packet=32M or something similar on the commandline). The duplicate entry error can probably be fixed by running myisamchk on the table. Hope this helps. ryan I have some problem in load a 28 MB LONGTEXT data into mysql database using "LOAD DATA INFILE ...". At the beginning, server returns me the error message as below: ERROR 1030: Got error 139 from table handler I tried the same command again, then I got another error message: ERROR 1062: Duplicate entry 'Chr1_A_thaliana' for key 1 But, there is no entries in the table. Could you give me any suggestion? Thank you in advance. Wei Zhu _ 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: SELECT Calculation
What you wrote will work just fine. It is very easy to create a test case and see if it works, saves you the trouble of posting to the list. mysql create table test (a int, b int, c int); Query OK, 0 rows affected (0.09 sec) mysql insert into test values (2,3,5); Query OK, 1 row affected (0.00 sec) mysql insert into test values (3,3,5); Query OK, 1 row affected (0.00 sec) mysql select * from test where a+b=c |2 |3 |5 | 1 row in set (0.00 sec) Can someone tell me if it is possible to have a calculation in a SELECT statement. EG SELECT * FROM (table_name) where (col_1 + col_2 = col_3) I am using MySQL 3.23.xx and PHP4 I only want to display those fields where the sum is true. Kindest Regards, Steve Lowe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Help with complex SQL Query
Greetings: Prelude: We have five tables all sharing a very similar structure (each has a Customer_ID and Server_ID field for example). Each table can contain zero to many records with duplicate Server_ID values allowed. Need: I need to be able to count the distinct Server_ID's across all of the tables. Problems: A customer can have one Server_ID in one table, ten Server_ID's (some duplicate) in another table and so on. The customer will have the same Customer_ID in all tables. I've tried inner joins, left joins, et all to no avail. The syntax below will only show two Server_ID's for a customer that has close to 10. SELECT DISTINCT Application.Server_ID FROM Application LEFT JOIN Content ON Application.Customer_ID = Content.Customer_ID LEFT JOIN Performance ON Content.Customer_ID = Performance.Customer_ID LEFT JOIN Ping ON Performance.Customer_ID = Ping.Customer_ID LEFT JOIN Port ON Ping.Customer_ID = Port.Customer_ID WHERE Application.Customer_ID = 1 OR Content.Customer_ID = 1 OR Performance.Customer_ID = 1 OR Ping.Customer_ID = 1 OR Port.Customer_ID = 1; What is the correct SQL to get a list of all of the distinct Server_ID's across the five tables? Thank you. Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.com/
Identifying unused databases
I have been offering free hosting of MySQL databases at freesql.org for the last few weeks. As a result I now have several hundred databases (which I think is great!), with a subset (perhaps 50) that are in active use. I would like to implement a policy where I can cull dormant or otherwise abandoned databases. Empty ones are easy, I can check the file dates in ~/mysql/data/whatever, and delete if there are no tables after 30 days or so. Databases with empty tables are similarly easy too. My problem is the case where a user creates a database, creates a table and adds data. I did not realise that the file date reported by ls -l is not updated unless the user inserts or updates. If the user has relatively static data and is only using selects, then that date will remain "old" and thus I cannot trust it to identify unused databases. What is the best (or a better) way to identify these abandoned databases? Each database has exactly one authorized user so I was considering starting mysqld with --log, and then writing a script to parse the logfile, but that seems inelegant. Is there an easier way to identify the last time a user connected to a database? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
__tz problem in sys/time.h
Description: When compiling mysql-3.23.36, many *.cc files caused a compilation error that said that __tz has multiple data definitions in /usr/include/sys/time.h. It first happens in the client subdirectory, but happens many times after that as well. I am using RH Linux 2.2.16-22smp gcc version 2.95.3 20010315 (release) How-To-Repeat: ./configure --prefix=/usr/local/mysql make Fix: The problem is in sys/time.h. This definition: extern int gettimeofday (struct timeval *__restrict __tv, __timezone_ptr_t __restrict __tz) __THROW; Above that in sys/time.h is this: #if defined __USE_GNU || defined __USE_BSD typedef struct timezone *__timezone_ptr_t; #else typedef void *__timezone_ptr_t; #endif The problem is that when compiling mysql, __USE_GNU is not defined, so in the declaration of gettimeofday, the wrong type is declared for __tz, which conflicts with its definition somewhere else. SO, in the mysql-3.23.36 source directory, in include/global.h, if you define __USE_GNU before the lines to include sys/time.h, #define __USE_GNU the compilation runs smoothly, with no more problems. Thank you, Greg Submitter-Id: none Originator:Gregory Berry Organization: none MySQL support: none Synopsis: __tz problem in sys/time.h Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Server: lt-mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 50 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open \ tables: 0 Queries per second avg: 0.180 Environment: System: Linux localhost 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Mar 19 16:33 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql __ Do You Yahoo!? Get email at your own domain with 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
Re: Identifying unused databases
You should be able to use 'find' on the directory and search by UNIX atime (atime is updated whenever the database is accessed, be it a read or a write). `find . -atime ...` man find for more details. From there, it's a simple shell script On Thu, 12 Apr 2001, Gary Huntress wrote: I have been offering free hosting of MySQL databases at freesql.org for the last few weeks. As a result I now have several hundred databases (which I think is great!), with a subset (perhaps 50) that are in active use. I would like to implement a policy where I can cull dormant or otherwise abandoned databases. Empty ones are easy, I can check the file dates in ~/mysql/data/whatever, and delete if there are no tables after 30 days or so. Databases with empty tables are similarly easy too. My problem is the case where a user creates a database, creates a table and adds data. I did not realise that the file date reported by ls -l is not updated unless the user inserts or updates. If the user has relatively static data and is only using selects, then that date will remain "old" and thus I cannot trust it to identify unused databases. What is the best (or a better) way to identify these abandoned databases? Each database has exactly one authorized user so I was considering starting mysqld with --log, and then writing a script to parse the logfile, but that seems inelegant. Is there an easier way to identify the last time a user connected to a database? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is this a bug?
Never mind; thanks for the pointers to TFM... =) The updated, working query looks like this: TO_DAYS(NOW()) - TO_DAYS(customers.last_mod) 14 Thanks all! On Thu, 12 Apr 2001, Chris Harshman wrote: At the first of the month (no changes made to the database; this script is just running SELECT statements at present) the number of rows returned by this query dropped noticeably. Is this a bug, is my query just fubar'd, or...? SELECT account.username AS account_username, customers.username AS customers_username, account.accout_no, account.email, customers.last_mod FROM account LEFT JOIN customers ON account.username = customers.username WHERE (customers.username IS NULL OR customers.username LIKE \"%_expired\") OR (customers.last_mod = current_date() - 14 AND customers.access_status = 'D') ORDER BY last_mod"; The number of rows returned: 4/10 253 4/9 247 4/8 243 4/7 241 4/6 234 4/5 226 4/4 221 4/3 216 4/2 207 4/1 197 3/31 333 3/30 312 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
PHP (--with MySQL) Installation error
I am trying to install PHP 4.0 on a intel machine running Red Hat Linux 6.2. I have the MySQL version 3.22.32 installed and works fine. It is located in: /usr/local/mysql-3.22.32-pc-linux-gnu-i686 When installing the PHP with the ./configure command I get: *** * Attention! * * Something is likely to be screwed up here, because the configure script * * was not able to detect a simple feature on your platform. This is often* * caused by incorrect configuration parameters. * *** I have Apache installed, up and running, installed MySQL and tested it and it works fine. I get to the PHP installation and get an error that something is most likely wrong. I have included the contents of the debug.log file. MySQL is located in /usr/local/mysql-3.22.32-pc-linux-gnu-i686 and I also verified the location of the apxs to be correct. Contents of debug.log: CONFIGURE: './configure' '--with-mysql=/usr/local/mysql-3.22.32-pc-linux-gnu-i 686' '--with-apxs=/usr/local/apache_1.3.12/bin/apxs' CC: gcc CFLAGS: -g -O2 CPPFLAGS: CXX: CXXFLAGS: INCLUDES:-I/usr/local/apache_1.3.12/include -I$(top_builddir)/Zend -I$(top_ srcdir) -I/usr/local/mysql-3.22.32-pc-linux-gnu-i686/include LDFLAGS: -Wl,-rpath,/usr/local/mysql-3.22.32-pc-linux-gnu-i686/lib/mysql -L/ usr/local/mysql-3.22.32-pc-linux-gnu-i686/lib/mysql LIBS: -lmysqlclient -lgd -lresolv -lm -ldl -lcrypt -lnsl -lresolv DLIBS: SAPI: apache PHP_RPATHS: /usr/local/mysql-3.22.32-pc-linux-gnu-i686/lib/mysql uname -a: Linux linux.rc.national.edu 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST 2000 i686 unknown gcc -o conftest -g -O2 -Wl,-rpath,/usr/local/mysql-3.22.32-pc-linux-gnu-i686/l ib/mysql -L/usr/local/mysql-3.22.32-pc-linux-gnu-i686/lib/mysql conftest.c -lmys qlclient -lgd -lresolv -lm -ldl -lcrypt -lnsl -lresolv 15 /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status End of debug.log file... P.S. PHP installs fine if I do not include the --with for the MySQL. Laurie A. Keith Network Manager National American University (605) 394-5008 [EMAIL PROTECTED]
relationship/field design
I have a table design question, looking for tips, not the exact sql to create the tables. I have tried several solutions, and as yet, I don't like what I am coming up with. So if someone could help me, I would be grateful. Assumptions: email_address's have several types, defined by a separate table: home work personal business website_admin mobile emergency other A user must have 1 email_address of any type, for account creation and messages. login_name password A user may have many email_address, only one of each type, as desired/needed A user may use an email_address, already being used, for account creation, but must use different login name/password. Message emails will have to be viewed online/downloaded after a login). (for multiple accounts off of one email address, especially for children) The biggest problem seems to be structuring the tables to force the requirement for at least ONE email address, but not having to create lots of empty fields. Sincerely, Dennis Gearon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URGENT: select in (select) or Join?
Hello, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word1%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement INTERSECT select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word2%') and C.CategoryCode=E.SubCategoryCode order by ME.Emplacement Can you Help me, IS there another way to do the join or intersection function All my Thanks for you. ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql installation problems on sparc-sun-solaris8
I downloaded the solaris 8 mysql package from ftp://ftp.sunfreeware.com/pub/freeware/sparc/8/mysql-3.22.26a-sol8-sparc-local.gz and installed it, but when i try to run /usr/local/mysql/bin/safe_mysqld, it reports the following error to /usr/local/mysql/var/wakko.err: mysqld started on Thu Apr 12 15:29:39 PDT 2001 ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory mysqld ended on Thu Apr 12 15:29:39 PDT 2001 any idea how to fix this? i tried looking for the libstdc++.so.2.10.0 library, but to no avail. Should i compile mysql from scratch or look more for the library. any ideas/experiences would be greatly appreciated. thanks, ethan [EMAIL PROTECTED]
connecting to mysql using php
i'm trying to connect to mysql using php so that i can do web based
queries of my tables. i'm new at this so here are some questions:
1. is localhost just the ip of my server or is it also the path to
where mysql is on my server?
2. if root is the login name should it be my login or just stay as root?
3. is mypasswd the same password i enter when i'm in the mysql
evironment in reference to (mysql -u root -p)?
once i can declare the dbcnx variable i'll be able to do queries with php.
josh
// Connect to the database server
$dbcnx = @mysql_connect("localhost",
"root", "mypasswd");
if (!$dbcnx) {
echo( "PUnable to connect to the " .
"database server at this time./P" );
exit();
}
--
dreaming america : visual media studio
503.222.2242 : http://dreamingamerica.com
...:::. http://rangermag.com :::...:::.:.v.1.i.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
Cracking Win 2000 hash?
I have a flat txt file that I need to decrypt so that I can build a new database for membership. It was encrypted on a Windows 2000 box. Here is an example of the format: mystic:kdYE[JQKAZAKaMZEKWNeL: mr:ihIAUNUYBACYUZeK_^]d: jr:bxX[TMcaXAeIed__[LWN: Anybody have any suggestions? Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cracking Win 2000 hash?
Do you have code on how it is encrypted? 'on a windows 2000 box' doesn't say much. Windows passwords are stored in the sam database, in a binary format, unreadable by users (and even by admins). You can brute force those with l0pthcrack (www.l0pht.com), I don't know if it works for windows 2000. On Thu, Apr 12, 2001 at 04:22:27PM -0700, Alan Halls wrote: I have a flat txt file that I need to decrypt so that I can build a new database for membership. It was encrypted on a Windows 2000 box. Here is an example of the format: mystic:kdYE[JQKAZAKaMZEKWNeL: mr:ihIAUNUYBACYUZeK_^]d: jr:bxX[TMcaXAeIed__[LWN: Anybody have any suggestions? Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using php
This is a real RTFM, but here we go:
On Thu, Apr 12, 2001 at 04:03:20PM -0700, josh kneedler wrote:
i'm trying to connect to mysql using php so that i can do web based
queries of my tables. i'm new at this so here are some questions:
1. is localhost just the ip of my server
Yes. Or just the word 'localhost'. Or your full server name.
2. if root is the login name should it be my login or just stay as root?
The name of the account you want to use to connect to the database.
3. is mypasswd the same password i enter when i'm in the mysql
evironment in reference to (mysql -u root -p)?
Yes.
once i can declare the dbcnx variable i'll be able to do queries with php.
josh
// Connect to the database server
$dbcnx = @mysql_connect("localhost",
"root", "mypasswd");
if (!$dbcnx) {
echo( "PUnable to connect to the " .
"database server at this time./P" );
exit();
}
--
dreaming america : visual media studio
503.222.2242 : http://dreamingamerica.com
...:::. http://rangermag.com :::...:::.:.v.1.i.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
Re: relationship/field design
On Thu, Apr 12, 2001 at 03:16:42PM -0700, Dennis Gearon wrote: The biggest problem seems to be structuring the tables to force the requirement for at least ONE email address, but not having to create lots of empty fields. Looks like you're looking for foreign keys, but you can't do that in mysql. Just code carefully :-) http://www.mysql.com/doc/e/x/example-Foreign_keys.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
Re: Cracking Win 2000 hash?
"l0phthcrack" should work, since the "rocket scientists" in Redmond have still retained the "NetBIOS" version of the password (the old "Windows for Workgroups" version) in the SAM. So much for improved security... (HA HA HA HA HA HA HA ) Roel Vanhout wrote: Do you have code on how it is encrypted? 'on a windows 2000 box' doesn't say much. Windows passwords are stored in the sam database, in a binary format, unreadable by users (and even by admins). You can brute force those with l0pthcrack (www.l0pht.com), I don't know if it works for windows 2000. On Thu, Apr 12, 2001 at 04:22:27PM -0700, Alan Halls wrote: I have a flat txt file that I need to decrypt so that I can build a new database for membership. It was encrypted on a Windows 2000 box. Here is an example of the format: mystic:kdYE[JQKAZAKaMZEKWNeL: mr:ihIAUNUYBACYUZeK_^]d: jr:bxX[TMcaXAeIed__[LWN: Anybody have any suggestions? Alan
Re: connecting to mysql using php
Let me explain a little further.
- Original Message -
From: "josh kneedler" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 13, 2001 7:03
Subject: connecting to mysql using php
i'm trying to connect to mysql using php so that i can do web based
queries of my tables. i'm new at this so here are some questions:
1. is localhost just the ip of my server or is it also the path to
where mysql is on my server?
Using the word localhost is only used when mysql server is on the same
machine as your web server otherwise you need ip address or full host name.
2. if root is the login name should it be my login or just stay as root?
Not a good idea to use root, create another user with restricted access.
3. is mypasswd the same password i enter when i'm in the mysql
evironment in reference to (mysql -u root -p)?
once i can declare the dbcnx variable i'll be able to do queries with php.
josh
// Connect to the database server
$dbcnx = @mysql_connect("localhost",
"root", "mypasswd");
if (!$dbcnx) {
echo( "PUnable to connect to the " .
"database server at this time./P" );
exit();
}
--
dreaming america : visual media studio
503.222.2242 : http://dreamingamerica.com
...:::. http://rangermag.com :::...:::.:.v.1.i.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
Re: privilege problem
...And you have checked that permissions have been set correctly, both in MySQL and at the OS level. - Original Message - From: "Leon Zilber" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 13, 2001 3:27 Subject: privilege problem I am not sure I am encoutering the following problem when I try to access the database? java.sql.SQLException: Server configuration denies access to data source java.sql.SQLException: Server configuration denies access to data source My java program defines: user and a password and when I connect to the DB, I use user and password, but for some reason, I get SQL Exception - Server configuration denies access to data source. Thank you very much for your help, Leon __ Do You Yahoo!? Get email at your own domain with 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
UTF-8 supported, compatible or plain won't work ?
Can you use UTF-8 with MySQL ? Is UTF-8 supported now, just compatible or plain won't work ? I've read conflicting discussion on this topic. thanks, - Sam. - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
