Red Hat 8.0 compile problems with 4.0.10

[Duncan Maitland]

I am having trouble compiling a custom mysqld (version 4.0.10) under Red
Hat 8.0 - I did email this list a few weeks ago and I have tried a few
things since then but I am asking again in the hope that someone more
knowledgeable might be able to help.

As far as I can tell this is a compiling or linking problem.


System information:
The system is a dual AMD Athlon MP 1800+ on a Tyan S2466 mainboard with
1GB ram and 1GB swap. The system is using an Adaptec 2400A ATA RAID
card.

Operating system:
Standard installation of Red Hat Linux 8.0 - kernel is 2.4.18-14smp


My configure line:
./configure --prefix=/usr/local/mysql-4.0.10
--localstatedir=/home/database/mysql-4.0.10 --enable-assembler
--disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-thread-safe-client
--with-extra-charsets=complex --with-debug --with-tcp-port=3307
--with-unix-socket-path=/tmp/mysql-4.0.10.sock



The problem surfaces when the mysql_install_db script attempts to
install the prepared grant tables. Output is as follows:

[root@jupiter mysql-4.0.10-gamma]# ./scripts/mysql_install_db
--defaults-file=/etc/mysql/mysql-4.0.10.cnf
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked against is corrupt, improperly
built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=268435456
read_buffer_size=1044480
sort_buffer_size=1048568
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 466543 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x83e3718
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbf5fefb8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8089d51
0x823f280
0x825dc8d
0x822fe03
0x80ab6de
0x8095113
0x823a6d5
0x827669a
./scripts/mysql_install_db: line 1: 18414 Segmentation fault
/usr/local/mysql-4.0.10/libexec/mysqld
--defaults-file=/etc/mysql/mysql-4.0.10.cnf --log --debug --bootstrap
--skip-grant-tables --basedir=/usr/local/mysql-4.0.10
--datadir=/home/database/mysql-4.0.10 --skip-innodb --skip-bdb
Installation of grant tables failed!

Examine the logs in /home/database/mysql-4.0.10 for more information.
You can also try to start the mysqld daemon with:
/usr/local/mysql-4.0.10/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/mysql-4.0.10/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/mysql-4.0.10/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /home/database/mysql-4.0.10 that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the
/usr/local/mysql-4.0.10/bin/mysqlbug script!
[root@jupiter mysql-4.0.10-gamma]#



The stack trace resolved as follows:

0x8089d51 handle_segfault + 431
0x823f280 __pthread_sighandler + 116
0x825dc8d vfprintf + 8057
0x822fe03 _db_doprnt_ + 189
0x80ab6de _Z19close_thread_tablesP3THDb + 290
0x8095113 handle_bootstrap + 779
0x823a6d5 pthread_start_thread + 177
0x827669a thread_start + 4


If anyone has any ideas, or even better, if anyone has a solution to
this problem then please reply to this post.

