I could not understand what you try to do. But generally mysql runs on a
server machine and the clients connect to it. Every client program you
write can connect to mysql server seperately. If you want and need you
can also write a server program too. But you have to be more clear about
your pr
Hi all,
I think that I should ask the question like that.
I want to run MySQL on 14 client. What am I do. I try but There is a problem
that i can't find... Please help me.
Hüseyin DEMİRAĞ
İstikbal Furniture Int.
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Hüse
On Mon, Jul 21, 2003 at 12:39:59AM -0500, Dan Nelson wrote:
> > >
> > > Create symlinks from the mysql data dir to each user's directory:
> > >
> > > /var/db/mysql/user1 -> /home/hostings/user1/data
> > > /var/db/mysql/user2 -> /home/hostings/user2/data
> > >
> > > etc. Then any table the user
On Wed, 23 Jul 2003, Sam Tregar wrote:
> SELECT a2.name
> FROM alpha AS a1, bravo AS b, alpha AS a2
> WHERE a1.name = 'fred' AND
> a1.id = b.afrom AND
> b.ato = b.id;
Whoops, that last line should read:
b.ato = a2.id;
-sam
--
MySQL General Mailing List
On Tue, 22 Jul 2003, Larry Brown wrote:
> Table alpha:
>
> id int(3) not null auto_increment,
> name char(12) not null,
> Table bravo:
>
> afrom int(3) not null,
> ato int(3) not null,
> in the php variable coming in I have fred and need to run a query to get
> george.
You just need to join f
I've actually noticed this in the past several releases; I apologize for
not mentioning it sooner.
I run:
BUILD/compile-pentium --with-other-libc=/usr/local/mysql-glibc-2.2.5
--prefix=/usr/local --with-extra-charsets=none --without-innodb --without-isam
and part-way through, it fails.
Specifical
Hello
Does any version (production or future) of mysql supports Bookmarks?
Regards
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
Hi again,
Sorry I completely forget the query:
SELECT * FROM Kardex WHERE Fecha IN (SELECT maxfecha FROM fechas)
This is really weird cause I try the same query in SQL form M$ and it
work. Is a simple query and I know that can be rebuild with other query
syntax but the question here is why it does
I need to migrate a 3.23.52 MySQL server to a version with InnoDB (and row
level locking). The catch is, I need to do it in a hurry (by the end of the
week). It is a production system with over 300 users. Some tables have over
2,000,000 rows.
The main question I have is should I take this op
Hi
when you log in to MySQL use
mysql -u root
you will then be asked to enter a password. On a new instalation the
password may be blank - nothing
After that you should be able to create databases.
You might find information about privilages and GRANT usefull
http://www.mysql.com/doc/en/User_A
At 21:56 -0500 7/22/03, Greg Macek wrote:
Hello,
I have a strange question. I'm in the design phase for a table and was
wondering if it's possible in MySQL to force a pair of fields in a
record to be unique within the table. I would like it to look like this:
user_id
job_id
What I'd like to do is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 21:56, Greg Macek wrote:
> Hello,
>
> I have a strange question. I'm in the design phase for a table and was
> wondering if it's possible in MySQL to force a pair of fields in a
> record to be unique within the table. I would li
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 12:28, Ola Ogunneye wrote:
> I am still getting my feet wet on mysql. I, however have seen the MYSQL
> Refereence Manual at the mysql site while I have also seen Mysql
> Cookbook referenced or mentioned in the list.
>
> As a tru
Hello,
I have a strange question. I'm in the design phase for a table and was
wondering if it's possible in MySQL to force a pair of fields in a
record to be unique within the table. I would like it to look like this:
user_id
job_id
What I'd like to do is never have the same user_id and job_id p
I am having some weird problem figuring this seemingly simple query out.
Here are the two tables from which I have to run the query
Table alpha:
id int(3) not null auto_increment,
name char(12) not null,
primary key(id)
example data
1 fred
2 bob
3 sam
4 rita
5 george
6 laura
7 nancy
Table brav
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits followed by a space? If so, field REGEXP '^[0-9]+ ' should
work.
I
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits followed by a space? If so, field REGEXP '^
Quoting Jackson Miller <[EMAIL PROTECTED]>:
> I need to migrate a 3.23.52 MySQL server to a version with InnoDB (and row
> level locking). The catch is, I need to do it in a hurry (by the end of the
>
> week). It is a production system with over 300 users. Some tables have over
>
> 2,000,000
I get the following error when trying to create a database. Being a total
newbie to MySQL I would appreciate any help I can get!
---
[EMAIL PROTECTED] bobo]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129 to s
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Date: Tue, 22 Jul 2003 22:30:03 +0300
From: Doruk Fisek <[EMAIL PROTECTED]>
I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux 2.4.21
on a x8
Why not change VIDEO -> VIDEO_PATH and just use the directory path as a
varchar() field to point you to the file stored on your computer. That way
you don't have to worry about it. Whenever I need to use images or large
files of some type, I just put it in a directory and reference the path to
i
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
I'm currently testing it by doing:
if(abs(left(field,locate(' ', field))>0),'Numeric bit at front', 'Not
Numeric bit at front')
It seems to work.
Well it kinda works. If 'field'
Does your university have a webpage indicating what advice is acceptable and
not considered plagarism?
- Original Message -
From: "Antonio Jose Rodrigues Neto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 9:54 PM
Subj
I am looking for a simple extraction/load program to load data daily from a
Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not
necessarily need to do any data-type transforms. It need to run on Windows
2000 and be able to run it as a service, or as a cron task if running unde
Help me ...
Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All,
I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make
tests using Fibre Channel and iSCSI with MYSQL. Please I will need informations
(cookbook) how does implement tunning on MySQL - Linu
O'Reilly's "Managing & Using MySQL" is a good intro.
--
Ray Thompson
> >
> > As a true novice starting out, can someone tell me which of the two
> > would be best suited for a true newbie
> >
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Yes...
Does it work?
- Original Message -
From: "Bob Ramsey" <[EMAIL PROTECTED]>
To: "Lingua2001" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 10:57 AM
Subject: Re: "between A and B" with another condition?
> Like this?
>
> mysql> select * from t2;
> +
At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote:
Thanks. I have been fighting with this all afternoon, now it seems I
can get to 4.1.0 and not 4.0.13. My databases still seem to be there
but I can't point to them either in mysql or in mysqlcc/DBManager. I
guess I have moved port 3306 to
If you actually get binary data loaded into your table, DO NOT run a
select * from table command.. It will stream out all the data and it's
not pretty..
instead run a select col1, col2, length(binarycol) ..
On Tue, 22 Jul 2003, Steven Wu wrote:
> Hi Jeremy D. Zawodny:
> I did not get any
Yes, that's the problem.
Until now I started the two servers from the command line/batch file/service
and each server had its own my.ini. The two servers are in replication: one
master and another slave. Two days ago I read that I can use a unique my.ini
for the both servers; and MySQL for Windows
Cory,
I'm not sure I understand what you're asking. MySQL casts the data to the
appropriate column type when that data is entered into the database. Data
in a varchar column is always stored as a string, just as data in an INT
field is always going to be of type INT.
-Rob
-Original
Hi,
I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux 2.4.21
on a x86.
CFLAGS="-O2 -march=athlon" CXX=gcc CXXFLAGS="-march=athlon -O2
-felide-constructors" ./configure --prefix=/usr/local/mysql
--with-charset=latin5 --without-docs --with-mysqld-ldflags=-all-static
--disable-sha
1st search list for binary storage to read about pro/cons (been debated
before)
If you still want to do it either use load_file, or a loader
application...
I don't reccomend using longblob to store big files.. Use the 64k blob
and inode/chunk the data.. better for streaming it out if that's wha
Hi Jeremy D. Zawodny:
I did not get any error message. It hust said "zero column change" and
the filed, VIDEO contains NULL data after I give "SELECT * from GAME"
command.
Steven Wu
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Steven Wu" <[EMAIL PROTECTED]>
Cc:
Thanks. I have been fighting with this all afternoon, now it seems I
can get to 4.1.0 and not 4.0.13. My databases still seem to be there
but I can't point to them either in mysql or in mysqlcc/DBManager. I
guess I have moved port 3306 to the 4.1.0 database. How do I name, say,
3307 as the 4.0.
2) Using the Opera browser, I open my pages and it sends variables through
"?var1=value1&var2=value2" perfectly until I tried using a form and
realised I am not getting anything back from $PHPSELF...
try $PHP_SELF
Peter
--
http://www.dragonstalon.co.uk/
Latest news at http://www.dra
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
> Hi Need emergency help:
>
> I am doing some project use the MySQL to store the video file. The
> format of video is either avi or mpg. However I can not successfully
> insert the video file into the cooresponding field of a table by
> us
Your maximum packet size must be greater than the size of the video file.
Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the coorespond
At 12:03 -0700 7/22/03, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not
successfully insert the
video file into the cooresponding field of a table by using the
"LOAD_FILE" func
I think the reference manual is basically what's on the web. The book
you ordered, "MySQL, Second Edition" is indispensible. Since Paul is on
the line, if there's ever a third edition, it would be nice to have the
book and the appendices broken into separate books (they'd be bundled
together at t
At 20:12 +0300 7/22/03, Primaria Falticeni wrote:
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two configurat
At 14:45 -0400 7/22/03, Ola Ogunneye wrote:
Hi Paul,
Thanks for the info, but is MySQL, Second Edition the same as the
reference manual? The link you gave me has 3 books and none of them was
the reference manual. Are you saying that I need the reference manual
and then the Second Edition? I just p
At 11:40 -0700 7/22/03, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
In this case, the "type" of the column as far as MySQL is concerned
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the cooresponding field of a table by using the "LOAD_FILE" function.
Does anyone know how to store video
At 11:30 -0700 7/22/03, MySQL wrote:
While watching a realtime data acquistion system's MySQL table fill, I
routinely run "mysql> SELECT * FROM TABLE". After 300+ rows scroll by [in
text mode under *nix], I've usually lost track of which column [out of
23] belongs to what datafield.
Is there an op
At 19:22 +0100 7/22/03, Anthony Hart-Jones wrote:
1) Windows ME seems incapable of applying passwords to usernames.
On my webspace, I can only log into the SQL database if I include
the password. On my WinME PC, only if I do NOT give a password.
The platform on which you run the MySQL server mak
Hi Paul,
Thanks for the info, but is MySQL, Second Edition the same as the
reference manual? The link you gave me has 3 books and none of them was
the reference manual. Are you saying that I need the reference manual
and then the Second Edition? I just purchased the Second Edition from
Amazon.
T
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Date: Tue, 22 Jul 2003 13:28:09 -0400
From: "Ola Ogunneye" <[EMAIL PROTECTED]>
As a true novice starting out, can someone tell me which of the two
would be b
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
Example:
Select
If(is_float(col1), 'is a float', 'not a float') as
typ
While watching a realtime data acquistion system's MySQL table fill, I
routinely run "mysql> SELECT * FROM TABLE". After 300+ rows scroll by [in
text mode under *nix], I've usually lost track of which column [out of
23] belongs to what datafield.
Is there an option to have the "mysql" tool repea
I found MySQL Cookbook really good for figuring out how to solve a problem -
good if you are coming from another database, or have a list of specific
problems.
I haven't read MySQL Reference Manual, but I have read Mastering MySQL 4 - I
thought it was quite good.
Head to your local book store, an
As Paul DuBois mentioned, everyone needs the reference manual. But it
is just that, a reference manual not a tutorial.
Paul's MySQL book I thought was excellent. I skipped the first first
few chapters which went over relational concepts, but it walks through
just about everything, including you
1) Windows ME seems incapable of applying passwords to usernames. On my
webspace, I can only log into the SQL database if I include the password.
On my WinME PC, only if I do NOT give a password.
2) Using the Opera browser, I open my pages and it sends variables through
"?var1=value1&var2=val
At 19:50 +0200 7/22/03, PaT! wrote:
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
-+
At 13:28 -0400 7/22/03, Ola Ogunneye wrote:
I am still getting my feet wet on mysql. I, however have seen the MYSQL
Refereence Manual at the mysql site while I have also seen Mysql
Cookbook referenced or mentioned in the list.
As a true novice starting out, can someone tell me which of the two
woul
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
-+
| id | int(11)
At 10:26 -0700 7/22/03, Richard Sumilang wrote:
I did a find for it and found...
-
# find / my.cnf | grep my.cnf
/etc/my.cnf
/etc/virtualhosting/templates/mysql/etc/my.cnf
/etc/my.cnf.admin_appl
/home/virtual/site1/fst/etc/my.cnf
/home/virtual/site2
Thnks a lot
Patrizio
-Messaggio originale-
Da: Egor Egorov [mailto:[EMAIL PROTECTED]
Inviato: lunedì 21 luglio 2003 14.02
A: [EMAIL PROTECTED]
Oggetto: Re: myisamchk -R
"PaT!" <[EMAIL PROTECTED]> wrote:
>
> I need a hint how to use myisamchk
>
> I use this syntax in a shell but it doe
how can i change the data type of a table? I'm not sure if that is my
problem. If anyone is interested here is a link what I've been trying to
do:
http://www.phpbuilder.com/board/showthread.php?threadid=10248279&goto=newpost
Thanks for any help given!
H
I am still getting my feet wet on mysql. I, however have seen the MYSQL
Refereence Manual at the mysql site while I have also seen Mysql
Cookbook referenced or mentioned in the list.
As a true novice starting out, can someone tell me which of the two
would be best suited for a true newbie
Th
I did a find for it and found...
-
# find / my.cnf | grep my.cnf
/etc/my.cnf
/etc/virtualhosting/templates/mysql/etc/my.cnf
/etc/my.cnf.admin_appl
/home/virtual/site1/fst/etc/my.cnf
/home/virtual/site2/fst/etc/my.cnf
/home/virtual/site3/fst/etc/my.c
David,
- Original Message -
From: "David Bernick" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 22, 2003 8:02 PM
Subject: mysql crashing regularly
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
your database is corrupt. It is trying to access a page at 8
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two configuration files is needed?
Iulian
- Original Messa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We're doing a select query on our INNODB database.
Linux 2.4.21 on x86 (Athlon). Mysql is 4.0.13. Anyone seen this problem before?
- -
InnoDB: Error: trying to access page number 538587904 in space 0
InnoDB: which is outside the tablespace bounds.
I
At 19:37 +0300 7/22/03, Primaria Falticeni wrote:
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the m
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the my.cnf/my.ini 's groups?
Thanks Anticipated,
Iuli
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.14, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
So, CREATE TEMPORARY TABLES only allows the initial create and insert into a
temporary table. Any other privileges like alter, update, delete, and
possibly drop are reserved for real tables and database grants.
Don't get me wrong, I'm glad we have the create temp table grant/option. We
can
OK, now we are both confused.
There is only 1 instance of each unit in the unit
table. Unit_id id the primary key.
There are thousands of instances of each unit in the
log table. Each record in this table holds unit_id,
temperature and date.
If I understand correctly, your suggested q
Lingua2001 wrote:
How can I extract values for "members whose level is below '3', and
their names are between the alphabets 'a' and 'b' "?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not Charlie, or Tom...etc.
I tried a query like
SELECT
"Liu Yang" <[EMAIL PROTECTED]> wrote:
>
> I have met a problem. Look at the following, please.
>
> mysql> grant all on school.* to [EMAIL PROTECTED]/24 identified by "win123";
> ERROR 1064: You have an error in your SQL syntax near '/24 identified by "win123"'
> at line 1
>
> I just want to lim
"Degan, George E, JR, MGSVC" <[EMAIL PROTECTED]> wrote:
> I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0.
> 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try
> to launch mysql it brings me to the old version, how do I access t
Geez, do I have to do all your work for you, :)
First thing I can think of is,
Ok this makes no sence you have a units table with unit_id as its main
descriptor, but there can be several cases with the same unit_id but you
want the one with the max date. Date on the other hand is stored in
anoth
Peter Gorelczenko <[EMAIL PROTECTED]> wrote:
> Good Morning,
> I'm running Alpha 4.1 on Linux. I'm new to MySql but familliar with other
> databases. I set up a user with "Create Temporary Tables" permissions. That
> user can create temp tables but can not alter or update the table. That
>
Like this?
mysql> select * from t2;
+-++
| name| number |
+-++
| bob | 3 |
| bob | 2 |
| bob | 1 |
| al | 1 |
| al | 2 |
| al | 3 |
| al | 4 |
| adam| 4 |
| adam| 3 |
| adam
Hi,
On Tue, Jul 22, 2003 at 02:37:14AM -0500, Lingua2001 wrote:
> How can I extract values for "members whose level is below '3', and
> their names are between the alphabets 'a' and 'b' "?
> For example, one of the results should be 'Alex', whose level is '1'.
> Or 'Bob', whose level is '2'. But n
- Original Message -
From: "Lingua2001" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 10:37 AM
Subject: "between A and B" with another condition?
> Hi there,
>
> How can I extract values for "members whose level is below '3', and
> their names are between the a
Hi,
On Tue, Jul 22, 2003 at 11:30:47AM -0400, Mojtaba Faridzad wrote:
> thanks Fred! that's better. actully I took a field with one character but
> it's better to run SELECT '1' FROM
>
> as I know, if there is not ORDER BY in the query, mySQL doesn't need to
> check all records and retreives
Hi there,
How can I extract values for "members whose level is below '3', and
their names are between the alphabets 'a' and 'b' "?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not Charlie, or Tom...etc.
I tried a query like
SELECT uid FR
Good Morning,
I'm running Alpha 4.1 on Linux. I'm new to MySql but familliar with other
databases. I set up a user with "Create Temporary Tables" permissions. That
user can create temp tables but can not alter or update the table. That
user is getting "Update command denied to user..." for
thanks Fred! that's better. actully I took a field with one character but
it's better to run SELECT '1' FROM
as I know, if there is not ORDER BY in the query, mySQL doesn't need to
check all records and retreives LIMIT number of them. I checked speed with
limit and without limit, limit was fas
I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0.
4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to
launch mysql it brings me to the old version, how do I access the new one without
killing the old one? (I have also tried p
Hi,
On Tue, Jul 22, 2003 at 09:40:31AM -0400, Mojtaba Faridzad wrote:
> for example:
>
> SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
>
> in this query, mytable and mycondition are variable and on run time, they
> are changed. I use this query to jump to the last page of a grid fo
Hello,
I coded a program by using VB 6.0 I will use this program on network(nearly 12
user). is it necessary to code two different program for both of server and client.
Or, Can I solve this problem by MYSQL Control Center.
Hüseyin DEMİRAĞ
İstikbal Furniture İnt.
at least on MyISAM table doesn't work. even it worked, still mysql should
have counted all possible records and then found the max.
If you check the manual, somebody on 2nd of October 2002 had the same
question but nobody answered to it.
http://www.mysql.com/doc/en/Counting_rows.html
- Origi
On 22 Jul 2003 at 9:30, gerald_clark wrote:
> If you are using MYISAM tables, count(*) does not scan the table to
> get the count.
That's only true if you have no WHERE clause and thus are counting
all the rows in the table. That doesn't seem to be what the original
poster is doing.
--
Keith
Would that help at all - since the COUNT(*) would execute fully and then
MAX would limit it? (or is the order of operations different than that?)
-M
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:26 AM
To: Mojtaba Faridzad; [EMAIL PROTECTE
Mojtaba Faridzad wrote:
First of all, I don't wanna let the query run to the end and after that,
count the number of records. as I mentioned, some tables are huge and takes
a long time to run COUNT(*) query for all records.
About LIMIT, it doesn't effect on COUNT query. but for the second query
a LIMIT will not work in any case with COUNT since you will always get exactly one row.
and what shall a LIMIT 1 on 1 row do here?
but you can try the MAX function here: (i guess it exists :)
SELECT MAX(COUNT(*), 10001) as numfound FROM mytable WHERE mycond;
-yves
-Ursprüngliche Nachri
-Ursprüngliche Nachricht-
Von: "Victoria Reznichenko" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Dienstag, 22. Juli 2003 11:56
Betreff: Re: Limiting query time
> Troy Hakala <[EMAIL PROTECTED]> wrote:
> > Is it possible to limit the query time in MySQL (3.x or 4.0)? For
> > e
First of all, I don't wanna let the query run to the end and after that,
count the number of records. as I mentioned, some tables are huge and takes
a long time to run COUNT(*) query for all records.
About LIMIT, it doesn't effect on COUNT query. but for the second query (
retreiving a field ) I c
Hi All,
I have a database consisting of 2 tables.
patient_info ( Patient Information ).Looks like
lastname VARCHAR(10)
fname VARCHAR(10)
ssno INT(9) PRIMARY KEY
IDINT(4) AUTO_INCREMENT
patientins_info ( PatientInsurance Information)
insco VARCHAR(10)
insid VARCHAR(10)
--- [EMAIL PROTECTED] wrote:
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> I'm working for my owner, who can be reached
> at [EMAIL PROTECTED]
>
> To confirm that you would like
>
>[EMAIL PROTECTED]
>
> added to the mysql mailing list, please send
- Original Message -
From: "Liu Yang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 5:00 PM
Subject: how can I use a subnet mask to limit
> Hello, mysql,
>
> I have met a problem. Look at the following, please.
>
> mysql> grant all on school.* to [EMAIL PROTECT
Hello, mysql,
I have met a problem. Look at the following, please.
mysql> grant all on school.* to [EMAIL PROTECTED]/24 identified by "win123";
ERROR 1064: You have an error in your SQL syntax near '/24 identified by "win123"' at
line 1
I just want to limit liuxin from some limit hosts to acces
- Original Message -
From: "Mojtaba Faridzad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 4:40 PM
Subject: Re: how to limit COUNT(*)
> for example:
>
> SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
>
> in this query, mytable and mycondition are v
At 9:25 +0100 7/22/03, Marek Lewczuk wrote:
> the correct syntax is WITHOUT quotes and WITHOUT spaces.
--ft_min_word_len=2
or
-O ft_min_word_len=2 <-- but -O is obsolete
but not
-O 'ft_min_word_len = 2'
But we want to set this variable in my.cnf, so the syntax shouldn't be
like
for example:
SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
in this query, mytable and mycondition are variable and on run time, they
are changed. I use this query to jump to the last page of a grid form.
sometimes the query may have more than million records and I want to give a
war
I have a table containing the fields unit_id,
temperature and date. This has data for around 20
units, with many 1,000's of records for each.
Further information on each unit is in another table
with just 1 entry per unit.
I need to select the most recent record for each unit
together with its ass
If you are using the result set as part of an application, you could select,
then count the rows or use a function such as in PHP : mysql_num_rows()
Jerry
- Original Message -
From: "Mojtaba Faridzad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 1:08 PM
Subjec
1 - 100 of 118 matches
Mail list logo
