mysql@lists.mysql.com

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

Importing diff format date to MySQL

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

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

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../include -D_REENTRANT -O -DDBUG_OFF -O

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.

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

compiling mysql 4.0.4 error

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 \

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../include -D_REENTRANT -O -DDBUG_OFF -O

stored procedure support

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)

re: MySQL Error

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:

Urgent help: character encoding???

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

Re: Re: thread creation problem

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

re: Importing diff format date to MySQL

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

re: varbinary equivalent ??

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

RE: MySQl db as filesystem.

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.

Problem with mysql jdbc Connector

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

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

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:

Indexing questions

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`

Re: I could't find my.cnf

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.

varbinary equivalent ??

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

RE: MySQl db as filesystem.

-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

Privileges

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

Problem with compilation of mysql.

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\

Re: Repair TABLE - OPERATION FAILED

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

Re: help needed

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

How to make individual batch SQL silent

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

Error running autoheader on a new clone of src tree for 4.0

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:

RE: I could't find my.cnf

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

RE: copy one database to another

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

Export of text fields from Access2000

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

help needed

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 -

Compiling MySQL 3.23.52 and 4.0.x on HPUX 11

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

Repair TABLE - OPERATION FAILED

Hello, Please help me. mysql repair table none; +++--+-+ | Table | Op | Msg_type | Msg_text| +++--+-+ | n_toccata.none | repair | error| 28

Re: selecting a certain number of rows

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

RE: copy one database to another

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

Re: MySQl db as filesystem.

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

solaris 8 and mysql

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.

RE: Re: Alternative for NOT EXISTS

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:

MySQL 3.23.49

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

Re: User Specific Instance Running

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

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

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:

re: selecting a certain number of rows

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

Re: varbinary equivalent ??

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

Re: mysql-3.23.52 on hpux 11 with innodb

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

Re: Alternative for NOT EXISTS

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

re: I could't find my.cnf

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

Re: MySQl db as filesystem.

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

InnoDB indexing questions

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`