mysql@lists.mysql.com

mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ
ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÎâÊÏÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ
Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É
ʹ»¼Õß½â³ý²¡Í´¡£
¾­Öڶ໼ÕßÁÙ´²Ê¹Óã¬Ö¤Êµ¸ÃÁÆ·¨¶ÔÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÓÐЧÂÊ¿É´ï90%ÒÔÉÏ£¬
ÖÎÁƺ󸴷¢Âʼ«µÍ¡£ÄÜ¿ìËÙÓÐЧֹʹ¡£
»¶Ó­»¼ÕßÀ´ÐÅÌáÎÊ£¬24СʱÄڵõ½×¨Òµ×Éѯ¡£

ÏêÇé²ÎÔÄÍøÕ¾£ºhttp://www.xfzg.com
24Сʱ×Éѯµç»°£º 022-27276811
022-27278031´ÞÖ÷ÈÎ
´ËÐÅÈç¶ÔÄúÉú»îÔì³É¸ÉÈÅÇëÔ­Á£¬Ë³ÊÖɾ³ý¡£

ÖÂ
Àñ!
   Ìì½òÊб±´óÒ½Ôº
   2002.8

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

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

Importing diff format date to MySQL

[Sankaranarayanan Mahadevan]

Hi,

I have data in CSV format file which has a date value
in the format 'dd/mm/yy'?
When i used 'Load data...' to import to a MySQL table,
all the fields gets the value from the file except the
date field that contains the date of birth??
is there any way to format and import???

Thanks
Regards
Shankar

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com

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

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

Re: MySQl db as filesystem.

[Joel Rees]

 At 12:58 +0200 10/10/02, Alex Polite wrote:
 Is there any way I could display a MySQL database as a filesystem
 under Linux?

To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked

 What does that mean?

Should we guess that he wants to be able to log into a database with csh,
run ls and get a list of tables, run cat on a table and get a
tab-delimited listing of the contents of the table?

On the surface it didn't seem like such an unreasonable question, ...

-- 
Joel Rees (thinking distractedly about trying to edit a MySQL table with
vi, among other things)
[EMAIL PROTECTED]


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

mysql-3.23.52 on hpux 11 with innodb

[Stephan Hendl]

Hallo,

does anybody build a runtime version of mysql-3.23.52 with innodb  on an hp/ux 11.0, 
64 bit runtime os?

Using hp's ansi c and aCC the innodb-sourcen gives an error like:

cc -DHAVE_CONFIG_H -I. -I../.././innobase/os -I.. -I../../include -I../include  
-D_REENTRANT  -O -DDBUG_OFF -O -DDBUG_OFF -D_REENTRANT  -DHAVE_BROKEN_PREAD 
-DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK 
-DDO_NOT_REMOVE_THREAD_WRAPPERS -DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT  -DDEBUG_OFF 
-DUNIV_MUST_NOT_INLINE -DUNIV_HPUX -c os0thread.c
cpp: ../include/univ.i, line 59: warning 2001: Redefinition of macro 
UNIV_MUST_NOT_INLINE.
cc: os0thread.c, line 59: error 1529: Cannot select field of non-structure.
cc: os0thread.c, line 59: error 1527: Incompatible types in cast: Must cast from 
scalar to scalar or to void type.

Compiling with gcc (3.2 from porting centre) the hpux linker has a problem like

gcc -O3 -DDBUG_OFF -felide-constructors -fno-exceptions -fno-rtti -O3 
-fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_BROKEN_PREAD 
-DDONT_USE_FINITE -D_INCLUDE_LONGLONG -DNO_FCNTL_NONBLOCK 
-DDO_NOT_REMOVE_THREAD_WRAPPERS -DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT -o mysql mysql.o 
readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses 
../libmysql/.libs/libmysqlclient.a -lcrypt -lnsl -lm -Wl,--defsym 
-Wl,__cxa_pure_virtual=0 -lcrypt -lnsl -lm
/usr/ccs/bin/ld: Unrecognized argument: --defsym
/usr/ccs/bin/ld: Usage:  /usr/ccs/bin/ld [options] [flags] files
collect2: ld returned 1 exit status


Thanks for helping me!

Stephan




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

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

I could't find my.cnf

[Perumal]

Dear sir/madam,

   Please anybody could give me an idea for the below:

I installed mysql-max5.1.tar on linux machine but I could  not find
a file  my.cnf over  installation directory to set my.cnf  to the
mysqld file.

Regards,
Perumal.


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

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

Re: copy one database to another

[Insanely Great]

Greetings...

I dont think that there is any SQL statement to do that.

As of changing the name, You can just go to the data directory of MySQL and
change the name of the directory of the database. MySQL stores each database
as a directoyr so changing the name of the directory will change the name of
the database.

I have tried this with MyISAM and ISAM tables, not sure of other table
types.

Rgds
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog

- Original Message -
From: Scott Pippin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 11, 2002 4:25 AM
Subject: copy one database to another


 I have one database(test) i would like to copy over to (test1).  Ehat is
 the syntax to do this?  Is there any to just change the name of the
 database?

 Thanks in advance
 (query, mysql)

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

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



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

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

compiling mysql 4.0.4 error

[Michal Dvoracek]

Hello,

i've problem with building mysql on RH 7.3

configure options:

./configure --prefix=/usr/local \
 --libexecdir=/usr/local/sbin \
 --localstatedir=/usr/local/var/mysql \
 --with-pthread \
 --with-unix-socket-path=/tmp/mysql.sock \
 --with-mysqld-user=mysql \
 --without-debug \
 --without-docs \
 --without-bench \
 --without-innodb \
 --without-extra-tools \
 --with-charset=czech \
 --with-extra-charsets=all \
 --enable-thread-safe-client \
 --enable-assembler \
 --with-openssl

i don't need innodb tables. I got:

g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME=\/usr/local\  
 -DDATADIR=\/usr/local/var/mysql\
-DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H 
-I./../include -I./../regex-I. -I../include 
-I. -I/usr/local/include-O3 -DDBUG_OFF -march=athlon -O3  -fno-implicit-templates 
-fno-exceptions -fno-rtti -c ha_berkeley.cc
make[3]: *** No rule to make target `../innobase/include/../ib_config.h', needed by 
`ha_innodb.o'.  Stop.
make[3]: Leaving directory `/usr/local/src/mysql-4.0.4-beta/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/local/src/mysql-4.0.4-beta/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql-4.0.4-beta'
make: *** [all-recursive-am] Error 2


innobase/include/../ib_config.h doesn't exists but exists
innobase/include/../ib_config.h.in

Solve: copy ib_config.h.in to ib_config.h (or repair configure sripts,
automaheader, automake, )

Regards,
Michal Dvoracek  [EMAIL PROTECTED]

SQL, TABLE


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

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-3.23.52 on hpux 11 with innodb

[Stephan Hendl]

Hallo,

does anybody build a runtime version of mysql-3.23.52 with innodb  on an hp/ux 11.0, 
64 bit runtime os?

Using hp's ansi c and aCC the innodb-sourcen gives an error like:

cc -DHAVE_CONFIG_H -I. -I../.././innobase/os -I.. -I../../include -I../include  
-D_REENTRANT  -O -DDBUG_OFF -O -DDBUG_OFF -D_REENTRANT  -DHAVE_BROKEN_PREAD 
-DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK 
-DDO_NOT_REMOVE_THREAD_WRAPPERS -DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT  -DDEBUG_OFF 
-DUNIV_MUST_NOT_INLINE -DUNIV_HPUX -c os0thread.c
cpp: ../include/univ.i, line 59: warning 2001: Redefinition of macro 
UNIV_MUST_NOT_INLINE.
cc: os0thread.c, line 59: error 1529: Cannot select field of non-structure.
cc: os0thread.c, line 59: error 1527: Incompatible types in cast: Must cast from 
scalar to scalar or to void type.

Compiling with gcc (3.2 from porting centre) the hpux linker has a problem like

gcc -O3 -DDBUG_OFF -felide-constructors -fno-exceptions -fno-rtti -O3 
-fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_BROKEN_PREAD 
-DDONT_USE_FINITE -D_INCLUDE_LONGLONG -DNO_FCNTL_NONBLOCK 
-DDO_NOT_REMOVE_THREAD_WRAPPERS -DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT -o mysql mysql.o 
readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses 
../libmysql/.libs/libmysqlclient.a -lcrypt -lnsl -lm -Wl,--defsym 
-Wl,__cxa_pure_virtual=0 -lcrypt -lnsl -lm
/usr/ccs/bin/ld: Unrecognized argument: --defsym
/usr/ccs/bin/ld: Usage:  /usr/ccs/bin/ld [options] [flags] files
collect2: ld returned 1 exit status


Thanks for helping me!

Stephan




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

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

stored procedure support

[Tonino]

Hi,

Just a short question - Does anyone know the progress of stored
procedure support in MySQL 4 

Thanks
Tonino




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

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

re: MySQL Error

[Victoria Reznichenko]

Abhi,
Thursday, October 10, 2002, 8:30:43 PM, you wrote:

A  I am not able to connect mysql server after executing this command

A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O 
A sort_buffer=4M -O read_buffer_size=1M

A [repository@shoggoth bin]$ ./mysql -u root
A ERROR 2002: Can't connect to local MySQL server through socket 
A '/tmp/mysql.sock' (2)

[skip]

A but my process is running. I have tryed to restart also but unable to 
A restart mysql server successifully.
A mysql show processlist;
A +---+--+---+-+-+--+-
A -+--+
A | Id| User | Host  | db  | Command | Time | 
A State  
A  | Info |
A +---+--+---+-+-+--+-
A -+--+
A | 19509 | root | localhost | mysql   | Sleep   | 481  
A |
A  | NULL |
A | 19532 | root | localhost | DS_data | Query   | 0| 
A NULL   
A  | show processlist |
A | 19547 | root | localhost | DS_data | Query   | 39   | Copying to tmp 
A table on
A disk | select distinct name_server1 from tbl_raw_zone_file limit 10 |
A +---+--+---+-+-+--+-
A -+--+


A The error (2002) Can't connect to ... normally means that there isn't a 
A MySQL server running on the system or
A that you are using a wrong socket file or TCP/IP port when trying to 
A connect to the mysqld server.

A Error Log
A -
A 021010 10:30:41  mysqld started
A No variable match for: -O 'read_buffer_size=1M'
A /usr/local/mysql/libexec/mysqld  Ver 3.23.49 for pc-linux-gnu on i686
A Use '--help' or '--no-defaults --help' for a list of available o

A I am using mysql version 3.23

A mysql select version();
A +-+
A | version()   |
A +-+
A | 3.23.49-log |
A +-+
A 1 row in set (0.00 sec)
A ptions
A 021010 10:30:41  mysqld ended
^

But error log shows that MySQL didn't start. Do you have another MySQL
server running?


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

Urgent help: character encoding???

[Nasir Aziz Gill]

Hi fellows,

Thanks for your help. Finally I have the data in the table. But I lost these
special Characters( à  ?  å  ä ); Which when I imported from the text file,
they existed. But I can't find them now by Select statement.

Should I use Character encoding if so, then how?
I am using Java with MySQL..

Please help with your kind and valuable suggestions...

Nasir
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19-09-2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19-09-2002



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

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

Re: Re: thread creation problem

[Egor Egorov]

Hello Philipp,
Wednesday, October 09, 2002, 10:38:01 AM, you wrote:

 PS Can't create a new thread (errno 11). If you are not out of available
 PS memory, you
 PS can consult the manual for a possible OS-dependent bug
 
 errno 11 may also mean that ulimits are exhausted.

PS okay, i will check that...

 PS debian 3.0
 PS kernel 2.4.19 (high memory enabled)
 PS mysql 3.23.52 (compiled from source)
 
 You better get MySQL official binaries from http://www.mysql.com/
 because compiling MySQL from source is a complicated process and
 tricky.

PS I am not really a newbie and quite okay compiling my own kernel and programms. 
What exactly do you mean by tricky or complicated ? Is
PS it possible that my problem raised because i did something wrong during the 
compilataion-process ?

Of course. I'm sure it is. 

First, 
What is the gcc version you have used for compilation?
What is the glibc version you have used to link MySQL?



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

re: Importing diff format date to MySQL

[Egor Egorov]

Sankaranarayanan,
Friday, October 11, 2002, 7:15:30 AM, you wrote:

SM I have data in CSV format file which has a date value
SM in the format 'dd/mm/yy'?
SM When i used 'Load data...' to import to a MySQL table,
SM all the fields gets the value from the file except the
SM date field that contains the date of birth??
SM is there any way to format and import???

No, you can't.
http://www.mysql.com/doc/en/Using_DATE.html



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

re: varbinary equivalent ??

[Victoria Reznichenko]

Tonino,
Friday, October 11, 2002, 10:55:30 AM, you wrote:

T What is the mysql equivalent of the Sybase varbinary data type ???

T I have a table that has 5 varbinary(255) columns in sybase and want to
T convert it to mysql ???

I don't have an exp. with Sybase. 

What about varchar(255) binary data type?
 http://www.mysql.com/doc/en/CHAR.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: MySQl db as filesystem.

[Nicolas MONNET (Tech)]

On Fri, 2002-10-11 at 10:06, Ed Carp wrote:

  At 12:58 +0200 10/10/02, Alex Polite wrote:
  Is there any way I could display a MySQL database as a filesystem
  under Linux?
 
  What does that mean?
 
 I think he wants to mount a MySQL database as a filesystem, like CFS with the 
loopback driver.  The answer is almost certainly no -
 why would you want to do such a thing?
 
 sql, query

Should'nt be too hard to do thanks to PODFUK® AKA uservfs:

http://uservfs.sf.net


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

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

Problem with mysql jdbc Connector

[janesh]

HI
I am accessing mysql through Websphere 5.0 through jsp file . it says
SQLException: Cannot connect to MySQL server on host:3306. Is there
a MySQL server running on the machine/port you are trying to connect to?
(java.security.AccessControlException)
SQLState: 08S01
VendorError: 0
This exception is also listed in Your mysql driver Readme file , resolution
for this is not clear.
Since i am using same machine , and other parameters are correct , i am
unable to find the solution
Please get back to me with relevant solution.
Thanks
Janesh



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

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 fails a test if compiled with 64 bit gcc on HP-UX 11.00

[Andrea Carpani]

Description:
 Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

How-To-Repeat:
 By compiling mysql 3.32.52 with the options mentioned below a simple make test will 
show the problem on test func_time

Fix: none
Submitter-Id:  none
Originator: none
Organization: none
MySQL support: none
Synopsis: mysql-test-run --local  func_time fails on 64 bit recompiled mysql on 
HP-UX 11.00
Severity:  [ non-critical | serious | critical ] (one line)
Priority:  [ low | medium | high ] (one line)
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.52 (Source distribution)
Environment:
System: HP-UX xx B.11.00 U 9000/800 113444601 unlimited-user license

Some paths:  /usr/bin/perl /usr/bin/make /opt/make/bin/gmake /opt/gcc/bin/gcc 
/usr/bin/cc
GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.4/specs
Configured with: ./configure  : (reconfigured) ./configure  : (reconfigured) 
./configure 
Thread model: posix
gcc version 3.0.4
Compilation info: CC='/usr/local/pa20_64/bin/gcc'  CFLAGS='-fomit-frame-pointer -O3 
-fPIC'  CXX='/usr/local/pa20_64/bin/gcc'  CXXFLAGS=''  
LDFLAGS='-L/usr/local/pa20_64/lib -lstdc++'
LIBC: 
lrwxr-xr-x   1 root   sys  8 Mar 28  2002 /lib/libc.0 - ./libc.1
-r-xr-xr-x   1 binbin1867776 May  2  2001 /lib/libc.1
-r-xr-xr-x   1 binbin1552384 Nov 27  2001 /lib/libc.2
-r--r--r--   1 binbin2176800 Nov 27  2001 /lib/libc.a
lrwxr-xr-x   1 root   sys 15 Mar 28  2002 /lib/libc.sl - 
/usr/lib/libc.2
lrwxr-xr-x   1 root   sys  8 Mar 28  2002 /usr/lib/libc.0 - ./libc.1
-r-xr-xr-x   1 binbin1867776 May  2  2001 /usr/lib/libc.1
-r-xr-xr-x   1 binbin1552384 Nov 27  2001 /usr/lib/libc.2
-r--r--r--   1 binbin2176800 Nov 27  2001 /usr/lib/libc.a
lrwxr-xr-x   1 root   sys 15 Mar 28  2002 /usr/lib/libc.sl - 
/usr/lib/libc.2
Configure command: ./configure --prefix=/opt/mysql --disable-shared 
--with-mysqld-user=mysql --without-debug CC=/usr/local/pa20_64/bin/gcc 
'CFLAGS=-fomit-frame-pointer -O3 -fPIC' CXX=/usr/local/pa20_64/bin/gcc 
'LDFLAGS=-L/usr/local/pa20_64/lib -lstdc++'

 mysql-test-run output

root@xx:/var/tmp/mysql-3.23.52/mysql-test mysql-test-run --local  func_time
Installing Test Databases
Removing Stale Files
Installing Master Databases
021010 13:40:54  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
021010 13:40:54  ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST USER   SYSTEM  ELAPSEDRESULT

func_time      [ fail ]

Below are the diffs between actual and expected results:
---
*** r/func_time.result  Wed Aug 14 01:24:51 2002
--- r/func_time.reject  Thu Oct 10 13:41:07 2002
***
*** 45,51 
  dayname(1962-03-03) dayname(1962-03-03)+0
  Saturday  5
  monthname(1972-03-04)   monthname(1972-03-04)+0
! March 3
  time_format(1998013100,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
  00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
  time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
--- 45,51 
  dayname(1962-03-03) dayname(1962-03-03)+0
  Saturday  5
  monthname(1972-03-04)   monthname(1972-03-04)+0
! March 4613937818241073200
  time_format(1998013100,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
  00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
  time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
---
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished

 Dump of r/func_time.reject

from_days(to_days(960101))to_days(960201)-to_days(19960101)
to_days(date_add(curdate(), interval 1 day))-to_days(curdate())
weekday(1997-11-29)
1996-01-01  31  1   5
period_add(9602,-12)  period_diff(199505,9404)
199502  13
now()-now() weekday(curdate())-weekday(now())  
unix_timestamp()-unix_timestamp(now())
0   0   0
from_unixtime(unix_timestamp(1994-03-02 10:11:12))   
from_unixtime(unix_timestamp(1994-03-02 10:11:12),%Y-%m-%d
%h:%i:%s)from_unixtime(unix_timestamp(1994-03-02 10:11:12))+0
1994-03-02 10:11:12 1994-03-02 10:11:12 19940302101112
sec_to_time(9001)   sec_to_time(9001)+0 time_to_sec(15:12:22)
sec_to_time(time_to_sec(0:30:47)/6.21)
02:30:0123001   54742   00:04:57
sec_to_time(time_to_sec('-838:59:59'))
-838:59:59
now()-curdate()*100-curtime()
0
strcmp(current_timestamp(),concat(current_date(), ,current_time()))
0
date_format(1997-01-02 03:04:05, %M %W %D %Y %y 

Indexing questions

[rafarife]

Hello,

I have some doubts about the index behaviour in InnoDB.

I have a table named 'Albaranes'. The definition is as follow:

CREATE TABLE `albaranes` (
  `Cli` varchar(6) NOT NULL default '',
  `Alb` varchar(8) NOT NULL default '',
  .
  .
  . 
  PRIMARY KEY  (`Alb`),
  UNIQUE KEY `Cliente` (`Cli`,`Alb`),
) TYPE=InnoDB;

The index 'Cliente' is composed of the field 'Cli' and the field 'Alb'
which belong to the primary index. I have read in the InnoDB documentation
the following text:

The records in non-clustered indexes (we also call them secondary indexes), 
in InnoDB contain the primary key value for the row. InnoDB uses this primary 
key value to search for the row from the clustered index.

Well, according to the text it wouldn`t be necessary to add the field 'Alb' 
to the 'Cliente' index to access to a specific record because InnoDB does that.
My question is: If I add the field 'Alb' to the 'Cliente' index, does InnoDB
add the field 'Alb' too?