Many thanks,
Duncan Maitland
[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: Formatting SQL in Access

[Bob Hall]

query database

On Fri, Feb 14, 2003 at 11:17:22AM +1100, Daniel Kasak wrote:
> You have to use the visual basic constant: vbCrLf

Or vbNewLine.

Bob Hall

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Delete duplicate rows

[Lewis Watson]

I need to delete duplicate rows. Each row that is in the table has an
exact duplicate of itself. There are four columns. No one column could be
defined as a primary key; however, two columns together could. What's
going to be the best way to do this?
Thanks.
Lewis

mysql, 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

Error No. 7

[Insanely Great]

Hello

When I use the Alter table structure command to alter any field,  it comes
up with an error
stating that Error number 7 - error in renaming of table "table name.myi" to
"sql-208..." and so on with (Errorcode 13). Thus I am unable to change the
structure of any table.

I am using MySQL ver 3.23.55 and on a Windows XP professional system.

Any help.

Insane




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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:ÄúºÃ!
ÇëÔÊÐíÎÒÏòÄú½éÉÜ´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þ¡£

ÉÌÕ½²Ð¿á£¬Ë­Ó®µÃ¸ü¶à¿Í»§Ë­¾ÍÓÐÁËÉú´æµÄȨÀû£¬µ«ÄúµÄ¿Í»§ÔÚÄÄÀïÄØ£¿Ñ°ÕÒÄúµÄ¿Í»§ÊÇÃæÁÙÉú´æµÄµÚÒ»²½¡£
ÏÖÔÚÓµÓдó·ͨϵÁÐÓªÏúÈí¼þÒ»ÇбäµÃ¼òµ¥£¬Ö»ÐèÄúÌîÉÏËùÐèÒª¿Í»§µÄÃû³ÆÈç"óÒ×¹«Ë¾""»¯¹¤ÆóÒµ""ÂÃÓÎÒµ""±±¾©
µØÇøÍâó½ø³ö¿Ú¹«Ë¾"µÈµÈ..¿É¸ù¾ÝÐèÒªÈÎÒâÌîд£¬Ö»Ð輸ÃëÖÓÄãËùÐèÒª¿Í»§¾ÍÁ¢¼´³ÊÏÖÔÚÄúµÄÃæÇ°£¬Ãæ¶ÔÉÏÍò
¼ÒÉõÖÁÉÏ°ÙÍò¼ÒÄúµÄÄ¿±ê¿Í»§ÈçºÎÁ¢¼´ÍƹãÄú×Ô¼ºÄØ£¿Ö»ÐèʹÓÃÎÒÃǵÄÈí¼þ²¢Ð´ÉÏÒ»·âÓʼþÉÌÒµÐź­Ë²¼äÊýÊ®Íò¼Ò
ÆóÒµ¾ù¿ÉÁ¢¼´ÊÕµ½£¬Ê£ÏµÄʾÍÊǽӵ绰£¬´¦Àí¶©µ¥ÁË¡£¶øÓÐÕë¶ÔÐԵķ¢ËÍÄúµÄÉÌÒµÓʼþÔò¿ÉÍêÈ«±Ü¿ªÀ¬»øÓʼþµÄ
ÏÓÒÉ¡£

ÎÒÃÇ»¹ÎªÄú×¼±¸ÁË´ó·ͨȫÇòÉÌóÐÅÏ¢·¢²¼Èí¼þ£¬Ëü¿ÉʹÄúµÄÉÌÒµÐÅϢ˲¼ä·¢²¼µ½³ÉǧÉÏÍò¼Ò¹úÄÚ»ò¹úÍâµÄÉÌ
óÐÅÏ¢ÍøÕ¾ÉÏ£¬¶øÕâÒ»ÇÐÖ»Ð輸ÃëÖÓʱ¼ä¡£

Ä¿Ç°¹úÄÚÍâÏÖÔÚ¹úÄÚ´ó¶àÊýÆóÒµÒѾ­¿ªÊ¼ÊµÊ©×Ô¼ºµÄÍøÂçÓªÏú¼Æ»®£¬¶ø´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þÊÇÆóÒµÍøÂçÓª
ÏúµÄ±Ø±¸¹¤¾ß¼òµ¥µÄ²Ù×÷¼´¿É×öǧÍòÈ˵Ĺã¸æ£¬È«Ã濪ÍØÊг¡¡¢Ñ°ÇóÈ«ÇòÂò¼Ò¡¢·è¿ñÔö¼ÓÏúÊÛ¶©µ¥¡¢Ê÷Á¢ÆóÒµÐÎ
Ïó¡¢½«ÆóÒµ¹ã¸æͶÈëËõ¼õΪÁ㣬ÕâÒ»ÇÐÄú¶¼¿ÉÒÔÔÚ˲¼ä×öµ½£¡


Ïêϸ×ÊÁÏÇë·ÃÎÊÎÒÃǵÄÍøÕ¾http://js.yuefeng2000.com»òÕß·¢Óʼþµ½[EMAIL PROTECTED]½øÐÐ×Éѯ£¬´ËÐÅÇë
ÎðÖ±½Ó»Ø¸´¡£

ÐĶ¯²»ÈçÐж¯£¬¸Ï¿ìÏÂÔØÊÔÓÃhttp://js.yuefeng2000.com
»ò·¢EMAILÃâ·ÑË÷È¡ÊÔÓãº[EMAIL PROTECTED]


Áí:±¾¹«Ë¾ÒòÒµÎñ·¢Õ¹ÐèÒª,³ÏÕ÷´úÀí,´ýÓöÓźñ.¸÷µØÇøÖ»ÓÐÒ»¸öÃû¶î,ÓÐÐËȤÕßÇëÀ´µç»òÀ´ÐŽøÐÐÁªÏµ.


´ó·ÍøÂç

꿅᣼http://js.yuefeng2000.com
µç»°£º025-2609854£¬4480931
´«Õ棺025-4480931
ÁªÏµÈË£ºÏÄС½ã
µç×ÓÓÊÏ䣺[EMAIL PROTECTED]



ÖÂ
Àñ!
   
   2003-02-15

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

cygwin strangeness

[Amy & Joseph Kormann]

I posted this to the win32 list and didn't get a response yet. Hopefully 
someone can help me.

Config information:
Hardware: P3-500
Software:
 Windows 98
 cygwin / bash 2.05b.0(8)-release (i686-pc-cygwin)
 g++ using gcc version 3.2 20020927
 mysql 3.23.55-max-debug for Win32/Win98 on i32 (executables off the 
web-site)

I've even tried compiling with the libraries specified on the web-site 
with the same results. This same source-code works fine on Linux.

Two problems:
1 - Cannot use load_defaults. I look for it and find it in 
libmysqlclient.lib, but if I link against it I get alot of errors (see 
following: NoLoadDefault.txt). I am able to link fine using libmySQL.lib 
but there is no load_defaults available.

2 - mysql_fetch_row() seems to be returning invalid MYSQL_ROW values. I 
have a query which returns back 100 rows using mysql_store_results(). I 
can tell this by looking at mysql_affected_rows() and the SQL is correct 
when executed in mysql. I am able to print a value for the first row, 
but it's not correct, then when attempting to access the second row, I 
get a seg-fault. To add to the strangeness, I have a control variable 
fldCnt which is assigned to 0; I print the value before I enter a 
for-loop to display the number of fields and columns. When I get into 
the for-loop, the  value changes. I'm also attaching the file - forgive 
the obvious spastic debugging.

Any suggestions?

Thanks in advance.

--
Amy and Joseph Kormann

NoLoadDefault.txt:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
g++ -c InsertMatrix.C -I/usr/include/mysql -I/cygdrive/c/mysql/include
In file included from /usr/include/c++/3.2/backward/iostream.h:31,
   from InsertMatrix.C:10:
/usr/include/c++/3.2/backward/backward_warning.h:32:2: warning: #warning 
This file includes at least one deprecated or antiquated header. Please 
consider using one of the 32 headers found in section 17.4.1.2 of the 
C++ standard. Examples include substituting the  header for the  
header for C++ includes, or  instead of the deprecated header 
. To disable this warning use -Wno-deprecated.
g++ -c ConnectionManager.C -I/usr/include/mysql -I/cygdrive/c/mysql/include
In file included from /usr/include/c++/3.2/backward/iostream.h:31,
   from ConnectionManager.C:1:
/usr/include/c++/3.2/backward/backward_warning.h:32:2: warning: #warning 
This file includes at least one deprecated or antiquated header. Please 
consider using one of the 32 headers found in section 17.4.1.2 of the 
C++ standard. Examples include substituting the  header for the  
header for C++ includes, or  instead of the deprecated header 
. To disable this warning use -Wno-deprecated.
g++ -o InsertMatrix -L/cygdrive/c/mysql/lib/opt -lmysqlclient -mt 
InsertMatrix.o ConnectionManager.o
InsertMatrix.o(.text+0xbe):InsertMatrix.C: multiple definition of `_main'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x0):D:\mysql-3.23.55\c: 
first defined here
Warning: resolving _mysql_query by linking to _mysql_query@8
Use --enable-stdcall-fixup to disable these warnings
Use --disable-stdcall-fixup to disable these fixups
Warning: resolving _mysql_error by linking to _mysql_error@4
Warning: resolving _mysql_errno by linking to _mysql_errno@4
Warning: resolving _mysql_close by linking to _mysql_close@4
Warning: resolving _mysql_real_connect by linking to _mysql_real_connect@32
Warning: resolving _mysql_init by linking to _mysql_init@4
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x18):D:\mysql-3.23.55\c: 
undefined reference to `__iob'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x76):D:\mysql-3.23.55\c: 
undefined reference to `__iob'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0xf7):D:\mysql-3.23.55\c: 
undefined reference to `__iob'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x117):D:\mysql-3.23.55\c: 
undefined reference to `__iob'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x3c):D:\mysql-3.23.55\l: 
undefined reference to `_getservbyname@8'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x4a):D:\mysql-3.23.55\l: 
undefined reference to `_ntohs@4'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x234):D:\mysql-3.23.55\l: 
undefined reference to `_socket@12'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x24e):D:\mysql-3.23.55\l: 
undefined reference to `_WSAGetLastError@0'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x341):D:\mysql-3.23.55\l: 
undefined reference to `_inet_addr@4'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x3d3):D:\mysql-3.23.55\l: 
undefined reference to `_htons@4'
/cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x406):D:\mysql-3.23.55\l: 
undefined reference to `_WSAGetLastError@0'
/cygdrive/c/mysql/lib/opt/mysqlclient.

Re: encrypted password

[Curtis Maurand]

I came to the same conclusion today after reading the docs again.  I would
prefer the des_encode if I need to get things back out of it, but since I'm
running 3.23.55, the des_encode function is not available to me.  I have a
need to encrypt data and then retrieve it later (credit card data).  I could
probably pass it through and md5 or des function via openssl I suppose and
then store it.  Perl and PHP both have functions to handle that.

Curtis


Tonu Samuel said:
> On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote:
>>
>> The manual suggests that the password function is really for intenal
>> mysql  functions.  Ideally you should use the encode or md5_encode
>> functions.
>>
>> update user set password=encode('password', 'salt') where user =
>> 'your_user';
>
> Unless manual does not say, what method is used for encode(), I would
> prefer MD5() which is known to be good enough.
>
> I remember something about "encode" from source code. If I remember
> properly it was "home-made" algorithm and home-made algorithms are
> always known to be "keep-away" algorithms.
>
> If you need security, always hire expert to analyze your needs and
> suggest exact ways to improve it. Even smaller mistake can void all
> efforts to secure something. Most security problems I have seen are
> results of doing security without knowing about topic. Often they lead
> to headlines as it was in CNN few months ago: "hackers stoled credit
> reports of 15000 people".
>
> Use MD5() for one-way hashing where result never needs to be decrypted
> (usually passwords)
> Use DES_ENCRYPT() for encrypting data if you want to decrypt it at some
> point.
> Surely do not use PASSWORD() anywhere.
>
> Tõnu




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Own mysqld per database

[Mark Arnold]

Hi,

I have an idea to reduce the interdependencies between my various databases as far as 
one database needing to be down for
maintenance is affecting other databases on the same server.
If I run one mysqld instance for all the databases on a server (the standard setup), 
all the databases become unavailable if I take
mysqld down, even though I might have to do maintenance for only one of the databases.
I have seen section 4.7.3 of the manual on mysqld_multi, however, this means defining 
different ports in all the connect statements
in all my scripts/programs I have.
Since I do have many scripts/db-connection configuration files, this means changing 
many files on many servers and i will definitely
overlook one or the other file. It also means having to change firewall settings every 
time I add/remove databases. Is there any way
to come in through the standard port for all the databases and then internally 
redirecting to the various engines/ports so that my
clients don't have to know about this?

Either as part of the standard MYSQL distribution or some additional add-on/plugin 
(hopefully a reliable one :) )...

Thanks,

MARK


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Rows

[Jerry]

I've gone over 60 million (per table and there are 4 of them) , had the
indexes sorted and it was a fast machine.

4 reference tables (foreign keys) then a counter which made a massive hash.

I'm starting to run into system and hard ware problems, more like open
files/inodes/through put, opposed to MySQL limits.

Which is nice. :)


Cheers
 -
 Jerry @
 MetalCat.Net
 -

 SQL

- Original Message -
From: "MySQL List" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 9:51 PM
Subject: Re: Rows


> Uhm, would that even be possible? that is one billion rows.
> I think that would take forever to search through! What do you think?
>
> I'm building an affiliate program, and I'm worried about the impressions,
> clicks and sales
> table getting too big, but shoot, if it could hold a few million with no
> problem, then
> I probably don't have to worry :o), or should I?
>
>
> Richard.
>
>
>
> - Original Message -
> From: "Jerry" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 14, 2003 3:23 PM
> Subject: Rows
>
>
> > Hi,
> >
> >  Any one gone over 1000 million rows ? or any where near ?
> >
> >  Pref. in ver 4+ with a MyISAM table.
> >
> >
> >  Cheers
> >  -
> >  Jerry @
> >  MetalCat.Net
> >  -
> >
> >  SQL
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

myisamchk vs. mysqlcheck

[Mark Arnold]

Hi,

I have a question about using myisamchk and mysqlchk.
I am running myisamchk -s on a certain table and get this error:
/usr/local/mysql/bin/myisamchk: MyISAM file /usr/local/mysql/var/db1/my_table.MYI
/usr/local/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table 
properly
MyISAM-table '/usr/local/mysql/var/db1/my_table.MYI' is usable but should be fixed

I am running mysql while doing the isamchk - which I know should be avoided. But in 
the manual it says I can do this as long as
nobody uses the table I am checking. I do not have any active connections, all 
connections are sleeping, but I still get the above
error.
I do not get the error however when I do "mysqlcheck db1 my_table".

