Java wizzard complete
My site now contains a usable Java code wizard. Those familiar with the VB and VBScript versions on my site, simply change the applied language to 'Java' and it will spit out a work-alike. The java class that is generated can be used for applications, applets, jsp and chili!beans for Chilisoft ASP. url: http://www.pbc.ottawa.on.ca - 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: C API problem
Hi John,
I had faced a similar problem earlier, I solved it my instaling MySQL-devel package
and include the libmyclient library stored in /usr/lib (not in /usr/lib/mysql/)in the
compile command.
Best of Luck,
Shambhu.
- Original Message --
john1 <[EMAIL PROTECTED]> wrote:
To:[EMAIL PROTECTED]
From:john1 <[EMAIL PROTECTED]>
Date:Thu, 1 Mar 2001 23:03:11 +0800
Subject:C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [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
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.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: Select problem
On Fri, 2 Mar 2001, Nathan Clemons wrote:
>
> Can't you do something with SUM() to get the results, possibly in
> coordination with GROUP BY?
>
> --Nathan
>
Not to my knowledge/imagination. What are you going to group by? You want and
incremental grouping or better you want a dynamic calculation on a very specific
subset of the rows (0->current_row) while current_row inrcrements through the result.
This cannot be done in a query and probably not in SQL at all.
I can only imagine this as a loop in a higher level language (take your pick:
perl/php/C). I would start thinking of creating a temporary table with
Id,Month,Sum(sales) and from there getting the runnning sales (the Id would range from
1->12).
dummy_code follows:
for(curr_count=1;curr_count<=12;curr_count++){
pose_query("select curr_count,sum(sales_per_month) from temp_table where
id<=curr_count");
}
Maybe I'm too tired to see straight and the answer is looking at me straight in the
face but that was my $0.02 anyhow.
regards,
thalis
> On 2001.03.01 23:49:28 -0500 Thalis A. Kalfigopoulos wrote:
> > Now that I notice more closely the numbers, my answer was obviously wrong
> > with regard to the 3rd column :o)
> >
> > Very interesting question...but I doubt there is a SQL way to do that.
> > Looking fwd to what the rest will sugest.
> >
> > cheers,
> > thalis
> >
> >
> > On Fri, 2 Mar 2001, Richard Vibert wrote:
> >
> > > Hi,
> > > At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote:
> > > >On Fri, 2 Mar 2001, Richard Vibert wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I having trouble working out how to get a result set similar to the
> > > > > following where I select from a table with Date & Sales column.
> > > > >
> > > > > My specific question is can I have a column that accumulates
> > values, if so
> > > > > could I have some guidance on how to express this in a select
> > statement
> > > > please.
> > > > >
> > > > >
> > > > > +--+---+---+
> > > > > | Month| Sales | Cum Sales |
> > > > > +--+---+---+
> > > > > | Jan | 1000 | 1000 |
> > > > > | Feb | 1500 | 2500 |
> > > > > | Mar | 1200 | 3700 |
> > > > > | April| 1400 | 5100 |
> > > > > +--+---+---+
> > > > >
> > > > > Many thanks in advance.
> > > > >
> > > > > Richard
> > > >
> > > >I assume the query should be like:
> > > >
> > > >select MONTHNAME(date_col) as Month,count(sales_amount) as
> > > >Sales,sum(sales_amount) as Cum_sales from lala_table group by
> > > >MONTHNAME(date_col);
> > > >
> > > >regards,
> > > >thalis
> > >
> > > Thanks for your reply.
> > >
> > > This is not quite what I'm after. Count(sales) gives me the number of
> > sales
> > > transactions.
> > >
> > > The first two cols I write as monthname(date_col) as Month, sum(sales)
> > as Sales
> > >
> > > It's the next column that's got me. That needs to be a "Running total"
> > if
> > > you like.
> > >
> > > Richard
> > > ===
> > > Richard Vibert
> > > [EMAIL PROTECTED]
> > > Tatura Mitre10
> > > ===
> > >
> > >
> >
> >
> >
> > -
> > 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
> >
> --
> Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123
> Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr
> O | S | D | N,50 Nagog Park,Acton,MA01720
> http://www.osdn.com/ Open Source Development Network
> Nextel: 978-423-0165 [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
Work
öÅÌÁÀ ÷ÁÍ ÐÒÉÑÔÎÏÇÏ É ÕÓÐÅÛÎÏÇÏ ÄÎÑ!
üÔÏ ÚÁÒÁÂÏÔÏË ÂÅÚ ÏÔÒÙ×Á ÏÔ ÍÏÎÉÔÏÒÁ;-)
åÓÌÉ ÷Ù ÐÒÏÑ×ÉÔÅ ÎÅËÏÔÏÒÙÊ ÉÎÔÅÒÅÓ É ÔÅÒÐÅÎÉÅ (Á ÇÌÁ×ÎÏÅ, ÒÁÚÂÅÒÅÔÅÓØ, ËÁË
üôï ÒÁÂÏÔÁÅÔ), ÷Ù ÍÏÖÅÔÅ ÈÏÒÏÛÏ ÚÁÒÁÂÏÔÁÔØ (ÄÏ 50.000$ É ÂÏÌÅÅ!!!, ÜÔÏ ÚÁ×ÉÓÉÔ
ÔÏÌØËÏ ÏÔ ÷ÁÓ) × ÔÅÞÅÎÉÅ ÓÌÅÄÕÀÝÉÈ 90 ÄÎÅÊ. ëáöåôóñ îå÷ïúíïöîùí??
îÁÐÉÛÉÔÅ ÍÎÅ É Ñ ×ÙÛÌÀ ÷ÁÍ ÒÕËÏ×ÏÄÓÔ×Ï ÁÂÓÏÌÀÔÎÏ ÂÅÓÐÌÁÔÎÏ. åÓÌÉ ÷Ù ÐÏÌÎÙÊ ÌÅÎÔÑÊ
(ÐÒÏÛÕ ÐÒÏÝÅÎÉÅ ÚÁ ÐÒÅÄÐÏÌÏÖÅÎÉÅ!!!), ÔÏ ÜÔÏ ÎÅ ÄÌÑ ÷ÁÓ!!! ìÕÞÛÅ ÚÁÎÉÍÁÊÔÅÓØ ÓÅÒÆÉÎÇÏÍ
ÉÌÉ ËÌÉËÁÊÔÅ ÐÏ ÂÁÎÎÅÒÁÍ ÉÌÉ ÎÅ ÚÁÎÉÍÁÊÔÅÓØ ÎÉÞÅÍ.
ó Õ×ÁÖÅÎÉÅÍ, ÷ÉÔÁÌÉÊ.
!!!åÓÌÉ ÐÒÅÄÌÏÖÅÎÉÅ ÷ÁÓ ÎÉÞÅÍ ÎÅ ÚÁÉÎÔÅÒÅÓÏ×ÁÌÏ, ÐÒÉÎÏÛÕ Ó×ÏÉ ÉÚ×ÉÎÅÎÉÑ É ÎÅ
ÎÁÄÏ ÓÅÒÄÉÔØÓÑ ("ÓÐÁÍ" ÉÍÅÅÔ Ó×ÏÉ ÉÚÄÅÒÖËÉ, ÔÁË ÖÅ ËÁË ÒÁÄÉÏ É TV), ÎÏ ÎÅ
ÚÁÂÙ×ÁÊÔÅ, ÞÔÏ ÓËÁÚÁÌ ÐÅÒ×ÙÊ ÍÉÌÌÉÁÒÄÅÒ óûá üÎÄÒÀ ëÁÒÎÅÇÉ:
"ñ ÌÕÞÛÅ ÂÕÄÕ ÚÁÒÁÂÁÔÙ×ÁÔØ 1% × ÒÅÚÕÌØÔÁÔÅ ÕÓÉÌÉÊ 100 ÞÅÌÏ×ÅË, ÞÅÍ 100% ×
ÒÅÚÕÌØÔÁÔÅ Ó×ÏÉÈ ÓÏÂÓÔ×ÅÎÎÙÈ ÕÓÉÌÉÊ."
÷ÓÔÁÎØÔÅ ÎÁ ÐÕÔØ Ë ÆÉÎÁÎÓÏ×ÏÊ ÎÅÚÁ×ÉÓÉÍÏÓÔÉ É ó÷ïâïäå!!
îå ðòïðõóôéôå üôõ ÷ïúíïöîïóôø! - üôï îéþåçï îå óôïéô, ôáë
ðïþåíõ îå ðïðòïâï÷áôø?
E-mail: [EMAIL PROTECTED]
__
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=2053962
-
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
Work
öÅÌÁÀ ÷ÁÍ ÐÒÉÑÔÎÏÇÏ É ÕÓÐÅÛÎÏÇÏ ÄÎÑ!
üÔÏ ÚÁÒÁÂÏÔÏË ÂÅÚ ÏÔÒÙ×Á ÏÔ ÍÏÎÉÔÏÒÁ;-)
åÓÌÉ ÷Ù ÐÒÏÑ×ÉÔÅ ÎÅËÏÔÏÒÙÊ ÉÎÔÅÒÅÓ É ÔÅÒÐÅÎÉÅ (Á ÇÌÁ×ÎÏÅ, ÒÁÚÂÅÒÅÔÅÓØ, ËÁË
üôï ÒÁÂÏÔÁÅÔ), ÷Ù ÍÏÖÅÔÅ ÈÏÒÏÛÏ ÚÁÒÁÂÏÔÁÔØ (ÄÏ 50.000$ É ÂÏÌÅÅ!!!, ÜÔÏ ÚÁ×ÉÓÉÔ
ÔÏÌØËÏ ÏÔ ÷ÁÓ) × ÔÅÞÅÎÉÅ ÓÌÅÄÕÀÝÉÈ 90 ÄÎÅÊ. ëáöåôóñ îå÷ïúíïöîùí??
îÁÐÉÛÉÔÅ ÍÎÅ É Ñ ×ÙÛÌÀ ÷ÁÍ ÒÕËÏ×ÏÄÓÔ×Ï ÁÂÓÏÌÀÔÎÏ ÂÅÓÐÌÁÔÎÏ. åÓÌÉ ÷Ù ÐÏÌÎÙÊ ÌÅÎÔÑÊ
(ÐÒÏÛÕ ÐÒÏÝÅÎÉÅ ÚÁ ÐÒÅÄÐÏÌÏÖÅÎÉÅ!!!), ÔÏ ÜÔÏ ÎÅ ÄÌÑ ÷ÁÓ!!! ìÕÞÛÅ ÚÁÎÉÍÁÊÔÅÓØ ÓÅÒÆÉÎÇÏÍ
ÉÌÉ ËÌÉËÁÊÔÅ ÐÏ ÂÁÎÎÅÒÁÍ ÉÌÉ ÎÅ ÚÁÎÉÍÁÊÔÅÓØ ÎÉÞÅÍ.
ó Õ×ÁÖÅÎÉÅÍ, ÷ÉÔÁÌÉÊ.
!!!åÓÌÉ ÐÒÅÄÌÏÖÅÎÉÅ ÷ÁÓ ÎÉÞÅÍ ÎÅ ÚÁÉÎÔÅÒÅÓÏ×ÁÌÏ, ÐÒÉÎÏÛÕ Ó×ÏÉ ÉÚ×ÉÎÅÎÉÑ É ÎÅ
ÎÁÄÏ ÓÅÒÄÉÔØÓÑ ("ÓÐÁÍ" ÉÍÅÅÔ Ó×ÏÉ ÉÚÄÅÒÖËÉ, ÔÁË ÖÅ ËÁË ÒÁÄÉÏ É TV), ÎÏ ÎÅ
ÚÁÂÙ×ÁÊÔÅ, ÞÔÏ ÓËÁÚÁÌ ÐÅÒ×ÙÊ ÍÉÌÌÉÁÒÄÅÒ óûá üÎÄÒÀ ëÁÒÎÅÇÉ:
"ñ ÌÕÞÛÅ ÂÕÄÕ ÚÁÒÁÂÁÔÙ×ÁÔØ 1% × ÒÅÚÕÌØÔÁÔÅ ÕÓÉÌÉÊ 100 ÞÅÌÏ×ÅË, ÞÅÍ 100% ×
ÒÅÚÕÌØÔÁÔÅ Ó×ÏÉÈ ÓÏÂÓÔ×ÅÎÎÙÈ ÕÓÉÌÉÊ."
÷ÓÔÁÎØÔÅ ÎÁ ÐÕÔØ Ë ÆÉÎÁÎÓÏ×ÏÊ ÎÅÚÁ×ÉÓÉÍÏÓÔÉ É ó÷ïâïäå!!
îå ðòïðõóôéôå üôõ ÷ïúíïöîïóôø! - üôï îéþåçï îå óôïéô, ôáë
ðïþåíõ îå ðïðòïâï÷áôø?
E-mail: [EMAIL PROTECTED]
__
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=2053962
-
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 problem
Can't you do something with SUM() to get the results, possibly in coordination with GROUP BY? --Nathan On 2001.03.01 23:49:28 -0500 Thalis A. Kalfigopoulos wrote: > Now that I notice more closely the numbers, my answer was obviously wrong > with regard to the 3rd column :o) > > Very interesting question...but I doubt there is a SQL way to do that. > Looking fwd to what the rest will sugest. > > cheers, > thalis > > > On Fri, 2 Mar 2001, Richard Vibert wrote: > > > Hi, > > At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote: > > >On Fri, 2 Mar 2001, Richard Vibert wrote: > > > > > > > Hi, > > > > > > > > I having trouble working out how to get a result set similar to the > > > > following where I select from a table with Date & Sales column. > > > > > > > > My specific question is can I have a column that accumulates > values, if so > > > > could I have some guidance on how to express this in a select > statement > > > please. > > > > > > > > > > > > +--+---+---+ > > > > | Month| Sales | Cum Sales | > > > > +--+---+---+ > > > > | Jan | 1000 | 1000 | > > > > | Feb | 1500 | 2500 | > > > > | Mar | 1200 | 3700 | > > > > | April| 1400 | 5100 | > > > > +--+---+---+ > > > > > > > > Many thanks in advance. > > > > > > > > Richard > > > > > >I assume the query should be like: > > > > > >select MONTHNAME(date_col) as Month,count(sales_amount) as > > >Sales,sum(sales_amount) as Cum_sales from lala_table group by > > >MONTHNAME(date_col); > > > > > >regards, > > >thalis > > > > Thanks for your reply. > > > > This is not quite what I'm after. Count(sales) gives me the number of > sales > > transactions. > > > > The first two cols I write as monthname(date_col) as Month, sum(sales) > as Sales > > > > It's the next column that's got me. That needs to be a "Running total" > if > > you like. > > > > Richard > > === > > Richard Vibert > > [EMAIL PROTECTED] > > Tatura Mitre10 > > === > > > > > > > > - > 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 > -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [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: Select problem
Now that I notice more closely the numbers, my answer was obviously wrong with regard to the 3rd column :o) Very interesting question...but I doubt there is a SQL way to do that. Looking fwd to what the rest will sugest. cheers, thalis On Fri, 2 Mar 2001, Richard Vibert wrote: > Hi, > At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote: > >On Fri, 2 Mar 2001, Richard Vibert wrote: > > > > > Hi, > > > > > > I having trouble working out how to get a result set similar to the > > > following where I select from a table with Date & Sales column. > > > > > > My specific question is can I have a column that accumulates values, if so > > > could I have some guidance on how to express this in a select statement > > please. > > > > > > > > > +--+---+---+ > > > | Month| Sales | Cum Sales | > > > +--+---+---+ > > > | Jan | 1000 | 1000 | > > > | Feb | 1500 | 2500 | > > > | Mar | 1200 | 3700 | > > > | April| 1400 | 5100 | > > > +--+---+---+ > > > > > > Many thanks in advance. > > > > > > Richard > > > >I assume the query should be like: > > > >select MONTHNAME(date_col) as Month,count(sales_amount) as > >Sales,sum(sales_amount) as Cum_sales from lala_table group by > >MONTHNAME(date_col); > > > >regards, > >thalis > > Thanks for your reply. > > This is not quite what I'm after. Count(sales) gives me the number of sales > transactions. > > The first two cols I write as monthname(date_col) as Month, sum(sales) as Sales > > It's the next column that's got me. That needs to be a "Running total" if > you like. > > Richard > === > Richard Vibert > [EMAIL PROTECTED] > Tatura Mitre10 > === > > - 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 problem
Hi, At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote: >On Fri, 2 Mar 2001, Richard Vibert wrote: > > > Hi, > > > > I having trouble working out how to get a result set similar to the > > following where I select from a table with Date & Sales column. > > > > My specific question is can I have a column that accumulates values, if so > > could I have some guidance on how to express this in a select statement > please. > > > > > > +--+---+---+ > > | Month| Sales | Cum Sales | > > +--+---+---+ > > | Jan | 1000 | 1000 | > > | Feb | 1500 | 2500 | > > | Mar | 1200 | 3700 | > > | April| 1400 | 5100 | > > +--+---+---+ > > > > Many thanks in advance. > > > > Richard > >I assume the query should be like: > >select MONTHNAME(date_col) as Month,count(sales_amount) as >Sales,sum(sales_amount) as Cum_sales from lala_table group by >MONTHNAME(date_col); > >regards, >thalis Thanks for your reply. This is not quite what I'm after. Count(sales) gives me the number of sales transactions. The first two cols I write as monthname(date_col) as Month, sum(sales) as Sales It's the next column that's got me. That needs to be a "Running total" if you like. Richard === Richard Vibert [EMAIL PROTECTED] Tatura Mitre10 === - 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
Aborted connection error on RedHat 7
Hello there. I'm writing these lines because I'm having a weird problem with mySQL 3.23.33 (also with 3.23.32) on servers running RedHat 7.0. Each time that I run my SQL based applications, I start getting the following errors on mySQL: 010302 0:45:59 Aborted connection 10207 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:04 Aborted connection 10216 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:10 Aborted connection 10227 to db: 'db201' user: 'visual' host: `sql1' (Got an error reading communication packets) 010302 0:46:10 Aborted connection 10225 to db: 'db200' user: 'visual' host: `sql1' (Got an error reading communication packets) I get the above error messages like four times per minute. I'm having this problem on three different servers all of them running RedHat 7.0. I tried using the precompiled mySQL version, but I got the same error. I also tried downgrading gcc 2.96 to gcc 2.95 and recompiling mySQL, but the problem was still there. Do you have any ideas of what is causing this? Perhaps it is a bug on the RedHat libraries? Any help would be appreciated. Thank you! Regards, Daniel Fritzler - 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: Aphace and MySql
- Original Message - From: "Jim Ray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 02, 2001 10:46 AM Subject: Aphace and MySql > Will MySQL work with Aphace for windows? > > Thank you > > Jim Ray > Work perfectly here. Now I'm using Apache 1.3 + MySQL 3.23 + PHP4 + Windows 98 - 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 problem
On Fri, 2 Mar 2001, Richard Vibert wrote: > Hi, > > I having trouble working out how to get a result set similar to the > following where I select from a table with Date & Sales column. > > My specific question is can I have a column that accumulates values, if so > could I have some guidance on how to express this in a select statement please. > > > +--+---+---+ > | Month| Sales | Cum Sales | > +--+---+---+ > | Jan | 1000 | 1000 | > | Feb | 1500 | 2500 | > | Mar | 1200 | 3700 | > | April| 1400 | 5100 | > +--+---+---+ > > Many thanks in advance. > > Richard I assume the query should be like: select MONTHNAME(date_col) as Month,count(sales_amount) as Sales,sum(sales_amount) as Cum_sales from lala_table group by MONTHNAME(date_col); regards, thalis - 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
Aphace and MySql
Will MySQL work with Aphace for windows? Thank you Jim Ray - 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: more date problems
Quentin, Thanks for all your help! I ran isamchk for the third time, and finally it pooped out the errors I needed. I was able to repair, but I unfortunately lost all of the data from today. I'm guessing when the server crashed yesterday, it left MySQL hanging, and thus caused the problem. Since I didn't use the update_log, all data from today is gone. Live and learn. Thanks for all your help! -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 5:58 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems mysql> select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' Indicates a problem with the table structure; the result would be +--+ | count(*) | +--+ |0 | +--+ If there was a problem with the data. I suggest reviewing the isamchk results, and I'll leave it to the MySQL guys to interpret the error further. Good Luck Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 4:33 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Ok, here goes... mysql> select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ This tells me that there are about 400 people that have signed up TODAY. The date is correct on the server: mysql> select now(); +-+ | now() | +-+ | 2001-03-01 19:33:05 | +-+ So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql> select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' I have checked the tables using the checking utility, they show up fine. What's going on? =) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:45 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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]>
RE: more date problems
Why can't you do something along the lines of: select count(*) from pollResults where dayofyear(now()) = dayofyear(dateEntered) and year(dateEntered) = 2001; -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 5:51 PM To: Daren Cotter Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: more date problems On Thu, 1 Mar 2001, Daren Cotter wrote: > Ok, here goes... > > mysql> select member_id, signup_date from members order by member_id desc > limit 410; > +---+-+ > | member_id | signup_date | > +---+-+ > (here's the last 20 or so rows) > | 0120472 | 2001-03-01 | > | 0120471 | 2001-03-01 | > | 0120470 | 2001-03-01 | > | 0120469 | 2001-03-01 | > | 0120468 | 2001-03-01 | > | 0120467 | 2001-03-01 | > | 0120466 | 2001-03-01 | > | 0120465 | 2001-02-28 | > | 0120464 | 2001-02-28 | > | 0120463 | 2001-02-28 | > | 0120462 | 2001-02-28 | > | 0120461 | 2001-02-28 | > | 0120460 | 2001-02-28 | > | 0120459 | 2001-02-28 | > | 0120458 | 2001-02-28 | > +---+-+ Sorry if I've missed earlier threads about this, but what type is the signup_date field? AFAIK, datetime fields should show show the full date (and time) even though you don't insert it. So it should be '2001-03-01 00:00:00' or whatever NOW() inserts, if thats what you use :) Atle - 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
Select problem
Hi, I having trouble working out how to get a result set similar to the following where I select from a table with Date & Sales column. My specific question is can I have a column that accumulates values, if so could I have some guidance on how to express this in a select statement please. +--+---+---+ | Month| Sales | Cum Sales | +--+---+---+ | Jan | 1000 | 1000 | | Feb | 1500 | 2500 | | Mar | 1200 | 3700 | | April| 1400 | 5100 | +--+---+---+ Many thanks in advance. Richard === Richard Vibert [EMAIL PROTECTED] Tatura Mitre10 === - 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: more date problems
mysql> select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' Indicates a problem with the table structure; the result would be +--+ | count(*) | +--+ |0 | +--+ If there was a problem with the data. I suggest reviewing the isamchk results, and I'll leave it to the MySQL guys to interpret the error further. Good Luck Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 4:33 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Ok, here goes... mysql> select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ This tells me that there are about 400 people that have signed up TODAY. The date is correct on the server: mysql> select now(); +-+ | now() | +-+ | 2001-03-01 19:33:05 | +-+ So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql> select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' I have checked the tables using the checking utility, they show up fine. What's going on? =) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:45 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipien
Re: more date problems
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" <[EMAIL PROTECTED]> wrote: >>So, the question is, why does this not return 400, like it should??? >> >>OK, weird! Now I am getting this error... >> >>mysql> select count(*) from members where signup_date = '2001-03-01'; >>ERROR 1032: Can't find record in 'members' have you tried mysql> select count(*) from members where signup_date = CURDATE(); assuming the signup_date is in the -MM-DD format. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to make install mysql with DB-3.2.9a
Hello, I have mysql-3.23.33 installed, when trying to add BDB support using db-3.23.33 I get the message below after doing "make install" from /usr/src/mysql-3.23.33. Note: I had no problem with "make" or "configure" and I did follow all installation steps explained on www.mysql.com website. . . . . . . Making install in client make[1]: Entering directory `/usr/src/mysql-3.23.33/client' make[2]: Entering directory `/usr/src/mysql-3.23.33/client' /bin/sh ../mkinstalldirs /usr/local/mysql/bin /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysql /usr/local/mysql/bin/mysql /usr/bin/ginstall -c mysql /usr/local/mysql/bin/mysql /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqladmin /usr/local/mysql/bin/mysqladmin /usr/bin/ginstall -c mysqladmin /usr/local/mysql/bin/mysqladmin /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqlshow /usr/local/mysql/bin/mysqlshow /usr/bin/ginstall -c mysqlshow /usr/local/mysql/bin/mysqlshow /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqldump /usr/local/mysql/bin/mysqldump /usr/bin/ginstall -c mysqldump /usr/local/mysql/bin/mysqldump /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqlimport /usr/local/mysql/bin/mysqlimport /usr/bin/ginstall -c mysqlimport /usr/local/mysql/bin/mysqlimport /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqltest /usr/local/mysql/bin/mysqltest /usr/bin/ginstall -c mysqltest /usr/local/mysql/bin/mysqltest make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/usr/src/mysql-3.23.33/client' make[1]: Leaving directory `/usr/src/mysql-3.23.33/client' Making install in ./db-3.2.9a/build_unix make[1]: Entering directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' install_include install_lib install_utilities install_docs make[1]: install_include: Command not found make[1]: *** [install] Error 127 make[1]: Leaving directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' make: *** [install-recursive] Error 1 Anyone knows how to solve this problem? Regards, Boulat Khakimov. - 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: more date problems
On Thu, 1 Mar 2001, Daren Cotter wrote: > Ok, here goes... > > mysql> select member_id, signup_date from members order by member_id desc > limit 410; > +---+-+ > | member_id | signup_date | > +---+-+ > (here's the last 20 or so rows) > | 0120472 | 2001-03-01 | > | 0120471 | 2001-03-01 | > | 0120470 | 2001-03-01 | > | 0120469 | 2001-03-01 | > | 0120468 | 2001-03-01 | > | 0120467 | 2001-03-01 | > | 0120466 | 2001-03-01 | > | 0120465 | 2001-02-28 | > | 0120464 | 2001-02-28 | > | 0120463 | 2001-02-28 | > | 0120462 | 2001-02-28 | > | 0120461 | 2001-02-28 | > | 0120460 | 2001-02-28 | > | 0120459 | 2001-02-28 | > | 0120458 | 2001-02-28 | > +---+-+ Sorry if I've missed earlier threads about this, but what type is the signup_date field? AFAIK, datetime fields should show show the full date (and time) even though you don't insert it. So it should be '2001-03-01 00:00:00' or whatever NOW() inserts, if thats what you use :) Atle - 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: MyODBC
> Ok, I am new in the IT world, and I just want to set up a mySql server. > I installed mySql on the WinNt server (on the lan in my office) with > mysqladmin running, and i installed myODBC on my win98 computer, with > settings that would match the server. > How can i test if this is working without making an application? > do i need myODBC installed on teh server as well?? If you have defined the data source withing the ODBC administrator then you should be able to use MQuery (part of MS OFFICE) if you have it. Regards Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989 - 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
date troubles
I should note, however, that this query works FINE: mysql> select count(*) from members where signup_date = '2001-02-28'; +--+ | count(*) | +--+ | 732 | +--+ This APPEARS to work, but the "127" should be more like 420 mysql> select count(*) from members where signup_date > '2001-02-28'; +--+ | count(*) | +--+ | 127 | +--+ As opposed to before, when I got an error doing the following query, it now works, but does not return the correct value. I shut-down and restart the server, which is why I'm guessing I no longer get the error: mysql> select count(*) from members where signup_date = now(); +--+ | count(*) | +--+ | 127 | +--+ Could this have anything to do with mysql caching this query somehow? I don't see how it works for one date, and not the others? - 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: BDB tables crashing mysql 3.23.33
On Thursday 01 March 2001 13:32, Quentin Bennett wrote: > > >After the patch, MySQL still passes our test suite, which is a good sign. > > > >But how come it passed the test suite with the bug in place ?? ;-) It does not any more, with the bug not fixed, that is. We update the test suite every time we find a new bug. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - 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: more date problems
Ok, here goes... mysql> select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ This tells me that there are about 400 people that have signed up TODAY. The date is correct on the server: mysql> select now(); +-+ | now() | +-+ | 2001-03-01 19:33:05 | +-+ So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql> select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' I have checked the tables using the checking utility, they show up fine. What's going on? =) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:45 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: MyODBC
I'm just setting this up myself and there is a program called admndemo (or something like that) that comes with myodbc that will allow you to check if things are working or not without having to create a program. - Original Message - From: "Katelyn Sweet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 02, 2001 0:53 Subject: MyODBC > Ok, I am new in the IT world, and I just want to set up a mySql server. > I installed mySql on the WinNt server (on the lan in my office) with > mysqladmin running, and i installed myODBC on my win98 computer, with > settings that would match the server. > How can i test if this is working without making an application? > do i need myODBC installed on teh server as well?? > HELP!!! > kate > > > - > 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: more date problems
Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: PHP and MySQL
> Hi, > > I've installed MYSQL on Red hat. > > I'm trying to run the command > > mysqlaccess > > It asks for the Password for MySQL superuser root: > Can anyone tell me the password for this? > > > Thanks > Sandeep mysqlaccess is a perl script to check the access priviliges of a user:db:host scenario. What you need is to run safe_mysql to get the daemon running and then mysql (which will not ask for a pass the 1st time) and set a password for root by yourself. best of luck, thalis p.s. alternatively to the above: read the first ~500 lines from the mysql manual - 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: more date problems
Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: more date problems
Hi, Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: PHP and MySQL
Hi, I've installed MYSQL on Red hat. I'm trying to run the command mysqlaccess It asks for the Password for MySQL superuser root: Can anyone tell me the password for this? Thanks Sandeep - 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: Problem compiling mysql on FreeBSD
Hi All, Does anyone have any ideas on this one? Could I maybe try to install a newer version of whatever package installs libstdc++? Anyone know what package installs this file? Thanks for the help, Shawn - Original Message - From: Shawn Heeley <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 11:56 PM Subject: Re: Problem compiling mysql on FreeBSD > Hi Bill and All, > > Thanks for the suggestions. Here's what I've tried: > > Installed gmake and gcc. My pkg_info looks like the following (I've cut out > the irrelevant ones): > bash-2.03 The GNU Borne Again Shell > gcc-2.95.3.test3GNU compiler suite > gettext-0.10.35 GNU gettext package > glib-1.2.7 Some useful routines of C programming > gmake-3.79.1GNU version of 'make' utility > gtk-1.2.7 General Toolkit for X11 GUI > gtk-engines-0.10Theme engine for gtk+ toolkits > libtool-1.3.3 Generic shared library support script > mysql-client-3.23.33 Multithreaded SQL database (client) > mysql-server-3.23.33 Multithreaded SQL database (server) > qt-1.45 A C++ X GUI toolkit > > After installing the only version of gcc I could fine 2.95.3(?), both > methods below produced exactly the same error. BTW, in order to install > gcc, I had to install gmake. The error message I'm getting is usually, in my > limited experience, due to the version of libstdc++.so on my system not > being the same version of libstdc++ that mysql was compiled/linked with. > Does anyone know the version that mysql was compiled with and if so, how do > I check what version I currently have? > > Thanks all for the help, > Shawn > > - Original Message - > From: Bill Swanson <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; Shawn Heeley <[EMAIL PROTECTED]> > Sent: Wednesday, February 28, 2001 8:05 AM > Subject: Re: Problem compiling mysql on FreeBSD > > > > Try upgrading to gcc 2.95.2. That should fix the problem. > > This cured my 'Installation of grant tables failed' error > > condition. > > > > Rgds, Bill Swanson > > DNA Enterprises, Inc. > > MIS Manager > > 972-671-1972 > > email: [EMAIL PROTECTED] > > > > > > > > -- Original Message -- > > From: "Shawn Heeley" <[EMAIL PROTECTED]> > > Date: Tue, 27 Feb 2001 23:07:01 -0500 > > > > >Hi folks, > > > > > >This appears to be a common problem that I can't seem to find a > > solution. > > >No matter which approach I take to trying to install mysql- > > server, the end > > >result is the same. It doesn't work. I apologize for the long > > message. > > >Thanks for the help. > > > > > >System Specs > > >FreeBSD www.machine.com 4.0-RELEASE FreeBSD 4.0-RELEASE #0: Mon > > Mar 20 > > >22:50:22 GMT 2000 > > >libtool -> libtool-1.3.3 > > >mysql-client-> mysql-client-3.23.33 > > > > > >I've tried two different approaches for installation. > > > > > >Source Installation > > >pkg_add ./mysql-server-3.23.33.tgz > > > > > >Result: > > >machine# pkg_add ./mysql-server-3.23.33.tgz > > >Preparing db table > > >Preparing host table > > >Preparing user table > > >Preparing func table > > >Preparing tables_priv table > > >Preparing columns_priv table > > >Installing all prepared tables > > >/usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined > > symbol > > >"__ti9exception" > > >Installation of grant tables failed! > > >> > >pkg_add: command '/usr/local/bin/mysql_install_db' failed > > >mysql:*:88: > > >You already have a group "mysql", so I will use it. > > >mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin > > >You already have a user "mysql", so I will use it. > > >Changed home directory of "mysql" to "/var/db/mysql" > > > > > >Running the mysqld command above produces the following message: > > >machine# /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: > > Undefined symbol > > >"__ti9exception" > > > > > >Using the Ports method: > > >cd /usr/ports/databases/mysql322-server;make install > > > > > >Result: > > >===> Patching for mysql-server-3.22.32 > > >===> Applying FreeBSD patches for mysql-server-3.22.32 > > >Ignoring previously applied (or reversed) patch. > > >3 out of 3 hunks ignored--saving rejects to > > scripts/mysql_install_db.sh.rej > > >*** Error code 3 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > >*** Error code 1 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > >*** Error code 1 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > >*** Error code 1 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > >*** Error code 1 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > >*** Error code 1 > > > > > >Stop in /usr/ports/databases/mysql322-server. > > > > > > > > > > > >-- > > --- > > >Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > >To request
more date problems
okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart 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
ERROR 1030: Got error -1 from table handler
Getting the above error message on one of our servers using mySQL. Went to go and set up WebCalender on it and tracked an issue down to mySQL. If I execute the query of: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231; It works fine and I get results back. However, if I add a simple ORDER BY, as in: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231 ORDER BY webcal_entry.cal_time; Then I get "ERROR 1030: Got error -1 from table handler" returned back to me. I've shut down mysql (made sure no active processes left) and run isamchk -r on the ISM files. This was the output: # isamchk -r *.ISM - recovering ISAM-table 'webcal_entry.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_repeats.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_user.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_user.ISM' Data records: 2 - Fixing index 1 - - recovering ISAM-table 'webcal_user_layers.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_user_pref.ISM' Data records: 12 - Fixing index 1 # This did nothing to affect the problem. Some helpful info about the system: # mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) # rpm -qa | grep -i mysql MySQL-3.22.32-1 mysqlgui-static-1.7.1-1 MySQL-client-3.22.32-1 MySQL-devel-3.22.32-1 MySQL-shared-3.22.32-1 # uname -a Linux 2.2.14-5.0.14smp #2 Fri Jun 30 16:25:11 EDT 2000 i686 unknown # Any help appreciated. -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [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: PHP and MySQL
I had the same problem. Ensure the permissions for /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
-Original Message-
From: Ben Kennish [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:56 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine .
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
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: weird date behavior
When you specify now it is giving a date and a time. So if you do your query it may be checking the date and time in the signup_date field and if it doesn't find a time it just matches the date. What I would do if you want results for the day and not the exact time is to change the query so that it only tries to match the day/month/year w/out the timestamp. I noticed some similar things in Microsoft SQL but haven't worked w/ MySQL enough to know that this is the case. So this is all theory. Aaron Weiker -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:39 PM To: [EMAIL PROTECTED] Subject: weird date behavior I have a field in my table that stores the date a member has signed up...i run a query using distinct to show me how many members signup each day. Yesterday, our server crashed, and today i am seeing weird behavior with mysql: SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108984 INSERT INTO members (blah blah) VALUES (blah blah); SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108985 The total count is incremented, but not for today's date. Anyone have any ideas? - 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: MyODBC for Windows ME
I have used it on a Win98 systems to access a MySQL DB on a Linux server. I found it highly unreliable. I would get a whole record entered before, as often as not, it would get kicked back with an error message, saying it could not save the (new) record, because someone else was accessing that record it at the time (no-one else was even so-much-as accessing webpages). Did I want to save the record to the clipboard? That was no help, as once we had an error on a record, It could not be re-entered until I accessed the DB by telnet and deleted the problem record. When we upgraded from Redhat 6.1 to 7, we were able to get PHP working, allowing us to use PhpMyAdmin. So far, that solution has been problem-free. On 28 Feb 2001, at 22:57, genge1 wrote: > Has anyone installed MyODBC under Windows ME? > Did you use the Win95 or NT version? > I don't have the OS, still on Win95 and 98, but I have a client who > wants to install the driver. > > Thanks in advance. > > Greg Engel > > > - > 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 > John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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: BDB tables crashing mysql 3.23.33
After the patch, MySQL still passes our test suite, which is a good sign. But how come it passed the test suite with the bug in place ?? ;-) Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Alter Table Process
Hi, Would ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol); do this in one sweep of the table, creating one temporary copy, or go through the table twice, one for each index? Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
weird date behavior
I have a field in my table that stores the date a member has signed up...i run a query using distinct to show me how many members signup each day. Yesterday, our server crashed, and today i am seeing weird behavior with mysql: SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108984 INSERT INTO members (blah blah) VALUES (blah blah); SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108985 The total count is incremented, but not for today's date. Anyone have any ideas? - 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: Problen in mysql 'read only'
> Did you change the permissions of the files after starting > the sever, or before? > > Did you read the GRANT section of the manual. > Does your user have the UPDATE privilege? > > > Raman Aggarwal wrote: > > > > Dear Sir > > > > I am a regular user of MySql. I will be obliged if you help me. > > > > 1. The path of the data directory is > > /var/lib/mysql > > 2. The database name is 'directory' > > 3. The permissions of directory are > > drwxrwxrwx2 root root 4096 Mar 1 16:24 directory > > 4. All the files in the directory are having the permissions > > -rw-rw-rw-2 root root > > > > Now when I want to insert the data error message appears that the table is read >only. error 1036. > > > > I tried all combination of permissions but no result. > > > > Mysql version is 3.22.25 > > > > Raman IMHO I don't think Mysql should be restarted after changing the permissions of the files at the OS level. Does MySQL cache the permissions too[?] Anyway, perror gave me: $ perror 1036 Error code 1036: Unknown error 1036 Are you sure you are giving the error code correct here? regards, thalis - 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: Win 2000 Not starting
I'd love to here an answer to this one too. Exact same scenario.. exact same problem. --- "Lucy" <[EMAIL PROTECTED]> > wrote: >Hi >1. I'm working in Windows 2000, intending to run MySQL to localhost on same >laptop. >2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 >places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I >unzipped binary directly to d: > >3. None of these have worked: >d:\mysql\bin\mysqld --debug >d:\mysql\bin\mysqld --standalone --debug >d:\mysql\bin\mysqld --standalone >d:\mysql\bin\mysqld --basedir d:\mysql >d:\mysql\bin\mysqld --skip-grant-tables --debug >d:\mysql\bin\mysqld --skip-grant-tables >d:\mysql\bin\mysqld-nt --standalone --debug >d:\mysql\bin\mysqld-nt --standalone > >I was shutting down via Task Manager but have repeated by shutting down the >laptop aswell. >All cases, everything just hangs, nothing happens. > >4. As per Manual, this command: >d:\mysql\bin\mysqld > >produced a mysql.err file which states "REady for connections" >and it came back to the prompt d:> >I thought this might have started the server up, so I then tried d:>mysql >but it didn't recognise this. >I tried >d:\mysql\bin\mysqlshow >but it came back with error message, "Can't connect to MySQL server on >'localhost'. Check that it's running. > >5. I particularly didn't want to use the mysqld-nt install option because I >don't want the bother of installing as a service with >users/passwords, this is just development work, Windows defaults of being >available for all users is fine. > Also the Manual states the option file my.cnf is supported by program >"mysqld", implicitly it therefore does not support programs "mysql-nt", >"mysql-opt". As I've changed default location, I need the option file I >believe. >Anyone any ideas? Cheers, Lucy > > >- >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 == %-- 8-P ---% % "Yeah, I have a life.. sure umm.. % %somewhere.. where did I leave that% %thing??" % % % % Robert Wahl <[EMAIL PROTECTED]> % % n00b for life % %--% _ Visit Stomped.com for your daily dose of news for gamers - And get free e-mail too! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Search engine stuff.... help!
Hey guys, I've got a question regarding a search engine I have to write
Basically what I have is this.. This is for a web page BTW.
I have a table with a TEXT field in it. I'd like to take that field
and search for keywords... I've got a mySQL database and this is how I'm
doing it...
SELECT a FROM b,c WHERE(b.serializedarray LIKE CONCAT('%', c.keywords,'%'));
Where b is the table containing the serialized data and c is a single column
HEAP table with the list of keywords...
Now... My question is kind of two fold...
A) Is this the best way to do it? The query is much more complex (there are
5 separate 'lists' that I am comparing the text field to.
and - thiis is my real question
B) How do I show limited page results? I want to break up the results into
groups of 5 per page and have x pages (count % 5). My problem is that the
origional query gets lost once the page has returned the first set of
results and I have no real way of keeping them... There can be too many to
append to the of the link to the next page and I don't want to use
form POSTS since I have to have buttons for all of them
Any suggestions from a mysql point of view? This is using PHP BTW
John Coggeshall
[EMAIL PROTECTED]
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Read my Biweekly Column on O'Reilly's ONLamp.com "PHP Foundations" and my
weekly Zend.com Code Gallery Column "In The Spotlight" Also be sure to visit
www.coggeshall.org!
-
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: Can't find mysqladmin
Did you also install the mysql client rpm? "K.K" wrote: > > Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I > actually upgraded mysql to the newest version and everything went fine and > it verified after the installation was done. > > The problem that I have is that I cannot log into mysql now. I have tried > to located mysqladmin anywhere on the server and it seems to be missing and > I cannot log into MYSQL. However when I do a ps -ef I can see that > safe_mysqld is running along with the three other processes. > > Any clues on how to log in would be appreciated > > (It has just been one of those days) > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.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: [Q] DBI connect with MySQL
Your Apache must be configured to support perl cgi scripts.
Is it?
What is in the Apache error log?
[EMAIL PROTECTED] wrote:
>
> Hi,gurus,
> I am a novice at MySQL. When I try to run a sample program in the book of
> "MySQL & mSQL" I get a error message from my apache server as follows,
> *
> Internal Server Error
> The server encountered an internal error or misconfiguration and was unable to
>complete your request.
>
> Please contact the server administrator, [EMAIL PROTECTED] and inform them of
>the time the error occurred, and anything you might have done that may have caused
>the error.
>
> More information about this error may be available in the server error log.
> *
>
> The sample program is
>
> #!/usr/bin/perl -w
>
> use strict;
> use CGI qw(:standard);
> use CGI::Carp;
> use DBI;
> CGI::use_named_parameters(1);
>
> my ($db);
> my $output = new CGI;
>
> $db = param('test') or die("Could not find database!");
> my $dbh = DBI->connect("DBI:mysql:$db:$server",root,passward );
>
> if (not $dbh) {
> print header, start_html('title'=>"Information on $host => $db",
> 'BGCOLOR'=>'white');
>
> print < $host
> $db
> For the following reasons the connection failed.
> $DBI::errstr
>
> END_OF_HTML
> exit(0);
> }
>
> print header, start_html('title'=>"Information on $host => $db",
> 'BGCOLOR'=>'white');
> print < $host
> $db
>
> Tables
>
> END_OF_HTML
>
> my @tables = $dbh->func( '_ListTables' );
> foreach (@tables) {
> print "$_\n";
> }
> print <
>
> END_OF_HTML
>exit(0);
>
>
> Could someone tell me what is wrong? Thanks a lot.
>
> Regards,
>
> --Wen
> [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: BDB tables crashing mysql 3.23.33
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I decided to drop the offending
>database, and re-create it. No problem so far. Right after
>I run the offending queries (see below), mysqld dies. Any subsequent
>connection attempt to mysqld hangs, and the server is basically
>dead (requiring a killall -9 mysqld). There is a file called
>log.01 that appeared, as well as an error message (see below).
>
>I can replicate this error quite easily, as it happens each time the
>query
>is run.
>
>
>CREATE TABLE tblCharge (
> ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
> ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
> ChargeDate date DEFAULT '-00-00' NOT NULL,
> ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
> FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
>DEFAULT 'New' NOT NULL,
> ChargeAuthorizationMessage text,
> ChargeComment text,
> ChargeTimeStamp varchar(20),
> PRIMARY KEY (ChargeID),
> KEY ServiceID (ServiceID),
> KEY ChargeDate (ChargeDate)
>) type=BDB;
>
>
>
>Query #1:
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>COMMIT;
>
>Query #2
>BEGIN;
>UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
>ChargeID = 1;
>COMMIT;
>
>Query #3
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>
>
I do have a patch for it now. From what I understood in the code, this is
actually a more correct way to do things, but I would like to get Monty's
approval to be sure. After the patch, MySQL still passes our test suite,
which is a good sign. So if you are in dire straits, go ahead and apply it,
otherwise, wait until 3.23.34 - if there is something wrong with the current
fix, it will be corrected by then. Here it is:
--- 1.33/sql/field.cc Wed Feb 7 19:43:54 2001
+++ 1.34/sql/field.cc Thu Mar 1 11:49:05 2001
@@ -4075,8 +4075,8 @@
const char *Field_blob::unpack(char *to, const char *from)
{
memcpy(to,from,packlength);
+ ulong length=get_length(from);
from+=packlength;
- ulong length=get_length();
if (length)
memcpy_fixed(to+packlength, &from, sizeof(from));
else
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
-
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: Antwort: PHP and MySQL - Specifying location for mysql.sock
Ben Kennish wrote: > > HOORAY! It's finally working. > > However, I'd prefer to have my mysql.sock socket file in /tmp/ > > Anyone know how to change the settings for MySQL (and also PHP4 and > phpMyAdmin) so that it looks in /tmp/ instead? > > Cheers. > > Ben > > Rick Emery wrote: > > > > I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have > > permissions set to: drwxr-xr-x > > > > This cured the problem for me. > > > > rick > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 01, 2001 6:19 AM > > To: Ben Kennish > > Cc: [EMAIL PROTECTED] > > Subject: Antwort: PHP and MySQL > > > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > > through socket '/var/lib/mysql/mysql.sock' (111) in > > > /var/www/html/index.php on line 5" > > > > Are you sure that your MySQL installation creates the socket right there? > > If > > I'm not mistaken, it may be created in /tmp. > > > > - > > 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 > > > > - If you are running Red Hat Linux, you don't want the socket in /tmp. The nightly cleanup daemon will delete it eventually. You can tell mysqld and mysql wher the socket is by including entries in /etc/my.cnf ( See the manual) For PHP, you can probably put it in your connect routine. > > 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 > > -- > Ben Kennish > > Software Developer > Fubra Limited > > web | www.fubra.net > email | [EMAIL PROTECTED] > phone | +44 (0)870 1222 600 > fax | +44 (0)870 1222 699 > > - > 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
Index Question
My question is about indexes...basically, I'm wondering how many indexes is too much, and what the drawbacks are of having more indexes on a table? I'm guessing INSERT and UPDATE queries probably take longer? My table has the following fields: member_id, first_name, last_name, username, password, email, street1, street2, city, state, zip, country_id, signup_date, signup_ip, ref_id, sex, age, income I know for sure I will want to index the username and email fields. However, should I index the entire field, or would 5 or 6 characters be enough to index? I will also be selecting BY country_id, signup_date, and ref_id as well, is it okay to index all of them? I will also be using the signup_ip field to delete duplicate accounts, should I therefore index that field so the "distinct" operator works better? Is it okay to have 6 indexes on a table like this? The table may have upwards of a million entries. TIA! - 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: [Q] DBI connect with MySQL(SOLVED)
Okay, I get it. The problem comes from the statement below,
wen> $db = param('test') or die("Could not find database!");
After I revised it to "my $db = "test" or die("Could not find database!");"
I get expected result.
Thanks for your consideration.
Regards,
--Wen
[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: Why Heap Tables doesn´t support auto increment colums
On Thu, Mar 01, 2001 at 11:47:41AM -0500, Joe Kislo wrote: > > I´m currently working on system for Managing http Session and would like > > to use a heap table for storing the session information. Session > > information is only of temporary intrest. But still I need an unique > > ID for reference with some other Tabels storing dtaa for the session. > > All these tables are Heap tables. So there is no Probelem if the ID > > generated by the auto_increment column is not unique when the Database > > server is restarted. > > There's a couple problems with that to begin with. First, you're > storing state in a HEAP table. If the mysql server gets reset, all the > sessions are lost. It would be tough to think you want to write your > system so your database server cannot ever be restarted, especially when > writing the data to a MyISAM table would probably be at a trivial loss > of speed. Read my mail. The data I store is only of temporary intrest. So there is no Problem when they are lost during mysqlserver restart. > Also, if you used an auto_incrementing column, you would be > handing out sessionIDs sequentially. It would be trivial for somebody > to usurp somebody else's sessionID by simply subtracting or adding 1 to > their own. There is now way for an user to see the session ID. The Session ID is internaly handled and retrieved from the database every single request. Thats why I want to use Heap Tables to reduse overhead. The System is working perfektly. Solong Estartu -- Gerhard Schmidt mailto:[EMAIL PROTECTED] Softwaredevelopment adMaster network Tel.: +49 89 38356-334 Kaiserstraße 16 D-80801 München http://www.admasternetwork.net PGP signature
Re: Antwort: boolean type
> > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
> > closest to the boolean type
>
> ShortInt: 0 == FALSE, <> 0 == TRUE
> That's how I do it anyway.
>
> Or maybe combine multiple bool fields to one and use binary logic.
Or quoting from http://www.bitbybit.dk/mysqlfaq/faq.html
Q: create a column of type BOOLEAN?
MySQL does not have a boolean type per se. The usual way to create a boolean value, is
to use the ENUM type:
mysql> CREATE TABLE truths
-> (answer ENUM('true','false') NOT NULL);
(don't forget the NOT NULL clause, or you end up having not two, but three legal
values for the field.)
You can also use the following hack to define a field which can contain only one of
two values, namely the empty string ("") or NULL:
mysql> CREATE TABLE truths
-> (answer CHAR(0));
The special beauty of the second example is that the data in the field only occupies
one bit, as opposed to an ENUM field, which always occupies at least a byte. However,
you get to do quite a bit of encoding and decoding of these values on your front end...
regards,
thalis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compiling MySQL client programs under AIX 4.3
OK, I admit it, I'm stumped. I've done this before, but I've lost the script that used to do this. All I'm trying to do is build a simple MySQL client program under AIX 4.3 with gcc, and I can't seem to get the link libraries right (the worst part of porting!). Any help appreciated. I've done this before, I can't find the shell script that does it, and as I recall when I did this a year or so ago, it was a complete pain, because it was an obscure set of libraries, in an obscure order. Any help appreciated. /usr/local/bin/gcc -w -DDBUG_OFF -static -o xxx xxx.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lnsl -lm -lpthread -lpthreads -lpthreads_compat ld: 0711-317 ERROR: Undefined symbol: thread_unlock ld: 0711-317 ERROR: Undefined symbol: thread_waitact ld: 0711-317 ERROR: Undefined symbol: thread_setmystate_fast ld: 0711-317 ERROR: Undefined symbol: thread_tsleep ld: 0711-317 ERROR: Undefined symbol: thread_twakeup ld: 0711-317 ERROR: Undefined symbol: thread_setstate ld: 0711-317 ERROR: Undefined symbol: thread_terminate_ack ld: 0711-317 ERROR: Undefined symbol: thread_setmystate ld: 0711-317 ERROR: Undefined symbol: thread_tsleep_event ld: 0711-317 ERROR: Undefined symbol: thread_waitlock_local ld: 0711-317 ERROR: Undefined symbol: thread_waitlock ld: 0711-317 ERROR: Undefined symbol: thread_kill ld: 0711-317 ERROR: Undefined symbol: thread_twakeup_event ld: 0711-317 ERROR: Undefined symbol: thread_getregs ld: 0711-317 ERROR: Undefined symbol: thread_init ld: 0711-317 ERROR: Undefined symbol: thread_setstate_fast ld: 0711-317 ERROR: Undefined symbol: thread_terminate_unlock ld: 0711-317 ERROR: Undefined symbol: t_open ld: 0711-317 ERROR: Undefined symbol: t_getstate ld: 0711-317 ERROR: Undefined symbol: t_unbind ld: 0711-317 ERROR: Undefined symbol: t_sync ld: 0711-317 ERROR: Undefined symbol: t_close ld: 0711-317 ERROR: Undefined symbol: t_bind ld: 0711-317 ERROR: Undefined symbol: t_getinfo ld: 0711-317 ERROR: Undefined symbol: _terrno ld: 0711-317 ERROR: Undefined symbol: t_alloc ld: 0711-317 ERROR: Undefined symbol: t_connect ld: 0711-317 ERROR: Undefined symbol: t_rcvconnect ld: 0711-317 ERROR: Undefined symbol: t_free ld: 0711-317 ERROR: Undefined symbol: t_rcv ld: 0711-317 ERROR: Undefined symbol: t_look ld: 0711-317 ERROR: Undefined symbol: t_rcvrel ld: 0711-317 ERROR: Undefined symbol: t_sndrel ld: 0711-317 ERROR: Undefined symbol: t_rcvdis ld: 0711-317 ERROR: Undefined symbol: t_snddis ld: 0711-317 ERROR: Undefined symbol: t_snd ld: 0711-317 ERROR: Undefined symbol: t_optmgmt ld: 0711-317 ERROR: Undefined symbol: t_sndudata ld: 0711-317 ERROR: Undefined symbol: t_rcvudata ld: 0711-317 ERROR: Undefined symbol: t_rcvuderr ld: 0711-317 ERROR: Undefined symbol: t_errlist ld: 0711-317 ERROR: Undefined symbol: t_nerr ld: 0711-317 ERROR: Undefined symbol: t_listen ld: 0711-317 ERROR: Undefined symbol: t_accept ld: 0711-317 ERROR: Undefined symbol: .setenv ld: 0711-317 ERROR: Undefined symbol: .timegm -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 940/367-2744 (cell phone) Is your web site data driven? Are you swamped with work managing, updating, and deploying that data on to your web site? You need Escapade! Check us out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html - 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: [Q] DBI connect with MySQL
iii> You will get errors like these if your script does not print out a header iii> before spitting out other information. It is usually best to print the iii> header in the very beginning of the script so you do not have to worry about iii> it. You dont have to wait until you are about to print out some html. iii> iii> $output->header(); I add "$output->header();" just behind "my $output = new CGI;", but the result does not change. Maybe still there are other factors as you said. Thanks so much for your information. Regards, --Wen [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: how do you format this query?
If all you need is a count of the items why not issue Select count(distinct threads) as ctr from messages Jack ;-)= - Original Message - From: "Ed Lazor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 11:53 PM Subject: how do you format this query? > Hi =) Could you help me with creating a proper query? I have a table that > stores messages with a field for the message id, thread, and parent. The > goal is to create a query that gives me the total threads. I read in a > book and found the DISTINCT key allows me to run a query like this: > > select DISTINCT threads from messages; > > Then all I have to do is count the total number of rows returned. I'm > concerned this query will create unnecessary overhead as the number of > messages in the archive exceeds tens of thousands. Is there a query that > will give me the information I'm looking for without creating the overhead? > > -Ed > > > - > 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: C API problem
Laurent Oget writes:
> I am not sure this will solve your probleme but you need to add -lnsl and -lsocket
>to the compile command line.
>
> On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> > dear Sir :
> >
> > MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> > a simple C API programe which catched from the MySQL tutorial, it
> > chokes at the end of compile process . the programe is as follows:
> >
> > #include
> > #include
> >
> > #define def_host_name NULL
> > #define def_user_name NULL
> > #define def_password NULL
> > #define def_db_name NULL
> >
> > MYSQL *conn;
> > int main(int argc,char *argv[])
> > {
> > conn=mysql_init(NULL);
> > mysql_real_connect(
> > conn,
> > def_host_name,
> > def_user_name,
> > def_password,
> > def_db_name,
> > 0,/*port defaut*/
> > NULL, /*socket default*/
> > 0); /*flag*/
> > mysql_close(conn);
> > exit(0);
> > }
> >
> > I compile as follows:
> >
> > gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
> >-L/home/MySQL/MySQL/lib \
> > -lmysqlclient
> >
> > then I get :
> >
> > /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> > my_open.o(.text+0x14):undefined reference to 'open64'
> > /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> > mf_format.o(.text+0x201):undefined reference to '__lxstat64'
>
> > /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> > my_open.o(.text+0x21):undefined reference to 'fopen64'
> >
> > nothing left to do with the situation, I beg your help. anyway I'm a
> > newcomer. thank you very much.
> >
> > please send message to [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
> >
>
> --
> Laurent Oget, Ph.D. [EMAIL PROTECTED]
> Senior Engineer Zvolve Systems Inc http://zvolve.com
> Chercheur AssociéLiafa http://liafa.jussieu.fr
>
No, the above means he has to update his glibc.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: INSERT DELAYED still keeps CRUSHING (trying everything)
Sinisa, i thought i pointed out that mysql ALWAYS crashes on any single INSERT DELAY anytime, any database, under any conditions and during any weather. NO single INSERT DELAY can be executed successfully. Regards, Artem - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 8:58 PM Subject: Re: INSERT DELAYED still keeps CRUSHING (trying everything) > Artem Koutchine writes: > > Hello again! > > > > In the prev episode i said that when i do INSERT DELAYED > > mysql just catches sig 11, crashes and restarts. No record > > inserted whatsoever. Nothing is written into the update log. > > > > Here is a sample (even though it says 1 row affected, it is > > actually not affected. nothing is inserted): > > > > mysql> insert delayed into aaa (aid, aname) values (111,'hello'); > > Query OK, 1 row affected (0.00 sec) > > mysql> 010301 20:17:22 mysqld restarted > > > > In the error log: > > > > 010301 20:16:27 mysqld started > > /usr/local/mysql/bin/mysqld: ready for connections > > mysqld got signal 11; > > The manual section 'Debugging a MySQL server' tells you how to use a > > stack trace and/or the core file to produce a readable backtrace that > > may > > help in finding out why mysqld died > > 010301 20:17:22 mysqld restarted > > /usr/local/mysql/bin/mysqld: ready for connections > > > > > > I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday), > > MySQL 3.23.33. Compiled using the options which are used in the > > FreeBSD port of mysql to make it stable on high loads. But it is build > > from the original tar ball taken from www.mysql.com. That does not > > matter, since patches for mysql on FreeBSD > > are minimal and not really needed. > > > > Sinisa recommended to try precompiled binary for FreeBSD. I did. > > Same story - keeps crashing on INSERT DELAYED. (not to mention > > that i hate to use precompiled stuff, because it is never configured > > as i want it to be). > > > > What's going on? I really need INSERT DELAYED since i need > > to insert millions of records in a short time for development and > > testing purposes. > > > > Regards, > > Artem > > > > > > Hi! > > Can you make a test case that would always crash MySQL ?? > > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team > - 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: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)
>On 28.02.2001 13:13:05 Bob Hall wrote: > > > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen > > >til at spørge på dansk... ;-) > > > > Det er alltid hyggelig å se på andre språg på internettet, men hvis > > du skriver på dansk, så skal de aller fleste taper sjansen å lære om > > ADO og MySQL. > >Bitte was? Ich würde ja gerne helfen, nur leider verstehe ich nicht, was ihr >gerade gesagt habt. Es wäre nett, wenn ihr entweder in Deutsch, >oder vlt. doch >in Englisch posten würdet! > >Danke sehr! Carsten wrote to a compatriot that they could write in that form of Norwegian spoken south of Skagerrok. I responded in a Danish dialect sung near the Oslo fjord that if they switched from English, few people would be able to learn from their discussion. And Alexander used the linguistic relative of Anglo-Saxon spoken in Berlin to ask us to write in English. This resulted in an extended thread, with several people asking us to post in that derivative of Low German spoken in London and Washington DC by the suburbanite tribes who never roll their 'r's. I hope this clarifies matters. People who are looking for help will be most likely to find it on the list or in the archives if the information is in English. Therefore English postings create the greatest good for the greatest number of people. People who have trouble with English are welcome to post in any language they wish, and hope for an answer. In general, it's best to post in English if you can. Rural dialects spoken in the mountainous regions of Albania should be avoided, unless you are posting many times to ask for help in recovering a hopelessly crashed database without backups, in which case they are preferred. Next up: how the prehistoric wanderings of the SQL people resulted in the dialects in use today. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: INSERT DELAYED still keeps CRUSHING (trying everything)
Artem Koutchine writes:
> Hello again!
>
> In the prev episode i said that when i do INSERT DELAYED
> mysql just catches sig 11, crashes and restarts. No record
> inserted whatsoever. Nothing is written into the update log.
>
> Here is a sample (even though it says 1 row affected, it is
> actually not affected. nothing is inserted):
>
> mysql> insert delayed into aaa (aid, aname) values (111,'hello');
> Query OK, 1 row affected (0.00 sec)
> mysql> 010301 20:17:22 mysqld restarted
>
> In the error log:
>
> 010301 20:16:27 mysqld started
> /usr/local/mysql/bin/mysqld: ready for connections
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace that
> may
> help in finding out why mysqld died
> 010301 20:17:22 mysqld restarted
> /usr/local/mysql/bin/mysqld: ready for connections
>
>
> I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
> MySQL 3.23.33. Compiled using the options which are used in the
> FreeBSD port of mysql to make it stable on high loads. But it is build
> from the original tar ball taken from www.mysql.com. That does not
> matter, since patches for mysql on FreeBSD
> are minimal and not really needed.
>
> Sinisa recommended to try precompiled binary for FreeBSD. I did.
> Same story - keeps crashing on INSERT DELAYED. (not to mention
> that i hate to use precompiled stuff, because it is never configured
> as i want it to be).
>
> What's going on? I really need INSERT DELAYED since i need
> to insert millions of records in a short time for development and
> testing purposes.
>
> Regards,
> Artem
>
>
Hi!
Can you make a test case that would always crash MySQL ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: [Q] DBI connect with MySQL
You will get errors like these if your script does not print out a header
before spitting out other information. It is usually best to print the
header in the very beginning of the script so you do not have to worry about
it. You dont have to wait until you are about to print out some html.
$output->header();
Also, if your script has parse errors or something similar you will get that
error.
Hope this helps.
ryan
> Hi,gurus,
> I am a novice at MySQL. When I try to run a sample program in the book of
> "MySQL & mSQL" I get a error message from my apache server as follows,
> *
> Internal Server Error
> The server encountered an internal error or misconfiguration and was
unable to complete your request.
>
> Please contact the server administrator, [EMAIL PROTECTED] and inform
them of the time the error occurred, and anything you might have done that
may have caused the error.
>
> More information about this error may be available in the server error
log.
> *
>
> The sample program is
>
> #!/usr/bin/perl -w
>
> use strict;
> use CGI qw(:standard);
> use CGI::Carp;
> use DBI;
> CGI::use_named_parameters(1);
>
> my ($db);
> my $output = new CGI;
>
> $db = param('test') or die("Could not find database!");
> my $dbh = DBI->connect("DBI:mysql:$db:$server",root,passward );
>
> if (not $dbh) {
> print header, start_html('title'=>"Information on $host => $db",
> 'BGCOLOR'=>'white');
>
> print < $host
> $db
> For the following reasons the connection failed.
> $DBI::errstr
>
> END_OF_HTML
> exit(0);
> }
>
> print header, start_html('title'=>"Information on $host => $db",
> 'BGCOLOR'=>'white');
> print < $host
> $db
>
> Tables
>
> END_OF_HTML
>
> my @tables = $dbh->func( '_ListTables' );
> foreach (@tables) {
> print "$_\n";
> }
> print <
>
> END_OF_HTML
>exit(0);
>
>
> Could someone tell me what is wrong? Thanks a lot.
>
> Regards,
>
> --Wen
> [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
The links in the manual ->'MySQL_Full.htm' don't work
They didn't work 'onsite'/live, or when downloaded. They *used* to work for both. - 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
Win 2000 Not starting
Hi 1. I'm working in Windows 2000, intending to run MySQL to localhost on same laptop. 2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I unzipped binary directly to d: 3. None of these have worked: d:\mysql\bin\mysqld --debug d:\mysql\bin\mysqld --standalone --debug d:\mysql\bin\mysqld --standalone d:\mysql\bin\mysqld --basedir d:\mysql d:\mysql\bin\mysqld --skip-grant-tables --debug d:\mysql\bin\mysqld --skip-grant-tables d:\mysql\bin\mysqld-nt --standalone --debug d:\mysql\bin\mysqld-nt --standalone I was shutting down via Task Manager but have repeated by shutting down the laptop aswell. All cases, everything just hangs, nothing happens. 4. As per Manual, this command: d:\mysql\bin\mysqld produced a mysql.err file which states "REady for connections" and it came back to the prompt d:> I thought this might have started the server up, so I then tried d:>mysql but it didn't recognise this. I tried d:\mysql\bin\mysqlshow but it came back with error message, "Can't connect to MySQL server on 'localhost'. Check that it's running. 5. I particularly didn't want to use the mysqld-nt install option because I don't want the bother of installing as a service with users/passwords, this is just development work, Windows defaults of being available for all users is fine. Also the Manual states the option file my.cnf is supported by program "mysqld", implicitly it therefore does not support programs "mysql-nt", "mysql-opt". As I've changed default location, I need the option file I believe. Anyone any ideas? Cheers, Lucy - 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: Use Ukrainian lenguage.
when do configure: --with-charset=win-1251 It is clearly explained in the manual. READ THE MANUAL! - Original Message - From: "Rolf Hopkins" <[EMAIL PROTECTED]> To: "Vitaly Dugaev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 6:59 PM Subject: Re: Use Ukrainian lenguage. > I have never tried changing the default language myself but a suggestion > only is that are your columns of the right type? > > - Original Message - > From: "Vitaly Dugaev" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, March 01, 2001 19:32 > Subject: Use Ukrainian lenguage. > > > Dear support group of MySQL, > > When I use MySQL for Windows with languages like Ukrainian, Rassian I can't > use case insensitive select, or operator like Upper. > Can you help me? > Becouse I understand that I mast recompile server, is'nt it? > Please give me ansver!!! > > Sincerely, > Anatolii. > > > > - > 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
INSERT DELAYED still keeps CRUSHING (trying everything)
Hello again! In the prev episode i said that when i do INSERT DELAYED mysql just catches sig 11, crashes and restarts. No record inserted whatsoever. Nothing is written into the update log. Here is a sample (even though it says 1 row affected, it is actually not affected. nothing is inserted): mysql> insert delayed into aaa (aid, aname) values (111,'hello'); Query OK, 1 row affected (0.00 sec) mysql> 010301 20:17:22 mysqld restarted In the error log: 010301 20:16:27 mysqld started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died 010301 20:17:22 mysqld restarted /usr/local/mysql/bin/mysqld: ready for connections I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday), MySQL 3.23.33. Compiled using the options which are used in the FreeBSD port of mysql to make it stable on high loads. But it is build from the original tar ball taken from www.mysql.com. That does not matter, since patches for mysql on FreeBSD are minimal and not really needed. Sinisa recommended to try precompiled binary for FreeBSD. I did. Same story - keeps crashing on INSERT DELAYED. (not to mention that i hate to use precompiled stuff, because it is never configured as i want it to be). What's going on? I really need INSERT DELAYED since i need to insert millions of records in a short time for development and testing purposes. Regards, Artem - 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: BDB tables crashing mysql 3.23.33
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I decided to drop the offending
>database, and re-create it. No problem so far. Right after
>I run the offending queries (see below), mysqld dies. Any subsequent
>connection attempt to mysqld hangs, and the server is basically
>dead (requiring a killall -9 mysqld). There is a file called
>log.01 that appeared, as well as an error message (see below).
>
>I can replicate this error quite easily, as it happens each time the
>query
>is run.
>
>
>CREATE TABLE tblCharge (
> ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
> ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
> ChargeDate date DEFAULT '-00-00' NOT NULL,
> ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
> FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
>DEFAULT 'New' NOT NULL,
> ChargeAuthorizationMessage text,
> ChargeComment text,
> ChargeTimeStamp varchar(20),
> PRIMARY KEY (ChargeID),
> KEY ServiceID (ServiceID),
> KEY ChargeDate (ChargeDate)
>) type=BDB;
>
>
>
>Query #1:
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>COMMIT;
>
>Query #2
>BEGIN;
>UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
>ChargeID = 1;
>COMMIT;
>
>Query #3
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>
>
>
>ERROR 2013: Lost connection to MySQL server during query
>mysql> COMMIT;
>Number of processes running now: 0
>010228 13:59:40 mysqld restarted
Quick update on this bug - if you change ChargeAuthorizationMessage and
ChargeComment to varchar(255) the bug does not happen. In other words, the
offender is the text field.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
-
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
Can't find mysqladmin
Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I actually upgraded mysql to the newest version and everything went fine and it verified after the installation was done. The problem that I have is that I cannot log into mysql now. I have tried to located mysqladmin anywhere on the server and it seems to be missing and I cannot log into MYSQL. However when I do a ps -ef I can see that safe_mysqld is running along with the three other processes. Any clues on how to log in would be appreciated (It has just been one of those days) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: Problems with MySQLGUI 1.7 and ssh
Todd A. Jacobs writes:
> I downloaded and compiled the latest version of MySQLGUI and am connecting
> to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
> following ssh tunnel:
>
> ssh -x -g -L 3306:localhost:3306 mysql
>
> I get this error message from the MySQLGUI client:
>
> Can't connect to local MySQL server through \
> socket '/tmp/mysql.sock' (111)
>
> What does this mean? At first glance, it looks like an X Windows error.
> I don't have X running on the MySQL server; only on the remote. Could
> this be the problem? That wouldn't really make sense; why would the client
> require X services from the database host?
>
> If it's something else, how can I fix it? Why can't I connect? I'm really
> frustrated.
>
> --
> Todd A. Jacobs
> CodeGnome Consulting, LTD
>
>
Hi!
This command enabled me to test mysqlgui over SSH tunnel without a
single problem :
#!/bin/sh
ssh1 -C [EMAIL PROTECTED] -L 110:work:110 -L 26:localhost:25 -L 6667:xxx.yyy.zzz:6667
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: BDB tables crashing mysql 3.23.33
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote: > > I've replicated this problem on 3 different machines, and > on 3.23.33 and 3.23.32. I had been using BDB tables for a > couple weeks now in testing, without a hitch until the above > query starting being used. I also tried to recompile mysql > statically, with the same results. There is a bug when handling a text (blob) field. I'm looking into it, and hope to have a patch for it this morning. > I really hope there is an easy patch/fix to this problem, as my > development team has just finished writing 15000 lines of code > and use DBD tables extensively throughout the application. My > company has purchased a basic license for mysql, and quite > frankly this error really concerns me. > > If it was this easy to crash BDB tables and there is no quick > fix, I will have to stop using mysql altogether throughout my > company. We rely heavily on mysql right now, and this kind > of error makes me wonder if this is not a mistake. Until a > solution can be found, I will instruct my team to start porting > the application to postgres, I simply can't take the chance of > using these versions of mysql in production. I've added this bug to our test suite, so it won't crop back up again once it's fixed. Thank you for the test case! Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q] DBI connect with MySQL
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform them of the
time the error occurred, and anything you might have done that may have caused the
error.
More information about this error may be available in the server error log.
*
The sample program is
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use CGI::Carp;
use DBI;
CGI::use_named_parameters(1);
my ($db);
my $output = new CGI;
$db = param('test') or die("Could not find database!");
my $dbh = DBI->connect("DBI:mysql:$db:$server",root,passward );
if (not $dbh) {
print header, start_html('title'=>"Information on $host => $db",
'BGCOLOR'=>'white');
print <$host
$db
For the following reasons the connection failed.
$DBI::errstr
END_OF_HTML
exit(0);
}
print header, start_html('title'=>"Information on $host => $db",
'BGCOLOR'=>'white');
print <$host
$db
Tables
END_OF_HTML
my @tables = $dbh->func( '_ListTables' );
foreach (@tables) {
print "$_\n";
}
print <
END_OF_HTML
exit(0);
Could someone tell me what is wrong? Thanks a lot.
Regards,
--Wen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error in Config .33
Dual PIII half gig ram. VaLinux 6.2.3 When running configure, It checks size of char and says 0. it fails and says that a static libm.a is not found. It is in /usr/lib, but it says to install a static version. Is there any other workaround for this. - 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: Why Heap Tables doesn´t support auto increment colums
> I´m currently working on system for Managing http Session and would like > to use a heap table for storing the session information. Session > information is only of temporary intrest. But still I need an unique > ID for reference with some other Tabels storing dtaa for the session. > All these tables are Heap tables. So there is no Probelem if the ID > generated by the auto_increment column is not unique when the Database > server is restarted. There's a couple problems with that to begin with. First, you're storing state in a HEAP table. If the mysql server gets reset, all the sessions are lost. It would be tough to think you want to write your system so your database server cannot ever be restarted, especially when writing the data to a MyISAM table would probably be at a trivial loss of speed. Also, if you used an auto_incrementing column, you would be handing out sessionIDs sequentially. It would be trivial for somebody to usurp somebody else's sessionID by simply subtracting or adding 1 to their own. -Joe - 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
MyODBC
Ok, I am new in the IT world, and I just want to set up a mySql server. I installed mySql on the WinNt server (on the lan in my office) with mysqladmin running, and i installed myODBC on my win98 computer, with settings that would match the server. How can i test if this is working without making an application? do i need myODBC installed on teh server as well?? HELP!!! kate - 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: PHP and MySQL
Joe and Nancy M wrote: > > Thanks to everyones help, I have my webpages using php to read my mysql > table and presenting the appropriate information. I upload and refresh my > table via telnet when the whole thing needs refreshing. > > I would like to give my end user a tool to change the table when just a few > rows need updating. > > Can any of you point me to a resource that would have sample php code that > just displays a whole table and allows add/chg/delete functionality. > > Thanks once again! > > Joe. Try phpMyAdmin ... (http://www.phpwizard.net/projects/phpMyAdmin/) -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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: BDB tables crashing mysql 3.23.33
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I decided to drop the offending
>database, and re-create it. No problem so far. Right after
>I run the offending queries (see below), mysqld dies. Any subsequent
>connection attempt to mysqld hangs, and the server is basically
>dead (requiring a killall -9 mysqld). There is a file called
>log.01 that appeared, as well as an error message (see below).
>
>I can replicate this error quite easily, as it happens each time the
>query
>is run.
>
>
>CREATE TABLE tblCharge (
> ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
> ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
> ChargeDate date DEFAULT '-00-00' NOT NULL,
> ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
> FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
>DEFAULT 'New' NOT NULL,
> ChargeAuthorizationMessage text,
> ChargeComment text,
> ChargeTimeStamp varchar(20),
> PRIMARY KEY (ChargeID),
> KEY ServiceID (ServiceID),
> KEY ChargeDate (ChargeDate)
>) type=BDB;
>
>
>
>Query #1:
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>COMMIT;
>
>Query #2
>BEGIN;
>UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
>ChargeID = 1;
>COMMIT;
>
>Query #3
>BEGIN;
>INSERT INTO tblCharge
>VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>
>
>
>ERROR 2013: Lost connection to MySQL server during query
>mysql> COMMIT;
>Number of processes running now: 0
>010228 13:59:40 mysqld restarted
Thanks for reporting the bug - I have been able to repeat it, and am now
trying to figure out what is happening. Unfortunately, Tim and Monty, who are
the ones working on BDB code are not going to be available for a couple of
days, and since I do not know that code as well, it would take me some time
to understand how things work ( which I need to do anyway, and now is a good
chance) before I can provide a fix.
Please note that our BDB tables have not yet received nearly as much of the
"baptism of fire" as MyISAM. We will however, fix all the reported bugs
promptly.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
-
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: C API problem
I am not sure this will solve your probleme but you need to add -lnsl and -lsocket to
the compile command line.
On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from the MySQL tutorial, it
> chokes at the end of compile process . the programe is as follows:
>
> #include
> #include
>
> #define def_host_name NULL
> #define def_user_name NULL
> #define def_password NULL
> #define def_db_name NULL
>
> MYSQL *conn;
> int main(int argc,char *argv[])
> {
> conn=mysql_init(NULL);
> mysql_real_connect(
> conn,
> def_host_name,
> def_user_name,
> def_password,
> def_db_name,
> 0, /*port defaut*/
> NULL,/*socket default*/
> 0); /*flag*/
> mysql_close(conn);
> exit(0);
> }
>
> I compile as follows:
>
> gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
>-L/home/MySQL/MySQL/lib \
> -lmysqlclient
>
> then I get :
>
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x14):undefined reference to 'open64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> mf_format.o(.text+0x201):undefined reference to '__lxstat64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x21):undefined reference to 'fopen64'
>
> nothing left to do with the situation, I beg your help. anyway I'm a
> newcomer. thank you very much.
>
> please send message to [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
>
--
Laurent Oget, Ph.D. [EMAIL PROTECTED]
Senior Engineer Zvolve Systems Inc http://zvolve.com
Chercheur Associé Liafa http://liafa.jussieu.fr
-
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
Segmentation fault launching mysqld after compiling 3.23.33
Hi all. I've compiled mysql 3.23.33 with support for DB-Berkeley. After it when I try to launch mysqld it gave me a segmentation fault. Anybody has a similar problem? Note: I use Slackware 7.1 in a PC. Thanks in advance. Iago. - 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: Antwort: PHP and MySQL - Specifying location for mysql.sock
HOORAY! It's finally working. However, I'd prefer to have my mysql.sock socket file in /tmp/ Anyone know how to change the settings for MySQL (and also PHP4 and phpMyAdmin) so that it looks in /tmp/ instead? Cheers. Ben Rick Emery wrote: > > I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have > permissions set to: drwxr-xr-x > > This cured the problem for me. > > rick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 01, 2001 6:19 AM > To: Ben Kennish > Cc: [EMAIL PROTECTED] > Subject: Antwort: PHP and MySQL > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) in > > /var/www/html/index.php on line 5" > > Are you sure that your MySQL installation creates the socket right there? > If > I'm not mistaken, it may be created in /tmp. > > - > 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 -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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
AIX 4.2.1
Is there reasonably current version of mysql that I can install or compile under aix4.2.1. I have been unable to compile 3.23.33 because of size limitations. -- Mike Klein Manager, System Services Information Technology Loyola University New Orleans 6363 St. Charles Ave. New Orleans, LA 70118 504.865.3470 - 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: Antwort: Re: boolean type
[EMAIL PROTECTED] wrote:
>
> On 01.03.2001 13:51:58 Robert Vetter wrote:
>
> > ENUM("no","yes")
>
> I always wondered: How much space does this take?
1 or 2 bytes, depending on the number of enumeration values (65535
values maximum). I've read this in the _MANUAL_ !
Robert
-
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: Use Ukrainian lenguage.
I have never tried changing the default language myself but a suggestion only is that are your columns of the right type? - Original Message - From: "Vitaly Dugaev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 19:32 Subject: Use Ukrainian lenguage. Dear support group of MySQL, When I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Becouse I understand that I mast recompile server, is'nt it? Please give me ansver!!! Sincerely, Anatolii. - 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 dbi modules
HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. Any help would be appreciated, TIA >Subject: Mysql dbi modules > >I have almost installed all of the dbi/dbm modules but can't get thru the >'make test'. I get the error msg: >'t/10dsnlist.DBI->connect(database=test) failed: Can't connect to >local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at >t/10dsnlist.t line 45' > >MySql is ruuning but the database is located at 'local/mysql' and the >mysql.sock socket is present. This is setup in /etc/my.cnf > >How can I change the test to reference the current setup? > > > >Thanks, Dave - 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
[Q] DBI connect with MySQL
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform them of the
time the error occurred, and anything you might have done that may have caused the
error.
More information about this error may be available in the server error log.
*
The sample program is
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use CGI::Carp;
use DBI;
CGI::use_named_parameters(1);
my ($db);
my $output = new CGI;
$db = param('test') or die("Could not find database!");
my $dbh = DBI->connect("DBI:mysql:$db:$server",root,passward );
if (not $dbh) {
print header, start_html('title'=>"Information on $host => $db",
'BGCOLOR'=>'white');
print <$host
$db
For the following reasons the connection failed.
$DBI::errstr
END_OF_HTML
exit(0);
}
print header, start_html('title'=>"Information on $host => $db",
'BGCOLOR'=>'white');
print <$host
$db
Tables
END_OF_HTML
my @tables = $dbh->func( '_ListTables' );
foreach (@tables) {
print "$_\n";
}
print <
END_OF_HTML
exit(0);
Could someone tell me what is wrong? Thanks a lot.
Regards,
--Wen
[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: Error 1052:Query problem
Well, for starters, I would say you need > Table_B.Cnty="US" AND Table_A.ID="*"; not > Cnty="US" AND ID="*"; - Original Message - From: "soon chee keong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 20:16 Subject: Error 1052:Query problem > Table_A: ID APPL > > B BI > A BII > * * > * * > C BII > * * > D BI > > Table_B: Cnty ID > > USC > Aus A > Aus B > USD > > * signifies no data > > why does the following produce an error: 1052?? > > SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND > Cnty="US" AND ID="*"; > > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: [auto_increment]
There is entirely unexpected behavior here.
If you have gone to the trouble of defining a column in your database as
an auto_increment field
it should not simply stop working because you enter a negative number.
What we saw yesterday was the addition of a row with a negative number in
the auto_increment field, caused auto_increment to stop for any
FUTURE insert.
In other words, inserting a negative number makes the column not an
auto_increment field any more.
Somehow, in my mind this breaks the basic concept of a database schema,
that once you define something
it shouldn't change out from under you.
Here, we are in effect having to add that restriction programmatically.
The sequence went like this:
create table megatest3
( foo int not null auto_increment primary key,
blah char)
insert megatest3 (blah) values("A")
[ now we have 1,A in the table ]
insert megatest3 (foo, blah) (-1, "B")
[ now we have 1,A in table, and -1, B in table ]
insert megatest3(blah) values("C")
[ now we have 1,A, -1,B,and MAXINT, "C" ]
insert megatest3(blah) values("D")
[ now we have an sql error for double key, presumably because it is
trying to put in MAXINT]
Now imagine these sql statements spread over the span of say a week.
You might not get so lucky
as to figure out what is going on as we were.
-Tom
Jason Landry wrote:
> Well, except that the value of an auto-increment field CAN be set to a
> specific value (perhaps negative) an INSERT or UPDATE statement.
>
> > If Autoincrement can only work with positive numbers, then any
> > key that is auto_increment should automatically be made unsigned.
> >
-
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: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P. Hasenfratz wrote: > > > Why not use a timestamp column to guarentee the order in which rows get > > > inserted into the table? You can then order on the timestamp column. > > > > Hmm, timestamp, ie. seconds as finest resolution, might be to broad > depending on > > the hits his site will get - imagine that 2+ users access the site in the > same > > second, then you won't be able to distinguish them, will you? > > What's if you combine a timestamp with the client's IP address? > > for example: > > 5/6/2001 > IP : 212.33.69.2 > > => clientstamp will be 05.06.2001-212.033.069.002 Besides the fakt tha this ID not unique. There ist the Problem that the ID you proposed ist an String ID and strings als Index are the Major Preformance killer on Databases. Wie kann calculate an intager from the two information. totaly loosing the Uniqueness. The question still is. Why are auto_increment columns are not supported fuer Heap Tables. SoLong Estartu -- Gerhard Schmidt mailto:[EMAIL PROTECTED] Entwicklung adMaster network Tel.: +49 89 38356-334 Kaiserstraße 16 D-80801 München http://www.admasternetwork.net PGP signature
Re: running mysql not as a server
Broadly speaking, I would agree with Cal becasue MySQL is, by its very nature, a server application.. However, you can easily emulate it being an application by adding net start(s) and net stop(s) to the beginning and end of your application - you may have timing issues, however, with the start and stops and your application - you will need to ensure that everything is in place before you start your app main code and that everything closes off properly before your app releases all resources. I think the first will just be a timing or return function problem and the second a flush buffer and ensuring all updates have taken place. O'course I aint heard of anyone trying this yet! Andy The rest of life is left as an exercise for the reader :-) - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: "Michael Gilman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 7:38 AM Subject: RE: running mysql not as a server > Michael, > > IMHO, if you are looking for a desktop database, something built around a > .dbf file would be a more suitable choice. (My personal fav is FoxPro even > though it's a M$ product) MySQL, while it probably can be made to do this, > is not designed to do this. > > Cal > http://www.calevans.com > > > -Original Message- > From: Michael Gilman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 01, 2001 6:08 AM > To: [EMAIL PROTECTED] > Subject: running mysql not as a server > > > How can I run mySQL in a Windows app in a non-server mode. That is how can I > get the app to start mySQL when the app starts and shut it down when the app > is exited. Are there any issue that might cause a problem? > Thanks for your help. > Best Regards, > Mike > > Michael Gilman, PhD > Data Mining Technologies Inc. > (516) 470-9011 ext 100 > [EMAIL PROTECTED] > > The information transmitted in this email is intended only for the person(s) > or entity to which it is addressed and may contain confidential and/or > privileged material. Any review, retransmission, dissemination or other use > of, or taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this email in error, please contact the sender and permanently delete the > email from your computer. > > > > > - > 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: Antwort: Re: Antwort: AW: version 3.23.29a-1
Yeah, except when the RPMS were created with an error. MySQL should not require Perl to be installed in order for it to work, so in this case, yes, use no dependancy flag. Have a look at the archives around november, december last year. Heaps of info in regards to this. - Original Message - From: <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 16:42 Subject: Antwort: Re: Antwort: AW: version 3.23.29a-1 > > On 01.03.2001 02:37:17 Rolf Hopkins wrote: > > > Or use the no dependency flag or upgrade. > > That's as good as suggesting to not use rpm at all. The dependencies are in > there with a reason, you know. > Never upgrade/install with --force/--nodeps. > - 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: Upgrading MySQL causes Error - ASP
Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
it should be something
related to GROUP BY clause.
Celso.
- Original Message -
From: Gerald L. Clark <[EMAIL PROTECTED]>
To: Celso Pires <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:11
Subject: Re: Upgrading MySQL causes Error - ASP
> They replaced your MySQL with a new version.
> Did they re-compile Apache and PHP to use the new MySQL libraries,
> or is it trying to use the now missing ones?
>
> Celso Pires wrote:
> >
> > Hi there,
> >
> > I've got a site hosted at an ISP and everything was going well when they
> > decided to upgrade the software. Now my site is running under Win2K,
IIS5,
> > MySQL 3.23.33 and MyODBC 2.50.36.
> > In order to get easier to explain what is going wrong, I've built the
> > following test:
> >
> > CREATE TABLE person (
> > person_ID INTEGER NULL,
> > name CHAR(50) NULL,
> > gender CHAR(1) NULL
> > );
> >
> > INSERT INTO person (person_id, name, gender) values
> >
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m
');
> >
> > mysql> select count(*) as quantity, gender
> > -> from person
> > -> group by gender;
> > +--++
> > | quantity | gender |
> > +--++
> > |2 | f |
> > |3 | m |
> > +--++
> > 2 rows in set (0.01 sec)
> >
> > *** As you can realize, so far so good. Now things get worse ***
> >
> >
> >
> > GROUP BY TEST
> >
> >
> > <%
> > Response.Write "Begin"
> >
> > strConn =
> >
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
> > Set conn = Server.Createobject("ADODB.Connection")
> > conn.Open(strConn)
> >
> > strSQL = "select count(*) as quantity, gender "
> > strSQL = strSQL & "from person "
> > strSQL = strSQL & "group by gender;"
> >
> > Response.Write strSQL & ""
> >
> > Set Rs = conn.Execute(strSQL)
> >
> > While Not Rs.EOF
> >Response.Write "Quantity: " & RS("quantity") & " - Gender: " &
> > RS("gender") & ""
> >Rs.MoveNext
> > Wend
> >
> > Rs.Close
> > conn.close
> > response.write "The End"
> > %>
> >
> >
> >
> > *** The page above should print:
> > Begin
> > select count(*) as quantity, gender from person group by gender;
> > Quantity: 2 - Gender: f
> > Quantity: 3 - Gender: m
> > The End
> >
> > *** Instead, I'm getting this:
> >
> > Begin
> > select count(*) as quantity, gender from person group by gender;
> > The End
> >
> > *** It means that the record set is empty.
> >
> > Thank you very much for any help.
> >
> > Regards,
> >
> > Celso.
> >
_
> > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.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
>
>
-
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
C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [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
C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [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: BDB tables crashing mysql 3.23.33
[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offending
> database, and re-create it. No problem so far. Right after
> I run the offending queries (see below), mysqld dies. Any subsequent
> connection attempt to mysqld hangs, and the server is basically
> dead (requiring a killall -9 mysqld). There is a file called
> log.01 that appeared, as well as an error message (see below).
>
> I can replicate this error quite easily, as it happens each time the
> query
> is run.
>
>
> CREATE TABLE tblCharge (
> ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
> ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
> ChargeDate date DEFAULT '-00-00' NOT NULL,
> ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
> FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
> ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
> DEFAULT 'New' NOT NULL,
> ChargeAuthorizationMessage text,
> ChargeComment text,
> ChargeTimeStamp varchar(20),
> PRIMARY KEY (ChargeID),
> KEY ServiceID (ServiceID),
> KEY ChargeDate (ChargeDate)
> ) type=BDB;
>
>
>
> Query #1:
> BEGIN;
> INSERT INTO tblCharge
> VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
> COMMIT;
>
> Query #2
> BEGIN;
> UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
> ChargeID = 1;
> COMMIT;
>
> Query #3
> BEGIN;
> INSERT INTO tblCharge
> VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
>
>
>
> ERROR 2013: Lost connection to MySQL server during query
> mysql> COMMIT;
> Number of processes running now: 0
> 010228 13:59:40 mysqld restarted
>
> ERROR 2006: MySQL server has gone away
> No connection. Trying to reconnect...
> Connection id:4
> Current database: Funio
>
> ./mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var \
> --user=root --pid-file=/usr/local/mysql/var/suave.pid --skip-locking
> ./mysqld: ready for connections
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace that
> may
> help in finding out why mysqld died
> Attemping backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong
>
>
> I've replicated this problem on 3 different machines, and on 3.23.33 and
> 3.23.32.
> I had been using BDB tables for a couple weeks now in testing, without a
> hitch
> until the above query starting being used. I also tried to recompile
> mysql
> statically, with the same results.
>
> I really hope there is an easy patch/fix to this problem, as my
> development
> team has just finished writing 15000 lines of code and use DBD tables
> extensively throughout the application. My company has purchased a
> basic license for mysql, and quite frankly this error really concerns
> me.
>
> If it was this easy to crash BDB tables and there is no quick fix, I
> will
> have to stop using mysql altogether throughout my company. We rely
> heavily
> on mysql right now, and this kind of error makes me wonder if this is
> not a
> mistake. Until a solution can be found, I will instruct my team to
> start porting the application to postgres, I simply can't take the
> chance of using these versions of mysql in production.
>
>
>
>
> Description:
> BDB tables crash very easily
> How-To-Repeat:
> See above
> Fix:
> no idea
>
> Originator: Mark Steele
> Organization:
> Mark Steele
> Vice president research and development
> Inet Technologies Inc.
> [EMAIL PROTECTED]
>
> MySQL support: [email support]
> Synopsis: BDB tables crash
> Severity:
> Priority:
> Category: mysql
> Class:
> Release: mysql-3.23.32 (Source distribution)
> Server: /usr/local/mysql/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for
> pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.32
> Protocol version10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 1 min 12 sec
>
> Threads: 1 Questions: 61 Slow queries: 0 Opens: 48 Flush tables: 1
> Open tables: 42 Queries per second avg: 0.847
> Environment:
> System: Linux suave 2.4.1 #11 Sat Feb 17
Re: beta
marsha writes:
> Hi guys,
>
> I am part of a team developing an interface from Microsoft Access on a
> Windows environment to mySQL on a Cobalt RAQ server (LINUX).
>
> When you say the software mySQLgui is in "beta testing", what level is
> that? Is alpha a step higher than beta, as in the best and ready for
> distribution. Or is delta a step higher than beta? In other words, which
> direction does the chain of progression go and how many levels are there?
>
> Thanks,
> Marsha Hardacre
> Database Programmer
> Anne Holmes and Associates
> 5117 Jersey Ridge Road
> Davenport IA 52807
>
>
Hi!
First of all mysqlgui is not beta any more. I will have to fix that.
Second, it goes like this:
CVS - alpha - beta - gamma - stable
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [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
Antwort: Error 1052:Query problem
On 01.03.2001 13:16:47 soon chee keong wrote: > Table_A: ID APPL > > B BI > A BII > * * > * * > C BII > * * > D BI > > Table_B: Cnty ID > > USC > Aus A > Aus B > USD > > * signifies no data > > why does the following produce an error: 1052?? > > SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND > Cnty="US" AND ID="*"; Which ID? ID from Table_A, or ID from Table_B? - 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
AW: Antwort: Select from dual?
DUAL is a dummy table in oracle ... !
In mysql you have two way to set variables:
1. set them directly via SET @variable={ integer expression | real
expression | string expression }[,@variable= ...].
2. or do something like select @variable:={ integer expression | real
expression | string expression }
you can read it out in the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Variables
> -Ursprungliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 1. Marz 2001 10:54
> An: M. A. Ould-Beddi
> Cc: [EMAIL PROTECTED]
> Betreff: Antwort: Select from dual?
>
>
>
> On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote:
>
> > I know that in Oracle it is possible to select a number
> > from DUAL and put it in a variable. Is it possible
>
> ??? What's DUAL?
>
>
>
> -
> 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: Problen in mysql 'read only'
Did you change the permissions of the files after starting the sever, or before? Did you read the GRANT section of the manual. Does your user have the UPDATE privilege? Raman Aggarwal wrote: > > Dear Sir > > I am a regular user of MySql. I will be obliged if you help me. > > 1. The path of the data directory is > /var/lib/mysql > 2. The database name is 'directory' > 3. The permissions of directory are > drwxrwxrwx2 root root 4096 Mar 1 16:24 directory > 4. All the files in the directory are having the permissions > -rw-rw-rw-2 root root > > Now when I want to insert the data error message appears that the table is read >only. error 1036. > > I tried all combination of permissions but no result. > > Mysql version is 3.22.25 > > Raman > > > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.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: Antwort: PHP and MySQL
I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions set to: drwxr-xr-x This cured the problem for me. rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:19 AM To: Ben Kennish Cc: [EMAIL PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > through socket '/var/lib/mysql/mysql.sock' (111) in > /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - 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: Antwort: PHP and MySQL - Default Socket Setting
[EMAIL PROTECTED] wrote: > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) in > > /var/www/html/index.php on line 5" > > Are you sure that your MySQL installation creates the socket right there? If > I'm not mistaken, it may be created in /tmp. > > - > 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 No it was creating it in /var/lib/mysql but then PHP doesn't like this Thanks to you, we've managed to get it working using the following commands... mysqladmin shutdown safe_mysqld --user=root --socket=/tmp/mysql.sock & This works but would you happen to know how I can get NySQL to create the socket in /tmp/ at startup? (rather than having to shut it down and reboot with a new socket) Cheers, -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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: Calculated Field
Hi, > How do I set up a field called Minutes which has the (default) value, where > > round((SessionTime+30)/60) = Minutes > > Is it possible to set this up? In other databases (Alpha Five) I would have > used a Calculated Field attribute to achieve this. > > Can MySql handle it.. ??? In SQL databases in general, there is no such thing as a 'Calculated' field type. What you're probably used to is just a convinience supplied by other database systems. What you need to do to accomplish what you want is to calculate that minutes value on the fly, within the SELECT statement that retrieves your data. You don't need to add any fields to your table to do this. Here's an example: SELECT ROUND((SessionTime + 30) / 60) AS Minutes FROM YourTable Regards, Basil Hussain ([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: mysql ./config..... concerning lncurses
These libraries should be on Debian installation CD. You just need to install them. "Mark R. Martinez" wrote: > > Hello, > Our problem concerns an abnormal abort of: > ./configure --prefix=/usr/local/mysql > > error messages show that lncurses, lcurses, ltermcap, could not be found. > We are running Debian Linux 2.2x, on SPARC. We are trying to install > 3.23.33. Any help would be useful thank you. > > Mark R. M. > > # > I shall pass through this world only once. Any good I can do or any > kindness I can show another human being let me do it now and not defer it, > for I shall not pass this way again. > > DEFECTIO NON OPTIO EST > "Failure is not an option" > > I do not SUFFER from insanity I enjoy every minute of it! > > > Name: config.log >config.logType: Plain Text (TEXT/PLAIN) > Encoding: BASE64 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL causes Error - ASP
They replaced your MySQL with a new version.
Did they re-compile Apache and PHP to use the new MySQL libraries,
or is it trying to use the now missing ones?
Celso Pires wrote:
>
> Hi there,
>
> I've got a site hosted at an ISP and everything was going well when they
> decided to upgrade the software. Now my site is running under Win2K, IIS5,
> MySQL 3.23.33 and MyODBC 2.50.36.
> In order to get easier to explain what is going wrong, I've built the
> following test:
>
> CREATE TABLE person (
> person_ID INTEGER NULL,
> name CHAR(50) NULL,
> gender CHAR(1) NULL
> );
>
> INSERT INTO person (person_id, name, gender) values
> (1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m');
>
> mysql> select count(*) as quantity, gender
> -> from person
> -> group by gender;
> +--++
> | quantity | gender |
> +--++
> |2 | f |
> |3 | m |
> +--++
> 2 rows in set (0.01 sec)
>
> *** As you can realize, so far so good. Now things get worse ***
>
>
>
> GROUP BY TEST
>
>
> <%
> Response.Write "Begin"
>
> strConn =
> "DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
> Set conn = Server.Createobject("ADODB.Connection")
> conn.Open(strConn)
>
> strSQL = "select count(*) as quantity, gender "
> strSQL = strSQL & "from person "
> strSQL = strSQL & "group by gender;"
>
> Response.Write strSQL & ""
>
> Set Rs = conn.Execute(strSQL)
>
> While Not Rs.EOF
>Response.Write "Quantity: " & RS("quantity") & " - Gender: " &
> RS("gender") & ""
>Rs.MoveNext
> Wend
>
> Rs.Close
> conn.close
> response.write "The End"
> %>
>
>
>
> *** The page above should print:
> Begin
> select count(*) as quantity, gender from person group by gender;
> Quantity: 2 - Gender: f
> Quantity: 3 - Gender: m
> The End
>
> *** Instead, I'm getting this:
>
> Begin
> select count(*) as quantity, gender from person group by gender;
> The End
>
> *** It means that the record set is empty.
>
> Thank you very much for any help.
>
> Regards,
>
> Celso.
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 Daemon...........
Since you did not
./mysql_install_db --user=mysql
the files are owned by the wrong id.
chown -R mysql /usr/home/treebc.com/mysql/var
if that is the correct location for the database directories.
nirmala wrote:
>
> Hi,
> We have installed Mysql on our server(UNIX) . When I am telnet into the
> server and try to start Mysql by below procedure, I am getting problem.
> Anyone can help me.
>
> [/usr/home/tree/www/treebc.com] : {2} % cd mysql/bin
> [/usr/home/tree/www/treebc.com/mysql/bin] : {3} % ls
> comp_errmysqladmin
> isamchk mysqlbug
> isamlog mysqldump
> msql2mysql mysqlhotcopy
> mysql mysqlimport
> mysql_find_rows mysqlshow
> mysql_fix_privilege_tables perror
> mysql_install_dbprint_defaults
> mysql_setpermission replace
> mysql_zap resolveip
> mysqlaccess safe_mysqld
> [/usr/home/tree/www/treebc.com/mysql/bin] : {3} % ./mysql_install_db
>
> To start mysqld at boot time you have to copy support-files/mysql.server
> to the right place for your system
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> This is done with:
> /usr/home/tree/www/treebc.com/mysql/bin/mysqladmin -u root password 'new-passwor
> d'
> See the manual for more instructions.
>
> NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
> the /usr/home/tree/www/treebc.com/mysql/bin/mysql_fix_privilege_tables. Otherwis
> e you will not be
> able to use the new GRANT command!
>
> Please report any problems with the /usr/home/tree/www/treebc.com/mysql/bin/mysq
> lbug script!
>
> The latest information about MySQL is available on the web at http://www.mysql.c
> om
> Support MySQL by buying support/licenses at http://www.tcx.se/license.htmy.
>
> [/usr/home/tree/www/treebc.com/mysql/bin] : {4} % ./safe_mysqld
> Starting mysqld daemon with databases from /usr/home/tree/www/treebc.com/mysql/v
> ar
> mysqld daemon ended
> [/usr/home/tree/www/treebc.com/mysql/bin] : {5} % ./safe_mysqld &
> [1] 13065
> [/usr/home/tree/www/treebc.com/mysql/bin] : {6} % Starting mysqld daemon
> with databases from /usr/home/tree/www/treebc.com/mysql/var
> mysqld daemon ended
>
> Regards,
> Nirmala,
> ([EMAIL PROTECTED])
> Tree Data Resources Pte Ltd.
> Tel: (65) 2736588 X 15.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create DB's in different directories.Please!How?
My greetings. Please forgive me for my bad English and please help me with my problem. Solution of that problem i didn't find in mailing list, in manual and in others sources. I was working and searching hard, but i can't find it. My problem is: i want to create databases for my users on my server in different directories. Possible in their own home directories and make qoutas on databases sizes. May by simply make quotas on databases without replacing their in different directories? But it's better to replace. I think. It's possible ? Please help me. With my reguards. Maxim M. Polyakov.
