What's better with assumption

Hi, All I've CGI Application using C/C++ Assume that connection establishment by client and MySQL database server is very fast, what's better between : - Persistent Connection - Non Persistent Connection Because as CGI application it's difficult to use persistent connection, excep

table corrupted after an error free load

Hi, Sorry to disturb, but I cannot find any answer in online doc and web archive. >Description: I insert 34000 rows in a simple table with all text fields, and myisamchk tells the table is corrupted, while a select into outfile does not give any error compared to the original file. >H

Re: Alphabetizing book titles

Hi. Try this: SELECT title FROM titles ORDER BY IF(SUBSTRING(title,1,4)="The ",SUBSTRING(title,5), IF(SUBSTRING(title,1,2)="A ",SUBSTRING(title,3), IF(SUBSTRING(title,1,3)="An ",SUBSTRING(title,4), title))); But in version 3.23.36 the next: SELECT title FROM titles ORDER

Re: innodb inserts/select crash

Hi! You are getting a lock wait timeout error, not a crash. In the newest version 3.23.44 code 101 has been replaced by a native MySQL error number 1205 and a descriptive message. >Hi there. > >Can anyone offer a solution to this problem. >CREATE TABLE `raw` ( > `cid` int(11) default NULL,

update from table x to table y

Hi does anyone know of a way of taking some data from one table and updating another table with it? If MySQL doesn't support it i'm gonna have to go back to Access or something! thanks Rich _ Get your FREE download of MSN Explor

Re: order by, group by

Looks like no one knows the answer to this question... - Original Message - From: "Christian Andersson" <[EMAIL PROTECTED]> To: "MySQL Mailing list" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 10:30 PM Subject: order by, group by > I asked before, but got no answer, so I ask aga

Re: Problem: myisamchk: error: Checksum for key....

On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: > Grzegorz Paszka writes: > > > > Yes, I say more, that I created new database and filled it by perl script from >data source and I have the same situation. I think that is the best way of rebuild >index file :) > > See in our

Re: Problem: myisamchk: error: Checksum for key....

Grzegorz Paszka writes: > On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: > > Before I wrote to this list I read manual. Especially chapter 4.4 . > > I've done what You suggested but it didn't help. (Stage 3: Difficult repair). > That's one problem. > > Another is as I wrot

Re: Fulltext search variable

Hi! On Nov 13, Christopher Thorpe wrote: > Hi Sergei > > Sorry to post off list to you, not sure what else to do... I've posted to > the list twice but received no reply at all to my query. I'm doing a whole > load of MATCH AGAINST queries, but have no luck at all in using the > truncation opera

Re: update from table x to table y

Rich, >Hi >does anyone know of a way of taking some data from one table and updating >another table with it? >If MySQL doesn't support it i'm gonna have to go back to Access or something! >thanks > >Rich Sinisa is right now writing a multi-table update to 4.0. Some updates can be handled alread

Solution for testing PHP/MS Access on Linux

Hello, some days ago I asked help on this list because I have to develop and test on Linux/Apache some PHP pages that will have to run on on an IIS/NT box. On the real server the pages must manage a MS Access database via ODBC (this mixed setup cannot be changed: explanations in the original mess

Re: order by, group by

> Looks like no one knows the answer to this question... =or we don't want to state the obvious/seem rude when saying "RTFM" 7.19 SELECT Syntax "All keywords used must be given in exactly the order shown above. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER

Re: update from table x to table y

> Hi does anyone know of a way of taking some data from one table and updating > another table with it? > > If MySQL doesn't support it i'm gonna have to go back to Access or > something! Rich =only "go back" to Access if you're a glutton for punishment! =try MySQL/HTMLmanual/manual_Referen

Re: order by, group by

mysql On Mon, 12 Nov 2001, Christian Andersson wrote: > Is it possible in myslq to do an order by before an group by? For me it is not clear why would you want to do that. Can you give an example? -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Cam

mysql 4 alpha

hi! is there anybody, who knows of a site or documentation about the new features of mysql? maybe also articles or whatever? or is there even someone who already made some testing with the new alpha version? greetings christian _ Do You

Re: order by, group by

DL Neil writes: > "All keywords used must be given in exactly the order shown above. For example, a >HAVING clause must come after > any GROUP BY clause and before any ORDER BY clause." As far as I understood the original post, the question was if there's a way to get MySQL to perform an ORDER

RE: Fulltext search variable

Hi Sergei Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get the same results... we've actually got the ft_min_length set to 2 as we have a few authors whose surnames are Li (and we've found no major performance issues). I'd tried a few longer words before like 'genom*' fo