I have made tests and I have noticed that if I define the index 'Cliente' as
(Cli) the time that the query takes in recovering all the table records is
more or less the same that the query takes if I define the index 'Cliente'
as (Cli,Alb) (there isn't a considerable difference). The query executed is
'Select Cli,Alb From Albaranes where Cli  'AnyValue''. I'm interesting in 
recovering the records ordered by Cli,Alb for increasing the speed of some 
reports so, I executed the query 'Select Cli,Alb From Albaranes where
Cli  'AnyValue' Order by Cli,Alb' and I checked that if I define the index
as (Cli) InnoDB doesn´t use the field 'Alb' (which is used to search for
the row from the clustered index by InnoDB) to order the selected records.
I suppose InnoDB only uses this primary key value to search for the rows
and not to order the rows, doesn´t it?

My last question is if I add the fields from the clustered index to other
secondary indexes (for example the index 'Cliente'), have I to define
the secondary index as 'UNIQUE'? I think that it´s not necessary and the
only I could obtain is that inserts are slower because InnoDB has to 
preserve the data uniqueness.

Let me ask a question that is not related to InnoDB. I have three primary
fields (varchar) in a table and I have some doubts in the way of defining them. 
What is better, defining three fields and the primary index is formed by
all of them or defining only one field which is composed of the concatenation
of the three fields and the index is formed only by one field?. I'm always
going to search by the first field.


Regards,

Lourdes.



__
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: I could't find my.cnf

[Perumal]

Dear sir,

   Please give me an idea for the below problem.

 I installed mysql-max on linux machine, but mysql.sock file is not
available in  /temp directory. It gives 'Can't connect to local mysql server
through socket 'temp/mysql.sock' ' when i run this.

What to do to avoid this problem.

Perumal.





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

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

varbinary equivalent ??

[Tonino]

HI,

What is the mysql equivalent of the Sybase varbinary data type ???

I have a table that has 5 varbinary(255) columns in sybase and want to
convert it to mysql ???

Any ideas welcome - 

Many thanks
Tonino




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

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 db as filesystem.

[Ed Carp]

 -Original Message-
 From: Paul DuBois [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 5:57 PM
 To: Alex Polite; [EMAIL PROTECTED]
 Subject: Re: MySQl db as filesystem.

 At 12:58 +0200 10/10/02, Alex Polite wrote:
 Is there any way I could display a MySQL database as a filesystem
 under Linux?

 What does that mean?

I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback 
driver.  The answer is almost certainly no -
why would you want to do such a thing?

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

Privileges

[Alexander Burbello]

 I need to know urgent.

 There are two tables ('db' and 'tables_priv') in mysql database.

 I gave privileges, for example, to the table 'tables_priv', I give only
 select to the table Tb01.

 But I give other privileges, now to the table 'db'. I gave insert, delete
 and update privileges to the database 'Test'.

 Teste  - Database
   |
    Tb01   - Table

 The user has these privileges,
 What can he do?
 Can he insert on the table tb01?
 Can he select data in all the tables of the database?

 Regards


 Alexander




 sql, query

___
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
http://br.geocities.yahoo.com/

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

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

Problem with compilation of mysql.

[Philippe Benchemoul]

You can find the message I have when I try to compile mysql :
-
rm -f .libs/libmysql.lo
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/progs/mysql\
-DDATADIR=\/usr/local/progs/mysql/var\
-DSHAREDIR=\/usr/local/progs/mysql/share/mysql\ -DDONT_USE_RAID
-I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -Wimplicit
-Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused
-mcpu=pentiumpro -O3 -fno-omit-frame-pointer -c libmysql.c  -fPIC -DPIC
-o .libs/libmysql.lo
In file included from /usr/include/linux/config.h:4,
 from /usr/include/asm/atomic.h:4,
 from ../include/global.h:206,
 from libmysql.c:18:
/usr/include/linux/autoconf.h:64: warning: `CONFIG_SMP' redefined
../include/global.h:205: warning: this is the location of the previous
definition
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to function `gethostbyname_r'
libmysql.c:1325: warning: assignment makes pointer from integer without
a cast
libmysql.c: In function `myodbc_remove_escape':
libmysql.c:2574: warning: `end' might be used uninitialized in this
function
make[2]: *** [libmysql.lo] Error 1
make[2]: Leaving directory
`/space1/users/pbenchem/PHP/mysql-3.23.52/libmysql_r'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/space1/users/pbenchem/PHP/mysql-3.23.52'
make: *** [all-recursive-am] Error 2
--

Organization:
 organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis:  synopsis of the problem (one line)
Severity:  [ non-critical | serious | critical ] (one line)
Priority:  [ low | medium | high ] (one line)
Category:  mysql
Class: [ sw-bug | doc-bug | change-request | support ] (one line)
Release:   mysql-3.23.52 (Source distribution)
Server: /usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.49-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 16 days 20 hours 34 min 35 sec

Threads: 1  Questions: 19101  Slow queries: 0  Opens: 71  Flush tables:
1  Open tables: 24 Queries per second avg: 0.013
Environment:
machine, os, target, libraries (multiple lines)
System: Linux machine.wanadoo.com 2.2.18-RAID #3 SMP Wed Jan 24 17:32:56
CET 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 2220 (Debian GNU/Linux)
Compilation info: CC='gcc'  CFLAGS='-Wimplicit -Wreturn-type -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses
-Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3
-fno-omit-frame-pointer'  CXX='gcc'  CXXFLAGS='-Wimplicit -Wreturn-type
-Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3
-fno-omit-frame-pointer'  LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root   14 Aug 23 14:45 /lib/libc.so.5
- libc.so.5.4.46
-rw-r--r--1 root root   563068 Feb  4  2002
/lib/libc.so.5.4.46
lrwxrwxrwx1 root root   13 Sep 24 13:39 /lib/libc.so.6
- libc-2.2.5.so
-rwxr-xr-x1 root root  1153784 Apr 28 11:57
/lib/libc-2.2.5.so
-rw-r--r--1 root root  2390922 Apr 28 11:58 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr 28 11:58 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
--enable-assembler --with-extra-charsets=complex
--enable-thread-safe-client --with-innodb --with-berkeley-db
--enable-thread-safe-client 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses
-Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses
-Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo
-Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'
CXX=gcc

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

Re: Repair TABLE - OPERATION FAILED

[Jocelyn Fournier]

Hi,

perror 28
Error code  28:  No space left on device

Make some space on your hard disk ;)

Regards,
  Jocelyn
- Original Message -
From: tl [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 11, 2002 10:55 AM
Subject: Repair TABLE - OPERATION FAILED


 Hello,
 Please help me.

 mysql repair table none;
 +++--+-+
 | Table  | Op | Msg_type | Msg_text|
 +++--+-+
 | n_toccata.none | repair | error| 28 when writing to datafile |
 | n_toccata.none | repair | error| 28 when writing to datafile |
 | n_toccata.none | repair | status   | Operation failed|
 +++--+-+
 3 rows in set (0.14 sec)


 mysql select * from none limit 12;
 ERROR 1016: Can't open file: 'none.MYD'. (errno: 144)
 mysql check table none;

++---+--+---
--+
 | Table  | Op| Msg_type | Msg_text
|

++---+--+---
--+
 | n_toccata.none | check | warning  | Table is marked as crashed and last
repair failed   |
 | n_toccata.none | check | warning  | Size of indexfile is: 309248
Should be: 35840  |
 | n_toccata.none | check | error| Size of datafile is: 2809856
Should be: 2809916 |
 | n_toccata.none | check | error| Corrupt
|

++---+--+---
--+
 4 rows in set (0.00 sec)



 Thank's very much.

 Alvydas




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

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




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

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

Re: help needed

[Daniel Kiss]

Hi Sheela,

At 01:49 2002.10.11. -0700, you wrote:
hi,
I am using mysql
while creating a table I want to give column
descriptioneither by using  a query or GUI
ex
create table t1(
a bigint not null ' here i wamt to tell what for the a
is
)

pl help me

thanks
sheela

You can add comments to your sql statements like this: /* comment here */

For example:

create table t1
  (a bigint not null, /*comment1*/
  b int, /*comment1*/
  c char /*comment1*/
  )

Good luck,
 Daniel


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

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

How to make individual batch SQL silent

[rick]

I know how to make a whole batch SQL script silent (-s option of mysql), but is there 
a way within a script to make one or more individual statements silent?  In Oracle 
PL/SQL, it can be done using echo on/off and termout on/off.

Thanks,
R

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

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 running autoheader on a new clone of src tree for 4.0

[Shane Allen]

I am trying to build MySQL from a new clone of the bitkeeper repository, and am
running into some difficulty...

I am running Debian Woody, and am running unstable. Following are the relevant
utilities/versions installed on my system:

===
root@local-dbmaster-test:/usr/local/src/temp/mysql-4.0# autoconf --version
autoconf (GNU Autoconf) 2.54
Written by David J. MacKenzie and Akim Demaille.

Copyright 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
root@local-dbmaster-test:/usr/local/src/temp/mysql-4.0# automake --version
automake (GNU automake) 1.5
Written by Tom Tromey [EMAIL PROTECTED].

Copyright 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
root@local-dbmaster-test:/usr/local/src/temp/mysql-4.0# libtool --version
ltmain.sh (GNU libtool) 1.4.2a (1.922.2.100 2002/06/26 07:25:14)
root@local-dbmaster-test:/usr/local/src/temp/mysql-4.0# m4 --version
GNU m4 1.4
===

Following is the output of autoheader --verbose (run after aclocal)

===
root@local-dbmaster-test:/usr/local/src/temp/mysql-4.0# autoheader --verbose
WARNING: Using auxiliary files such as `acconfig.h', `config.h.bot'
WARNING: and `config.h.top', to define templates for `config.h.in'
WARNING: is deprecated and discouraged.

WARNING: Using the third argument of `AC_DEFINE' and
WARNING: `AC_DEFINE_UNQUOTED' allows to define a template without
WARNING: `acconfig.h':

WARNING:   AC_DEFINE([NEED_MAIN], 1,
WARNING: [Define if a function `main' is needed.])

WARNING: More sophisticated templates can also be produced, see the
WARNING: documentation.
autoheader: autoheader: running /usr/bin/autom4te --language=autoconf  --verbose   
  
 to trace from configure.in
autoheader: running: /usr/bin/autom4te --language=autoconf  --verbose  --trace A   
  
C_CONFIG_HEADERS:'$$config_h ||= $1;' --trace AH_OUTPUT:'$$verbatim{$1} = \
$2;' --trace AC_DEFINE_TRACE_LITERAL:'$$symbol{$1} = 1;' configure.in /tmp/a   
  
hOhFqbK/traces.pl
autom4te: the trace request object is:
$VAR1 = bless( [
 '0',
 0,
 [
   '/usr/share/autoconf'
 ],
 [
   '--reload-state=/usr/share/autoconf/autoconf/autoconf.m4f',
   'aclocal.m4',
   'configure.in'
 ],
 {
   'AC_HEADER_STAT' = 1,
   'AC_FUNC_STRFTIME' = 1,
   'AC_PROG_RANLIB' = 1,
   'AC_FUNC_WAIT3' = 1,
   'AC_FUNC_SETPGRP' = 1,
   'AC_HEADER_TIME' = 1,
   'AC_FUNC_SETVBUF_REVERSED' = 1,
   'AC_HEADER_SYS_WAIT' = 1,
   'AC_TYPE_UID_T' = 1,
   'AM_CONDITIONAL' = 1,
   'AC_CHECK_LIB' = 1,
   'AC_PROG_LN_S' = 1,
   'AC_FUNC_MEMCMP' = 1,
   'AC_FUNC_FORK' = 1,
   'AC_FUNC_GETGROUPS' = 1,
   'AC_HEADER_MAJOR' = 1,
   'AC_FUNC_STRTOD' = 1,
   'AC_HEADER_DIRENT' = 1,
   'AC_FUNC_UTIME_NULL' = 1,
   'AC_CONFIG_FILES' = 1,
   'AC_FUNC_ALLOCA' = 1,
   'AC_C_CONST' = 1,
   'include' = 1,
   'AC_FUNC_OBSTACK' = 1,
   'AC_FUNC_LSTAT' = 1,
   'AC_STRUCT_TIMEZONE' = 1,
   'AC_FUNC_GETPGRP' = 1,
   'AC_DEFINE_TRACE_LITERAL' = 1,
   'AC_CHECK_HEADERS' = 1,
   'AC_TYPE_MODE_T' = 1,
   'AC_CHECK_TYPES' = 1,
   'AC_PROG_YACC' = 1,
   'AC_TYPE_PID_T' = 1,
   'AC_FUNC_STRERROR_R' = 1,
   'AC_STRUCT_ST_BLOCKS' = 1,
   'AC_PROG_GCC_TRADITIONAL' = 1,
   'AC_TYPE_SIGNAL' = 1,
   'AM_PROG_LIBTOOL' = 1,
   'AC_FUNC_FNMATCH' = 1,
   'AC_PROG_CPP' = 1,
   'AC_FUNC_STAT' = 1,
   'AC_PROG_INSTALL' = 1,
   'AM_GNU_GETTEXT' = 1,
   'AC_FUNC_STRCOLL' = 1,
   'AC_LIBSOURCE' = 1,
   'AC_C_INLINE' = 1,
   'AC_FUNC_CHOWN' = 1,
   'AC_PROG_LEX' = 1,
   'AH_OUTPUT' = 1,
   'AC_HEADER_STDC' = 1,
   'AC_FUNC_GETLOADAVG' = 1,

RE: I could't find my.cnf

[Simon Green]

The file you are looking for is my-huge.cnf, my-large.cnf, my-medium.cnf,
ny-small.cnf.
Should be under /mysql/share/
Copy to /etc/ and edit for you needs.
Simon

-Original Message-
From: Perumal [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 06:23
To: [EMAIL PROTECTED]
Subject: I could't find my.cnf


Dear sir/madam,

   Please anybody could give me an idea for the below:

I installed mysql-max5.1.tar on linux machine but I could  not find
a file  my.cnf over  installation directory to set my.cnf  to the
mysqld file.

Regards,
Perumal.


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

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

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

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

RE: copy one database to another

[Simon Green]

SELECT INTO TABLE!
Simon

-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 06:31
To: Scott Pippin; [EMAIL PROTECTED]
Subject: Re: copy one database to another


Greetings...

I dont think that there is any SQL statement to do that.

As of changing the name, You can just go to the data directory of MySQL and
change the name of the directory of the database. MySQL stores each database
as a directoyr so changing the name of the directory will change the name of
the database.

I have tried this with MyISAM and ISAM tables, not sure of other table
types.

Rgds
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog

- Original Message -
From: Scott Pippin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 11, 2002 4:25 AM
Subject: copy one database to another


 I have one database(test) i would like to copy over to (test1).  Ehat is
 the syntax to do this?  Is there any to just change the name of the
 database?

 Thanks in advance
 (query, mysql)

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

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



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

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

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

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

Export of text fields from Access2000

[Ivo Dvorak]

Hello,

I export a table from Access 2000 on WinXP to MySQL using the MyODBC 3.51.04 and text 
fields are exported as text fields from Access instaed of varchar as it should 
logically be (MEMO is the Access equivalent for Mysql text type).

I have Jet SP6 and latest MDAC installed. Is there a workaround from this?

PLEASE send message to [EMAIL PROTECTED] if you know what to do.

Thanks.

Ivo


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

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

help needed

[E.N.Sheela]

hi,
I am using mysql
while creating a table I want to give column
descriptioneither by using  a query or GUI
ex
create table t1(
a bigint not null ' here i wamt to tell what for the a
is
)

pl help me

thanks
sheela

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com

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

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

Compiling MySQL 3.23.52 and 4.0.x on HPUX 11

[JOUANNET, Rodolphe]

Products use :

B3913DB HP aC++ Compiler (S800) version C.03.33.01
B3901BA HP C/ANSI C Developer's Bundle for HP-UX 11.i(S800)
GNU makeversion 3.79.1.2001-06-12

Procedure :

./configure --prefix=/usr/local/mysql --with-innodb

Modifying these files :

config.h: add this line
#define inline 

innobase/os/os0thread.c: line 60 in #ifdef UNIV_HPUX replace :

return((ulint)(a.field1)); 

by

return((ulint)a);

For MySQL 4 only:
mysys/my_tempnam.c: line 112 and 118 replace :

((char**) environ)=(char**) temp_env;

by

environ=(char**) temp_env;

(non standard lvalue casting)

Finaly :

make
make install

Success compilations for mySQL 3.23.52 and 4.0.3 beta...

Best 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

Repair TABLE - OPERATION FAILED

[tl]

Hello,
Please help me.

mysql repair table none;
+++--+-+
| Table  | Op | Msg_type | Msg_text|
+++--+-+
| n_toccata.none | repair | error| 28 when writing to datafile |
| n_toccata.none | repair | error| 28 when writing to datafile |
| n_toccata.none | repair | status   | Operation failed|
+++--+-+
3 rows in set (0.14 sec)


mysql select * from none limit 12;
ERROR 1016: Can't open file: 'none.MYD'. (errno: 144)
mysql check table none;
++---+--+-+
| Table  | Op| Msg_type | Msg_text 
|   |
++---+--+-+
| n_toccata.none | check | warning  | Table is marked as crashed and last repair 
|failed   |
| n_toccata.none | check | warning  | Size of indexfile is: 309248  Should be: 
|35840  |
| n_toccata.none | check | error| Size of datafile is: 2809856 Should be: 
|2809916 |
| n_toccata.none | check | error| Corrupt  
|   |
++---+--+-+
4 rows in set (0.00 sec)



Thank's very much.

Alvydas




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

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: selecting a certain number of rows

[Roger Baklund]

* Sean Moshenko 
[...]
 SELECT * from table FETCH FIRST 10 ROWS ONLY.

Check out the LIMIT option of the select statement:

URL: http://www.mysql.com/doc/en/SELECT.html 

SELECT * from table LIMIT 10

-- 
Roger

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

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

RE: copy one database to another

[Ed Carp]

 I dont think that there is any SQL statement to do that.

No, just use mysqldump to do it.

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: MySQl db as filesystem.

[Paul DuBois]

At 13:32 +0900 10/11/02, Joel Rees wrote:
   At 12:58 +0200 10/10/02, Alex Polite wrote:
  Is there any way I could display a MySQL database as a filesystem
  under Linux?

To which, on Thu, 10 Oct 2002 at 17:56:31 -0500, Paul DuBois asked

  What does that mean?

Should we guess that he wants to be able to log into a database with csh,
run ls and get a list of tables, run cat on a table and get a
tab-delimited listing of the contents of the table?

On the surface it didn't seem like such an unreasonable question, ...

I didn't say it was unreasonable.  I asked what it meant.  Answering
based on a guess about what the question really means often is fruitless.


--
Joel Rees (thinking distractedly about trying to edit a MySQL table with
vi, among other things)
[EMAIL PROTECTED]

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

solaris 8 and mysql

[Larry Felton Johnson]

I think I inadvertently sent this earlier to the admin email
address.  Sorry.

Has anyone out there successfully configured and used the mysql which
comes preinstalled on newer versions of solaris 8 for sparc.

mysqld is dying, and this message is in the error log.

-
021010 15:00:57  mysqld started
021010 15:00:57  /opt/sfw/mysql/libexec/mysqld: Can't find file: './mysql/host.
frm' (errno: 13)
021010 15:00:57  /opt/sfw/mysql/libexec/mysqld: Normal shutdown
-

I followed the suggestions for this error from both the mysql.info file
(setting the UMASK)  and from the manual (making sure the databases were
initiallized with mysql_install_db.


host.frm installs in /opt/sfw/mysql/var/mysql/

Any ideas?

Larry
-- 
===
As surgeons keep their instruments and knives always at hand for cases 
requiring immediate treatment, so shouldst thou have thy thoughts ready 
to understand things divine and human, remembering in thy every act, 
even the smallest, how close is the bond that unites the two.  

  Marcus Aurelius, Meditations. iii. 13.
===

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

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: Alternative for NOT EXISTS

[Victor Kirk]

 SELECT u.uname FROM users u
   WHERE NOT EXISTS (SELECT * FROM team_members=20
   WHERE team_id =3D 7 AND user_id=3Du.user_id);

It sounds to me like you are trying to ask the database:

  Tell me all the users that aren't in team 7.

Yes.

 If so, this should work:

  SELECT u.uname
FROM users u
LEFT JOIN team_members t ON u.user_id =3D t.user_id
 AND t.team_id =3D 7
   WHERE t.team_id is NULL

Perfect :-) thanks very much this query works perfectly, you are a star.

Thanks to all the helpful suggestions :-)

Vic
--
This message, including attachments, is intended only for the use by the
person(s) to whom it is addressed. It may contain information which is
privileged and confidential. Copying or use by anybody else is not
authorised. If you are not the intended recipient, please contact the sender
as soon as possible. The views expressed in this communication may not
necessarily be the views held by Serco Integrated Transport.

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

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 3.23.49

[J Ross Nicoll]

I seem to have found a bug in MySQL 3.23.49 (untested in later versions). 
It appears that if the server cannot resolve the hostname of an incoming
TCP connection, it crashes.

I've been testing this under a RedHat 7.2/7.3 hybrid, and only came across 
the problem because I've managed to somehow stop DNS from working 
correctly! Unfortunately, I don't yet know exactly what's wrong 
with DNS.

Putting the hostname of the incoming IP address into the /etc/hosts file 
has solved this for us, but I thought you might want to know.


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

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: User Specific Instance Running

[Anthony W. Marino]

Victoria Reznichenko wrote:

Anthony,
Friday, October 11, 2002, 5:26:39 AM, you wrote:

AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
AWM this users environment (RH 7.3).
AWM my.cnf has been  modified to include  individual user, port , 
AWM bind-address and host specifics (and etc) unique to that user and is 
AWM passed as --defaults-file through mysqld_safe script.  Data 
AWM directories are already available with this user/group's ownership.

AWM All attempts to run mysql -u root  file and other  privledged commands

This is not a privilege command :-)
It means that you connect as user 'root' without a password to the
database 'file'.

This occurs immediately after running  mysql_install_db then running 
mysql.server scripts so there isn't any passwords at this time.


AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied
AWM ?

--skip-grant-tables is an option of mysqld, not a mysql client
program.
  

Understood, however, doesn't using that switch (with mysqld) impact how 
you gain access to the server from a security aspect  whether using 
mysql, mysqladmin etc?

Thank You,
Anthon


  





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

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

ld.so.1: ./perl: fatal: relocation error

[Faine, Mark]

Perl 5.6.1
Platform/OS: Solaris 9
Compiler: GCC 2.95.2 - Tried with both Gnu binutils and Sun
Attempted with mysql 3.23.47 and 3.23.52

When I try to compile perl it appears to compile just fine until I run
'make test' then I get the following error message for many of the
various tests:

lib/dirhand..Can't load '../lib/auto/File/Glob/Glob.so' for
module File::Glob: ld.so.1: ./perl: fatal: relocation error: file
../lib/auto/File/Glob/Glob.so: symbol main: referenced symbol not
found at ../lib/XSLoader.pm line 75.
 at ../lib/File/Glob.pm line 101
Compilation failed in require at lib/dirhand.t line 20.

This is repeated for 54 of the tests.  I have tried everything I can
think of and nothing I have tried will make this thing compile
properly.  Any suggestions, help, recommendations will be greatly
appreciated.

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: selecting a certain number of rows

[Victoria Reznichenko]

Sean,
Thursday, October 10, 2002, 10:54:24 PM, you wrote:

SM In a previous job I had the (mis)fortune to develop software exclusively on
SM DB2.  While doing so I would often use FETCH to examine a certain number of
SM records.  Example:

SM SELECT * from table FETCH FIRST 10 ROWS ONLY.

SM When I use this particular syntax in any mysql interface (I've used 2) I get
SM syntax error statements.  Now either I have forgotten the exact syntax
SM (unlikely, but possible) or mysql doesn't support this.  Assuming the
SM latter, is there an alternative method to acheive my desired result or do I
SM have the syntax wrong?

You can use LIMIT clause, f.e.
SELECT * FROM table_name LIMIT 10;

http://www.mysql.com/doc/en/SELECT.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: varbinary equivalent ??

[Peter Brawley]

Tonino,
 
 What is the mysql equivalent of the Sybase varbinary data type ???
 
 I have a table that has 5 varbinary(255) columns in sybase and want to
 convert it to mysql ???
 
 Any ideas welcome - 

TINYBLOB (for 255) or BLOB, MEDIUMBLOB, LONGBLOB for bigger data.

PB





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

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

Re: mysql-3.23.52 on hpux 11 with innodb

[Heikki Tuuri]

Stephan,

- Original Message -
From: Stephan Hendl [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, October 11, 2002 12:16 PM
Subject: mysql-3.23.52 on hpux 11 with innodb


 Hallo,

 does anybody build a runtime version of mysql-3.23.52 with innodb  on an
hp/ux 11.0, 64 bit runtime os?

 Using hp's ansi c and aCC the innodb-sourcen gives an error like:


cc -DHAVE_CONFIG_H -I. -I../.././innobase/os -I.. -I../../include -I../inclu
de  -D_REENTRANT  -O -DDBUG_OFF -O -DDBUG_OFF -D_REENTRANT  -DHAVE_BROKEN_PR
EAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -DDO_NOT_REM
OVE_THREAD_WRAPPERS -DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT  -DDEBUG_OFF -DUNIV
_MUST_NOT_INLINE -DUNIV_HPUX -c os0thread.c
 cpp: ../include/univ.i, line 59: warning 2001: Redefinition of macro
UNIV_MUST_NOT_INLINE.
 cc: os0thread.c, line 59: error 1529: Cannot select field of
non-structure.
 cc: os0thread.c, line 59: error 1527: Incompatible types in cast: Must
cast from scalar to scalar or to void type.

looks like HP-UX-11 has pthread_t defined to be a pointer or integer type
like most other operating systems. In HP-UX-10.20 it was a struct with 3
fields!

Rodolphe Jouannet fixed it with a patch like the following in 3.23:

Subject: Compiling MySQL 3.23.52 and 4.0.x on HPUX 11
From: JOUANNET, Rodolphe
Date: Fri, 11 Oct 2002 14:36:54 +0200


ChangeSet
  1.1226 02/10/11 15:44:45 [EMAIL PROTECTED] +1 -0
  os0thread.c:
Fix compilation error on HP-UX-11: pthread_t is a scalar there, not a
struct
like in HP-UX-10.20

  innobase/os/os0thread.c
1.17 02/10/11 15:44:30 [EMAIL PROTECTED] +2 -2
Fix compilation error on HP-UX-11: pthread_t is a scalar there, not a
struct
like in HP-UX-10.20

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: hundin.mysql.fi
# Root: /home/heikki/mysql

--- 1.16/innobase/os/os0thread.c Sun Aug 25 10:20:08 2002
+++ 1.17/innobase/os/os0thread.c Fri Oct 11 15:44:30 2002
@@ -52,8 +52,8 @@
 /*=*/
  os_thread_id_t a)
 {
-#ifdef UNIV_HPUX
-/* In HP-UX a pthread_t is a struct of 3 fields: field1, field2,
+#ifdef UNIV_HPUX10
+/* In HP-UX-10.20 a pthread_t is a struct of 3 fields: field1,
field2,
 field3. We do not know if field1 determines the thread uniquely. */

  return((ulint)(a.field1));


 Thanks for helping me!

 Stephan

Thank you for notifying us of the problem!

Heikki
Innobase Oy

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: Alternative for NOT EXISTS

[Michael T. Babcock]

Victor Kirk wrote:

If so, this should work:

 SELECT u.uname
   FROM users u
   LEFT JOIN team_members t ON u.user_id =3D t.user_id
AND t.team_id =3D 7
  WHERE t.team_id is NULL



Perfect :-) thanks very much this query works perfectly, you are a star.
  

I'd like to take this opportunity to point out that there is a 
sql-general list hosted by Yahoo! that is quite good for generic SQL 
query questions, although they usually won't deal with issues like I 
can't use LEFT JOINs the way this list will.  The point, though, is 
that I've found a lot of good suggestions there and learned a lot about 
forming good SQL queries.

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
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

re: I could't find my.cnf

[Egor Egorov]

Perumal,
Friday, October 11, 2002, 8:23:20 AM, you wrote:

PPlease anybody could give me an idea for the below:

P I installed mysql-max5.1.tar on linux machine but I could  not find
  
What a surprise! We didn't knew that v5.1 is already available ;)

P a file  my.cnf over  installation directory to set my.cnf  to the
P mysqld file.

You should create my.cnf by yourself. You can find examples of
my.cnf(my-*.cnf) in the MySQL documentation dir on your OS.



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

Re: MySQl db as filesystem.

[Michael T. Babcock]

Joel Rees wrote:

Should we guess that he wants to be able to log into a database with csh,
run ls and get a list of tables, run cat on a table and get a
tab-delimited listing of the contents of the table?

On the surface it didn't seem like such an unreasonable question, ...

The easiest way would probably be to write an sh-like 'shell' that 
executed commands it didn't recognize via a 'real' shell, but filtered 
the rest.  It would take 'ls' and use it to show a list of databases, cd 
'databasename' as 'use databasename', then 'ls' would show tables and 
'cd tablename' would push FROM tablename onto the stack in some form.

The only problem I see is the reading of data in any complex way ... SQL 
queries can do things that no 'ls' command could ever do without using 
`ls -l --query=select name, address from cust left join custorders on 
cust.id = custorders.custid left join orders on custorders.orderid = 
orders.id left join orderstatus on orders.statusid = orderstatus.id 
where orderstatus.name in ('invoiced', 'shipped')`

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
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

InnoDB indexing questions

[rafarife]

Hello,

I have some doubts about the index behaviour in InnoDB.

I have a table named 'Albaranes'. The definition is as follow:

CREATE TABLE `albaranes` (
  `Cli` varchar(6) NOT NULL default '',
  `Alb` varchar(8) NOT NULL default '',
  .
  .
  . 
  PRIMARY KEY  (`Alb`),
  UNIQUE KEY `Cliente` (`Cli`,`Alb`),
) TYPE=InnoDB;

The index 'Cliente' is composed of the field 'Cli' and the field 'Alb'
which belong to the primary index. I have read in the InnoDB documentation
the following text:

The records in non-clustered indexes (we also call them secondary indexes), 
in InnoDB contain the primary key value for the row. InnoDB uses this primary 
key value to search for the row from the clustered index.

Well, according to the text it wouldn`t be necessary to add the field 'Alb' 
to the 'Cliente' index to access to a specific record because InnoDB does that.
My question is: If I add the field 'Alb' to the 'Cliente' index, does InnoDB
add the field 'Alb' too?

I have made tests and I have noticed that if I define the index 'Cliente' as
(Cli) the time that the query takes in recovering all the table records is
more or less the same that the query takes if I define the index 'Cliente'
as (Cli,Alb) (there isn't a considerable difference). The query executed is
'Select Cli,Alb From Albaranes where Cli  'AnyValue''. I'm interesting in 
recovering the records ordered by Cli,Alb for increasing the speed of some 
reports so, I executed the query 'Select Cli,Alb From Albaranes where
Cli  'AnyValue' Order by Cli,Alb' and I checked that if I define the index
as (Cli) InnoDB doesn´t use the field 'Alb' (which is used to search for
the row from the clustered index by InnoDB) to order the selected records.
I suppose InnoDB only uses this primary key value to search for the rows
and not to order the rows, doesn´t it?

My last question is if I add the fields from the clustered index to other
secondary indexes (for example the index 'Cliente'), have I to define
the secondary index as 'UNIQUE'? I think that it´s not necessary and the
only I could obtain is that inserts are slower because InnoDB has to 
preserve the data uniqueness.

Let me ask a question that is not related to InnoDB. I have three primary
fields (varchar) in a table and I have some doubts in the way of defining them. 
What is better, defining three fields and the primary index is formed by
all of them or defining only one field which is composed of the concatenation
of the three fields and the index is formed only by one field?. I'm always
going to search by the first field.


Regards,

Lourdes.



__
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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