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

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 wa

re: I could't find my.cnf

Perumal, Friday, October 11, 2002, 8:23:20 AM, you wrote: P>Please 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: 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

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

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

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: lib/dirh

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-

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 s

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

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

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: 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: http://www.mysql.com/doc/en/SELECT.html > SELECT * from table LIMIT 10 -- Roger - Before posting, ple

Repair TABLE - OPERATION FAILED

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

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 inlin

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

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 wo

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 th

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 co

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

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

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 comm

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

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\" -DDONT_US

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 privilege

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

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 posting

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.

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

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 s

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 exception

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

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

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

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 wit

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:

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) http://lists.mysql.com/

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

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 \ --without-d

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

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

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

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,