Re: order by, group by

On Tue, 13 Nov 2001, Carl Troein wrote: > As far as I understood the original post, the question was if > there's a way to get MySQL to perform an ORDER BY prior to > doing the GROUP BY. Yes it was but "prior to" does not make much sense and that is why I asked the original poster for an example.

how do you find out which table fields are foreign keys?

I created the "persons" and "shirts" tables as described in the MySQL tutorial: http://www.mysql.com/doc/e/x/example-Foreign_keys.html such that the "owner" field in shirts is a foreign key referencing the "persons" table. However, "describe shirts" does not indicate that the field is a fore

why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

http://www.mysql.com/doc/n/o/node_357.html explains the different string data types and the storage requirements: Column Type Storage required [...] VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255 [...] TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8 [...] These t

Re: Fulltext search variable

Hi! On Nov 13, Christopher Thorpe wrote: > Hi Sergei > > Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get > the same results... we've actually got the ft_min_length set to 2 as we have > a few authors whose surnames are Li (and we've found no major performance > issues).

Re: update from table x to table y

thanks for that, but that will add a row as opposed to updating a column won't it? I don't want to insert a new row. All I want to do is update a value in table1 if it is present in table2 cheers Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PROTECTED]> >To: "Richard D

RE: Hash Tables / Indexes

> From: Karl J. Stubsjoen > Hello, > > Can someone explain hash tables or hash indexes and if we can > take advantage > of them in MySQL? > > Thanks! > > Karl A few words on a meaty subject... Hashing is a search method based on an arithmetic or algorithmic transformation of the key. Hashing i

RE: Fulltext search variable

Hi Sergei and everyone... Thanks for the help... looking forward to 4.0.1!! best wishes Chris -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:30 PM To: Christopher Thorpe Cc: [EMAIL PROTECTED] Subject: Re: Fulltext search variab

Re: update from table x to table y

Duplicating values (cf keys) in tables involves de-normalisation and is therefore not recommended. Your observation row cf column is correct. I felt the question was sufficiently broad to risk interpreting "update" as wider than "UPDATE", sorry - the other response seemed to hit that nail on t

Re: order by, group by

Im trying to make a "data" system that is language-independent, ie the data stored can have any language therefore the same information is stored several times but with different values (depending on language) lets say that I have this table.. articles(id,language,name,description) what I would

Re: Can't connect via IP, but can via hostname

I notice you didn't have the time to look it up either. Rick Emery wrote: > Help the guy out by telling him WHERE in the manual to look. Answers, such > as "Please read mysql manual, your question covered by manual." are of no > help. > > -Original Message- > From: Abu @ Trabas Dot Com

Re: order by, group by

Thank you for your responce, you have guessed it correctly the only difference is the usage of MAX which I cannot use (see my explenation on what I want to do in a seperate message) I'm not sure IF I can do it with sub-selects either, but when subselects is present in mysl, I could try that one..

RE: Can't connect via IP, but can via hostname

