3.23.46 compile trouble on SCO 5.0.4

I have a SCO 5.0.4 system with most of the contents of the Skunkware 2000 CD (FSU Threads, GNU development tools), as well as, the official patches from SCO/Caldera. I have the SCO Development System installed but not licensed, so the includes and libs are available. The MySQL binary re

Re: importing from text base file with "|" delimiters

On Fri, Dec 14, 2001 at 03:16:56PM -0800, Phillip B. Bruce wrote: > Hi, > > How can I import a text file database in which delimiters are "|" > character field separated into mysql database? > Crack open the manual and look for the section on *load data*. The answer is there... -- Regards, Dou

Strange error message

Hey, We're getting a weird error message on 4.0 alpha: Database error in vBulletin: Link-ID == false, connect failed mysql error: Can't connect to MySQL server on '' (11) mysql error number: 2003 Date: Friday 14th of December 2001 08:36:02 PM Has anyone else experienced this? Thanks, James Co

Re: MySQL v.s. Oracle

On Thu, Dec 13, 2001 at 12:54:33PM +0100, Robert Sundström wrote: > > I have done some admittedly not-so-scientific testing on MySQL (both > with MyISAM and InnoDB) to find that both combinations performs best > in single user systems. That shouldn't surprise anyone. There little if any content

Re: win32 libmysqld.dll

At 22:22 14/12/2001 -0500, Edward Meyer wrote: Hi, This you will get with the Win32 4.0.1 release in the next weeks. Regards, Miguel >Has anybody built the embedded server libmysqld.dll for windows 2000? > >I downloaded the source code, however there is not a project file for the >embedded serv

win32 libmysqld.dll

Has anybody built the embedded server libmysqld.dll for windows 2000? I downloaded the source code, however there is not a project file for the embedded server. I have compiled the rest of the code, but I would like to get the embedded server compiled also for a project I am thinking about. An

alter table add primary key error.

Mysql 2.23.45 win98. I create a table "user". FieldTypeNullKeyDefaultExtra idchar(10) userNamechar(20) I type " alter table user add primary key (id);". It work fine. "alter table user drop primary key;". Work fine. But "alter table user add primary key (userName)" didn

Re: stupid join question

AFAIK, the problem is in the Group statement. You can't count on the grouped field. You need to group by ad.id and then use group functions (max(name) etc... to get the info, and count on review... That's how I would do it. --Brian On Fri, 14 Dec 2001, Jon Drukman wrote: > i'm trying to join

stupid join question

i'm trying to join 3 tables. tables 1 and 2 contain information about a person, table 3 contains reviews of that person and may not have any data. outer join, right? i can't get it to work though. the tricky part is i don't want to return the actual data from the 3rd table, i just want the

RE: mysqlclient.lib compiling problem

All is well now. Thank you for you help Miquel. jake -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:51 PM To: Devore, Jacob; '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem At 16:52 14/12/2001 -0800, Devo

Re: mysqlclient.lib compiling problem

At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the header in your code and the wsock32.lib in the link libraries. Regards, Miguel >I am trying to link with the static lib mysqlclient.lib and keep getting >errors like this > >mysqlclient.lib(libmysql.obj) : error LNK2001

Re: Question on mySQL replication

Hi Peter We use the mysql replication stuff here. Its very reliable, and the synchronization between master & slave is pretty much instant. There does seem to be one problem when the master rotates its transaction logs, the slave does not pick it up and you need to manually issue "reset slave"

Re: dbi accessor for mysql_insertid

That should be: $dbh->{mysql_insertid}; if retrieving from a database handle, otherwise use $sth->{mysql_insertid}; if from a statement handle. >On Fri, 14 Dec 2001 19:45:02 -0600, Rich Duzenbury <[EMAIL PROTECTED]> wrote: >> >>DBI version 1.15 >>DBD::mysql version 2.0416 >> >>Blows up on t

Re: dbi accessor for mysql_insertid

DBI Version: 1.19 DBD::mysql Version: 2.0416 Rich Duzenbury wrote: RD: Date: Fri, 14 Dec 2001 19:45:02 -0600 RD: From: Rich Duzenbury <[EMAIL PROTECTED]> RD: To: sherzodR <[EMAIL PROTECTED]> RD: Cc: [EMAIL PROTECTED] RD: Subject: Re: dbi accessor for mysql_insertid RD:

Re: mysqlclient.lib compiling problem

no, I haven't fixed it yet ;-) "Devore, Jacob" wrote: > > How did you fix it, just use the dll? > > Thanks, > > jake > > -Original Message- > From: Colin Faber [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 14, 2001 5:07 PM > To: Devore, Jacob > Cc: '[EMAIL PROTECTED]' > Subjec

Re: dbi accessor for mysql_insertid

DBI version 1.15 DBD::mysql version 2.0416 Blows up on trying to use $dbh->mysql_insertid(): Can't locate object method "mysql_insertid" via package "DBI::db" (perhaps you forgot to load "DBI::db"? Would you mind telling me what version you are running? Thank you. Regards, Rich At 03:36 PM

Re: Order By number of rows returned ?

Hmmmrunning MySQL 3.22.32 on actual server :( No temporary heap tables :( Girish - Original Message - From: "Christopher Bergeron" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 12:49 AM Subject: RE: Order By number of rows returned ? > Crea

RE: mysqlclient.lib compiling problem

How did you fix it, just use the dll? Thanks, jake -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:07 PM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem I've run into the same problem with mysql

Re: mysqlclient.lib compiling problem

I've run into the same problem with mysql++'s msvc++ port mysql++.lib. "Devore, Jacob" wrote: > > I am trying to link with the static lib mysqlclient.lib and keep getting > errors like this > > mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol > _WSAGetLastError@0 > >

mysqlclient.lib compiling problem

I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake --

RE: Order By number of rows returned ?

Creating temporary _fileS_ will create a lot of disk unnecessary disk i/o. depending on how "busy" your DB is, I would use tables in memory vs. files on disk... just my .02c -CB -Original Message- From: sherzodR [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:25 AM To: Giri

I can't see the error in my code ):

Hi! The set: I have a variable in my table with ONE of the following as blob: 1.0 1.5 ... 12.5 The search the user does with a htlm-select (arrayvar[]) with multipe-selections where possible selectabe values could be: "" "1.0','1.5" "2.0','2.5" "3.0','3.5" "4.0','4.5" "5.0','5.5" "6.0','6.5"

RE: Default 1 == Default 16777216?

For those that silently follow these more unusual threads, what was the cause? Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 December 2001 8:07 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Default 1 == De

many aborted connections, errors reading communication packets

I'm receiving many aborted connections, errors reading communication packets. I've read many of the posts from people with this same problem, but have not found an answer. One addition detail that was not mentioned in any of the other threads is that The problem started when I added a secure cert

Re: MySQL Searchable Mailing List Archive now up.

Hi guys, I think i've already pointed this out but im also archiving ALL of the mailing lists from mysql at http://www.mysqldeveloper.com/lists/ Tony Buckley wrote: > > - Original Message - > From: "Robert Alexander" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, Decemb

Re: MySQL Searchable Mailing List Archive now up.

- Original Message - From: "Robert Alexander" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. > So, being 'between contracts' right now, I decided finally to > write one. I've actually been ke

Question on mySQL replication

Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you. ---

importing from text base file with "|" delimiters

Hi, How can I import a text file database in which delimiters are "|" character field separated into mysql database? -- *** Phillip B. Bruce *** *** http://pbbruce.home.mindspring.com

RE: row count for multiple tables.

* Nissim Lugasy > How do I retrieve the count for multiple tables with one sql command? describe select * from t1,t2,t3,t4,t5 where t1.id=t1.id; You will get the table names in the 'names' column and the row counts in the 'rows' column. -- Roger ---

Re: dbi accessor for mysql_insertid

$dbh->mysql_insertid() Rich Duzenbury wrote: RD: Date: Fri, 14 Dec 2001 14:15:36 -0600 RD: From: Rich Duzenbury <[EMAIL PROTECTED]> RD: To: [EMAIL PROTECTED] RD: Subject: dbi accessor for mysql_insertid RD: RD: Statement handles appear to have an accessor method to ret

mysqlgui

hi in the help file of mysqlgui we find that it has the functions for: - Generating a menu with table fields based on tables that the user has choosen - Parametrized queries, where the user can put any number of ?var? strings and getting a dialog with all ?var? specified, so that inputed values

MySQL Searchable Mailing List Archive now up.

Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being 'between contracts' right now, I decided finally to write one. I've actually been keeping an archi

Distribute MySQL with VB App

Hello, Is it possible to distribute a MySQL db with a visual basic application - in other words, use MySQL as the backend DB for a Visual Basic app? Karl Stubsjoen www.excelbus.com/info-m - Before posting, please check: h

Smalltalk and mySQL

Anyone have any experience of using mySQL within Smalltalk servers on a unix/linux platform? Any decent links? I am just exploring this now as I have heard there is now a Smalltalk mod for Apache. This sounds like a fun combination to play with! thanks, Tony ---

row count for multiple tables.

How do I retrieve the count for multiple tables with one sql command? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Fw: timestamp additional info

At 12:18 -0800 2001/12/14, Steve Osborne wrote: > Timestamp additional info: > > INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) >VALUES ('$NameID','1','$RegNumc','NULL'); > >ProdRegDate is the field that I want to timestamp. (Again, I've tried > passing '', NULL, and 'NULL'). > > St

dbi accessor for mysql_insertid

Statement handles appear to have an accessor method to return the last insert id: $new_id = $sth->insertid; But I cannot seem to locate one for the database handle. The closest I have found is the $new_id = $dbh->{'mysql_insertid'}; In the case of a $dbh->do(...) where there is no statement h

Re: timestamp additional info-SOLVED

Thanks, it is working perfectly as described Steve > Don't reference the timestamp column at all in your INSERT (or future > UPDATE) statements and the timestamp should update just fine on its own. > > i.e. > INSERT INTO Owners (NameID,ProductsKey,RegNum) > VALUES ('$NameID','1','$RegNum

RE: timestamp additional info

mysql> CREATE TABLE tblTEST ( -> KeyValue int(10) NOT NULL default 0, -> DataValue varchar(255) default NULL, -> LastEdited timestamp(14) NOT NULL, -> PRIMARY KEY (KeyValue) -> ); mysql> insert into tblTEST (KeyValue, DataValue) values( 1, 'Hello'); Query OK, 1 row affect

Re: timestamp additional info

You are inserting the string 'NULL' Don't include it at all in the insert. Steve Osborne wrote: > Timestamp additional info: > > INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) > VALUES ('$NameID','1','$RegNumc','NULL'); > > ProdRegDate is the field that I want to timestamp. (Again,

Re: Fw: timestamp

You have not shown us what you are doing, only described it. Write a test case that creates a table with a timestamp field, populates the table, and does a select on it. Show us what you are doing, and the results. Steve Osborne wrote: > I've tried passing nothing '' and NULL and 'NULL', and s

Re: timestamp additional info

Don't reference the timestamp column at all in your INSERT (or future UPDATE) statements and the timestamp should update just fine on its own. i.e. INSERT INTO Owners (NameID,ProductsKey,RegNum) VALUES ('$NameID','1','$RegNumc'); BTW, you cannot change the default for a timestamp column - it is

Re: Coredump when running scripts/mysql_install_db

On Fri, 14 Dec 2001, Michael Widenius wrote: > > Hi! > > > Michael> A couple of others have reported this in the last month. I reported what > Michael> I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43 > Michael> built from source with gcc 2.95.3 according to the instr

RE: MySQL v.s. Oracle

On Thu, 2001-12-13 at 03:54, Robert Sundström wrote: > queries, with medium sized transactions (3-5 statements per transaction, > where transactions was supported). On my regular desktop box I was able to > get about 700 statements per second using MyISAM and about two thirds of > that using In

Fw: timestamp additional info

mysql (filter) Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve -

Re: sub selects

At 12:50 -0800 2001/12/14, Joel Wickard wrote: >can you perform sub selects in mysql? The quick answer is "coming soon." Please see: http://www.mysql.com/doc/D/i/Differences_from_ANSI.html and http://www.mysql.com/doc/T/O/TODO_future.html HTH /Rob ~ Rob

timestamp additional info

Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL

Re: Fw: timestamp

I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In response to Mikel, the field is declared as NULL and default is NULL. I've experimented with changing the Null and Default columns in phpMyAdmin, but it stays as NULL and default as NULL. Steve. > > Steve Osborne wrot

RE: timestamp

How are you storing data to the record? It should be: CREATE TABLE mytable ( mydata int NOT NULL, timestamp timestamp ); INSERT INTO mytable VALUES(123,NULL); UPDATE mytable SET mydata=456; -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 200

Re: sub selects

As far as I know, not yet Joel Wickard wrote: JW: Date: Fri, 14 Dec 2001 12:50:39 -0800 JW: From: Joel Wickard <[EMAIL PROTECTED]> JW: To: [EMAIL PROTECTED] JW: Subject: sub selects JW: JW: can you perform sub selects in mysql? JW: JW: JW: --

Re: Fw: timestamp

Steve Osborne wrote: > > Rick, > > > Just add a field of type TIMESTAMP to your record. Whenever the field is > added or updated, this field will be updated as well. > > > The field is already a 'timestamp(14)' type field, but all that is being > stored in the fields are zero's

RE: sub selects

no -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: sub selects can you perform sub selects in mysql? - Before posting, please che

Re: sub selects

no, but you can acheive the same results please consult the manual http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Etienne Joel Wickard wrote: > > can you perform sub selects in mysql? > > - > Before posting, please

Fw: timestamp

Rick, Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this?

sub selects

can you perform sub selects in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]>

RE: timestamp

You've answered your own question. Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 12:48 PM To: MySQL (E-mail)

timestamp

Is there a way that will allow a mysql database automatically add the current timestamp to a record when the record is added to the database? Would formatting it through php be useful, and if so, does anyone know how? Thanks, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROT

Re: Troubles with Mysql + InnoDB

Hi! I tried with 3.23.47, and the script did not fail. The assertion failure means that adding of a foreign key constraint fails because of some error number which should not happen. You could modify and recompile MySQL so that mysql/innobase/dict0crea.c, line 1237, would print the error code:

RE: Changing location of database files

If you use a premade one - maybe... but if you create one from scratch with only the datadir variable, then it shouldn't. But if you create one from scratch, at least print out a premade one and make sure you create it correctly. You may also want to examine the command you use to start MySQL. It

Re: installing solaris binary

Re: MySQLGUI At 17:05 +0200 2001/12/14, Sinisa Milivojevic wrote: >Very soon there will be a new executable available. Great news! Thanks very much, Sinisa. /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http

Re: MySql forum or newsgroup

At 10:30 2001-12-14 -0600, Philip Molter wrote: >On Fri, Dec 14, 2001 at 11:14:00AM -0500, Etienne Marcotte wrote: >: Sorry but I've never seen a mailing list archive really working.. > >That's a fault of mailing list archive designers, not mailing list >archives. [snip] I agree. Besides, and mo

RE: Changing location of database files

Jonathon wrote: "You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it." Only problem is that the server is up and running p

Re: Table Exists

If you want to check before creating a table: CREATE TABLE IF NOT EXISTS table_name; If you want to do it before deleting: DELETE TABLE IF EXISTS table_name; [EMAIL PROTECTED] wrote: : Date: Fri, 14 Dec 2001 11:34:26 -0500 : From: [EMAIL PROTECTED] : To: [EMAIL PROTECTED]

RE: Table Exists

If you're using PHP, there should be a function for it. You can also use IF NOT EXISTS in your table commands like: CREATE TABLE IF NOT EXISTS, so that you don't overwrite anything. What also might come in handy here is either SHOW TABLES (provided you're in the right database), or DESCRIBE tabl

RE: Changing location of database files

You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it. Read the first two parts of this chapter (they're short) for a few mor

RE: Table Exists

Mysql>show tables; Would be the easy way Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:34 AM To: [EMAIL PROTECTED] Subject: Table Exists What is the e

locking with BDB tables

I am trying mysql-max 4 with BDB table types and transaction-isolation-level=READ-COMMITTED. When I do an update/delete in one session the table row is locked until rollback or commit for all other sessions. Should this be the case, and if not how do I get round this? Regards, Simon Simon Bur

Table Exists

What is the easiest way to check if a table exists in the current database? I checked the documentation, and couldn't find anything (but maybe I missed it). Glen - Before posting, please check: http://www.mysql.com/manual.ph

RE: [PHP] Performance

My first guess is that you have a problem with MySQL restarting frequently. If you have a bunch of problems, it might restart in the middle of a script... Try turning on logging on the MySQL server and see if it's restarting frequently. Second guess would be that there was a problem with either t

Re: MySql forum or newsgroup

On Fri, Dec 14, 2001 at 11:14:00AM -0500, Etienne Marcotte wrote: : Sorry but I've never seen a mailing list archive really working.. That's a fault of mailing list archive designers, not mailing list archives. : No good search feature, hard to follow a thread (next by thread, next by : date, et

Changing location of database files

I've tried searching for the file that gives the location of the database directory, but am unable to find it. Without physically altering that directory is there any other way of changing the location of the database directory? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-

Re: Order By number of rows returned ?

Create temporary files instead, in that case you don't have to worry about DROPing the tables, they will get dropped as soon as the mysql session is closed. Girish Nath wrote: GN: Date: Fri, 14 Dec 2001 15:29:38 - GN: From: Girish Nath <[EMAIL PROTECTED]> GN: To: Johnny Withe

Re: MySql forum or newsgroup

I agree. I think the forum is a great idea. - Richard - Original Message - From: "Etienne Marcotte" <[EMAIL PROTECTED]> To: "Philip Molter" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 11:14 AM Subject: Re: MySql forum or newsgroup > Sorry but I've never s

Re: MySql forum or newsgroup

Sorry but I've never seen a mailing list archive really working.. No good search feature, hard to follow a thread (next by thread, next by date, etc) Plus to post you need to be member of the mailing list, therefore receive 400 emails a day... On a forum you register, you post only when you hav

DISTINCT problem

Hello, i've the db of CD Titles which among others contains tables: Titles Songs SongAuthors SongIntereprets Persons I need to perform queries which outputs a set of Titles matching the criteria which restrict either or all of the tables. If I make a join of the tables with restrictions on ea

Re: MySql forum or newsgroup

On Fri, Dec 14, 2001 at 07:16:40AM -0800, Jason Rowski wrote: : Hi, : : I willing to build and host a free mySQL discussion : forum/newsgroup for the mySQL community. I have web : space available and can easily build a discussion : forum using vbulletin and mySQL in a couple of days. : : Does th

Re: MySql forum or newsgroup

I also think it would be a great idea, my mail box is filling up even with filtering!! Jo - Original Message - From: "Jason Rowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 7:16 AM Subject: MySql forum or newsgroup > Hi, > > I

MySQL on OpenBSD 3.0 - got signal 14

Hi - I have MySQL 3.23.42 running on OpenBSD 3.0, Pentium III, 256mb ram. MySQL was installed with the following commands: pkg_add mysql-client-3.23.42.tgz pkg_add mysql-server-3.23.42.tgz mysqladmin reports the following: -- mysqladmin Ver 8.21 Distrib 3.23.42, for unknown-openbsd3.0

Re: Order By number of rows returned ?

Hi Thanks for that, it works really well :) Best Regards Girish - Original Message - From: "Johnny Withers" <[EMAIL PROTECTED]> To: "'Girish Nath'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 3:03 PM Subject: RE: Order By number of rows returned ? > I'm

Re: Coredump when running scripts/mysql_install_db

Hi! Michael> A couple of others have reported this in the last month. I reported what Michael> I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43 Michael> built from source with gcc 2.95.3 according to the instructions in the Michael> manual. I believe the problem is that

Re: possible bug?

anti spam words: database,sql,query,table you can first put it here to be sure it's a bug be specific, showing table definitions, query that is not working please provide OS, mySQL version, any relevant information Etienne "Karl J. Stubsjoen" wrote: > > database,sql,query,table > > Hello, >

Re: MySql forum or newsgroup

If benjamin and all other "gurus" read/post on the webforum, sure I'd like it, since it's not easy to manage hundreds of emails a day... Etienne Jason Rowski wrote: > > Hi, > > I willing to build and host a free mySQL discussion > forum/newsgroup for the mySQL community. I have web > space ava

MySql forum or newsgroup

Hi, I willing to build and host a free mySQL discussion forum/newsgroup for the mySQL community. I have web space available and can easily build a discussion forum using vbulletin and mySQL in a couple of days. Does the mySQL community think that we need a discussion forum where all the mysql me

possible bug?

database,sql,query,table Hello, Where is the correct place/procedure to report a possible bug? I think I found one. Karl Karl Stubsjoen excelbus.com/info-m - Before posting, please check: http://www.mysql.com/manual.php

RE: Order By number of rows returned ?

I'm not sure if you can do this all in one query.. I tried a few JOINs, and nothing seemed to work. However, I'm not up to speed on how to join things together to get the best results. However, you can do it by creating a temp table: create table tmp01( web_account char(4) not null default '

Re: installing solaris binary

Kristof Cossement writes: > Hi, I am delighted with the fact there is a mysql GUI for solaris, > > BUT I cannot get it installed, > > I downloaded the binaries from the mysql site Sun Solaris 2.7 Sparc static > binary of MySQLGUI 1.6 > > , and got a .gz file, which is perfectly unzippable. > >

Re: [PHP-DB] MYSQL query help

It's not the IN, it's the sub-query you cannot use. MySQL doesn't support them and it's just about the main reason I don't like it. Alternatives? You could execute your subquery and return the results to an array. Loop through the array, using the index and the indexed element to drive a serie

installing solaris binary

Hi, I am delighted with the fact there is a mysql GUI for solaris, BUT I cannot get it installed, I downloaded the binaries from the mysql site Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 , and got a .gz file, which is perfectly unzippable. But then I have one file, that is not execut

Re: Join Problem

Dave Butler wrote: > I am struggling with a join query using MySQL 3.23.31 under AIX 4.3.3. > Here are the tables involved: > > select CAT.linenum, CAT.acct, FD.amount > from sched_acct_cat CAT LEFT JOIN fd FD > ON CAT.acct = FD.acct > where CAT.sched_acct = 'INC_STMT' > AND FD.entity='FMCI'

Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

Trond Eivind =?iso-8859-1?Q?Glomsr=F8d?= writes: > Robert Alexander <[EMAIL PROTECTED]> writes: > > > >Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > > > >> Ron Jamison writes: > > >> > Using MySQL 3.23.46 from: > > >> > > > >> > http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unkno

Re: MYSQL query help

Harpreet writes: > I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative > that would work? > > select * from lib_asset_tbl where material_id <>'' and asset_id in (select > asset_id from lib_copy_tbl) > > Help is appreciated. > > Regards, > Harpreet Kaur > Software Develop

MYSQL query help

I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id <>'' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. ---

Join Problem

I am struggling with a join query using MySQL 3.23.31 under AIX 4.3.3. Here are the tables involved: CREATE TABLE sched_acct_cat ( sched_acct varchar(8) NOT NULL default '', linenum int(11) unsigned NOT NULL default '0', acct varchar(8) default NULL, label varchar(40) default NULL, ind

Re: MySQL Complient Certification

Hi. On Fri, Dec 14, 2001 at 02:57:52PM +0600, [EMAIL PROTECTED] wrote: > > I want to know is there any certification saying that a particular > package/program is MySQL complient...? I don't think so. Bye, Benjamin. -- [EMAIL PROTECTED]

RE: query

I posted this in a previous mail, but one method would be to use phpmyadmin (web based). Download it at http://www.phpwizard.net Another method would be mysqldump. Cheers Ed -Original Message- From: yogesh deshmukh [mailto:[EMAIL PROTECTED]] Sent: December 14, 2001 5:48 AM To: [EMAIL

Re: Very Important!!

Hello Eric, it seems you have a little misconception here. But, due to the kind of the topic, let me first clarify that I am just a member of this mailing list and in no way affiliated with MySQL AB (your salutation lets assume that you were not aware that you wrote to a public mailing list). O

Troubles with Mysql + InnoDB

Hi! At run of a script there is an error and the server falls. The script, the log file and my configuration follow. Client output: #mysql -p USTAT < test.sql Password: ERROR 2013 at line 22: Lost connection to MySQL server during query -- begin script ---

Order By number of rows returned ?

Hi I'm trying to do some sorting by relevance on a query. Essentially, i'd like to know if there is way to order the results by number of rows returned or if this is the best i can get and do the rest within PHP? mysql> SELECT web_account, code_short FROM lookup WHERE code_short IN ('U', 'S', 'G

Re: mysql server not starting!

Dipali Chittar writes: > InnoDB: Operating system error no 13 is a file operation "perror 13" will tell you that it's a permission problem. Check your file permissions and ownership, as indicated by the installation notes. BTW, your time seems to be off by 12 hours. Unless I'm mi

Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

Trond Eivind Glomsrød writes: > Robert Alexander <[EMAIL PROTECTED]> writes: > > > I know that, but I'm pretty sure sourceforge is one of their mirrors. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > Yes, it should be one of our mirrors. I truly do not know whether files are exact copy.

  1   2   >