RE: What is the best known practice for insertion...?

[Daevid Vincent]

This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html

> -Original Message-
> From: Zysman, Roiy [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, January 19, 2003 11:16 PM
> To: [EMAIL PROTECTED]
> Subject: What is the best known practice for insertion...?
> 
> 
> Hi All,
> I'm trying to insert multiple lines to a table with 3 col. 
> All 3 of them
> are a part of the primary key.
> But while inserting the data , sometime occurs the situation where I
> want to insert an already exist entry with the same keys. And mysql
> barfs out that this key already exist in the table.
> The solution to it would be probably to query for each entry that I'm
> about to insert if that entry exists , but it looks like it 
> would be an
> enormous overhead. I'm asking this question on a 
> _performance_ context .
> What is the best way , ignore the error messages mysql barfs out or
> query each entry for existences before inserting it ?


-
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 !! -- mySQL on TCP/IP on Mac OS X

[Ram Kumar]

greetings nug

how can we access mySQL installation (from entropy.ch, Marc Liyanage)
through TCP/IP on a network

we are able to access mySQL on localhost, but tcp fails

regards, ram
 
--

 +--+
   Mac Solutions
   http://www.macsolutionsindia.com +91 98102 70848
ram @ macsolutionsindia.com
   MSN: [EMAIL PROTECTED]   support @ macsolutionsindia.com
 +--+
 Simplifying solutions for you...  Macintosh, Windows, Client/Server, Web



-
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

What is the best known practice for insertion...?

[Zysman, Roiy]

Hi All,
I'm trying to insert multiple lines to a table with 3 col. All 3 of them
are a part of the primary key.
But while inserting the data , sometime occurs the situation where I
want to insert an already exist entry with the same keys. And mysql
barfs out that this key already exist in the table.
The solution to it would be probably to query for each entry that I'm
about to insert if that entry exists , but it looks like it would be an
enormous overhead. I'm asking this question on a _performance_ context .
What is the best way , ignore the error messages mysql barfs out or
query each entry for existences before inserting it ?

Roiy 

-
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:Potential Customer - Technical Questions

[Nasser Ossareh]

re: Question 1:  

You are right that windows does not ship the ODBC provider but MS has actually created 
one and is available for free download.  You also need the MyODBC driver which is 
created by MySQL folks (also free).  Apart from these two there are a few other pieces 
of software that you need..  I have installed all of them, and guess what?  They 
actually work!!! with C#... if you are using VB6 in .NET framework, you shouldn't have 
any problem...  here's a site that will offer you all the links you need for setting 
up your system.
http://www.mysql.com/articles/dotnet/index.html
(my specs: XP-home client - MySQL 3.23.48 on linux 2.4)

re: Question 2, 3:
I have used the setup with VB6, but in theory it should work with the environment that 
you are refering to.  You really need to try it without panicing... ;-) you don't need 
a bundling program.. you just need a couple of hours free time and some patience.  

Also I haven't tested this, but my guess is that all the drivers are being packaged in 
the executable.. so you can just drop it on a new machine and run with it (but maybe I 
am day dreaming???).

re: Question 4
There should be no charge for using MySQL in a commercial product... please don't put 
new ideas in MySQL folks' heads ;-)

Nasser.
  


-- "A A" <[EMAIL PROTECTED]> writes:

