Re: Utilizing the Database Server's Cache

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Jeremy Zawodny writes: >> >> Monty recently proposed some changes to MySQL's client/server protocol >> which will enable "real" prepared statements. So I'd guess it'll >> happen somewhere in the 4.x tree. >> >> > Al

Re: MyISAM API

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Wendy Dillon writes: >> Hi everyone, >> >> I realise that a number of people have already asked this but as it was a >> while ago thought more info may now be available: >> >> Is there any documentation for the MyISA

ORDER BY bug; must also select column that is being ordered by

Hi! Luke> Description: Luke> Luke> I have a table full of pages for a church website I am developing. Each has Luke> some data (text) and a title, page id, updated (date) and created(date). I Luke> want to select a list of pages with their id and title and updated date Luke> according to when

Re: MySQL licencing [id:fns]

On Mon, 2001-10-29 at 05:41, Gabor Penoff wrote: > Hi folks, > > We'd like to distribute a commercial software - written by ourselves > - and we'd like to use MySQL as the SQL server solution. > The question is: do we need to buy MySQL server licence or not? > I read the MySQL licening page somet

RE: FW: pls help for index problem

hey, >Well, how many records are in the table? How many would be returned by the >query you present? My prefered (gw) table have 8313193 records for trail (on production should have 70,000,000 records approximately ) . And no. of records are returned have 71430 records by the query. >Is the S

Re:difficulty compiling v4 --without-innodb

Did you mean V4 must ran with innodb? Oh! I have bad experience with innodb. It ate a lot my hard disk space. SF At 23:30 28/10/2001 -0500, jim barchuk wrote: >Hello Heikki! > > > you probably should > > > > #undef HAVE_INNOBASE_DB > > > > in some file, maybe sql/handler.h > > Search with gre

Can not load database

Hello mysql I have been give the database files for a mysql database that I can not get to open and display records. I have run myisamchk, isamchk, mysqlcheck, mysqldump and all return the "header does not support check/repair" or I do get a bytesec error when I try to do the isamchk Data recor

Re: 3.23.43 fails merge test ON make test of src.

Michael Widenius wrote: > Hi! > > > "R" == R Talbot <[EMAIL PROTECTED]> writes: > > R> Hi! > > "rjtalbo" == rjtalbo <[EMAIL PROTECTED]> writes: > > rjtalbo> I am using Mysql 3.23.40 on Linux kernel 2.2.14 Caldera.. > > > > R> Thanks for the response. > R> I did discover .. mysql-test-ru

RE: Help On Load Data File

Hi Calvin, Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html and search for "Warnings". A paragraph probably of particular interest to you is: "Warnings occur under the same circumstances as when values are inserted via the INSERT statement (see section 6.4.3 INSERT Syntax), except that

Help On Load Data File

Hi list member, I have a slight problem here. I am testing on the data convertion from text file into MySQL table. I am able to use the 'load data infile' command and insert the data into the table, however, with 1000 warnings. I don't know where I can see the warning messages ? Can you peop

Re:difficulty compiling v4 --without-innodb

Hello Heikki! > you probably should > > #undef HAVE_INNOBASE_DB > > in some file, maybe sql/handler.h > Search with grep where the above has been > defined. > >Having difficulty compiling v4-alpha --without-innodb. I am -not- a Sure did have that. A bunch of them in different files which is par

Implementing NEXT n BACK page in query

Dear list, I would like to query on the first page only the last 50 records/rows (order by ID desc) in the following script file which uses MySQL, and I want to have NEXT page for the 50 rows earlier than last 50 queried and continue similarly. I think I can use JavaScript for BACK page to go back

Re: [MySQL 4.0.0 core dumps on build]

Stupid damned frigging spam filters... database, sql Forwarded Message: Ed Carp ([EMAIL PROTECTED]) writes: > Ed Carp ([EMAIL PROTECTED]) writes: > > > >Description: > > ./configure;make produces core dump when conf_to_src runs. > > >How-To-Repeat: > > make distclean;./configure;make

MySQL licencing [id:fns]