Is the only reason for this the fact that I have mysql running? Are mysqlcheck and 
myisamchk doing the exact same thing. Or are
there scenarios in which one reports errors and the other doesn't.

Does mysqlcheck lock tables while checking? If so, does it do full locks or is 
read-access possible during the check is performed?

Thanks,

MARK


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Search All Fields ?

[John Berman]

Hi

Im using MYSQL and ASP

Im trying to implement a Search cross ALL 40 Fields in the table I have
tried lines like


  b_search = b_search & "[AGENOTES] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[MARITALSTATUS] LIKE '%" & pSearch & "%'
OR "
b_search = b_search & "[CHILDREN] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[PARENTS] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[SIBLINGS] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[YEARSMARRIED] LIKE '%" & pSearch & "%'
OR "
b_search = b_search & "[JCPUBLICATIONDATE] LIKE '%" & pSearch &
"%' OR "
b_search = b_search & "[POSITION] LIKE '%" & pSearch & "%' OR "

to build the search but I get a Query is to Complex error returned.

Am I going the right way about this ?

I think I can possibly index the fields and then maybe query the index ?


Any pointers would be appreciated

Regards

John Berman


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Slower access from a client some router hops away from mysqlserver

[Paul DuBois]

At 0:44 +0100 2/15/03, Jose Luis Pérez wrote:

We have developed an application with Visual Basic 6 managing through
myoledb some mysql server tables.

Perhaps it´s basic, but we have seen that the client application runs much
more slower in a point separated
through 2 routers and with 2 Mbps circuits than in the vlan where the mysql
server is located.

I assume that the bandwith is not the problem (a wan connnection with 2Mbps
circuits is enough) and there is some fine tunning (application, myoledb or
mysqlserver) we are not configuring in a proper way.


Why assume that?

It sounds like the application, myoledb and the MySQL server are the
constants, and that the network is the independent variable.

Bandwidth may appear to be adequate, but it seem to me like the network is
where you want to look to find the latency problems.



I will appreciate a lot any ideas about this.

Thanks


José Luis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Slower access from a client some router hops away from mysql server

[William R. Mussatto]

>
> We have developed an application with Visual Basic 6 managing through
> myoledb some mysql server tables.
>
> Perhaps it´s basic, but we have seen that the client application runs
> much more slower in a point separated
> through 2 routers and with 2 Mbps circuits than in the vlan where the
> mysql server is located.
>
> I assume that the bandwith is not the problem (a wan connnection with
> 2Mbps circuits is enough) and there is some fine tunning (application,
> myoledb or mysqlserver) we are not configuring in a proper way.
The first think I WOULD check is if bandwidth is the issue.  2 Mbps is
much slower than local LAN.  Also there is the possiblity of dropped
packets and retransmittals.  The more routers the slower this would be. 
Have you checked how busy the WAN is.

Just my $0.02 worth.

> I will appreciate a lot any ideas about this.
>
> Thanks
>
>
> José Luis


William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Slower access from a client some router hops away from mysql server

[Jose Luis Pérez]

We have developed an application with Visual Basic 6 managing through
myoledb some mysql server tables.

Perhaps it´s basic, but we have seen that the client application runs much
more slower in a point separated
through 2 routers and with 2 Mbps circuits than in the vlan where the mysql
server is located.

I assume that the bandwith is not the problem (a wan connnection with 2Mbps
circuits is enough) and there is some fine tunning (application, myoledb or
mysqlserver) we are not configuring in a proper way.

I will appreciate a lot any ideas about this.

Thanks


José Luis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Does MySQL store TimeZone and DayLight Saving Time changes ?

[Mariella Di Giacomo]

Hello,

We are running MySQL server Ver 3.23.8 on a Linux system.

We have a table that contains a field whose type is
MODIFIED | timestamp(14)

We would like to find out if there an easy way in MySQL to convert
the date that is on the MODIFIED field (timestamp)
to GMT time without an external program.

Does MySQL store TimeZone and DayLight Saving Time changes ?
Or does it have a way to find it once you have a field whose type is 
timestamp ?


Thanks a lot in advance for your help,

Patrick, Mariella




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

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: Row numbers

[Pete Harlan]

On Fri, Feb 14, 2003 at 01:04:00PM -0500, Luc Foisy wrote:
> I didn't say it had nothing to do with the data, I said it had
> nothing to do with the data in the database.  The data in the
> recordset returned from the database referenced by row is important.

[...]

> 1. There are a lot of functions that return values that have nothing
> to do with data contained in the database. Math functions for one,
> they calculate return values using data that is in the database. And
> many many other functions. Why not one more.

You're not just asking for a function whose input doesn't come from
the database, you're asking for one whose input comes from a later
pass in data processing.  After the row is inserted into the final
result set, this value has to be updated.

> In the 4.x series the
> developers implemented SQL_CALC_FOUND_ROWS and FOUND_ROWS(),
> something that could just have easily been handled by external
> programming...

I'm sure they weighed the utility of the change (saves a lot of
traffic and time, when you need it) against the complexity of its
implementation (probably very little, given what it does) and decided
it was worth it.  Every addition to a language or library has to be
made very carefully because they generally will be there forever.

The function you describe requires a row to be updated where currently
there is no updating going on, adding complexity where there is none
now.

> 2. There is a use for it. since...
>
> 3. Going through the archives, I have seen many many people ask for
>it.

I've seen people ask for a ROWNUM() function or somesuch, which
reveals the implementation's ordering of records in the source table;
that request shows up once in a while (and usually reveals a
misunderstanding of rdbms, imo).  But in the result set?  We're
talking about $resultNum++ as you loop through the results.  (Or the
@x solutions other people have mentioned.)  I've never heard someone
ask for the functionality you want before.

Even if there were many such requests, assigning serial numbers to
sequential output, if that's what you want, is what general purpose
languages are for, not what relational databases are for.  Imo.

Extreme example:
Why not add "SELECT ... INTO EMAIL [EMAIL PROTECTED]" to the language so
the server can email you results?

(You may find examples where the folks at MySQL have chosen to add
non-rdbms features into their server, but that doesn't mean they want
to add anything whatsoever and then maintain it forever.)

> 4. Those numbers probably already exist, how else does it ORDER BY,
>it has to put the results in an array of some kind

I believe those numbers are unknown when generating the row values.

--
Pete Harlan, who doesn't speak for the MySQL developers of course.
[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: Rows

[Stefan Hinz]

Jerry,

>  Any one gone over 1000 million rows ? or any where near ?

I saw something like 4 terabytes of data in a table on this list.
Maybe I was too tired by the time I read this, or even asleep already.

As MySQL doesn't impose limits to the table size, you're in for a
fight with file size limitations by your OS and stuff like that.

I'll leave it to Jeremy (jeremy.zawodny.com) and the other gurus to
provide you with impressive figures :)

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Cannot Connect

[Stefan Hinz]

RBE,

> I just got a copy of MySql and am trying both SqlGui and MySqlcc.  In
> desperation, I also tried the command line.  When I finally got it 
> started, it fails to connect, refuses every password and I find I am 
> unable to set a user and a password.

It bit more information could help to track down the problem:

1) Which MySQL version do you use?
2) Which OS?
3) Do you connect via localhost, i.e. are your clients running on the
same machine as your MySQL server?
4) How exactly are you tring to connect (mysql -hlocalhost -uuser
-psecret)?

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Load Data Infile problem.

[Paul DuBois]

At 16:53 -0600 2/14/03, Webmaster MBT wrote:

Haven't been able to identify it yet... I'm attaching the file so maybe
someone can help me with this.


Well, it's your data file.  You should know what the line terminators are.



BTW, how do I tell the command what is the ending symbol?


Add a LINES TERMINATED BY clause at the appropriate spot in the LOAD
DATA statement.  Common ones are:

For newlines (common on Unix):

LINES TERMINATED BY '\n'

For carriage returns (common on Mac OS):

LINES TERMINATED BY '\r'

For carriage return/linefeed pairs (common on DOS/Windows):

LINES TERMINATED BY '\r\n'

Note that you may need to double the \ characters to get them passed
through PHP properly to MySQL.


Thanks in advance.

-Mensaje original-
De: Paul DuBois [mailto:[EMAIL PROTECTED]]
Enviado el: Viernes, 14 de Febrero de 2003 04:43 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: Re: Load Data Infile problem.


The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?


This is typically a problem of not having the line-ending terminator
specified correctly.  What's the line-ending sequence that you're
using in your file?

sql, query



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

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: Load Data Infile problem.

[Paul DuBois]

The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?


This is typically a problem of not having the line-ending terminator
specified correctly.  What's the line-ending sequence that you're
using in your file?


sql, query

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Load Data Infile problem.

[Webmaster MBT]

Hi List.

I have been working on a problem that is driving me crazy.

I have to create a process in which I upload some info to a table. Since I
have to add some different information to that table, I decided to do it
like this.

