3.22.23 table problem
Hi! "Goodman," == Goodman, Michael [EMAIL PROTECTED] writes: Goodman, I'm not sure exactly what happened, but mysql was freezing everytime I tried Goodman, to access a particular table...everytime I tried to select anything from it, Goodman, alter it, drop it, whateverjust nothing worked and mysql crashed. I Goodman, ended up having to temporarily remove the table files, kill mysql and Goodman, restart it, then create a new table from scratch. I have the old corrupt Goodman, tables backed up and I need tro recover that data very badly! Goodman, Remember that this is mysql 3.22 not 3.23, therefore the tables are ISAM and Goodman, not MyISAMwould anyone know how to recover the lost data? I'll even send Goodman, the files over if someone wants to take a look. Have you read the 'repair' section in the MySQL manual ? http://www.mysql.com/doc/R/e/Repair.html Everything concerning myisamchk in this chapter should also work for isamchk. If you can get this to work, please send a backup of your original table (before attempting to recover data) to: ftp://support.mysql.com/pub/mysql/secret and we will take a look at this! 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: A report generator MySQL
Hi Laurie, You can also try: http://www.scibit.com/Mascon Full Reporting support, with images, graphs, pivottables, etc, etc. -Original Message- From: Laurie Savage [mailto:[EMAIL PROTECTED]] Sent: 20 January 2001 04:03 To: [EMAIL PROTECTED] Subject: A report generator MySQL I am writing a database to store student academic records at my local high school. I wish to generate attractively published reports home to parents. Does anybody know of a method or product that will produce elegantly formatted reports from MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-INST] PHP and MySQL in red hat 7.0
In your php.ini file: extension=mysql.so -Rasmus On Sat, 20 Jan 2001 [EMAIL PROTECTED] wrote: Thanks Matt. MySQL is finally working. But the problem now is that PHP is not recognizing its MySQL functions. The error I am getting is: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/Willy/MySQL/test1.php on line 28 Well, the php_mysql RPM has been installed along with mod_php4.rpm. PHP can recognize its own functions but not those of MySQL. I checked for the RPMs to be installed and I have installed all the php RPMs ( including php-mysql RPM). despite doing all that I get this error. MySQL is running perfect as I get the status when I type "mysqladmin -u=root status". Please help me. This is very urgent for me. Thank You. Willy -- From: Matt Wagner[SMTP:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 4:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: socket problem in red hat. [EMAIL PROTECTED] writes: Hi there, I am setting up a lab on MySQL and I am not able to. Its a red hat 7.0 server and has PHP installed and working with apache. I installed MySQL from the very RPMs Red Hat provided. Whenever I try to start the server, I get the error message: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't understand what this socket problem is and I went through all documentation and couldn't find a solution to this. Can you please provide a solution to this at the earliest. I have students piling on my head and I have already skipped my deadline of setting the server up. Hi! We have seen this problem (although I have not personally investigated) with many RH7+default_mysql. The quick and easy solution (until I figure out further) is to download the MySQL RPMs from: http://www.mysql.com/downloads/mysql-3.23.html Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall ours. Like I said, I'm not sure what RedHat is doing wrong with their MySQL RPMs... But I have seen this numerous times with regard to their supplied RPMs. Something is amiss. I will investigate more. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ___/ Developer -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL in red hat 7.0
Dear Rasmus, I checked the php.ini file and the entry "extension=mysql.so" already exists under the "dynamic extensions" section. But the problem still exists. Please help me. regards, Willy -- From: Rasmus Lerdorf[SMTP:[EMAIL PROTECTED]] Sent: Saturday, January 20, 2001 2:59 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-INST] PHP and MySQL in red hat 7.0 In your php.ini file: extension=mysql.so -Rasmus On Sat, 20 Jan 2001 [EMAIL PROTECTED] wrote: Thanks Matt. MySQL is finally working. But the problem now is that PHP is not recognizing its MySQL functions. The error I am getting is: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/Willy/MySQL/test1.php on line 28 Well, the php_mysql RPM has been installed along with mod_php4.rpm. PHP can recognize its own functions but not those of MySQL. I checked for the RPMs to be installed and I have installed all the php RPMs ( including php-mysql RPM). despite doing all that I get this error. MySQL is running perfect as I get the status when I type "mysqladmin -u=root status". Please help me. This is very urgent for me. Thank You. Willy -- From: Matt Wagner[SMTP:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 4:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: socket problem in red hat. [EMAIL PROTECTED] writes: Hi there, I am setting up a lab on MySQL and I am not able to. Its a red hat 7.0 server and has PHP installed and working with apache. I installed MySQL from the very RPMs Red Hat provided. Whenever I try to start the server, I get the error message: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't understand what this socket problem is and I went through all documentation and couldn't find a solution to this. Can you please provide a solution to this at the earliest. I have students piling on my head and I have already skipped my deadline of setting the server up. Hi! We have seen this problem (although I have not personally investigated) with many RH7+default_mysql. The quick and easy solution (until I figure out further) is to download the MySQL RPMs from: http://www.mysql.com/downloads/mysql-3.23.html Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall ours. Like I said, I'm not sure what RedHat is doing wrong with their MySQL RPMs... But I have seen this numerous times with regard to their supplied RPMs. Something is amiss. I will investigate more. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ___/ Developer -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: temp tables lock unrelated tables
Michael Griffith writes:
My TMPDIR is actually not separate from the data. There is plently of disk
space. In fact, thinking it was some sort of RAM problem I reduced the size
of the database by almost 30% with no change in performace.
You say this should not happen, yet as I've been searching the mailing list
there's at least 2-3 threads in the last year talking about this problem.
Most posts have gone unanswered.
I acutally have over 250 unrelated threads that get locked during a 1 minute
long query. Since my web server is set for 256 MAX processes, the website
that links to the DB dies until the offending query ends.
This happens with many queries. All are tuned and have worked for months
until recently. In fact no code has changed in our scripts. Unrelated table
just started locking all of a sudden. Also we have run isamchk
100% of the tables are in RAM. The only disk access should be updates. This
may be useful. This is the mysqladmin ext output when NO query is locked:
+--++
| Variable_name| Value |
+--++
| Aborted_clients | 1 |
| Aborted_connects | 1 |
| Created_tmp_tables | 7809 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 69600 |
| Handler_read_first | 251|
| Handler_read_key | 6190764|
| Handler_read_next| 19966429 |
| Handler_read_rnd | 1085708844 |
| Handler_update | 940141 |
| Handler_write| 593065 |
| Key_blocks_used | 59010 |
| Key_read_requests| 18022185 |
| Key_reads| 57325 |
| Key_write_requests | 600364 |
| Key_writes | 277250 |
| Max_used_connections | 256|
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 511|
| Open_files | 106|
| Open_streams | 0 |
| Opened_tables| 1173 |
| Questions| 675496 |
| Running_threads | 5 |
| Slow_queries | 20005 |
| Uptime | 23360 |
+--++
Hi!
Are all your tables HEAP tables or are they in a RAM disk ??
Also, please send me the entire processlist when such a lockup
occurs.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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: temp tables lock unrelated tables
Michael Griffith writes:
Cacheing before writing sounds like exactly the type of thing that would
explain the problem. However, I'm on FreeBSD (Sorry, didn't give too many
details). Anybody know if there is something similar in to bdflush BSD?
I did run iostat to monitor the the activity during the freeze. It appears
that the writes to the disk about double the usual, but average 1MB/s.
7200 RPM SCSI Barracuda, seems like it should be able to handle more. CPU is
even 50% idle
Currently I do not have the TMPDIR on a separate physical disk from the
data. This is looking like the most obvious solution. But I'm still
confused -- I had no problems at all 48 hours ago. Now suddenly disk
locking.
Thanks.
Hi!
What FreeBSD ?? If any of 4.* kind, there were many important patches
for it, especially since 10th of January.
Ken Menzel has sent a lot of important details on patching of the
latest FreeBSD generations to this list. Please read his mailings.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
replication crashed, a bug?
My replication crashed just once again... my my.cnf on the slave contains: master-host = 123.123.123.123 master-user = rep master-password = hidden replicate-do-db = db1 server-id = 6 replicate-ignore-table=db1.specials I created a new DB on the master called "specials". created 100 tables on the specials called data00, data01, data02 etc. I then did a replace into specials.data10 select * from db1.specials where mynumber LIKE '10%'; on the master which works fine, but the slave crashed and I found *nothing* in mysql.err, it was empty, even after I tried "SLAVE START" several times. I then restartes thge mysql-server on the slave and did "SLAVE START" again and then found in mysql.err: ERROR: 1146 Table 'specials.data10' doesn't exist 010120 16:19:20 Slave: error running query 'replace into specials.data10 select * from db1.specials where mynumber LIKE '10%'' 010120 16:19:20 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave Of course, the the database specials and the table don't exist. they are not in the replication. I now did a mysqldump -d specials file and created the database and tables on the slave to get the slave running again, but that's not how the problem should be solved. Is this a bug? mysql 3.23.28-gamma Thanks Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dreamweaver can't connect to MySQL - that can't be!
"Murph" [EMAIL PROTECTED] writes: I'm test-driving Dreamweaver UltraDev 4 and can't get it to connect to = my remotely hosted MySQL database despite the last six hours' worth of = effort. Macromedia's online docs aren't helping much. Can you do it via any other front end? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SECURITY issue in remote tcp/ip connecting?
Derek Sivers wrote: Any measures I could take (like SSH) to encrypt the transaction? Use CIPE tunnel. You can find it: http://sites.inka.de/sites/bigred/devel/cipe.html Is this anything like ipsec? http://www.openbsd.org/faq/faq13.html (I'm using OpenBSD.) Or, rather, could I use ipsec for this same thing as CIPE, too? From reading the two sites/descriptions, it sounds like the same thing. Yes, but CIPE have smaller footprint and seems easier to install. But this doesn't matter if you like IPSec in some reason. IPSec have own advantages by wider support. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error with Mysqld operating......
Hi:
Happy New Year!!
Today I downloaded the Mysql-3.23.31 and installed
on win98.
When I executed a little test query string on
the localhost web (win98 )just like :
-
?
mysql_pconnect ("localhost","root","1234");
mysql_select_db("gon");
$result=mysql_query("select * from mymp3 ");
if ($resutl) {
echo "Query successful!!"; }
?
--
I thought it to be a simple test, but it always
happen to pop up the message menu :
:
: DUBUG :
:---:
:test signal:
:---:
then pop up the follow menu shows system error:
--
MYSQLD caused an invalid page fault in
module MYSQLD.EXE at 015f:0052cad0.
Registers:
EAX=0004 CS=015f EIP=0052cad0 EFLGS=00010246
EBX=0008 SS=0167 ESP=0181f964 EBP=0181f9d0
ECX=0004 DS=0167 ESI=816c4c10 FS=3357
EDX=0181fe84 ES=0167 EDI=816d9990 GS=
Bytes at CS:EIP:
8b 01 ba ff fe fe 7e 03 d0 83 f0 ff 33 c2 83 c1
Stack dump:
004d0611 0004 816d9990 816c4c10 0008 015f
bff80f5d c15d82e8 0109 0181fa08 0034 0181fa08
0034 0181fa00 002
-
and then mysqld stop running and shutdown itself.
What's wrong with that ? Was it my own system problem?
or any other error ?
Would you please tell me how to solve it? Thanks!
Fongming from Taiwan!!
2001/1/21
-
This mail sent through IMP: http://web.horde.org/imp/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error with Mysqld operating......
On Saturday 20 January 2001 09:32, fongming wrote:
Hi:
Happy New Year!!
Today I downloaded the Mysql-3.23.31 and installed
on win98.
When I executed a little test query string on
the localhost web (win98 )just like :
-
?
mysql_pconnect ("localhost","root","1234");
mysql_select_db("gon");
$result=mysql_query("select * from mymp3 ");
if ($resutl) {
echo "Query successful!!"; }
?
--
I thought it to be a simple test, but it always
happen to pop up the message menu :
:
: DUBUG :
:---:
:test signal:
:---:
then pop up the follow menu shows system error:
--
MYSQLD caused an invalid page fault in
module MYSQLD.EXE at 015f:0052cad0.
Registers:
EAX=0004 CS=015f EIP=0052cad0 EFLGS=00010246
EBX=0008 SS=0167 ESP=0181f964 EBP=0181f9d0
ECX=0004 DS=0167 ESI=816c4c10 FS=3357
EDX=0181fe84 ES=0167 EDI=816d9990 GS=
Bytes at CS:EIP:
8b 01 ba ff fe fe 7e 03 d0 83 f0 ff 33 c2 83 c1
Stack dump:
004d0611 0004 816d9990 816c4c10 0008 015f
bff80f5d c15d82e8 0109 0181fa08 0034 0181fa08
0034 0181fa00 002
-
and then mysqld stop running and shutdown itself.
What's wrong with that ? Was it my own system problem?
or any other error ?
Would you please tell me how to solve it? Thanks!
We have just recently detected this bug and I have sent an advisory with the
patch to [EMAIL PROTECTED] If you can, wait until we release an update.
If not, use 3.23.30. Of course, you could apply the patch and compile MySQL
yourself, if you have Visual C++.
--
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
install_driver(mysql) failed: Can't load '../blib/arch/auto/
I installed mysql on a Redhat client on the LAN. Used ./configure --without-server option. Now when I make test Msql-Mysql-modules I get the following: [root@lowlyfollower Msql-Mysql-modules-1.2214]# make test make[1]: Entering directory `/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1. 2214/mysql' make[1]: Leaving directory `/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1.2 214/mysql' make[1]: Entering directory `/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1. 2214/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5. 00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $ve rbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/ DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1.2 214/mysql' make: *** [test] Error 2 The mysql server is up and running and I do have have write priveledges. Can anyone please help? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 C API: Problem with load_defaults
I'm using the code found on page 245 - 247 of Paul Dubois' book, MySQL. When
I attempt to make it
under Code Crusader, I get the error found below.
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c common.c -o
common.o
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c client4.c -o
client4.o
cc1: warnings being treated as errors
client4.c: In function `main':
client4.c:35: warning: passing arg 2 of `load_defaults' from incompatible
pointer type
make: *** [show_argv.o] Error 1
This occurs in the groups argument to load_defaults. Groups is declared as
char *groups[] = {"client", null};
load_defaults is called in the following manner:
snip
my_init();
load_defaults ("my", groups, argc, argv);
snip
When I remove the -Werror, it makes fine, and the program runs correctly.
Has anybody else encountered
this problem?
Software versions:
glibc version is 2.1.3-15
mysql version is 3.23.27-beta, installed from source with
./configure --enable-thread-safe-client --with-pthread --with-debug
Running Redhat 6.2 (Zoot)
Thanx
-Brian K. Hlady
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VARCHAR comparison problem
Hi, I recently ran into a problem when doing comparison against varchar field. Basically, comparing 'foo' and 'foo ' (note extra space) against the records produced the same results - almost as if MySQL trims the whitespace from the search parameter before running the search. Can anyone shed light on this issue? This is with the 3.23.30-gamma. -Andrei * We are not a clone. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
info please (newbie)
is this the proper comparison: MySQL and Cold Fusion Server (not CF Studio)? i just started a database class (relational/ODBC) -they will of course, eventually, use CF and Access... only a little -it's a general class. i, of course:), wish to resist those! i run OS X pb. one kindly friend was helping to get going (we haven't really gotten up yet) with Jakarta/Tomcat and the free license version of FrontBase. i only barely know what those are, but i did download, compile, and run the test... but my friend he figure out how to configure it to run with Apache (x.x.14). maybe the folks here would recommend other alternatives? i would like to be able to work on my machine still transfer it to the school's network (i guess). i haven't asked the teacher yet, but i need a plan. hope i'm in the right place... all recommendations are appreciated. TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL C API: Problem with load_defaults
On Sat, Jan 20, 2001 at 02:53:22PM -0500, Hlady, Brian wrote:
I'm using the code found on page 245 - 247 of Paul Dubois' book, MySQL. When
I attempt to make it
under Code Crusader, I get the error found below.
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c common.c -o
common.o
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c client4.c -o
client4.o
cc1: warnings being treated as errors
client4.c: In function `main':
client4.c:35: warning: passing arg 2 of `load_defaults' from incompatible
pointer type
make: *** [show_argv.o] Error 1
This occurs in the groups argument to load_defaults. Groups is declared as
char *groups[] = {"client", null};
Try putting "const" in front of "char" and see what happens.
load_defaults is called in the following manner:
snip
my_init();
load_defaults ("my", groups, argc, argv);
snip
When I remove the -Werror, it makes fine, and the program runs correctly.
Has anybody else encountered
this problem?
Software versions:
glibc version is 2.1.3-15
mysql version is 3.23.27-beta, installed from source with
./configure --enable-thread-safe-client --with-pthread --with-debug
Running Redhat 6.2 (Zoot)
Thanx
-Brian K. Hlady
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select queries on merged tables?
Just a quick question, maybe I'm missing the point of using merged tables, but why do I have to use like '%string' to find a match from a merged table instead of = 'string'? Example. mysql select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from combined_search where PARTNO = 'DSB-C300' order by PRICE,STOCK; ERROR 1030: Got error 124 from table handler mysql select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from combined_search where PARTNO like '%DSB-C300' order by PRICE,STOCK; | PARTNO | SUP | SUP_PARTNO | STOCK | PRICE | DESCR | | | DSB-C300 | tec | 143224 | 0 | 95.32 | USB WEBCAM 32FPS DESKTOP 64M COLOR |DIGITAL VIDCAM| | DSB-C300 | mer | 1621452| 0 | 95.69 | USB WEB CAM, 300K PIXEL | | | DSB-C300 | ing | 119607 |22 | 97.00 | USB WEBCAM 32 FPS DESKTOP 64 MILLION |COLOR DIGITAL VIDEO CAM | +--+--++---+---+--+ 3 rows in set (0.73 sec) -- - / \John Hoffmann Systems Engineer / . \ Professional Services VA LiNUX Systems Inc \ . /http://www.valinux.com[EMAIL PROTECTED] \_/ Linux Systems Work: (510) 687-6879Cell: (613) 290-5217 - This is Linux Country. On a quiet night, you can hear Windows reboot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VARCHAR comparison problem
On Sat, Jan 20, 2001 at 02:46:49PM -0600, Andrei Zmievski wrote: I recently ran into a problem when doing comparison against varchar field. Basically, comparing 'foo' and 'foo ' (note extra space) against the records produced the same results - almost as if MySQL trims the whitespace from the search parameter before running the search. Can anyone shed light on this issue? This is with the 3.23.30-gamma. MySQL does trailing whitespace removal on all VARCHAR data as described in the manual. 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
datetime field
How much space is taken by the datetime field? Is there any way that we can only store date or time in it? How we can seperate date and time from this field? Regaards, Ghazi, Muhammad Farhan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
datetime field
How much space is taken by the datetime field? Is there any way that we can only store date or time in it? How we can seperate date and time from this field? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: datetime field
In the last episode (Jan 21), Muhammad Farhan Ghazi said: How much space is taken by the datetime field? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Storage_requirements Is there any way that we can only store date or time in it? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types How we can separate date and time from this field? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions - Before posting, please check: http://www.mysql.com/manual.php (the manual) Maybe we should put this someplace more conspicuous. People don't seem to know about the manual.. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VARCHAR comparison problem
At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote: MySQL does trailing whitespace removal on all VARCHAR data as described in the manual. Hmm, well that presents a problem in my application that counts on exact comparisons - I guess a way to do it is to use 'like' instead of '='? -Andrei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC access 2000
when i connect to a mysql server and use the odbc driver, i get #deleted no matter what i do. I can connect authenticate ok. does nayone have a suggestion ?? thanks in advance Gabriel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VARCHAR comparison problem
At 11:01 PM -0600 1/20/01, Andrei Zmievski wrote: At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote: MySQL does trailing whitespace removal on all VARCHAR data as described in the manual. Hmm, well that presents a problem in my application that counts on exact comparisons - I guess a way to do it is to use 'like' instead of '='? You might consider using one of the TEXT types. Trailing space removal isn't used for those types. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