Hi folks, We'd like to distribute a commercial software - written by ourselves - and we'd like to use MySQL as the SQL server solution. The question is: do we need to buy MySQL server licence or not? I read the MySQL licening page sometimes, but it's still not clean to me. We will use MySQL as a

[MySQL 4.0 compile fails on Linux]

>Description: make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" - DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql \"" -DHAVE_CONFIG_H -I../i

MySQL 4.0.0 getopt.c will not compile on OSF 5.1

>Description: Compilation of MySQL 4.0.0 on OSF 5.1 aborts in getopt.c due to an error in the number of arguments to readv() and writev(). This boils down to the problem that compiling the following 2-line "program" with gcc 3.0.1 on OSF 5.1 screws up the header fi

range bug?

Hi, not sure if this is a known issue (ver 3.23.43 lists a fix called: "Fixed unlikely bug, which returned non-matching rows, in SELECT with many tables and multi-column indexes and 'range' type.") Anyways, when I do a query like: SELECT sum(minutes) FROM stats_2001 WHERE sdate between 'Oct 29

Mutlipe Tables and null values

I hope someone can help me out with this problem I have two tables one for users holding all there info each user has a unique ID. I also have a table that records each transaction each transaction has a unique ID and the ID of the user who made the transaction. I whish to do and SQL query that re

Re: Problem with Batch mode

--- Feny Suha <[EMAIL PROTECTED]> wrote: > Hi all! > I've got trouble when i need to run mysql with batch mode. I can't run it. > I did these following steps > > shell> mysql -u root -p --batch > password : ** > - > > then the screen had no effect. > I do this step too > > shell> mysql -u

[MySQL 4.0.0 core dumps on build]

>Description: ./configure;make produces core dump when conf_to_src runs. >How-To-Repeat: make distclean;./configure;make >Fix: Unknown. >Submitter-Id: >Originator:Ed Carp >Organization: Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~e

Re: Problem compiling MySQL-4.0.0-alpha with charset german1