1.I create a temporary table copying the structure of my final table. I.E.
$query_temp_table="CREATE TEMPORARY TABLE tguias SELECT * FROM guias WHERE
1=0";
$temp_table=mysql_query($query_temp_table, $cosmo_logistic) or
die(mysql_error());
I do this in PHP.
It works fine It seems.
2. I populate the temporary table.
$query_populate_tguias="LOAD DATA LOCAL INFILE
'c:/cosmo/www/upload/guias.txt' INTO TABLE tguias FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
(cliente,asesora,extra1,peso,albaran,gerente,tipo,imprimir)";
$populate_tguias=mysql_query($query_populate_tguias, $cosmo_logistic) or
die(mysql_error());
3. Then I pass the information along with some other variables to the real
table.
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar = "SELECT * FROM tguias";
$poblar = mysql_query($query_poblar, $cosmo_logistic) or die(mysql_error());
$row_poblar= mysql_fetch_assoc($poblar);
$totalRows_poblar= mysql_num_rows($poblar);
   do { 
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar_guias="INSERT INTO guias
(cliente,asesora,peso,albaran,gerente,tipo,imprimir,manifiesto,Status)
VALUES
(\"".$row_poblar['cliente']."\",\"".$row_poblar['asesora']."\",".$row_poblar
['peso'].",\"".$row_poblar['albaran']."\",\"".$row_poblar['gerente']."\",\""
.$row_poblar['tipo']."\",".$row_poblar['imprimir'].",\"".$manifiesto."\",\"A
\")";
$poblar_guias=mysql_query($query_poblar_guias, $cosmo_logistic) or
die("No pude insertar el registro ".mysql_error());
} while ($row_poblar=mysql_fetch_assoc($poblar));?>

with this source file:
"13DAN010","D79406","13DAN010", 1 ,"20430002201","75301;753","PAQUETE","1"
"13DAN010","D55816","13DAN010", 1.32
,"20430003101","100201;1002","PAQUETE","1"

it Does not work at all. I wonder if it is because it has a . in the number
even as the field receiving it is a decimal(10,2) or if it is because in one
of the field I have ;. 

The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?

This is driving me crazy.

When I do this same procedure on another table with source code like: 
"D79427","LOPEZ DURAN ELISA","ACUEDUCTO TARRAGONA 59","15","PASEOS DEL
BOSQUE","NAUCALPAN","53297"," ","LOPEZ DURAN ELISA","",F,T

it Works correctly even as it has two false or true fields.







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 building .src.rpm

[John Oliver]

I grabbed MySQL-3.23.55-1.src.rpm to build on my box, due to all the
problems I'm seeing with the RPMs from mysql.com  But *that* isn't
working, either...

+ automake
configure.in:7: your implementation of AM_INIT_AUTOMAKE comes from an
configure.in:7: old Automake version.  You should recreate aclocal.m4
configure.in:7: with aclocal and run automake again.
automake: strings/Makefile.am: Assembler source seen but `CCAS' not
defined in `configure.in'
automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not
defined in `configure.in'
error: Bad exit status from /var/tmp/rpm-tmp.26184 (%build)


RPM build errors:
user mysqldev does not exist - using root
user mysqldev does not exist - using root
user mysqldev does not exist - using root
Bad exit status from /var/tmp/rpm-tmp.26184 (%build)

This is under Red Hat 8.0, so I do *not* have an old Automake...

[joliver@joliver-lnx joliver]$ rpm -qa | grep automake
automake-1.6.3-1
automake14-1.4p6-3
automake15-1.5-4

-- 
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
***   sendmail, Apache, ftp, DNS, spam filtering ***
Colocation, T1s, web/email/ftp hosting  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Invalid Date Bug

[Don Vu]

thanks for the thoughts guys...we've already taken steps to validate on the client 
side. I just never knew about this aspect of date columns and it struck me as odd that 
a database would allow invalid data to go in...interesting feature. Personally I place 
a higher premium on data integrity over speed but that's just me...

take care,
d

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 5:00 PM
To: Peter Grigor; Don Vu; MySQL Mailing List (E-mail)
Subject: Re: Invalid Date Bug


At 16:55 -0500 2/14/03, Peter Grigor wrote:
>Yep, you're right. Never noticed that before :)
>
>I think that would probably be considered a bug. But possibly for
>efficiency's sake the check was made ultra simple.

It can be argued either way.  You could just as well consider it a
bug that you try to shove garbage into your database. :-)

Client-side validation has the disadvantage that you must do it in
each client, of course.  On the other hand, for things like web apps,
you may as well validate the data in the client anyway: Suppose MySQL
validated the date and returned an error for a bad data.  You'd just
have to tell the user that anyway, plus you wasted time sending a
bad query to the server.  If you check the date in your app, you can
tell the user immediately and skip the bad query.

>
>Peter
><^_^>
>-
>Peter Grigor
>Hoobly Free Classifieds
>http://www.hoobly.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: Invalid Date Bug

[Peter Grigor]

I'm with you for sure...client processing is the way to go...fat servers
suck.

Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com


- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; "Don Vu"
<[EMAIL PROTECTED]>; "MySQL Mailing List (E-mail)"
<[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 4:59 PM
Subject: Re: Invalid Date Bug


> At 16:55 -0500 2/14/03, Peter Grigor wrote:
> >Yep, you're right. Never noticed that before :)
> >
> >I think that would probably be considered a bug. But possibly for
> >efficiency's sake the check was made ultra simple.
>
> It can be argued either way.  You could just as well consider it a
> bug that you try to shove garbage into your database. :-)
>
> Client-side validation has the disadvantage that you must do it in
> each client, of course.  On the other hand, for things like web apps,
> you may as well validate the data in the client anyway: Suppose MySQL
> validated the date and returned an error for a bad data.  You'd just
> have to tell the user that anyway, plus you wasted time sending a
> bad query to the server.  If you check the date in your app, you can
> tell the user immediately and skip the bad query.
>
> >
> >Peter
> ><^_^>
> >-
> >Peter Grigor
> >Hoobly Free Classifieds
> >http://www.hoobly.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: Invalid Date Bug

[Paul DuBois]

At 16:55 -0500 2/14/03, Peter Grigor wrote:

Yep, you're right. Never noticed that before :)

I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.


It can be argued either way.  You could just as well consider it a
bug that you try to shove garbage into your database. :-)

Client-side validation has the disadvantage that you must do it in
each client, of course.  On the other hand, for things like web apps,
you may as well validate the data in the client anyway: Suppose MySQL
validated the date and returned an error for a bad data.  You'd just
have to tell the user that anyway, plus you wasted time sending a
bad query to the server.  If you check the date in your app, you can
tell the user immediately and skip the bad query.



Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.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

matlab interface

[Jeff Mathis]

hello,

does anyone know of a good mysql-matlab release 13 interface? the
standard database connection capability within matlab is a really poor
implementation based on JDBC. JDBC is fine, but not how the matlab
people use it.

thanks

jeff

-- 
Jeff Mathis, Ph.D.  505-995-1434
The Prediction Company  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Invalid Date Bug

[Peter Grigor]

Yep, you're right. Never noticed that before :)

I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.

Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com


- Original Message -
From: "Don Vu" <[EMAIL PROTECTED]>
To: "MySQL Mailing List (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 4:43 PM
Subject: Invalid Date Bug


Is it just me, or does Mysql allow invalid dates to be entered into columns
with date datatype? I found some data that blew up in a perl script when
doing some date manipulation, and it turns out I have invalid dates in my
database, such as June 31, 2003. Of course June never has 31 days.

Is this a known bug? honestly, this seems like a pretty basic thing to
validate. Is there a patch/fix for it?

here's a transcript of a quick test i did afterwards...june 31 enters
successfully but not june 33:

mysql> create table DateTest ( id integer(11),
-> startDate date);
Query OK, 0 rows affected (0.01 sec)

mysql> desc DateTest;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| int(11) | YES  | | NULL|   |
| startDate | date| YES  | | NULL|   |
+---+-+--+-+-+---+
2 rows in set (0.00 sec)


mysql> insert into DateTest values (1, '2002-06-31');
Query OK, 1 row affected (0.00 sec)

mysql> select * from DateTest;
+--++
| id   | startDate  |
+--++
|1 | 2002-06-31 |
+--++
1 row in set (0.00 sec)


--
Don Vu > Madstone Theaters
85 fifth avenue, 12th floor > new york > new york > 10003
p 212.379.1545 > f 212.989.7744 > www.madstonefilms.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: Invalid Date Bug

[Keith C. Ivey]

On 14 Feb 2003, at 16:43, Don Vu wrote:

> Is it just me, or does Mysql allow invalid dates to be entered into
> columns with date datatype?

See the documentation (http://www.mysql.com/doc/en/DATETIME.html):

The MySQL server only performs basic checking on the validity of
a date: days 00-31, months 00-12, years 1000-. Any date not
within this range will revert to -00-00. Please note that
this still allows you to store invalid dates such as 2002-04-31.
It allows web applications to store data from a form without
further checking. To ensure a date is valid, perform a check in
your application.

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Invalid Date Bug

[Paul DuBois]

At 16:43 -0500 2/14/03, Don Vu wrote:

Is it just me, or does Mysql allow invalid dates to be entered into 
columns with date datatype? I found some data that blew up in a perl 
script when doing some date manipulation, and it turns out I have 
invalid dates in my database, such as June 31, 2003. Of course June 
never has 31 days.

Is this a known bug? honestly, this seems like a pretty basic thing 
to validate. Is there a patch/fix for it?

It's by design.  MySQL does only minimal validation of date values
for maximum server speed.

Validate your dates on the client end.  If, as you say, it's a pretty
basic thing, it shouldn't be too difficult. :-)



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Invalid Date Bug

[Don Vu]

Is it just me, or does Mysql allow invalid dates to be entered into columns with date 
datatype? I found some data that blew up in a perl script when doing some date 
manipulation, and it turns out I have invalid dates in my database, such as June 31, 
2003. Of course June never has 31 days.

Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is 
there a patch/fix for it?

here's a transcript of a quick test i did afterwards...june 31 enters successfully but 
not june 33:

mysql> create table DateTest ( id integer(11),
-> startDate date);
Query OK, 0 rows affected (0.01 sec)

mysql> desc DateTest;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| int(11) | YES  | | NULL|   |
| startDate | date| YES  | | NULL|   |
+---+-+--+-+-+---+
2 rows in set (0.00 sec)


mysql> insert into DateTest values (1, '2002-06-31');
Query OK, 1 row affected (0.00 sec)

mysql> select * from DateTest;
+--++
| id   | startDate  |
+--++
|1 | 2002-06-31 |
+--++
1 row in set (0.00 sec)


--
Don Vu > Madstone Theaters 
85 fifth avenue, 12th floor > new york > new york > 10003  
p 212.379.1545 > f 212.989.7744 > www.madstonefilms.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

Rows

[Jerry]

Hi,
 
 Any one gone over 1000 million rows ? or any where near ?
 
 Pref. in ver 4+ with a MyISAM table.

 
 Cheers
 -
 Jerry @
 MetalCat.Net
 -
 
 SQL 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Replication problem

[Phillip Salzman]

I've narrowed it down a lot.  We have two different PHP interfaces for the 
database.  One is for employees to access the data, and the other is for 
customers.  The UPDATEs and INSERTs on the system that customers use is not 
being replicated, but the one that employees is working perfectly.

The system the employees use is located on localhost, while the other isn't.  
Do you think this would make a difference, how about different versions of 
the client libs?

Any ideas?



Phillip Salzman <[EMAIL PROTECTED]> said:

> 
> 
> Hello,
> 
> I just setup replication on mysql 3.23.55 and seem to be having some 
problems.
>  The slave machine does not seem to want to copy all the data on start.  I
> have a table with 54,000 rows on the master, and after I load up the slave
> there are only 54,850 on that machine.
> 
> I can drop the table and do a 'load table from master', and it will update 
the
> changes to each row, but won't add new rows to the slave.
> 
> Has anyone seen this before?  I've been looking online and cannot seem to 
find
> anything.  Any assistance would be very much appriciated.
> 
> Thanks,
> 
> ---
> Phillip Salzman
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> 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 4.09 query cache bug

[Sanja Byelkin]

Hi!


[skip]
> When running a query like:
> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS
> TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
> (list_id,email,f1,f2,f3)
[skip]

Thank you for your bugreport. Now bug is fixed, here is patch:

diff -Nrc a/sql/sql_load.cc b/sql/sql_load.cc
*** a/sql/sql_load.cc   Fri Feb 14 22:21:22 2003
--- b/sql/sql_load.cc   Fri Feb 14 22:21:22 2003
***
*** 336,341 
--- 336,342 
}
if (transactional_table)
  error=ha_autocommit_or_rollback(thd,error);
+   query_cache_invalidate3(thd, table_list, 0);

  err:
if (thd->lock)

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Oleksandr Byelkin <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Lugansk, Ukraine
   <___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ERROR 1005 , Please help

[sindhu]

Hi ,
 I have a problem with the mysql database restore. When I take a backup of
a database and try to restore it on a particular server(Production) , I
get the following error message.

ERROR 1005 at line 12: Can't create table
'./CloneTracking/HitPickFileMaster.frm' (errno: 150)

But the same works on the development server running on the same machine.
The backup is also from one of the databases in the development server.

This is the output of the mysqladmin -version for the two servers
mysqladmin  Ver 8.23 Distrib 3.23.52, for sun-solaris2.9 on sparc
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.52-log
Protocol version10
Connection  genomics via TCP/IP
TCP port3307
Uptime: 12 hours 47 min 21 sec

Sindhu K. Pillai
Database Administrator / Developer
Fungal Genomics
Concordia University


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: New Database,

[Peter Grigor]

Really, for non-administrative tasks, you should look at the two sections in
the manual that deal with data definition (create, drop, etc) and data
manipulation (insert, select, delete)...you're after the data definition
stuff.

Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com


- Original Message -
From: "RBE" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 1:09 PM
Subject: Re: New Database,


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Friday 14 February 2003 10:01 am, Peter Grigor wrote:
> > - Original Message -
> > From: "Richard Nagle" <[EMAIL PROTECTED]>
> >
> > > Okay,
> > > I have installed, mySQL, ( all is well )
> > > and now looking to build my first database,
> > >
> > > is there a comprehensive user manual on how to,
> > > say in .pdf format out there ?
> > >
> > > if not, a on-line link maybe ?
> >
> > See http://www.mysql.com/documentation/index.html
>
> I got the manual.  It is well done and looks quite complete.  HOWEVER
> (emphasis, not shouting), for us beginners, it is a bit daunting and
> the instructions for resolving problems assume a directory tree that is
> not installed with the latest version of MySql.  (There is simply no
> tree at all -- everything is spread all over the disk).
>
> Once upon a time, back when DB2 was new, I wrote my own programs and
> interface using a relational database, but that was a very long time
> ago.  The new programs are supposedly more efficient, but, for me,
> baffling.  The GUI's are really strange as it seems terminology has
> changed rather radically.
>
> Is there -- anywhere -- a Step-by-Step HOWTO around for beginners, even
> if we were once anything but?
>
> - --
> Robert Black Eagle (DS)
> Get my key from http://www.keyserver.net/en
> Trying to copyright bits is like trying to make water dry.
> But politicians try, anyway.
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE+TTDUtjSYKkYJrmcRAgyxAJ9F47KzecKIa+WMjOETTYNwj/XdxACfd7hz
> eLdxzv23jMeWn0vJRo5Lp9Q=
> =Dy6G
> -END PGP SIGNATURE-
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Cannot Connect

[Adam Majer]

On Fri, Feb 14, 2003 at 12:01:32PM -0600, RBE wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> I just got a copy of MySql and am trying both SqlGui and MySqlcc.  In 
> desperation, I also tried the command line.  When I finally got it 
> started, it fails to connect, refuses every password and I find I am 
> unable to set a user and a password.
> 
> I installed the binary for glibc 2.2 (using 2.2.5), but cannot get 
> anything to connect.  The website documentation indicates a procedure 
> that requires certain sub-directories, none of which exist in this 
> implementation.  Could someone give me at least a hint as to how I can 
> set this up so I can use it?

Check if you are actually running the daemon :) It should be 
listening either or both of UNIX socket and TCP port.

eg. 

netstat -l -p

and look to the daemon.

- Adam

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Row numbers

[Luc Foisy]

> 
> On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> > >That means no field exists or should exist in the 
> database. I only want to 
> > >generate at query time.
> > >I can't use an autoincrement field since that wont work 
> very well with 
> > >results that are returned out of order and maybe not with 
> all the data.
> > >
> > >Using variables is the best response to my question. I 
> just dislike using 
> > >them cause they are ugly to work with because of the 
> session persistance 
> > >and because I have to issue multiple queries to do the job.
> 
> If the value isn't being used to even select a row, why not 
> wrap the lines
> with ...results... or perhaps just use PHP/Perl/? to 
> do an $i++ for
> display?
> 
> Why put this in the query at all, if it has nothing to do 
> with the data?

I didn't say it had nothing to do with the data, I said it had nothing to do with the 
data in the database.
The data in the recordset returned from the database referenced by row is important.

As I said, sure I could make external functions to do the job. But why? (I did because 
I have no choice at the moment)

1. There are a lot of functions that return values that have nothing to do with data 
contained in the database. Math functions for one, they calculate return values using 
data that is in the database. And many many other functions. Why not one more.
In the 4.x series the developers implemented SQL_CALC_FOUND_ROWS and FOUND_ROWS(), 
something that could just have easily been handled by external programming...

2. There is a use for it. since...

3. Going through the archives, I have seen many many people ask for it.

4. Those numbers probably already exist, how else does it ORDER BY, it has to put the 
results in an array of some kind

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Cannot Connect

[RBE]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I just got a copy of MySql and am trying both SqlGui and MySqlcc.  In 
desperation, I also tried the command line.  When I finally got it 
started, it fails to connect, refuses every password and I find I am 
unable to set a user and a password.

I installed the binary for glibc 2.2 (using 2.2.5), but cannot get 
anything to connect.  The website documentation indicates a procedure 
that requires certain sub-directories, none of which exist in this 
implementation.  Could someone give me at least a hint as to how I can 
set this up so I can use it?

- -- 
Robert Black Eagle (DS)
Get my key from http://www.keyserver.net/en
Trying to copyright bits is like trying to make water dry.
But politicians try, anyway.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE+TS78tjSYKkYJrmcRAiyFAKCMzo4PZCsVCL4VXgkPwgaf4QLpXwCgkgb2
QJ15fho4kWWvngoUei4VIGw=
=5Q6h
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Starting MySQL RPM

[John Oliver]

On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote:
> On Friday 14 February 2003 01:06, John Oliver wrote:
> 
> > I removed the Red Hat MySQL RPMs (which worked fine, other than not
> > supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com  When
> > I try to start it:
> >
> > [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
> > [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases
> > from /var/lib/mysql
> > 030213 15:01:06  mysqld ended
> >
> >
> > [joliver@joliver-lnx joliver]$
> >
> > And that's it.  Nothing is logged and, oddly enough,
> > /etc/rc.d/init.d/mysql doesn't contain the strings that are being echoed
> > to the console.  So I'm more than a little puzzled here... :-)  And
> > Google isn't helping me much, either :-(
> 
> Check error log file to see why MySQL server doesn't start.

I see you missed the part where I said "Nothing is logged"... :-)

I "fixed" that by removing the mysql.com RPMs and reinstalling the Red
Hat RPMs.  Someone else told me how to get InnoDB enabled with them.

-- 
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
***   sendmail, Apache, ftp, DNS, spam filtering ***
Colocation, T1s, web/email/ftp hosting  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Row numbers

[Michael T. Babcock]

On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> >That means no field exists or should exist in the database. I only want to 
> >generate at query time.
> >I can't use an autoincrement field since that wont work very well with 
> >results that are returned out of order and maybe not with all the data.
> >
> >Using variables is the best response to my question. I just dislike using 
> >them cause they are ugly to work with because of the session persistance 
> >and because I have to issue multiple queries to do the job.

If the value isn't being used to even select a row, why not wrap the lines
with ...results... or perhaps just use PHP/Perl/? to do an $i++ for
display?

Why put this in the query at all, if it has nothing to do with the data?
-- 
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

dates in delphi

[German Quiroz]

Hi,

I have problems inserting records to a table with a date field. If I 
do not include the field in the form, the record is inserted 
succesfully with a default value for the date, but if I enter the date 
from de form, I get an error from the application. As long as I know, 
MySQL date format is -mm-dd and delphi is dd-mm-. In spite to 
change this format in delphi's date control, I get the same error.

Does some of you guys knows a delphi date control wich works weel?

Thank you.

Regards.

German Quiroz


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 libmyclient.a

[Peter Grigor]

You need the zlib library...that's where compress is defined.

It can be found at http://www.gzip.org

Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com


- Original Message -
From: "Ron Sorber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 11:41 AM
Subject: Error with libmyclient.a


> Using MySQL 4.0.10-0 on Redhat linux 7.3
>
>
> ./libmysqlclient.a(my_compress.o): In function `my_uncompress':
>
> my_compress.o(.text+0xaa): undefined reference to `uncompress'
>
> ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
>
> my_compress.o(.text+0x13c): undefined reference to `compress'
>
> collect2: ld returned 1 exit status
>
>
> Any suggestions?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Error with libmyclient.a

[Steve Sapovits]

> ./libmysqlclient.a(my_compress.o): In function `my_uncompress':
> 
> my_compress.o(.text+0xaa): undefined reference to `uncompress'
> 
> ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
> 
> my_compress.o(.text+0x13c): undefined reference to `compress'
> 
> collect2: ld returned 1 exit status
> 
> 
> Any suggestions?

I believe you need the zlib library.

http://www.gzip.org/zlib/


Steve Sapovits
GSI Commerce, Inc.  http://www.gsicommerce.com
Email: [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error with libmyclient.a

[Ron Sorber]

Using MySQL 4.0.10-0 on Redhat linux 7.3


./libmysqlclient.a(my_compress.o): In function `my_uncompress':

my_compress.o(.text+0xaa): undefined reference to `uncompress'

./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':

my_compress.o(.text+0x13c): undefined reference to `compress'

collect2: ld returned 1 exit status


Any suggestions?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: New Database,

[Henning Heil]

mmh, in the beginning i had never used any database except access (is 
one? :-)), i learned rapidly by reading the docs - hope that will be 
good for you too - because external howtos often come to an end sooner 
than you want, the docs on the other hand will answer all your 
questions. if not you can return to the list.

