Two questions

Hi Q1: I've upgraded our mysql db from 3.23.43-1 to 3.23.46-1 on our Red Hat Linux 7.2 I used the binary rpm distribution. I had to keep our database up and running while I upgrading so I used the --force switch to upgrade the server (the old client always complained for dependecies problem).

Using ActiveX on Delphi

Hello, Does MySQL handles the ActiveX controls on Delphi? I have an web page and I would like that the client's request that will come to the MySQL server to open the ActiveX control in Delphi and then the results to be returned back to the client. Thank you. Kind Regards, Marian Strejac, CRS

MySQL Complient Certification

Hi all, I want to know is there any certification saying that a particular package/program is MySQL complient...? Thank You in advance. Yasela - Before posting, please check: http://www.mysql.com/manual.php (the

Re: READ LOCK Question.

Hi. On Thu, Dec 13, 2001 at 11:57:35AM +, [EMAIL PROTECTED] wrote: Hi all, This is in regard to setting up replication, I do not wish to shut down the master so I noticed I can do FLUSH TABLES WITH READ LOCK and then tar up the databases. I tried this on a non-critical machine and

query

Hello Sir, I am using mysql version 3.22(windows based). I wanted to know whether there is any tool to convert database of above version to the linux based mysql database. If so plz tell me where should I find such a tool. Thanking you waiting for reply Yogesh Deshmukh

Re: Binary data with embedded nulls (mysql_real_escape_string problem).

On Fri, 14 Dec 2001, Ian Collins wrote: I am having difficulties with entering binary data from a c program. I have passed the string through mysql_real_escape_string. Post the C data then. However read on. . . . drop table if exists junk5; create table junk5 ( id int not null,

Re: Heap Tables

Hi. On Thu, Dec 13, 2001 at 03:50:01PM +0200, [EMAIL PROTECTED] wrote: is it possible to insert many rows into a heap table? Yes. By the way, why didn't you simply try out yourself? I'm not sure how from the documentation. The same way as with other table types. If not, are there other

Transaction Safe Tables

Hi We want to create Transaction Safe tables in order to use the commit roolback options in MySql. How do I crate a Trasaction Safe table in MySql Thanks in Advance Ananth __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all

UNIQUE in InnoDB

I have found a problem with UNIQUE in InnoDB. Example: mysql CREATE TABLE b ( - idB int(11) NOT NULL auto_increment, - valor int(11) default NULL, - PRIMARY KEY (idB), - UNIQUE KEY valor (valor) - ) TYPE=MyISAM; Query OK, 0 rows affected (0.00 sec) mysql INSERT

Re: Replication

Hi. On Thu, Dec 13, 2001 at 09:05:46AM -0500, [EMAIL PROTECTED] wrote: [...] I have read the Replication section of the MySQL manual and I think I have a basic understanding of how the replication is being handled, but one thing I am a bit concerned about on the two local servers is latency.

RE: Why MySQL GUI download don't work?

Are you trying to use a download manager?. If so .. it didnt work for me. Disable it, and it will work. vicente -Mensaje original- De: Alex Shi [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 12 de diciembre de 2001 23:46 Para: [EMAIL PROTECTED] Asunto: Why MySQL GUI download don't

Re: Searching for the configuration file

Hi. Depending on from what source you installed MySQL, there may be none yet and you have to create it (I think this is the case for the RPMs). The places where MySQL looks for the file are listed here: http://www.mysql.com/doc/O/p/Option_files.html Bye, Benjamin. On Thu, Dec 13,

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

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

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

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

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

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:

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]

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,

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-unknown-linux-gnu-alp Try a

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

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

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

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

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

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 available

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

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

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

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

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

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

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

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

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

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

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,

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

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:

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

RE: Table Exists

Mysqlshow 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

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

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

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

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 more

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

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.

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:

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

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

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]

Fw: timestamp

Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip 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

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

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

Re: Fw: timestamp

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

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

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

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

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

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 instructions

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

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

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, I've

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 affected

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','$RegNumc');

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

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'). Steve Hi

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

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

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:

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 ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an

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

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

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

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

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.

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 ahem 'between contracts' right now, I decided finally to write one. I've actually been

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, December 14,

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

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

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

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

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

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

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: 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]' Subject: Re:

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: 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 trying to use

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 to

Re: mysqlclient.lib compiling problem

At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the winsock.h 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

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,

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

  1   2   >