Stephan Skusa ([EMAIL PROTECTED]) writes: > ./conf_to_src .. german1 > \ > ./ctype_extra_sources.c > make[2]: *** [ctype_extra_sources.c] Error 132 > make[2]: Leaving directory `/usr/src/mysql-4.0.0-alpha/libmysql' I'm running RedHat 6.2 and I'm seeing the same error with "latin1"

RE: problem with update

Hi, You'll need to post your query and the error message to get a meaningful response. Quentin -Original Message- From: Prachi Shroff [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 1:36 p.m. To: [EMAIL PROTECTED] Subject: problem with update Hi all! I am new to MySQl and am

problem with update

Hi all! I am new to MySQl and am having trouble executing an UPDATE statement in a perl script. The same UPDATE statement works fine when used on the prompt. Also, the same perl script executes other statements like SELECT. I am running mysql 3.23.42, perl 5.6.1 on a Windows2000 system. Has an

RE: Data Normalization Paradox

> -Original Message- > From: Ryan Fox [mailto:[EMAIL PROTECTED]] > Sent: 29 October 2001 00:55 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Data Normalization Paradox > > > > Among other criteria, it mentions that in first order normalization > > "No > repeating groups o

Re: Data Normalization Paradox

> Among other criteria, it mentions that in first order normalization "No repeating groups of data are allowed". It then gives a table with 3 rows of data, and shows that one of the columns (company name) has the same entry in two of the rows. It says "this table is not in 1st normal form". For

Re: Compiling C APIs

Douglas Blood ([EMAIL PROTECTED]) writes: > When I try to compile the default MyC API that is on the Contributed API > page I get the following error: > > I believe that the error has to do with the way database.h includes > mysql.h and that it can’t call the methods that are in it. > > /cygdri

Data Normalization Paradox

Hi, This a question for the programmers out there with proper style/form. I'm about to start my first real PHP/MySQL project, and since I want to do it correctly, I got a book to help me. It gives some basic information on RDBM's and mentions an organizational process called normalization. B

Re: PHP Tutorial for total beginner??

> From: "Chip Rose." <[EMAIL PROTECTED]> > Date: Sun, 28 Oct 2001 18:31:29 -0500 > To: [EMAIL PROTECTED] > Subject: PHP Tutorial for total beginner?? > > Can someone suggest a link to a total beginner PHP/MySQL tutorial? I've got > MySQL set up and running (finally!) on Linux, and really need an

RE: PHP Tutorial for total beginner??

http://www.devshed.com/Server_Side/PHP/PHP101 -Original Message- From: Chip Rose. [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 12:31 p.m. To: [EMAIL PROTECTED] Subject: PHP Tutorial for total beginner?? Can someone suggest a link to a total beginner PHP/MySQL tutorial? I've

Re: Table Names

On Sun, 28 Oct 2001 22:59:46 -, "DL Neil" <[EMAIL PROTECTED]> wrote: >>I need to create a series of MySQL tables with numerical value name, which for >>some reason I can't. IE: >>CREATE TABLE 101 ( tagnumber varchar(8) not null default '' ) >>CREATE TABLE 201 ( tagnumber varchar(8) not null d

PHP Tutorial for total beginner??

Can someone suggest a link to a total beginner PHP/MySQL tutorial? I've got MySQL set up and running (finally!) on Linux, and really need an interface for forms inputting of data. So far, I'm setting up a database as a contact manager/sales transaction history manager on steroids, and I'm ext

Re: MySQL Security w/ PHP

Hi! On Oct 28, Kevin Maynard wrote: > I have been building an extensive dB with MySQL for a large Insurance > Company and am nearing the completion stage. I have build several PHP > forms to show the preliminary pages to the various groups who will be > using this dB. > > I have created the

RE: MySQL Security w/ PHP

Have you tried something like SELECT User,Password from user where (User=$ID AND Password($PW)=password); ie. equate the result of password("string") to the stored, encrypted, password Regards Quentin -Original Message- From: Kevin Maynard [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 O

Re: Table Names

I need to create a series of MySQL tables with numerical value name, which for some reason I can't. IE: CREATE TABLE 101 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 201 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 301 ( tagnumber varchar(8) not null default '' ) I've loo

MySQL Security w/ PHP

I have been building an extensive dB with MySQL for a large Insurance Company and am nearing the completion stage. I have build several PHP forms to show the preliminary pages to the various groups who will be using this dB. I have created the sign-in page where each user has types in their I

Re: Table Names

Thanks. Guess I'll need to come up with another naming scheme. :) >>On Mon, 29 Oct 2001 00:48:44 +0100, "Carsten H. Pedersen" ><[EMAIL PROTECTED]> wrote: >>> I need to create a series of MySQL tables with numerical value >>> name, which for >>> some reason I can't. IE: >>> CREATE TABLE 10

Re: Ultimate DB Server

At present, I seem to be running out of time and through my research have come up with the following: - High bus speed. When you have 2GB of ram or something (needed with PGSQL, smart with MySQL), bus speed becomes the bottleneck. Any good processor out there (AMD is new to the SMP market, b

RE: Table Names

> Hello All, > > I need to create a series of MySQL tables with numerical value > name, which for > some reason I can't. IE: > CREATE TABLE 101 ( tagnumber varchar(8) not null default '' ) > CREATE TABLE 201 ( tagnumber varchar(8) not null default '' ) > CREATE TABLE 301 ( tagnumber varchar(8)

Re: Ultimate DB Server

Yeah- I am thinking dual P3-866 on an Asus board (CUV4X-D), 2GB of RAM, striped 18.1GB 7200RPM drives (U160) Linux 2.2.x is probably the way I'm thinking. Seems to be a nice stable place to go for a good locked down server. Of course, nobody is getting shells on it or anything, so it's stri

Re: Ultimate DB Server

I was planning Dual P3-866 with 2GB of RAM running Linux 2.2.x What do you think? - Original Message - From: "Todd Williamsen" <[EMAIL PROTECTED]> To: "'Mike Rogers'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 1:36 PM Subject: RE: Ultimate DB Server > Ram

Table Names

Hello All, I need to create a series of MySQL tables with numerical value name, which for some reason I can't. IE: CREATE TABLE 101 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 201 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 301 ( tagnumber varchar(8) not null default

Re: Mysql extensions

Designmedia writes: > Can sb explain me the difference between *.MYD, *.MYI and *.ISM in MySQL. > What have change between version 3.22 and 3.23 concerning these. The manual does a pretty good job of this, but to summarize, the MyISAM format was added in 3.23 and it's the default table format.

Re:MySQL server has gone away

Yes, Heikki, the error come from the very first SQL statement of my C program Thanks for your help. Pablo --- Heikki Tuuri <[EMAIL PROTECTED]> escribió: > Pablo, > > if your application claims that MySQL server has > gone > away but you can see with the interactive client > 'mysql' > that it

Fw: Mysql extensions

Hi, Can sb explain me the difference between *.MYD, *.MYI and *.ISM in MySQL. What have change between version 3.22 and 3.23 concerning these. Thx in advance Stef - Before posting, please check: http://www.mysql.com/manu

RE: Automatically adding the date to a record.

> Hello > > Whats the easiest way to automatically add the current date to a record > whenever a new record is inserted? I have tried > CREATE TABLE > TimeStamp DATE NOT NULL DEFAULT 'DATE()' > ...); > But this doesn't work. I have tried with TIMESTAMP type instead and > this too doe

Automatically adding the date to a record.

Hello Whats the easiest way to automatically add the current date to a record whenever a new record is inserted? I have tried CREATE TABLE TimeStamp DATE NOT NULL DEFAULT 'DATE()' ...); But this doesn't work. I have tried with TIMESTAMP type instead and this too doesn't work I just g

Re:difficulty compiling v4 --without-innodb

Jim, you probably should #undef HAVE_INNOBASE_DB in some file, maybe sql/handler.h Search with grep where the above has been defined. Regards, Heikki >Hello All! > >Having difficulty compiling v4-alpha --without-innodb. I am -not- a >compiler-gooroo. All I can do is try to decode error messa

Re: Ultimate DB Server

Hey guys, I am also in the same position as this guy. I was wondering if someone could offer up some specs on a server or any good vendors. I will have two servers. Both will be linux. One will be a client/server server for data entry via the internet and the other will be a web server accessed b

difficulty compiling v4 --without-innodb

Hello All! Having difficulty compiling v4-alpha --without-innodb. I am -not- a compiler-gooroo. All I can do is try to decode error messages. Never had a single problem compiling earlier versions -or- 4-alpha -without- --without-innodb. All of the above happens under both gcc-2.95.3/RH7 rpm and

RE: insert BLOB in perl

Hi, I am guessing that you default MySQL's charset to big5. Switch to latin1 and try to insert the image again. See if the error still persists. Why this error exists is beyond my knowledge though. I am guessing that Perl DBI escapes ' \ in bind_param call. And MySQL escapes the data again when

RE: SELECT Query in PHP

Congrats on getting to 48 hours - let us know which platform you prefer when you reach the number of hours that it took to get the 'Must Consult Some Else' tag! :-) QB -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Saturday, 27 October 2001 5:48 p.m. To: 'Mike'

Re: Ultimate DB Server

- Original Message - From: "Todd Williamsen" <[EMAIL PROTECTED]> To: "'Mike Rogers'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 9:36 AM Subject: RE: Ultimate DB Server > Ram plays a big factor in queries, most queries a

Re: mySQL and E-Commerce ?

Jon Shoberg wrote: > > Anyone have a list of major e-commerce companies that use mySQL for > 'significant' website and backend functions? > > Thanks > > - > Before posting, please check: >http://www.mysql.com/manual.php (

mySQL and E-Commerce ?

Anyone have a list of major e-commerce companies that use mySQL for 'significant' website and backend functions? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Optimizing query (2nd attempt)

Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username="testuser", I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 David

Re: Optimizing query (2nd attempt)

rows The rows column indicates the number of rows MySQL believes it must examine to execute the query. - Original Message - From: "David Wolf" <[EMAIL PROTECTED]> To: "Tore Van Grembergen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 5:09 PM Subject: Re: Optimiz

Re: Optimizing query (2nd attempt)

I seem to have fixed it.. I ran myisamchk on all the tables--and now the indexes work as expected.. Very strange indeed.. Though, there is a strange twist now: explain reports fewer rows to be checked than are displayed with the query runs.. Is that normal? David - Original Message - Fro

Re: Optimizing query (2nd attempt)

How do you do a compound index to index between two tables? David - Original Message - From: "Tore Van Grembergen" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 8:57 AM Subject: Re: Optimizing query (2nd attempt) > maybe y

Re: Optimizing query (2nd attempt)

maybe you heva to declare a compound index with userid and username. the sql parser now does not use the index on username. - Original Message - From: "David Wolf" <[EMAIL PROTECTED]> To: "Tore Van Grembergen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 4:46 PM

Bug with Insert Delayed in MySQL 4.0 ?

Hi, A quite strange bug just occurs with MySQL 4.0 : When I execute show processlist, I get : mysql> show processlist; +---+-+---+++--+ ---+ --

Re: Optimizing query (2nd attempt)

Yes.. There is an index on users.username :) David - Original Message - From: "Tore Van Grembergen" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 8:46 AM Subject: Re: Optimizing query (2nd attempt) > do you have an index de

Re: Optimizing query (2nd attempt)

do you have an index defined on users.username ? - Original Message - From: "David Wolf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 4:26 PM Subject: Optimizing query (2nd attempt) > I have a query as follows: > > SELECT log.entity, log.action, > LEFT(u

Optimizing query (2nd attempt)

I have a query as follows: SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.

MySQLGUI hangs on certain commands

I've been trying to play with MySQLGUI lately (running the win32 version of the GUI, Linux version of the server). I can connect fine. Run queries fine. But, when I try to do any grants on a database or edit a table, the client connects to the server as many times as it can (before the server runs

Problem with Batch mode

Hi all! I've got trouble when i need to run mysql with batch mode. I can't run it. I did these following steps shell> mysql -u root -p --batch password : ** - then the screen had no effect. I do this step too shell> mysql -u root -p -B password : ** - this had no effect too. Please gi

Grouping some data, not grouping others?

My project is a database of locations, searchable by multiple keywords. When a user searches the database a selection list of possible locations appears. A location will appear in the list once for each photo of that location. If the user selects an item from the list they are shown detaile

Python/mysql problem

Experiencing a weird problem retrieving an mxDateTime value from a mysql db in a Python script using the MySQLdb module. Here's what I'm doing, roughly: connection = MySQLdb.connect(db = DB_NAME) cursor = connection.cursor() cursor.execute('select date_entered, description ' 'fr

Re: Access Denied

On Sun, 2001-10-28 at 13:52, Anoop Gupta wrote: > Error: 1045 - Access denied for user: 'root@' (Using > password: NO) > > > Can you please help me out for the same.. Check out the manual. There are some good chapters about this: http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql

Access Denied

Hi Everybody, I am new to mysql. I am using mysql on my remove server. I am able to login to Mysql server with user root and passowrd is nill. mysql> prompt appear but when using mysql database it gives error message ie : Error: 1045 - Access denied for user: 'root@' (Using password: NO) Can

Anyone worked with the new 4.0 on RH6.2?

Having problems getting the server started. First mysql_install_db reported that resolveip can't resolve my servers host name (of cowa) bla bla bla but this means I only have to use ip addresses in my grant stuff. Fine but the problem is that mysql_safe --user=mysql starts then stops... that's a

Re:MySQL server has gone away

Pablo, if your application claims that MySQL server has gone away but you can see with the interactive client 'mysql' that it still is up and works if you submit new queries, then the problem is probably in your C application program. Please post the relevant C code here. Maybe some reader spots

RE: innodb problem (with JDBC/transactions)

Erik, please send me the lock monitor output. Version 3.23.44 has a better monitor where it is easier to correlate who locked what. But the way to proceed with an older lock monitor is to run individual SQL statements and look what they lock. In a single user environment all locks should be due t

Re: insert BLOB in perl

Hi, Jeremy Thanks for your response. I got the following message while running perl script. -- output -- processing DCP_0260.JPG size=148135 DBD::mysql::st execute failed: You have an error in your SQL syntax near '9ÿ\0 ¨Ý¦»;ßÈïÓõ,EÂ~9íÒ¬(9àJS~PÃve ‹Ï®G`Z¾NÒXã;ã\0çúÓºwéÓQtWîCÏ' at line 1 at .