good luck,

henning

p.s.: please keep the discussion on the list



Richard Nagle wrote, On 2/14/2003 5:24 PM:

in the simplest form,
how to create a new database.
how to assign users to that database.
how to create tables...etc etc

was looking for a more a layman approach
of documentation. of even a website.

Here is my issue.
mysql> create database Cognigen;
ERROR 1044: Access denied for user: '@localhost' to database 'Cognigen'

Rick



On Friday, February 14, 2003, at 11:05 AM, Henning Heil wrote:


Richard,

what exactly do you mean?

guidelines to good database engineering? which data how an where to 
store? intelligent table structures?

or technical instructions related to mysql? -> documentation, see 
message attachment

cherio,

henning


Richard Nagle wrote, On 2/14/2003 4:57 PM:

Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,

is there a comprehensive user manual on how to,
say in .pdf format out there ?

if not, a on-line link maybe ?

Thanks-
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

Re: mysql with subs

[erwan ancel]

Hi,
I have had this type of problems. Under Oracle, the CONNECT BY statement was
done for such queries if I can remember. But I don't know if mysql can
handle this statement, or has an equivalent.

Erwan

- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: "Lars Rasmussen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 5:20 PM
Subject: Re: mysql with subs


> This probably isn't best handled by mysql...use associative arrays to
store
> members of members in the hierarchy, then print out the associative
array's
> contents in order.
>
> Peter
> <^_^>
> -
> Peter Grigor
> Hoobly Classified Ads
> http://www.hoobly.com
>
>
> - Original Message -
> From: "Lars Rasmussen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 14, 2003 7:46 AM
> Subject: mysql with subs
>
>
> > Hej all,
> >
> > I have a really kinky mysql problem.
> >
> > Well lets start,
> > I have a table that looks like this
> > ++--+-+
> > |  id|title |subid|
> > ++--+-+
> > |   1| MAIN |   0 |
> > ++--+-+
> > |   2| MAIN2|   0 |
> > ++--+-+
> > |   3| sub1 |   2 |
> > ++--+-+
> > |   4|   sub1sub|   3 |
> > ++--+-+
> > |   5|sub2-1|   3 |
> > ++--+-+
> > |   6|sub2-2|   3 |
> > ++--+-+
> >
> > The id is the primary key, the title is just a text field, and subid is
> > the reference to witch id it is sub to.
> >
> > I need these datas to be called in the following order
> > MAIN
> > MAIN2
> > +- sub1
> >  '-sub1sub
> >  '-sub2-1
> > +- sub2
> >  '-sub2-2
> >
> > AND SO ON, it's supposed to go to as many subs as possible...(for
> > example down 100 subs)
> >
> > I hope you can make a sql command that can make it for me.
> > THANK YOU!
> >
> > //Regards
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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

