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,
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.
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 BY
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,
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
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 again, but
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 manual
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 wrote
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 operator.
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 already in
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
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 BY
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
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
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
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 BY
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*'
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.
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 foreign key:
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 two
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).
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 Dobson
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 is a means
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
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
the
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
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
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
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
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 it
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:
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 PROTECTED]
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
[...]
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
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
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
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
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
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
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.
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 report (cf
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:13 AM
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
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
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
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 field?
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 need
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 the
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 report
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
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
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
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 correctly I can
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
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
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
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 mysql
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 .
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
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
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
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 #
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.
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
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
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
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 we're
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
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 gg
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
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)
Try
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?
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
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? Do you
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
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 outline
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
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 more
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't
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
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 blue '
1
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)
=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
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 [EMAIL
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
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
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
compared
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 don't
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 u,
raw_data
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:
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,
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 example)
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
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
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
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
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
Hello Karl,
Try the 'FULLTEXT' section of the manual. I've used the fulltext index to create a
search engine for a mailing list archive, and I'm quite pleased with how it works.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
/Rob
Karl J. Stubsjoen wrote:
Hello,
I need to create a
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 blue '
1'no''bla cirkel' 'dette er ei bla cirkel'
2
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
HTH,
/Rob
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 ...
1 - 100 of 142 matches
Mail list logo