Return-Path: <[EMAIL PROTECTED]>
Received: from mx13.nyc.untd.com (mx13.nyc.untd.com [10.140.24.73])
by maildeliver05.nyc.untd.com with SMTP id AAA9CYS52AD23NNJ
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 19:31:52 -0500 (EST)
Received: from web.mysql.com (web.mysql.com [213.136.49.183])
by mx13.nyc.untd.com with SMTP id AAA9CYS5ZAUW2BH2
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 19:31:51 -0500 (EST)
Received: (qmail 29592 invoked by uid 7797); 20 Jan 2003 00:29:05 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: 
Precedence: bulk
List-Help: 
List-Unsubscribe: 
List-Post: 
List-Subscribe: 
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 29576 invoked from network); 20 Jan 2003 00:29:04 -
To: [EMAIL PROTECTED]
Date: Sun, 19 Jan 2003 16:28:27 -0800
From: "A A" <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
X-Sent-Mail: off
Reply-To: [EMAIL PROTECTED]
X-Mailer: MailCity Service
X-Priority: 3
Subject: Potential Customer - Technical Questions
X-Sender-Ip: 209.121.214.189
Organization: Lycos Mail  (http://www.mail.lycos.com:80)
Content-Type: text/plain; charset=us-ascii
Content-Language: en
Content-Transfer-Encoding: 7bit

Hi mySQL Support,

I am a small programming company and I currently use VB6 and MS Access as my database. 
 I am currently in negotiations to develop new applications with a number of different 
companies.  I am finding the number of entries the companies desire will exceed MS 
Access to unsafe levels.  

I am interested in mySQL as my new database, but I have a few questions before I make 
my decision.

Question 1:  mySQL does not have an ODBC connection in Windows and I understand there 
is a MySQL ODBC installation program I can use for connectivity.  My question is, once 
I make an application in VB6 with mySQL as the database.  Is there a problem with 
bundling the application and installing the program on a customer’s computer?  Will 
the customer have to install and set up mySQL ODBC or is there a VB6 bundling program 
that will install VB6 and mySQL components?

Question 2:  VB6 has a Designers – DataEnvironment ability.  Which links MS Access to 
the program.  Is mySQL able to use this DataEnvironment and code primarily the same as 
MS Access does?  Once again is there a bundling problem with this?

Question 3:  Is there a bundling program that caused the least amount of problems with 
VB6 and mySQL applications?

Question 4:  What are the appropriate fees associated with purchasing mySQL as a 
programming company who would use mySQL as its database in its applications.

I hope I was clear enough to understand.  Please feel free to clarify, I won’t be 
insulted.

Yours truly,
Sam



_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus

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

Mysql and Database Link

[MySQL]

Hi all,

I'm woundering if Mysql can use Database link, like Oracle can???

Eg. If i have some tables at my labtop, and want to make the same table(s) at my 
server with this command:

create table test as select * from test@database_link (This is how you do it on 
Oracle), but how do I do this in Mysql

Regards

Frank (Denmark)

-
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

Bug in MySQL Control Center 0.8.8 Beta Windows

[dan]

I have come across the following bug in MySQL Control Center 0.8.8 Beta for Windows:

When you have two databases that are identicle (ie, a master and a slave) and you
connect to both databases (one on a server and one on the local machine) when you
open a table listing for one database and open a table, then open the second
database, and it still reads from the first database that you opened, if you
disconnect from the first database that you opened, and try to open a table in the
second database, it will crash because it is still trying to access the first
database.

This is a really annoying bug, as it caused me to accidently update data in my slave
database instead of the master, because I didn't look closely and see that it hadn't
actually opened the table from the master database like it was suppose to.

-
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: Random ID creation in MySQL /Linux

[Daevid Vincent]

What language are you using? In PHP use this:
http://www.php.net/manual/en/function.session-id.php

You could also experiment with mySQL's built in 
NOW or CURRENT_TIMESTAMP or UNIX_TIMESTAMP
or ENCRYPT or MD5 or SHA or AES_ENCRYPT
or RAND
And some combination of those (hint hint)

> -Original Message-
> From: DIetrich Speer [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, January 19, 2003 6:26 PM
> To: [EMAIL PROTECTED]
> Subject: Random ID creation in MySQL /Linux
> 
> 
> Hello:
> I am trying to find a way to create a random ID for use as a 
> session ID in a
> MySQL table.
> In MS SQL I use NewID(). Does anybody know an equivalent to 
> use for MySQL,
> running on RedHat Linux 8.0?
> 
> I'd be greatful for any tip.


-
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

Random ID creation in MySQL /Linux

[DIetrich Speer]

Hello:
I am trying to find a way to create a random ID for use as a session ID in a
MySQL table.
In MS SQL I use NewID(). Does anybody know an equivalent to use for MySQL,
running on RedHat Linux 8.0?

I'd be greatful for any tip.

thks!

Dietrich


-
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

Article: Using the Ruby DBI Module

[Paul DuBois]

I've written an article, "Using the Ruby DBI Module," that discusses
using Ruby DBI to write programs that access databases.  The article 
is available here:

http://www.kitebird.com/articles/


I'd be interested in feedback, especially corrections if there
are errors.

The article follows an earlier one, "Using the Ruby MySQL Module,"
that describes the lower-level module on which the Ruby DBI MySQL
driver is based.  The earlier article is available at the same site.


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: 3.23.54a - Solaris 9/gcc 2.95.3 compile problem

[Len Rose]

I compiled gcc 2.95.2 on Solaris 9 and was then able to
successfully compile 3.23.54a under Solaris 9 (sparc)
without any unsual steps or configuration options.

>From my tests today, it seems neither gcc 2.95.3 or
3.x will compile mysql 3.23.54a under Solaris 9, in
case anyone is interested.


On Sun, Jan 19, 2003 at 08:57:49AM -0500, I wrote:

> Has anyone run into this? I did a search on the web site
> looking for information before posting, didn't see
> anything..
> 
>  3.23.54a - Compiling with gcc 2.95.3, Solaris 9 sparc..

> # snip
> Making all in sql
> make  all-recursive
> Making all in share
> source='sql_lex.cc' object='sql_lex.o' libtool=no \
> depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \
> depmode=gcc /bin/bash ../depcomp \
> g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/opt/local\""  -DDATADIR="\"/var/data\"" 
> -DSHAREDIR="\"/opt/local/share/mysql\""  -DHAVE_CONFIG_H -I. -I. -I.. -I./../include 
> -I./../regex  -I. -I../include -I.. -I. -O3 -DDBUG_OFF   -fno-implicit-templates 
>-fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c -o sql_lex.o `test -f sql_lex.cc || echo 
>'./'`sql_lex.cc
> sql_lex.cc: In function `void lex_init()':
> sql_lex.cc:85: `symbols' undeclared (first use this function)
> sql_lex.cc:85: (Each undeclared identifier is reported only once
> sql_lex.cc:85: for each function it appears in.)
> sql_lex.cc:87: `sql_functions' undeclared (first use this function)
> sql_lex.cc: In function `int find_keyword(LEX *, unsigned int, bool)':
> sql_lex.cc:168: implicit declaration of function `int get_hash_symbol(...)'
> sql_lex.cc:168: initialization to `SYMBOL *' from `int' lacks a cast
> *** Error code 1
> make: Fatal error: Command failed for target `sql_lex.o'
> # snip
> 
> Thanks


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

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

FW: Text field question

[Robyn Bailey]

Could anyone please tell me how I write an SQL statement to seperate
text from one field into multiple fields based on a aprticular character
(i.e. tab/comma/space). For example, I have a text field containing:
Text=Robyn Bailey Brisbane

I want to seperate this (per query) into 3 fields so that I can sort and
count the fields: Name=Robyn Surname=Bailey Location=Brisbane

I dont want it permanently just per query (for a report).

Thanks in advance
Robyn Bailey, CISSP



This email and any attachments are subject to copyright. They may also
contain confidential information. This email and any attachments may not
be distributed, reproduced, copied, stored or transmitted in any form or
by any means, without the prior written consent of Bridge Point
Communications Pty Ltd ABN 29 083 424 668. Any personal information in
this email must be handled in accordance with the Privacy Act 1988
(Cth). Emails may be interfered with, may contain computer viruses or
other defects and may not be successfully replicated on other systems.
Bridge Point Communications Pty Ltd gives no warranties in relation to
these matters. If you have any doubts about the authenticity of an email
purportedly sent by us, please contact Bridge Point Communications Pty
Ltd immediately.


-
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

Potential Customer - Technical Questions

[A A]

Hi mySQL Support,

I am a small programming company and I currently use VB6 and MS Access as my database. 
 I am currently in negotiations to develop new applications with a number of different 
companies.  I am finding the number of entries the companies desire will exceed MS 
Access to unsafe levels.  

I am interested in mySQL as my new database, but I have a few questions before I make 
my decision.

Question 1:  mySQL does not have an ODBC connection in Windows and I understand there 
is a MySQL ODBC installation program I can use for connectivity.  My question is, once 
I make an application in VB6 with mySQL as the database.  Is there a problem with 
bundling the application and installing the program on a customer’s computer?  Will 
the customer have to install and set up mySQL ODBC or is there a VB6 bundling program 
that will install VB6 and mySQL components?

Question 2:  VB6 has a Designers – DataEnvironment ability.  Which links MS Access to 
the program.  Is mySQL able to use this DataEnvironment and code primarily the same as 
MS Access does?  Once again is there a bundling problem with this?

Question 3:  Is there a bundling program that caused the least amount of problems with 
VB6 and mySQL applications?

Question 4:  What are the appropriate fees associated with purchasing mySQL as a 
programming company who would use mySQL as its database in its applications.

I hope I was clear enough to understand.  Please feel free to clarify, I won’t be 
insulted.

Yours truly,
Sam



_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus

-
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: SELECT * WHERE DATE > TODAY

[Paul DuBois]

At 15:40 -0800 1/19/03, Melissa Stranzl wrote:

I am trying to get my program to be searchable by
date, but it doesn't work.  I get an error message in
perl, that follows the code I included.  Any
suggestions are greatly appreciated.

PERL
--
@currenttime= localtime();

$y= $currenttime [5] + 1900;

$m= $currenttime [4];
$dom= $currenttime [3];

$ydoy= $y*1000 + $m + $dom;
print $ydoy;

my $dbh= DBI->connect ('DBI:mysqlPP:myd:localhost',
'pass', 'pass') ||die "Could not connect to database:
".DBI->errstr;
my $sth = $dbh->prepare("SELECT * from food WHERE
end_date > $ydoy");
$sth->execute($ydoy);


Wouldn't it be simpler to skip all that date manipulation stuff and
simply write your query like this?

SELECT * from food WHERE end_date > CURDATE()



while((end_date > $ydoy) = $sth->fetchrow_array)


That's illegal, because you're trying to assign a value to an
expression.  Also, "end_date" is a bareword.  Anyway, doesn't
your query already rule out records where the end_date values
are not greater than the current date?  So you should be able
to just write this as:

while (($start_date, $end_date, $event) = $sth->fetchrow_array)

(I'm assuming that SELECT * returns rows in start_date, end_date, event
column order, which may be incorrect.  If you're retrieving arrays,
you *REALLY* should name the columns explicitly in the order you want
in the SELECT statement, and *NOT* use SELECT *, which guarantees nothing
about column order in the result set.)


{
print "$start_date\n, $end_date\n, $event\n, $id";
}

die $sth->errstr if $sth->err;


$sth->finish();
$dbh->disconnect();

ERROR MESSAGE:
--

can't modify generic gt()) in list assignment at line
31 (which is the fetchrow_array line)
repeated HERE:
while((end_date > $ydoy) = $sth->fetchrow_array)
{
print "$start_date\n, $end_date\n, $event\n, $id";
}


Thanks again for your help.

Melissa Stranzl

917-922-7872



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

[Adolfo Bello]

On Sun, 2003-01-19 at 19:09, Nasser Ossareh wrote:
> Isn't there a typo somewhere... 
> Shouldn't you expect 5 instead of -5 (15 - id where id = 10)??   
> 
> Nevermind, let's assume that there is a typo somewhere and the correct expected 
>value is -5... however, in the domain of unsigned arithmetics -5 is precisely 
>18446744073709551611... don't you believe me:  look at this:
> 
> 18446744073709551611 + 5 = 18446744073709551616 which is 2 to power 64 (2^64). 
>Clearly in the architecture that you are using an unsigned int is a 64 bits 
>integer... if you set all the bits to 1 you will get the largest unsigned int in your 
>system and that is 18446744073709551615 which is (2^64)-1.  if you increment it by 
>one... all the bits switch to 0.  Hence within your architecture 2^64 = 0 and -5 is 
>represented correctly by 18446744073709551611 (which is 2^64 - 5).
> 
> Nasser
> sql, smallint, ...
Beautifully explained.

Adolfo


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

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

SELECT * WHERE DATE > TODAY

[Melissa Stranzl]

I am trying to get my program to be searchable by
date, but it doesn't work.  I get an error message in
perl, that follows the code I included.  Any
suggestions are greatly appreciated.

PERL
--
@currenttime= localtime();

$y= $currenttime [5] + 1900;

$m= $currenttime [4];
$dom= $currenttime [3];

$ydoy= $y*1000 + $m + $dom;
print $ydoy;

my $dbh= DBI->connect ('DBI:mysqlPP:myd:localhost',
'pass', 'pass') ||die "Could not connect to database:
".DBI->errstr;
my $sth = $dbh->prepare("SELECT * from food WHERE
end_date > $ydoy");
$sth->execute($ydoy);

while((end_date > $ydoy) = $sth->fetchrow_array)
{
print "$start_date\n, $end_date\n, $event\n, $id";
}

die $sth->errstr if $sth->err;


$sth->finish();
$dbh->disconnect();

ERROR MESSAGE:
--

can't modify generic gt()) in list assignment at line
31 (which is the fetchrow_array line)
repeated HERE:
while((end_date > $ydoy) = $sth->fetchrow_array)
{
print "$start_date\n, $end_date\n, $event\n, $id";
}


Thanks again for your help.

Melissa Stranzl

917-922-7872

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.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

Innodb Help....

[Nilza Lafayette]

Hi!

I'm new to MySQL and I´m trying to understand how
Innodb works. So far I have set up the InnoDB data
files and directories and have MySQL up and running. 
I set my "my.ini" file with the following:

# Uncomment the following if you are using Innobase
tables
innodb_data_home_dir=
innodb_data_file_path = D:/Program
Files/MySQL/data/ibdata1:10M:autoextend
innodb_log_group_home_dir = D:/Program
Files/MySQL/iblogs
innodb_log_arch_dir = D:/Program Files/MySQL/iblogs
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

1 - Everything works perfectly... But I am not
understanding InnoDB.  The database ibdata was
created, but I would like to create a database with
other name and not «ibdata»... I haven't found a good
FAQ for explaining this... 

2 - WHat about that ibdata1 I created?  I am assuming
that this is my database where transactional tables
will be created... But what should I do if I want to
create another database, with another name and Innodb
tables too? Should I keep my.ini with that
configuration? Or Should I change the ibdata to
another name?

3 - I just feel like I am missing something. If anyone
can explain to me about what exactly is going on with
this I would be grateful. I have been to the
Innodb.com site. Great tutorial, but It leaves me with
lots of questions... So please, don´t send me links
please.

Best Regards to all, Janine



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.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: Substraction

[Stefan Hinz, iConnect \(Berlin\)]

Brian,

> > create table test(id int unsigned);
> > insert into test values(10);
> > select 15 - id from test;
> > The result is 18446744073709551611 instead of -5.

Trying to confirm this with MySQL 4.0.7 on a Win2K box:

mysql> create table test(id int unsigned);
Query OK, 0 rows affected (0.56 sec)

mysql> insert into test values(10);
Query OK, 1 row affected (0.08 sec)

mysql> select 15 - id from test;
+-+
| 15 - id |
+-+
|   5 |
+-+
1 row in set (0.06 sec)

Now, once again with phpMyAdmin 2.3.3pl1:

SELECT 15 - id
FROM test LIMIT 0, 30
15 - id
5

But with the following statement (same with phpMyAdmin):

mysql> select 5 - id from test;
+--+
| 5 - id   |
+--+
| 18446744073709551611 |
+--+
1 row in set (0.00 sec)

Check the "1" in your "15". Maybe there's something wrong.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Brian Lindner" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 10:28 PM
Subject: Re: Substraction


> Octavian,
>
> Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> > Hi all,
>
> > I've tried the following query:
>
> > create table test(id int unsigned);
> > insert into test values(10);
> > select 15 - id from test;
>
> > The result is 18446744073709551611 instead of -5.
>
> I ran this.. and it worked for me
>
> MySql 4.0.7 on Linux... ran it through phpMyAdmin
>
> > Am I doing something wrong?
>
> > Thank you.
>
> > Teddy,
> > Teddy's Center: http://teddy.fcc.ro/
> > Email: [EMAIL PROTECTED]
>
>
>
>
> -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
>
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>
> --
>  Brian
>  Email: <[EMAIL PROTECTED]>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

[Nasser Ossareh]

Isn't there a typo somewhere... 
Shouldn't you expect 5 instead of -5 (15 - id where id = 10)??   

Nevermind, let's assume that there is a typo somewhere and the correct expected value 
is -5... however, in the domain of unsigned arithmetics -5 is precisely 
18446744073709551611... don't you believe me:  look at this:

18446744073709551611 + 5 = 18446744073709551616 which is 2 to power 64 (2^64). Clearly 
in the architecture that you are using an unsigned int is a 64 bits integer... if you 
set all the bits to 1 you will get the largest unsigned int in your system and that is 
18446744073709551615 which is (2^64)-1.  if you increment it by one... all the bits 
switch to 0.  Hence within your architecture 2^64 = 0 and -5 is represented correctly 
by 18446744073709551611 (which is 2^64 - 5).

Nasser
sql, smallint, ...

-- Brian Lindner <[EMAIL PROTECTED]> writes:

Return-Path: <[EMAIL PROTECTED]>
Received: from mx11.lax.untd.com (mx11.lax.untd.com [10.130.24.71])
by maildeliver03.nyc.untd.com with SMTP id AAA9CYGS4AWCVYC2
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 16:35:22 -0500 (EST)
Received: from web.mysql.com (web.mysql.com [213.136.49.183])
by mx11.lax.untd.com with SMTP id AAA9CYGS3A42HYBJ
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 13:35:21 -0800 (PST)
Received: (qmail 2737 invoked by uid 7797); 19 Jan 2003 21:29:14 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: 
Precedence: bulk
List-Help: 
List-Unsubscribe: 
List-Post: 
List-Subscribe: 
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 2704 invoked from network); 19 Jan 2003 21:29:13 -
Date: Sun, 19 Jan 2003 16:28:43 -0500
From: Brian Lindner <[EMAIL PROTECTED]>
X-Mailer: The Bat! (v1.62 Christmas Edition) UNREG / CD5BF9353B3B7091
Reply-To: Brian Lindner <[EMAIL PROTECTED]>
X-Priority: 3 (Normal)
Message-ID: <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
CC: "MySQL" <[EMAIL PROTECTED]>
Subject: Re: Substraction
In-Reply-To: <001901c2bfe4$58e8dda0$[EMAIL PROTECTED]>
References: <001901c2bfe4$58e8dda0$[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Octavian,

Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> Hi all,

> I've tried the following query:

> create table test(id int unsigned);
> insert into test values(10);
> select 15 - id from test;

> The result is 18446744073709551611 instead of -5.

I ran this.. and it worked for me

MySql 4.0.7 on Linux... ran it through phpMyAdmin

> Am I doing something wrong?

> Thank you.

> Teddy,
> Teddy's Center: http://teddy.fcc.ro/
> Email: [EMAIL PROTECTED]



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

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





--
 Brian
 Email: <[EMAIL PROTECTED]>




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

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






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

[Brian Lindner]

Octavian,

Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> Hi all,

> I've tried the following query:

> create table test(id int unsigned);
> insert into test values(10);
> select 15 - id from test;

> The result is 18446744073709551611 instead of -5.

I ran this.. and it worked for me

MySql 4.0.7 on Linux... ran it through phpMyAdmin

> Am I doing something wrong?

> Thank you.

> Teddy,
> Teddy's Center: http://teddy.fcc.ro/
> Email: [EMAIL PROTECTED]



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

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





--
 Brian
 Email: <[EMAIL PROTECTED]>




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

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

Re: Innodb enable/disable keys

[Heikki Tuuri]

Carlos,

- Original Message - 
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, January 19, 2003 7:13 PM
Subject: Innodb enable/disable keys


> 
> 
> 
> 
> Hi, i have a simple question:
> The sql statement: alter table _table_name_ disable keys;
> has any action on "INNODB" tables ?, helps improving bulk inserts ?.

no effect.

If you have UNIQUE secondary indexes, you can try

SET UNIQUE_CHECKS=0;

to speed up disk-bound inserts.

> thanx
> 
> Carlos

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

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

[Adolfo Bello]

On Sun, 2003-01-19 at 14:48, M A wrote:
> HI
> 
> i am new to mysql.. i have just installed the source code under
> /user/local/mysql
> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".
> 
> please let me know if i am doing something wrong

No. This is the standard Linux/Unix way of invoking a command from in
the working directory.

Adolfo


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

[Nasser Ossareh]

> telnet: Unable to connect to remote host: Connection refused

> I don't understand this problem. I've never had this problem.

This simply means that mysqld is not running on your server.  the result of the telnet 
test (i.e. Connection Refused) confirms that.  You need to start mysqld before trying 
mysqladmin.  

Nasser.
sql, smallint
-- root  writes:

Return-Path: <[EMAIL PROTECTED]>
Received: from mx09.lax.untd.com (mx09.lax.untd.com [10.130.24.69])
by maildeliver05.nyc.untd.com with SMTP id AAA9CXP6DAW9MAB2
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 09:34:43 -0500 (EST)
Received: from web.mysql.com (web.mysql.com [213.136.49.183])
by mx09.lax.untd.com with SMTP id AAA9CXP6CA29394A
for <[EMAIL PROTECTED]> (sender 
<[EMAIL PROTECTED]>);
Sun, 19 Jan 2003 06:34:42 -0800 (PST)
Received: (qmail 3821 invoked by uid 7797); 19 Jan 2003 14:32:07 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: 
Precedence: bulk
List-Help: 
List-Unsubscribe: 
List-Post: 
List-Subscribe: 
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 3807 invoked from network); 19 Jan 2003 14:32:07 -
To: [EMAIL PROTECTED]
Subject:
From: root 
Message-Id: 
Date: Thu, 16 Jan 2003 15:33:35 +0100

>Description:
I can connect on my database at localhost, but not at real hostname. Example when i 
want to change the password :

darkvador:/usr/bin# /usr/bin/mysqladmin -u root -h darkvador  password 'newpassword'
/usr/bin/mysqladmin: connect to server at 'darkvador' failed
error: 'Can't connect to MySQL server on 'darkvador' (111)'
Check that mysqld is running on darkvador and that the port is 3306.
You can check this by doing 'telnet darkvador 3306'

So, i make : telnet darkvador 3306
darkvador:/usr/bin# telnet darkvador 3306
Trying 192.168.0.1...
telnet: Unable to connect to remote host: Connection refused

I don't understand this problem. I've never had this problem.

thank you

NB : Sorry for my english !

>How-To-Repeat:
allways
>Fix:
no solution

>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.52 (Source distribution)

>Environment:

System: Linux darkvador 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i586 unknown
Architecture: i586

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.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 jan 16 13:08 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1145456 sep 18 04:50 /lib/libc-2.2.5.so
-rw-r--r--1 root root  2376426 sep 18 04:51 /usr/lib/libc.a
-rw-r--r--1 root root  178 sep 18 04:51 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin 
--datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql 
--includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man 
--enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb 
--enable-static --enable-shared --enable-local-infile --with-raid 
--enable-thread-safe-client --without-readline 
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql 
--without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all


-
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

scheduling of threads in mysql

[Sumit Mittal]

Hi,

I am working with MySQL v 3.23.51

I wanted to know whether there is any scheduling policy employed for the
numerous threads created for the clients on the server side. I couldnt
figure that out while going through your source distribution or your
documentation.

Thanks.

***
Sumit Mittal
Graduate Student,
Department of Computer Science.
http://www.cs.rice.edu/~mittal
***


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

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

Re: A mysql php question

[Stefan Hinz, iConnect \(Berlin\)]

Ryan,

this line is not correct:

> $line = mysql_fetch_array($result, MYSQL_ASSOC);

Instead, you will need to loop through the result set, like:

while($row = mysql_fetch_array($result)) {
 for($i=0; $i < mysql_num_fields($result); $i++) {
  echo $row[$i];
 }
}

You can find more info here: http://www.php.net/manual/en/ref.mysql.php

I leave formatting the output up to you ;-)

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Ryan McDougall" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 6:47 PM
Subject: A mysql php question


> Hello everyone,
>
> I'm not sure if this is the proper place to be asking this question as
I
> believe it is more of a question on how to traverse through php arrays
and such
> but it is using a mysql_query function. So if this not the place
pleace don't
> read any further and ignore and/or delete this message.
>
> So I am new to mysql AND php, with a background in Oracle SQL. Anyway
I am just
> starting out writing a web application for a DB of the collection of
videos,
> games, and cds of me and my wife's. So I want to start out with just
making a
> table with the field names as the header rows and then the data
underneath the
> corresponding field name/column. The current code (last part of this
message)
> only prints out the right column headers/field names and then puts the
right
> information under it but it only gives me the first record, I want all
records.
>
> *example of current code output*
> IdNum FName LName
> 1 Ryan  McDougall
>
> This is my code so far, be prepared to laugh as this is pretty bad
code I'm
> sure (I just don't want to be held liable for any injuries from
falling out of
> your chairs :-P ):
>
> 
> My PHP test file
> 
>  $link = mysql_connect ("localhost", "username", "password")
> or die ("Could not connect \n");
> print ("Connected successfully\n");
> mysql_select_db("DBname") or die("Could not select database");
>
> $query = "SELECT * FROM Who";
> $result = mysql_query ($query)
> or die ("Query failed");
>
> $line = mysql_fetch_array($result, MYSQL_ASSOC);
>
> print "\n";
> print "\t\n";
> foreach ($line as $key => $value) {
> print "\t\t$key\n";
> }
> print "\t\n";
> print "\t\n";
> foreach ($line as $col_value) {
> print "\t\t$col_value\n";
> }
> print "\t\n";
> print "\n";
>
> mysql_free_result ($result);
>
> mysql_close ($link);
>
> ?>
> 
> 
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.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
>


-
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

[Stefan Hinz, iConnect \(Berlin\)]

Hi,

> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".

If you're logged in as root, log out and log in as another Linux user.
(I'm a Windoze fan, but AFAIK root must type ./ for command for security
reasons.)

HTH,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "M A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 7:48 PM
Subject: mysql


>
>
> HI
>
> i am new to mysql.. i have just installed the source code under
> /user/local/mysql
> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".
>
> please let me know if i am doing something wrong
>
> Thanks
>
>
>
> _
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
>
> -
> 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: hot to obtain metadata on tables

[Stefan Hinz, iConnect \(Berlin\)]

Nedim,

> I am new to MySql. I need to obtain information about tables including
the
> names and types of each column, the primary keys etc.

SHOW TABLE STATUS;

To see only tables starting with "t": SHOW TABLE STATUS LIKE 't%';

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

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "M.Nedim Alpdemir" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 6:32 PM
Subject: hot to obtain metadata on tables


> Hi all,
>
> I am new to MySql. I need to obtain information about tables including
the
> names and types of each column, the primary keys etc.
>
> I understand that the describe  command does this. But are
there
> some system tables (similar to MS SQL server or IBM DB2) that I can
query
> for more detailed information?
>
> Can I obtain this kind of information by a single select statement
(using
> show tables and describe etc.).
>
> Any help will be appreciated?
>
> Thanks in advance?
>
> Nedim.
>
>
>
>
> -
> 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: SQL Count Query

[Jeff Donnici]

Thanks for the help, folks.

I see how the reference tables (either for the dates or the possible
number of days in the range) would work -- pretty slick solutions. I
worry about tables like that being able to scale, though, should a user
choose a large date range... I think, instead, I'll use the standard
query and then handle any gaps (non-existent dates) programmatically --
in the application, I'll check from row-to-row if we've skipped a date
and, if so, display the date with a 0. No extra tables and easily
commented to explain what's happening.

Thanks again!

J

-
Ah, yeah.  Okay, that's right.  So then you *will* need to do it
programmatically ... OR ... create a reference table that lists each of
the dates in which you're interested.  Then do a  LEFT JOIN against
that.

Filter: query, queries, smallint



-
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

mysqldump vs. BACKUP TABLE

[Alex Pilson]

Ok, I know some of the differences to both of these, but is there any 
strong reason to use mysqldump over issuing a SQL to BACKUP tables?

*Note. I will be looping through known tables of a particular 
database and issuing the BACKUP TABLE command, are there any other 
implications for issuing this command in succession for about twenty 
tables?
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
<--->

-
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

[Paul DuBois]

At 18:48 + 1/19/03, M A wrote:

HI

i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have "./" infront of the command
for example: mysqladmin won't work unless its written "./mysqladmin".

please let me know if i am doing something wrong


Sounds like you need to set your PATH.

Read this, it'll explain how to do it:

http://www.kitebird.com/mysql-cookbook/path.pdf



Thanks



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

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

mysql

[M A]

HI

i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have "./" infront of the command
for example: mysqladmin won't work unless its written "./mysqladmin".

please let me know if i am doing something wrong

Thanks



_
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus


-
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: SQL Count Query

[Paul DuBois]

At 10:18 -0700 1/19/03, Jeff Donnici wrote:

 > That would work, but it's not necessary.  He should use a

 LEFT JOIN, which will produce a row in the output for the
 left table, whether or not any right table rows match it. 
 The syntax is in the MySQL manual.

I appreciate the pointer to LEFT JOIN and have read through the site's
documentation on it. Unfortunately, I don't see how that will help me
get the non-existent dates in there with a count of 0. As Nasser pointed
out, there's nothing to do if no rows for those dates exist. In the case
of using a LEFT JOIN, I don't get what I'd be joining my table to...
Sorry for being dense, but any help you can provide is most appreciated.
Thanks!


Ah, yeah.  Okay, that's right.  So then you *will* need to do it
programmatically ... OR ... create a reference table that lists
each of the dates in which you're interested.  Then do a  LEFT JOIN
against that.



J



-
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 from another select?

[Paul DuBois]

At 17:18 +0200 1/19/03, Octavian Rasnita wrote:

Hi all,

For the query:

show columns from table like 'column';

... I want to get the type field.
How can I do that?


Into another table?

You can't.  You have to write a program that captures the result
and processes it.



I've tried:

select type from (
show columns from table like 'column');

But it gave me an error, (as expected).

Thank you

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



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

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

Selecting from another select?

[Octavian Rasnita]

Hi all,

For the query:

show columns from table like 'column';

... I want to get the type field.
How can I do that?

I've tried:

select type from (
show columns from table like 'column');

But it gave me an error, (as expected).

Thank you

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



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

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

What's wrong with this query?

[Octavian Rasnita]

Hi all,

I've tried to create the following type of field in a table:

create table temp(id float(100,50) unsigned);
insert into temp
values(123.1234567890123456789012345678901234567890123456789012345);
select * from temp;

This prints:

123.12345886230469

What's wrong with MySQL?
It didn't give me any error when creating the table or inserting the data,
but it modifies the number.

Thank you.
I use MySQL 4.05 under Windows 2k.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



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

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

Substraction

[Octavian Rasnita]

Hi all,

I've tried the following query:

create table test(id int unsigned);
insert into test values(10);
select 15 - id from test;

The result is 18446744073709551611 instead of -5.

Am I doing something wrong?

Thank you.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



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

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

A mysql php question

[Ryan McDougall]

Hello everyone,

I'm not sure if this is the proper place to be asking this question as I
believe it is more of a question on how to traverse through php arrays and such
but it is using a mysql_query function. So if this not the place pleace don't
read any further and ignore and/or delete this message.

So I am new to mysql AND php, with a background in Oracle SQL. Anyway I am just
starting out writing a web application for a DB of the collection of videos,
games, and cds of me and my wife's. So I want to start out with just making a
table with the field names as the header rows and then the data underneath the
corresponding field name/column. The current code (last part of this message)
only prints out the right column headers/field names and then puts the right
information under it but it only gives me the first record, I want all records.

*example of current code output*
IdNum FName LName
1 Ryan  McDougall

This is my code so far, be prepared to laugh as this is pretty bad code I'm
sure (I just don't want to be held liable for any injuries from falling out of
your chairs :-P ):


My PHP test file

\n");
print ("Connected successfully\n");
mysql_select_db("DBname") or die("Could not select database");

$query = "SELECT * FROM Who";
$result = mysql_query ($query)
or die ("Query failed");

$line = mysql_fetch_array($result, MYSQL_ASSOC);

print "\n";
print "\t\n";
foreach ($line as $key => $value) {
print "\t\t$key\n";
}
print "\t\n";
print "\t\n";
foreach ($line as $col_value) {
print "\t\t$col_value\n";
}
print "\t\n";
print "\n";

mysql_free_result ($result);

mysql_close ($link);

?>



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.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

hot to obtain metadata on tables

[M.Nedim Alpdemir]

Hi all,

I am new to MySql. I need to obtain information about tables including the
names and types of each column, the primary keys etc.

I understand that the describe  command does this. But are there
some system tables (similar to MS SQL server or IBM DB2) that I can query
for more detailed information?

Can I obtain this kind of information by a single select statement (using
show tables and describe etc.).

Any help will be appreciated?

Thanks in advance?

Nedim.




-
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: SQL Count Query

[Jeff Donnici]

Thanks, Harald. I'll experiment with this approach! 

J

--
You need a helper table containing just the numbers 0..N, where N is
greater than the maximum number of days in the query above.  For
example:

CREATE TABLE seq (val INT NOT NULL PRIMARY KEY);
INSERT INTO seq (val) VALUES (0), (1), (2), (3), (4), (5), (6), (7),
(8), (9);

Then you can use a LEFT JOIN:

  SELECT  + INTERVAL val DAY AS hit_date,
 COUNT(hit_date) AS hit_count
  FROM seq
  LEFT OUTER JOIN tbl1 ON to_days(hit_date) = to_days() +
val
  WHERE val BETWEEN 0 AND 
  GROUP BY val

where  is the number of days between  and .



-
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: SQL Count Query

[Jeff Donnici]

> That would work, but it's not necessary.  He should use a 
> LEFT JOIN, which will produce a row in the output for the 
> left table, whether or not any right table rows match it.  
> The syntax is in the MySQL manual.

I appreciate the pointer to LEFT JOIN and have read through the site's
documentation on it. Unfortunately, I don't see how that will help me
get the non-existent dates in there with a count of 0. As Nasser pointed
out, there's nothing to do if no rows for those dates exist. In the case
of using a LEFT JOIN, I don't get what I'd be joining my table to...
Sorry for being dense, but any help you can provide is most appreciated.
Thanks!

J



-
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 enable/disable keys

[Carlos Proal]

Hi, i have a simple question:
The sql statement: alter table _table_name_ disable keys;
has any action on "INNODB" tables ?, helps improving bulk inserts ?.

thanx

Carlos




_
Help STOP SPAM: Try the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


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

[Lisi]

I have a page with many ads that stores both the number of times an ad is 
displayed and how many times it gets clicked.  These are stored in two 
different tables (since different information is stored for each) but both 
have identical name columns. I am trying to display both # times displayed 
and # times clicked in the same table in an admin page.

Here is my query to find ads that were clicked on today:
SELECT ads_displayrate.name, SUM(ads_displayrate.count) as display, SUM( 
IF( ads_clickrate.date IS NULL, 0, 1 ) ) as click FROM ads_displayrate LEFT 
JOIN ads_clickrate ON ads_displayrate.name = ads_clickrate.name AND 
YEAR(ads_displayrate.date) = '2003' AND MONTH(ads_displayrate.date) = '01' 
AND DAYOFMONTH(ads_displayrate.date) = '19' GROUP BY ads_displayrate.name 
ORDER BY ads_displayrate.name

This works for clicks, but no matter what date I put in it only shows 
displays for the whole month - not the selected day. Also, if I use the 
following query to find clicks for the whole month

SELECT ads_displayrate.name, SUM(ads_displayrate.count) as display, SUM( 
IF( ads_clickrate.date IS NULL, 0, 1 ) ) as click FROM ads_displayrate LEFT 
JOIN ads_clickrate ON ads_displayrate.name = ads_clickrate.name AND 
YEAR(ads_displayrate.date) = '2003' AND MONTH(ads_displayrate.date) = '01' 
GROUP BY ads_displayrate.name ORDER BY ads_displayrate.name

it doubles the number from what it should be.

What am I doing wrong?

Thanks in advance,

-Lisi


-
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:SQL Count Query

[Adolfo Bello]

On Sun, 2003-01-19 at 10:44, Paul DuBois wrote:
> At 7:18 + 1/19/03, Nasser Ossareh wrote:
> >  >a row gets inserted into this table
> >whenever a visitor uses a certain tool on the site
> >
> >based on this approach your table does not have any entries for the 
> >days that no one uses the certain tool on the site.  As a result 
> >your query can not pull out records which don't exist.
> >
> >You could catter for this programmatically by a perl script.  The 
> >script could do this:
> 
> That would work, but it's not necessary.  He should use a LEFT JOIN,
> which will produce a row in the output for the left table, whether
> or not any right table rows match it.  The syntax is in the MySQL manual.
Well, the date is inserted into the master table only after a hit to the
tool. Then, if in a date the tool is not called/used, then that date
will not be in the master table. In this case a LEFT JOIN won't help.
__ 
   / \\  @  ____@   Adolfo Bello <[EMAIL PROTECTED]>
  /  // // /\  / \\  // \  //   Bello Ingenieria S.A. / ICQ: 65910258 
 /  \\ // / \\/  // //  / //cel: +58 416 609-6213
/___ / <_/\__\\//__/ // fax: +58 212 952-6797
  www.bisapi.com  //pager: www.tun-tun.com (# 609-6213)


-
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

resolving multiple ids in a single row from another table

[Vikash K Agarwal]

I have a table (TABLE1) which contains multiple fields for user-IDs.
Some examples are - the user who created it (FLD_U1), who last updated
it (FLD_U2), who is the current owner (FLD_U3) and so on.

If I want to make a query and resolve all these IDs to the corresponding
user-names, do I need to join the TABLE2 (which contains FLD_UID and
FLD_UNAME) as many times as there are fields for user ID in the parent
table (TABLE1) or is there some SQL trick which I can resolve all of
them with a single join OR is it that ne number of joins using the same
table does not affect performance of the query in a significant way. 

Note that the parent table(TABLE1) may have a million rows and I m
picking just one page (about 10-15) rows from it at one go.

Thx 
Vikash


-
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:SQL Count Query

[Paul DuBois]

At 7:18 + 1/19/03, Nasser Ossareh wrote:

 >a row gets inserted into this table
whenever a visitor uses a certain tool on the site

based on this approach your table does not have any entries for the 
days that no one uses the certain tool on the site.  As a result 
your query can not pull out records which don't exist.

You could catter for this programmatically by a perl script.  The 
script could do this:

That would work, but it's not necessary.  He should use a LEFT JOIN,
which will produce a row in the output for the left table, whether
or not any right table rows match it.  The syntax is in the MySQL manual.



create a temporary table
insert all records from your main table between TheStartDate and TheEndDate...
iterate through TheStartDate and theEndDate and add one record per 
day to the temporary table.
The SQL statement should display count-1 for each day.

I don't have perl on my system so I can't help with the script I 
hope someone else can.

-Nasser.


-
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@lists.mysql.com

[root]

>Description:
I can connect on my database at localhost, but not at real hostname. Example when i 
want to change the password :

darkvador:/usr/bin# /usr/bin/mysqladmin -u root -h darkvador  password 'newpassword'
/usr/bin/mysqladmin: connect to server at 'darkvador' failed
error: 'Can't connect to MySQL server on 'darkvador' (111)'
Check that mysqld is running on darkvador and that the port is 3306.
You can check this by doing 'telnet darkvador 3306'

So, i make : telnet darkvador 3306
darkvador:/usr/bin# telnet darkvador 3306
Trying 192.168.0.1...
telnet: Unable to connect to remote host: Connection refused

I don't understand this problem. I've never had this problem.

thank you

NB : Sorry for my english !

>How-To-Repeat:
allways
>Fix:
no solution

>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.52 (Source distribution)

>Environment:

System: Linux darkvador 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i586 unknown
Architecture: i586

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.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 jan 16 13:08 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1145456 sep 18 04:50 /lib/libc-2.2.5.so
-rw-r--r--1 root root  2376426 sep 18 04:51 /usr/lib/libc.a
-rw-r--r--1 root root  178 sep 18 04:51 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin 
--datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql 
--includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man 
--enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb 
--enable-static --enable-shared --enable-local-infile --with-raid 
--enable-thread-safe-client --without-readline 
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql 
--without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all


-
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

3.23.54a - Solaris 9/gcc 2.95.3 compile problem

[Len Rose]

Has anyone run into this? I did a search on the web site
looking for information before posting, didn't see
anything..

 3.23.54a - Compiling with gcc 2.95.3, Solaris 9 sparc..



# snip
Making all in sql
make  all-recursive
Making all in share
source='sql_lex.cc' object='sql_lex.o' libtool=no \
depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \
depmode=gcc /bin/bash ../depcomp \
g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/opt/local\""  -DDATADIR="\"/var/data\""  
-DSHAREDIR="\"/opt/local/share/mysql\""  -DHAVE_CONFIG_H -I. -I. -I.. -I./../include  
-I./../regex  -I. -I../include -I.. -I. -O3 -DDBUG_OFF   -fno-implicit-templates 
-fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c -o sql_lex.o `test -f sql_lex.cc || echo 
'./'`sql_lex.cc
sql_lex.cc: In function `void lex_init()':
sql_lex.cc:85: `symbols' undeclared (first use this function)
sql_lex.cc:85: (Each undeclared identifier is reported only once
sql_lex.cc:85: for each function it appears in.)
sql_lex.cc:87: `sql_functions' undeclared (first use this function)
sql_lex.cc: In function `int find_keyword(LEX *, unsigned int, bool)':
sql_lex.cc:168: implicit declaration of function `int get_hash_symbol(...)'
sql_lex.cc:168: initialization to `SYMBOL *' from `int' lacks a cast
*** Error code 1
make: Fatal error: Command failed for target `sql_lex.o'
# snip

Thanks

Len


-
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

全国独家免费抢注. cn顶级域名！

[mike]

mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû£¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû. 

.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£


 Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾
 
  Email:  
  [EMAIL PROTECTED]
  [EMAIL PROTECTED]
  0574-63133687
  0574-87707034

ÇëÄúÌîºÃÒÔÏÂÐÅÏ¢:

ÓòÃûÃû³Æ£º.cn  *  
×¢²áÄêÊý£º  *  
ÓòÃûËùÓÐÕß((ÖÐÎÄ)£º  * 
ÓòÃûËùÓÐÕß((Ó¢ÎÄ)£º  * 
ÁªÏµÈË(ÖÐÎÄ)£º  * 
Ê¡·Ý(ÖÐÎÄ)£º   
³ÇÊÐ(ÖÐÎÄ)£º  * 
ͨÐŵØÖ·(ÖÐÎÄ)£º  *  
ͨÐŵØÖ·(Ó¢ÎÄ)£º   
µç»°£º  * £¨Çë¼ÓÇøºÅ£¡£©  
´«Õ棺  * £¨Çë¼ÓÇøºÅ£¡£©  
ÓÊÕþ±àÂ룺  * 
µç×ÓÐÅÏ䣺  * 








-
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 4.0.8 on solaris 8 problem

[Oliver Schlag]

Hy Ali,

> ld.so.1:bin/mysqld : fatal : libCstd.so.1 : open failed : No such file
> or Directory

if you're using a sparc machine then you need to install the following
patches, please do not change to order of the patches :

109147-09
108434-02
108435-10

You can obtain theese patches via http://sunsolve.sun.com.

Happy weekend
Oliver




-
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