Views

[amit . mehta]

I wanted to use the Views feature that is available in Oracle which is the
counterpart of Queries available in MS Access.
mySQL does not support views at the moment. Is there a way I can achieve my
goals ?
The purpose of having a view/query is that I want to access data from that
view/query through jdbc. Having views/queries will make things very simple
as I can just do a select * from .

Any thoughts would be appreciated.

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: mysql with subs

[Peter Grigor]

This probably isn't best handled by mysql...use associative arrays to store
members of members in the hierarchy, then print out the associative array's
contents in order.

Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com


- Original Message -
From: "Lars Rasmussen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 7:46 AM
Subject: mysql with subs


> Hej all,
>
> I have a really kinky mysql problem.
>
> Well lets start,
> I have a table that looks like this
> ++--+-+
> |  id|title |subid|
> ++--+-+
> |   1| MAIN |   0 |
> ++--+-+
> |   2| MAIN2|   0 |
> ++--+-+
> |   3| sub1 |   2 |
> ++--+-+
> |   4|   sub1sub|   3 |
> ++--+-+
> |   5|sub2-1|   3 |
> ++--+-+
> |   6|sub2-2|   3 |
> ++--+-+
>
> The id is the primary key, the title is just a text field, and subid is
> the reference to witch id it is sub to.
>
> I need these datas to be called in the following order
> MAIN
> MAIN2
> +- sub1
>  '-sub1sub
>  '-sub2-1
> +- sub2
>  '-sub2-2
>
> AND SO ON, it's supposed to go to as many subs as possible...(for
> example down 100 subs)
>
> I hope you can make a sql command that can make it for me.
> THANK YOU!
>
> //Regards
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: New Database,