Help the guy out by telling him WHERE in the manual to look. Answers, such as "Please read mysql manual, your question covered by manual." are of no help. -Original Message- From: Abu @ Trabas Dot Com [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 11:33 PM To: [EMAIL PROTECTE

Re: Need to understand mysql mechanisms

Hello S! > I am sending this mail in order to get things straight > about table corruption which I am experiencing with > 4.0(as well as previous versions). > > 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, > AHA29160N SCSI controller OK, so this is a possibly a 'fairly' new box, meaning

Re: Can't connect via IP, but can via hostname

Gerald Clark writes: > I notice you didn't have the time to look it up either. And neither did you. This is getting seriously silly. :-) To see the original question, look at the bottom (weird, I know) of this message. To see an answer, look here: http://www.mysql.com/doc/C/a/Can_not_connect_t

Re: update from table x to table y

Hi, thanks dn, so, to confirm, there is no MySQL to represent the following?: update Raw,Unresolved_Duplicates_perm set Raw.Inactivate = 1 where Raw.Key_num = Unresolved_Duplicates_perm.MinOfKey and Raw.Peak1=0 Thanks Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PRO

RE: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

> http://www.mysql.com/doc/n/o/node_357.html > > explains the different string data types and the storage requirements: > > Column Type Storage required > [...] > VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255 > [...] > TINYBLOB, TINYTEXT L+1 bytes, where L < 2^

Re: Can't connect via IP, but can via hostname

Carl Troein writes: > http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Oops. That only convers the difference between 'localhost' and anything else. If whoever posted the question is interested in actually getting things to work, read the manual chapter on how the privilege system wo

Re: it shows columns when it should only show tables ( mysql client )

Hi. It's been a while, but here it goes... As far as I know, the mysql command line client does not know about commands, i.e. the name completion feature (via TAB) is _not_ context sensitive and will just present all completions which fit to the word fragment you typed. So, without knowledge wh

QUERY HELP - IF THEN ELSE

Hi... I want to output results based on the query from 3 tables ( described here ) TABLE 1 SUBID (SAME AS IN TABLE 2) ID FILE DATE DISCIPLINE (SAME AS IN TABLE 3) TABLE 2 NAME SUBID (SAME AS IN TABLE 1) TABLE 3 NAME EMAIL

why ever use TINYBLOB/TEXT -- isn't VARCHAR same size? (fwd)

Carsten H. Pedersen writes: > I assume that there is a small speed penalty in using TEXT/BLOB > fields, as compared to VARCHARs. I recall seeing some test where TEXT was actually faster, but it might have been in some special situation. On the whole, I think that being able to specify a length

RE: QUERY HELP - IF THEN ELSE

I'm trying to determine what you want displayed from your SELECT. I see 3 different displays that you want: a. SUBID,t1.ID,t1.FILE,t1.DATE,t1.DISCIPLINE,t2.NAME,t2.SUBID b. t3.DISCIPLINE,t3.NAME,t3.EMAIL c. table2.NAME,table3.NAME, table3.EMAIL Which do you want? -Original Message---

How to decrement int field?

Hello, I would really appreciate some help on this, thanks! I have a colomn with days_left, an integer. I have to write a Perl script to run on a cron job once a day and decrement all the fields in that column by 1. Is there a query to do this? Sincerely, Gil. -- http://planenews.com PGP pu

Re: order by, group by

Hi. If I understand correctly what you want to archieve, this is covered in the tutorial part of the manual: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html and the short answer is "no, only with temporary tables, until sub-queries are implemented". Bye, Benjamin.

Re: order by, group by

> Im trying to make a "data" system that is language-independent, ie the data > stored can have any language therefore the same information is stored > several times but with different values (depending on language) =Is this correct? "data" ~ news reports/magazine articles "article" ~ a news repo

Re: innodb inserts/select crash

What does this mean. How can I fix it. It seems silly that I have to read data out just to write it back in again instead of using the create...select command. Rich - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 10:1

Re: How to decrement int field?

Gil G. writes: > I have a colomn with days_left, an integer. I have to write a Perl > script to run on a cron job once a day and decrement all the fields > in that column by 1. Is there a query to do this? I'll leave the the cron job and perl script to you, but decrementing something is done

RE: How to decrement int field?

UPDATE mytable SET myvalue = myvalue-1 WHERE some_condition -Original Message- From: Gil G. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:23 AM To: [EMAIL PROTECTED] Subject: How to decrement int field? Hello, I would really appreciate some help on this, thanks! I hav

Timezone offset question

I have a data collection script which rolls raw data into a formatted table, based on year/month/day. I've been requested to roll up this raw data based on a different timezone - 3 hours behind - to better coincide with reports from a company in that timezone. This is the rollup SQL query we cur

RE: Securing username and password in script file

Our php users run their scripts under their own username. this requires the performance hit of treating php like any other cgi script (no mod_php) but they are on a shared server because they are a low volume site. On Sun, 11 Nov 2001, Peter Lovatt wrote: > Date: Sun, 11 Nov 2001 10:20:11 -

RE: How to decrement int field?

Update table set days_left = days_left- 1 where days_left > 0 [and other conditions]. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > m] On Behalf Of Gil G. > Sent: Tuesday, November 13, 2001 11:23 AM > To: [EMAIL PROTECTED] > Subject: How to decrement int f

RE: Hash Tables / Indexes

> From: Karl J. Stubsjoen > Imagine: a table with over 200,000 records in it and one of > the fields in > the table is a keywords field. Keywords seperated by commas. > The keyword > field is a collection of keywords that our clients use to identify the > content of their web pages. > What we

Re: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

At 4:07 PM + 11/13/01, Carl Troein wrote: >Carsten H. Pedersen writes: > >> I assume that there is a small speed penalty in using TEXT/BLOB >> fields, as compared to VARCHARs. > >I recall seeing some test where TEXT was actually faster, but >it might have been in some special situation. On t

Re: order by, group by

> > Im trying to make a "data" system that is language-independent, ie the data > > stored can have any language therefore the same information is stored > > several times but with different values (depending on language) > > =Is this correct? > "data" ~ news reports/magazine articles > "article"

UTF-8

If I understand correctly I can load data in UTF-8 to a MySql database that was compiled with character set (Latin-1). In all of the documentation that I looked at there is an indication that due to the lack of direct Unicode support in MySQL the use of the data which is stored in UTF-8 will be p

Re: innodb inserts/select crash

Rich, a fix is to analyze the locking behavior of your database and try to find out why the locking SELECT has to wait long times. But I think the OUTFILE - INFILE trick is easier. Inside MySQL the fix would be to log individually rows inserted by CREATE ... SELECT ... But I am not responsible f

Re: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size? (fwd)

At 16:07 + 2001/11/13, Carl Troein wrote: >//C - with a runny nose, a cup of tea, and a glass of Laphroaig ...for medicinal purposes, of course. :> My choice was McClellands, when reduced last week to a sorry-ass blob of protoplasm by the worst cold I've had in years. Feeling much better

RE: UTF-8

Hi Yes I do. There is no problem with this, except sorting etc. Bu search is ok. Regards Daniel Las > -Original Message- > From: Dana Sharvit [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 6:35 PM > To: '[EMAIL PROTECTED]' > Subject: UTF-8 > > > If I understand correctl

Re: how to do increments in parallel

The solution is fairly easy. In you update statement you place something like this : update table set valuefield = newvalue where keyfield = key and valuefield = oldvalue after the update you check affected rows. if affected rows = 0 then it means that somebody else already changed the valuefiel

Same table aliased twice causes infinite loop

I am running MySQL 3.23 on Windows 2000. I have a SQL statement which looks fine to me, although it does reference the same table twice. Here it is: SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u, raw_data d, raw_groups g, raw_groups gg WHERE u.forename = d.forename AND u

File permissions

Hi All! i tried the load_file after changing the File_priv in the user table of mysql database for a particular user 'user1'... insert into ecg_datafile values(1,1,load_file('/home/Venu/fr1w.jpg')); ERROR 13: Can't get stat of '/home/Venu/fr1w.jpg' (Errcode: 13) i get the following error, can a

binlog to a full disk loses updates

>Description: Writing to the binlog doesn't stall the update process when the disk is full. >How-To-Repeat: Turn on binlogging. Fill the disk. Do a few updates. Flush logs. Observe binlogs looking like this: -rw-rw1 mysqlm

Permission problem

I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every other database. After creating this new database now when i try to type in USE MYSQL, it changes to the mysql database . An

max_connect_errors & security behind a firewall

What is the security concerns about incresing the number of max_connect_errors? And if I am behind a firewall and the server is only accessed by only one machine, in the case it=B4s accessed only by the webserver. I have to admit that I dont understand the purpose of a too low default number for

Re: order by, group by

Christan Andersson wrote: >lets say that I have this table.. articles(id,language,name,description) >what I would like to do is retrieve 1 row per unique id in the chosen >language > >select * from articles where language='en'; > >that is quite simple, unfourtunally, not all articles have the de

Re: Timezone offset question

Start the server with the desired TZ set. Jeremy Wilson wrote: > I have a data collection script which rolls raw data into a formatted > table, based on year/month/day. I've been requested to roll up this raw > data based on a different timezone - 3 hours behind - to better coincide > with rep

Re: Access to MYSQL via ODBC?

Hello all, I just installed a Suse 7.2 Linux, with MySql.. MySQL runs, but when i try to access it, i get the following message: cleopatra:/usr/bin # mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) cleopatra:/usr/bin # mysq

Re: Timezone offset question

At 01:07 PM 11/13/01 -0600, Gerald Clark wrote: >Start the server with the desired TZ set. That's all fine and good, but difficult switch back and forth every 10 minutes while that query runs for local data, then for the remote data. -

RE: Permission problem

I typed show Grants for root@localhost; and saw that the root has all permissions other then select. I can delete , insert data into the tables of all the databases but cannot select. How can i give the root@localhost 'select' permissions. show grants for root@localhost displays: Grant insert,upd

RE: Same table aliased twice causes infinite loop

Yes, MYSQL allows the same table to be aliased twice or more in a select -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 12:35 PM To: [EMAIL PROTECTED] Subject: Same table aliased twice causes infinite loop I am running MySQL 3.23 on Win

Joins with priority

Hi, I have two tables, and I want to join them based on some priority rules: If some special values exist in the joined subset, join all of those values, otherwise join the first occurence of some other special value, if that value also does not exist, join the first occurence of a third v

Re: My Book (WAS Re: MySQL Developer's Handbook)

On Mon, Nov 12, 2001 at 01:36:45PM -0800, Jeremy Zawodny wrote: > Just *today* I signed a contract with O'Reilly & Associates to write > "Advanced MySQL" which I've begun working on. The goal is to have it > out in the 2nd half of next year. We've been discussing it for a few > months now, and w

Can't Compile DBD::mysql

Hi Everybody There! I'm being tryng to install DBD::mysql but I ever get this answer, even I recompile perl with the same gcc in this same box, I wasn't the problem so the file 'blib/arch/auto/DBD/mysql/mysql.so' is there on the source tree. Has someboby an idea? Thanks in advance. -Jose Alb

Re: Same table aliased twice causes infinite loop

Nick de Voil writes: > I am running MySQL 3.23 on Windows 2000. > > I have a SQL statement which looks fine to me, although it does reference > the same table twice. > > Here it is: > > SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u, > raw_data d, raw_groups g, raw_groups

Re: Hot Backups

If your database is large enough then any sort of hot backup will lock the tables for too long. The method I use is to use LVM to take a snapshot of the MySQL partition while MySQL is stopped. All my attempts to snapshot a live MySQL database resulted in inconsistent results... The following is

Re: File permissions

the mysql account under which the server runs does not have permission to read the file or its directory. Venugopal Allavatam wrote: > Hi All! > i tried the load_file after changing the File_priv in the user table of > mysql database for a particular user 'user1'... > > insert into ecg_datafi

Cannot access my MySQL

Hello all, I just installed a Suse 7.2 Linux, with MySql.. MySQL runs, but when i try to access it, i get the following message: cleopatra:/usr/bin # mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) cleopatra:/usr/bin # mysql

RE: Access to MYSQL via ODBC?

> cleopatra:/usr/bin # mysql -h localhost -u root -p > Enter password: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > cleopatra:/usr/bin # mysql -h localhost -u root -p > Enter password: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Tr

Introducing hidden row having duplicated primary key

Hello, I think I've found a bug. Just by playing with REPLACE and INSERT, the following happened. I'm including full log, demonstrating that I don't understand sql at all. ;-) Can someone explain me what "2 rows affected" means? How can I select the second row from the table? How can I delete it

Re[2]: Access to MYSQL via ODBC?

Hello Carsten, Tuesday, November 13, 2001, 9:48:56 PM, you wrote: CHP> Try running w/o -p cleopatra:/usr/bin # mysql -h localhost -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) ;( -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Coun

Re: order by, group by

> >will return all articles even if they do not have an english translation, > >BUT here is the problem.. which language will be the one I recieve? > >Svedish? english? French? > > > There seems to be a little confusion here regarding grouping and > ordering. What do you mean by "the one I receive

Re: Introducing hidden row having duplicated primary key

On Tue, Nov 13, 2001 at 08:53:09PM +0100, Martin MOKREJS wrote: > Hello, > > I think I've found a bug. Just by playing with REPLACE and INSERT, > the following happened. I'm including full log, demonstrating that I > don't understand sql at all. ;-) Can someone explain me what "2 rows > affected

Re: My Book (WAS Re: MySQL Developer's Handbook)

On Tue, Nov 13, 2001 at 02:20:59PM -0500, Bob Hall wrote: > > Can I request that you include a chapter on using MySQL with > FreeBSD? If I recall correctly, that's something you should be able > to write about. I probably should talk about some specific OS issues. I'll have to look at the outli

Re: Introducing hidden row having duplicated primary key

Looks correct to me. What do you think is the problem? 2 rows were affected by the replace. One row was deleted, and one was inserted, Both rows had a value of 'test' for column 'Tab'. Martin MOKREJŠ wrote: > Hello, > I think I've found a bug. Just by playing with REPLACE and INSERT, the > fo

Re: Introducing hidden row having duplicated primary key

On Tue, 13 Nov 2001, Gerald Clark wrote: > Looks correct to me. > What do you think is the problem? > > 2 rows were affected by the replace. > One row was deleted, and one was inserted, > Both rows had a value of 'test' for column 'Tab'. Cool, thanks to Jeremy Zawodny and you, now I know even mo

Re: Introducing hidden row having duplicated primary key

On Tue, Nov 13, 2001 at 12:45:17PM -0800, Jeremy Zawodny wrote: > On Tue, Nov 13, 2001 at 08:53:09PM +0100, Martin MOKREJS wrote: > > Hello, > > > > I think I've found a bug. Just by playing with REPLACE and INSERT, > > the following happened. I'm including full log, demonstrating that I > > don

Re: how to do increments in parallel

On Mon, Nov 12, 2001 at 11:29:48PM -0800, Jeremy Zawodny wrote: > On Mon, Nov 12, 2001 at 10:52:39PM -0800, Bennett Haselton wrote: > > Say I have two running programs and both of them periodically want to > > increment a value in a database. How can I do this so that the increments > > will be

Re: order by, group by

Christan Andersson wrote: > what I really want is the following.. > let say that the table (id,language,name,description) where id,language is > the primary key so that 1 id can have several languages > > the data in the database looks like this > > 1'en''blue circle''this is a blu

Show query page by page

Hi, I have a query result with 50 register and i want to show them in 5 pages, every page show 10 register. Thanks , for your answers Rhony - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Re: update from table x to table y

=No there isn't, because: 7.24 UPDATE Syntax UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [ORDER BY ...] [LIMIT #] - there is only 'space' for one tbl_name in the UPDATE clause. =I've had a quick look around. I'm su

Re: Cannot add blob data to innodb table

On Mon, 12 Nov 2001, Heikki Tuuri wrote: > Date: Mon, 12 Nov 2001 09:06:42 +0200 > From: Heikki Tuuri <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Cannot add blob data to innodb table > > Steve, > > >Date: Mon, 12 Nov 2001 08:52:54 > >To: [EMAIL PROTECTED] > >From: Heikki Tuuri <[

replication errors (broken binlog-do-db?)

>Description: I have two DB servers that we will simply call MASTER and SLAVE. MASTER is started with --binlog-do-db=DB1 so that only DB1 will be replicated to SLAVE. When SLAVE is initially started everything seems normal, in that all update/delete/insert/etc. queries are propogated to

myisamchk -a + indexes + hidden...?

It seems like myisamchk -a is hosing some statistic in a MyISAM table that gets re-created and stored permanently as once a query is run that uses that index, it always runs well until myisamchk -a is run again even between restarts of mysqld. It also seems that key_buffer_size has no effect on t

Re: table corrupted after an error free load

Riccardo Cohen wrote: > Hi, > Sorry to disturb, but I cannot find any answer in online doc and web archive. > > >Description: > I insert 34000 rows in a simple table with all text fields, and myisamchk >tells the table is corrupted, while a select into outfile does not give any error >c

Re: Timezone offset question

Jeremy Wilson wrote: > At 01:07 PM 11/13/01 -0600, Gerald Clark wrote: > >Start the server with the desired TZ set. > > That's all fine and good, but difficult switch back and forth every 10 > minutes while that query runs for local data, then for the remote data. The way I deal with it (and I d

Re: Same table aliased twice causes infinite loop

Sinisa Milivojevic wrote: > Nick de Voil writes: > > I am running MySQL 3.23 on Windows 2000. > > > > I have a SQL statement which looks fine to me, although it does reference > > the same table twice. > > > > Here it is: > > > > SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users

Re: Show query page by page

Auri Net SAC wrote: > Hi, > > I have a query result with 50 register and i want to show them in 5 pages, > every page show 10 register. LIMIT (see the manual) will help you. b. mysql - Before posting, please check: http:/

Re: Show query page by page

On Tue, Nov 13, 2001 at 04:24:47AM -0500, Auri Net SAC wrote: > Hi, > > I have a query result with 50 register and i want to show them in 5 > pages, every page show 10 register. Then you want to use the LIMIT option on your SELECT queries as shown in the manual. Jeremy -- Jeremy D. Zawodny, <[

Re: Search Engines

"Karl J. Stubsjoen" wrote: > Hello, > > I need to create a search engine out of a few MySQL tables I should > say: I need to search MySQL records like a search engin might. However, my > first go ended up as a complete failure because it is highly un-optimized to > search for (as an exampl

Re: Timezone offset question

> >Start the server with the desired TZ set. > > That's all fine and good, but difficult switch back and forth every 10 > minutes while that query runs for local data, then for the remote data. =Agreed you must stick with either one or the other, right? =Wrong! To fix the problem of different of

RE: myisamchk -a + indexes + hidden...?

Analyzing a table requires looking at every record in the table. If the table you are dealing with is a large one then there is a good chance that after analyzing the table your disk cache will not contain the records that you are trying to grab. Once you run the query it will almost certainly c

How to Get the New Number inserted in a AutoIncrement Field

I know that this is a old question, but I really need to know how can I get the number that Mysql use in a autoincrement field of a record I just inserted ... Is there any function like LAST_INSERTED or something like that ... Thanks a lot ---

Re: Show query page by page

>Hi, > >I have a query result with 50 register and i want to show them in 5 pages, >every page show 10 register. > >Thanks , for your answers >Rhony http://www.mysql.com/doc/S/E/SELECT.html See 'LIMIT' /Rob -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting

Re: Solution for testing PHP/MS Access on Linux

Hi, - Original Message - From: "mweb" <[EMAIL PROTECTED]> > some days ago I asked help on this list because I have to develop > and test on Linux/Apache some PHP pages that will have to run on > on an IIS/NT box. Regarding wrappers, have a look at http://php.weblogs.com/ADODB The ADODB

  1   2   >