[Peter Grigor]

BTW, exactly how did you acquire, install and execute mysql without visiting
mysql.com?

:)

Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com


- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 10:57 AM
Subject: New Database,


> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
>
> Thanks-
> 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
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: how to create database (auto)

[Sherzod Ruzmetov]

Hi Richard,

Do you think the following links may help? I got them from the online
manual:

[1] http://www.mysql.com/doc/en/CREATE_DATABASE.html
[2] http://www.mysql.com/doc/en/CREATE_TABLE.html
[3] http://www.mysql.com/doc/en/CREATE_FUNCTION.html
[4] http://www.mysql.com/doc/en/CREATE_INDEX.html
[5] http://www.mysql.com/doc/en/Cannot_create.html
[6] http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html

This was an automated reply to your message about 'how to create database'. 
I used 'create database' as a keyword to query the database.

If you no longer want to receive messages from the bot, send email to 
[EMAIL PROTECTED] with subject "unsubscribe".  


P.S. Feedbacks, suggestions and complaints should be directed to 
[EMAIL PROTECTED]

--  
[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: New Database,

[Victoria Reznichenko]

On Friday 14 February 2003 17:57, Richard Nagle wrote:

> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?

Please, check the following link:
http://www.mysql.com/documentation/index.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New Database,

[Henning Heil]

Richard,

what exactly do you mean?

guidelines to good database engineering? which data how an where to 
store? intelligent table structures?

or technical instructions related to mysql? -> documentation, see 
message attachment

cherio,

henning


Richard Nagle wrote, On 2/14/2003 4:57 PM:

Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,

is there a comprehensive user manual on how to,
say in .pdf format out there ?

if not, a on-line link maybe ?

Thanks-
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

Re: New Database,

[Maximo Migliari]

Its a lot easier asking people than trying to look for yourself isn't it?
Well, that is frowned uppon over here.  You should ask us questions when 
you have attempted to find the solution yourself first.

http://www.mysql.com

click on the documentation link on the header.
See, it wasn't so hard!

Maximo.

At 10:57 14/2/2003 -0500, you wrote:
Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,

is there a comprehensive user manual on how to,
say in .pdf format out there ?

if not, a on-line link maybe ?

Thanks-
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



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

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: New Database,

[Peter Grigor]

- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 10:57 AM
Subject: New Database,


> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
>
See http://www.mysql.com/documentation/index.html

Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com

























> Thanks-
> 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
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: New Database,

[Jerry]

Yes, there are, many :)

Jerry

- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 3:57 PM
Subject: New Database,


> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
>
> Thanks-
> 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
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

New Database,

[Richard Nagle]

Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,

is there a comprehensive user manual on how to,
say in .pdf format out there ?

if not, a on-line link maybe ?

Thanks-
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

re: Starting MySQL RPM

[Egor Egorov]

On Friday 14 February 2003 01:06, John Oliver wrote:

> I removed the Red Hat MySQL RPMs (which worked fine, other than not
> supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com  When
> I try to start it:
>
> [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
> [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases
> from /var/lib/mysql
> 030213 15:01:06  mysqld ended
>
>
> [joliver@joliver-lnx joliver]$
>
> And that's it.  Nothing is logged and, oddly enough,
> /etc/rc.d/init.d/mysql doesn't contain the strings that are being echoed
> to the console.  So I'm more than a little puzzled here... :-)  And
> Google isn't helping me much, either :-(

Check error log file to see why MySQL server doesn't start.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[PATCH]: mysql 4.0.10 - fix for missing include file

[Arkadiusz Miskiewicz]

Hi,

There is problem with include files. include/raid.h is installed as for
example /usr/local/include/mysql/raid.h and it includes my_dir.h which
is not installed in /usr/local/include/mysql/ and thus is not usable.

This patch fixes that:


diff -urN mysql-4.0.10-gamma.org/include/Makefile.am 
mysql-4.0.10-gamma/include/Makefile.am
--- mysql-4.0.10-gamma.org/include/Makefile.am  Wed Jan 29 12:29:24 2003
+++ mysql-4.0.10-gamma/include/Makefile.am  Fri Feb 14 15:19:26 2003
@@ -19,13 +19,13 @@
 pkginclude_HEADERS =   dbug.h m_string.h my_sys.h my_list.h \
mysql.h mysql_com.h mysqld_error.h mysql_embed.h \
my_semaphore.h my_pthread.h my_no_pthread.h raid.h \
-   errmsg.h my_global.h my_net.h my_alloc.h \
+   errmsg.h my_global.h my_net.h my_alloc.h my_dir.h \
my_getopt.h sslopt-longopts.h \
sslopt-vars.h sslopt-case.h $(BUILT_SOURCES)
 noinst_HEADERS =   config-win.h config-os2.h config-netware.h \
nisam.h heap.h merge.h my_bitmap.h\
myisam.h myisampack.h myisammrg.h ft_global.h\
-   my_dir.h mysys_err.h my_base.h \
+   mysys_err.h my_base.h \
my_nosys.h my_alarm.h queues.h rijndael.h sha1.h \
my_aes.h my_tree.h hash.h thr_alarm.h \
thr_lock.h t_ctype.h violite.h md5.h mysql_version.h.in


Note that we are building rpms for PLD Linux with latest mysql 4.0:


lftp ftp.nest.pld.org.pl:/test> ls */mysql*
lftt.pld.org.pl:/test> ls */mysql*4.0*
-rw-r--r--   1 pldadmin pldadmin 12146406 Feb 13 20:06 SRPMS/mysql-4.0.10-0.1.src.rpm
-rw-r--r--   1 pldadmin pldadmin  2714023 Feb 13 22:30 
athlon/mysql-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin   466269 Feb 13 22:30 
athlon/mysql-bench-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin   115858 Feb 13 22:30 
athlon/mysql-client-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin  1798365 Feb 13 22:30 
athlon/mysql-devel-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin   178342 Feb 13 22:30 
athlon/mysql-extras-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin61627 Feb 13 22:30 
athlon/mysql-extras-perl-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin   209305 Feb 13 22:30 
athlon/mysql-libs-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin   188490 Feb 13 22:30 
athlon/mysql-static-4.0.10-0.1.athlon.rpm
-rw-r--r--   1 pldadmin pldadmin  2620274 Feb 13 20:08 i386/mysql-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin   465297 Feb 13 20:08 
i386/mysql-bench-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin   114615 Feb 13 20:08 
i386/mysql-client-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin  1765964 Feb 13 20:08 
i386/mysql-devel-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin   176211 Feb 13 20:08 
i386/mysql-extras-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin61447 Feb 13 20:08 
i386/mysql-extras-perl-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin   204745 Feb 13 20:08 
i386/mysql-libs-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin   186742 Feb 13 20:08 
i386/mysql-static-4.0.10-0.1.i386.rpm
-rw-r--r--   1 pldadmin pldadmin  2698674 Feb 13 20:11 i586/mysql-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin   465257 Feb 13 20:11 
i586/mysql-bench-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin   116440 Feb 13 20:11 
i586/mysql-client-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin  1811782 Feb 13 20:11 
i586/mysql-devel-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin   177580 Feb 13 20:11 
i586/mysql-extras-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin61520 Feb 13 20:11 
i586/mysql-extras-perl-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin   206793 Feb 13 20:11 
i586/mysql-libs-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin   189800 Feb 13 20:11 
i586/mysql-static-4.0.10-0.1.i586.rpm
-rw-r--r--   1 pldadmin pldadmin  2747202 Feb 13 20:06 i686/mysql-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin   464972 Feb 13 20:06 
i686/mysql-bench-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin   116685 Feb 13 20:06 
i686/mysql-client-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin  1815609 Feb 13 20:06 
i686/mysql-devel-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin   179255 Feb 13 20:06 
i686/mysql-extras-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin61540 Feb 13 20:06 
i686/mysql-extras-perl-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin   209934 Feb 13 20:06 
i686/mysql-libs-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin   189381 Feb 13 20:06 
i686/mysql-static-4.0.10-0.1.i686.rpm
-rw-r--r--   1 pldadmin pldadmin  2872687 Feb 13 20:37 ppc/mysql-4.0.10-0.1.ppc.rpm
-rw-r--r--   1 pldadmin pldadmin   465480 Feb 13 20:37 
ppc/mysql-bench-4.0.10-0.1.ppc.rpm
-rw-r--r--   1 pldadmin pldadmin   127835 Feb 13 20:37 
ppc

Re: Show record number

[Diana Soares]

If your're using some other programming language to fetch the results,
maybe it should be better to do it with that language. 
Otherwise, if you really need it to be in SQL you can, for example, use
variables like this:

SET @c:=0;
SELECT @c:=@c+1, Name, St, PNumber FROM TABLE;


On Fri, 2003-02-14 at 13:36, John Thorne wrote:
> Hello
> 
> Query:
> 
> SELECT Name, St, PNumber
> >From TABLE
> WHERE St = FL
> ORDER BY PNumber
> 
> Would like output to be:
> 
> 1 Joe Jones 123-123-1234
> 2 Mary Adams 123-123-4567
> 3 Ted Smith 145-456-8974
> etc
> 
> How can I generate a record number
> 
> SELECT recnu(), Name, St, PNumber ??
> 
> thanks
> 
> jrt
-- 
Diana Soares


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Show record number

[John Thorne]

Hello

Query:

SELECT Name, St, PNumber
>From TABLE
WHERE St = FL
ORDER BY PNumber

Would like output to be:

1 Joe Jones 123-123-1234
2 Mary Adams 123-123-4567
3 Ted Smith 145-456-8974
etc

How can I generate a record number

SELECT recnu(), Name, St, PNumber ??

thanks

jrt




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 with subs

[Lars Rasmussen]

Hej all,

I have a really kinky mysql problem.

Well lets start,
I have a table that looks like this
++--+-+
|  id|title |subid|
++--+-+
|   1| MAIN |   0 |
++--+-+
|   2| MAIN2|   0 |
++--+-+
|   3| sub1 |   2 |
++--+-+
|   4|   sub1sub|   3 |
++--+-+
|   5|sub2-1|   3 |
++--+-+
|   6|sub2-2|   3 |
++--+-+

The id is the primary key, the title is just a text field, and subid is
the reference to witch id it is sub to.

I need these datas to be called in the following order
MAIN
MAIN2
+- sub1
 '-sub1sub
 '-sub2-1
+- sub2
 '-sub2-2

AND SO ON, it's supposed to go to as many subs as possible...(for
example down 100 subs)

I hope you can make a sql command that can make it for me.
THANK YOU!

//Regards



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Bug with innodb multi-table delete and foreign keys.

[Sinisa Milivojevic]

Scott Wong writes:
> Hi sinisa,
> 
> I tried this patch.
> It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on 
>compile
> so i went ahead and added to include/mysqld_error.h for testing. 
> i'm not sure if it's the right place or the right error code but it made mysql 
>compile
> 
> ***
> 256a257
> > #define ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB 1238
> ***
> 
> then ran the query again.
> 
> drop table parent;
> drop table child;
>  
> CREATE TABLE parent(id INT NOT NULL,
>PRIMARY KEY (id)) TYPE=INNODB;
> CREATE TABLE child(id  INT PRIMARY KEY, parent_id INT,
>INDEX par_ind (parent_id),
>FOREIGN KEY (parent_id) REFERENCES parent(id)
>ON DELETE CASCADE
> ) TYPE=INNODB; 
>  
>  insert into parent set id=1;
>  insert into child set id=1, parent_id=1;
>  delete parent,child from parent,child where parent.id=child.parent_id;
> 
> now i get 
> ERROR 2013: Lost connection to MySQL server during query
> mysql>
> Number of processes running now: 0
> 030213 15:54:20  mysqld restarted
> 
> 
> regards,
> Scott Wong

Yes, of course. I have sent just an excerpt.

Full patch is rather big and is not appropriate for mail. 

Plus I am still improving it in order to work under all conditions.

Full patch will be in 4.0.11.

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Datentypen

[Stefan Hinz]

Ingo,

> als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
> Beschreibung.
> Leider kann ich diese nicht in der Doku finden.

The list language is English. Anyway, here's what you're looking for.

English manual: http://www.mysql.com/doc/en/Column_types.html

German manual: 
http://mysql.de/documentation/mysql/bychapter/manual.de_Reference.html#Column_types

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: Datentypen

[Bernhard Döbler]

http://www.mysql.com/doc/en/Column_types.html

- Original Message - 
From: "n etman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 9:13 AM
Subject: Datentypen


> Hallo Liste,
> 
> als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
> Beschreibung.
> Leider kann ich diese nicht in der Doku finden.
> Schon mal vielen Dank im vorraus.
> 
> Ingo Döring
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: Strange sorting in table

[Viktor Vasiliou]

Paul,

Thanks for the explanation!


Best Regards,
Viktor Vasiliou



- Original Message - 
From: Paul DuBois 
To: Viktor Vasiliou ; [EMAIL PROTECTED] 
Sent: Friday, February 14, 2003 12:05 AM
Subject: Re: Re: Strange sorting in table


At 0:01 +0100 2/14/03, Viktor Vasiliou wrote:
>Ok, I guess you're right. It's just that it has never happend to me before.
>Thanks for your help.

In general, when you simply insert rows into a table, that's the order
in which they're returned.  That's just happy coincidence, and not
to be relied on.  And when you start deleting rows, you create gaps
into which subsequent rows may be inserted.  That entirely throws
off the retrieve-in-insertion-order property that you were observing.

ORDER BY's always the safest course when you need rows in order.
(Exception: MySQL's GROUP BY also sorts, so if you have a GROUP BY
and it sorts in the order you want, you don't also need an ORDER BY.

>
>
>Regards,
>Viktor


sql, query

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Future outlook: MySql + Linux and 2gig ram limit..

[xing]

Hi,

I am wondering if the MySQL staff have been working on a way to 
circumvent the current 2G ram usage limit for MySQL under LInux for 
maybe the 5.0 release?

Did a list search but did not find a thread regarding this matter so I 
want to get this question out of my system.

With the rising need of Innodb on ever growing size of databases, 
(10Gig data + 10million rows+, tons of indices including full-text), 
one would need to not only give lots of ram to myisam key/buffer cache 
but also quite a bit if not more to the innodb engine. Factoring the 
per connection ram usage of record/sort buffer 2gig of ram can be 
reached fairly easily and more ram need to be allocated to avoid hits 
to HD as much as possible.

Finally, is there a 2G ram limit on MySQL for Mac OS X builds?

The 2GIG limit  is perfectly fine for my setup now but I can see the 
need for more hitting critical level in a year and a half and would 
like to prepare for that point.

Thanks for any info...

Xing Li


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

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: Datentypen

[Roland Voegtli]

Leider kann ich diese nicht in der Doku finden.


how in the world did you manage to miss that one?
http://www.mysql.com/doc/en/Column_types.html

Regards
Roland


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

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: Datentypen

[Manuel Kiessling]

Hello Ingo,

n etman wrote:

als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
Beschreibung.


this is an english list.

dies ist eine englischsprachige Liste.

--
 Manuel Kiessling


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Datentypen

[n etman]

Hallo Liste,

als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
Beschreibung.
Leider kann ich diese nicht in der Doku finden.
Schon mal vielen Dank im vorraus.

Ingo Döring

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: My dump does not work

[kk]

When I faced the same problem, I was suggested to use MySQL Front. I have
(Bbeen also using phpMyAdmin.Both work fine.
(B
(BHope this will help u
(B
(Bregards
(B- Original Message -
(BFrom: "srinath sundarrajan" <[EMAIL PROTECTED]>
(BTo: <[EMAIL PROTECTED]>
(BSent: Friday, February 14, 2003 4:11 PM
(BSubject: My dump does not work
(B
(B
(B> Hello,
(B>
(B> I face a problem in transfering a mysql db from 1 machine to another. I
(Bused
(B> the mysqldump command to take the dump of a db from machine A running
(Blinux.
(B> I put the same on to a machine B running on linux. Then I used the
(Bmysqldump
(B> command to create the database. In all 15 tables should be there.
(B> Unfortunately only 3 tabels are there. The dump restoration stops midway
(B> through the third table without giving any error. I tried opening the
(B> original .sql file in wordpad. All the tabels & records are there. Any
(Bidea
(B> what could be the problem. Is there any way to transfer table by table.
(B> Machine B is a new one.
(B>
(B> Thanks & regards,
(B> Srinivasan.
(B>
(B> _
(B> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
(B> http://join.msn.com/?page=features/junkmail
(B>
(B>
(B> -
(B> Before posting, please check:
(B>http://www.mysql.com/manual.php   (the manual)
(B>http://lists.mysql.com/   (the list archive)
(B>
(B> To request this thread, e-mail <[EMAIL PROTECTED]>
(B> To unsubscribe, e-mail
(B<[EMAIL PROTECTED]>
(B> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(B>
(B
(B
(B
(B-
(BBefore posting, please check:
(B   http://www.mysql.com/manual.php   (the manual)
(B   http://lists.mysql.com/   (the list archive)
(B
(BTo request this thread, e-mail <[EMAIL PROTECTED]>
(BTo unsubscribe, e-mail <[EMAIL PROTECTED]>
(BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php