Hi,
How do i insert binary data into a BLOB field??? Like , if i
have a table with say 3 fields of which 1 is blob type, now how do
i store some binary file in that particular field??? Please help
me out as i have to look put for some corresponding function in
C++ API after that.Thank You
Hi!
On Jul 13, Alexander Newald wrote:
Hello,
I have a table with id (char(8)) and value (int(8))
To make my problem clear:
There is no set with id = 20030713
insert into table values (20030713,10);
The next set is (20030713,20) but as a set with 20030713 is
already available I
Hi,
As a newcomer to this mailing list -- and to the MySQL database environment
-- my main field of interest is the use of Spatial data. Before I start
dropping my questions (a have a few) all over this list, two quick ones to
start with:
1) For now, is the [EMAIL PROTECTED] the place to discuss
Hi,
does anybody know how to copy a record within one
table? I am looking for some simple method similair to
INSERT INTO orders SELECT * FROM orders WHERE
Order_ID=256; Actually, this method does not work and
I can not believe that MySQL does not offer some
simple method how to do it. Keep in
Hi,
you have to escape your binary data; check mysql_real_escape_string()
function in the manual and the archives. This is a frequently asked
question.
Thomas Spahni
On 14 Jul 2003, Sreesekhar Palaparthy wrote:
Hi,
How do i insert binary data into a BLOB field??? Like , if i
have a
I'm not sure if this is a bug report, possibly a security issue. I have
started getting Too many connections error, but not at times when I would
expect the database to be busy. The worrying thing is that the temp drive
gets completely filled (about 6Gb) with a file called #SQL456.MYD, and
Just take care that you do not cast and or modify your datecolumn in the where clause,
no matter what data type you use. Because then you would loose the index on it. So if
you use int in you applications it might indeed be wise to use int in the DB too.
However when starting a new application,
as far as i know, mysql version 4.0 and previous, do not support subqueries.
Select in select doesn't work.
Have a look in the manual if what u r trying to do is supported.
George Christoforakis.
PS: You don't mention your mysql version. Is this sql the exact command?
- Original Message
I never heard before that you can use a select statement in an arithmetic expression.
Only ALL, ANY, MIN, MAX, =, (and some other which do not come to my mind quickly)
should work.
Anyway, it is considered a subselect and therefore does not work yet. However, in
4.1 you should also be able to
2. 3MB is no problem at all (given that your hardware has free HD space
and that you do not have a quota of say 4MB)
3. with the new version you can also change session parameters on the
mysql command line. Use the keywords GLOBAL and LOCAL for global and/or
local changes. But this implies that
SELECT col1, IF(count(*)!=count(col2),NULL,'BAD')
FROM table1
GROUP BY col1;
This ONLY works EXACLTY for the case you submitted.
Please note that your example is wrong (I think). 3 should also return
NULL, shouldn't it?
/rudy
-Original Message-
From: Christopher Knight
From what I know is, that MySQL always locks the MyISAM table before you
insert, update or delete something from it. So the key here is not so
much if you should lock the table, but how you insert the data (single
inserts vs multi inserts). Multi inserts are the way to go. By locking
the table you
SELECT invoiceid,
IF(count(*)=1,sum(payment),0) pay1,
IF(count(*)=2,sum(payment),0) pay2,
IF(count(*)=3,sum(payment),0) pay3,
IF(count(*)=4,sum(payment),0) pay4,
IF(count(*)=5,sum(payment),0) pay5,
IF(count(*)=6,sum(payment),0) pay6
FROM payment
GROUP
Hello Christopher,
Friday, July 11, 2003, 6:31:33 PM, you wrote:
First select:
The results are just right what you want in your SELECT.
You have 5 different values in COLUMN1 and your select returns them.
From second column SELECT gets first value for each value of first
column.
Second select:
IF the dates are limited and can be agreed upon before running the
kwiri, you can use:
SELECT no,
IF (date=d1, data, NULL) d1,
IF (date=d2, data, NULL) d2,
IF (date=d3, data, NULL) d3
FROM table
GROUP BY no;
It will also NOT work if one date can contain multiple data,
Is there a limit to the number of records I can insert in a multiple-value
insert?
- Original Message -
From: Rudy Metzger [EMAIL PROTECTED]
To: Phil Bitis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:18 AM
Subject: RE: Improving insertion performance by locking
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / / / \/ / /
/_ / /__ / /_ / /_ /
Cell: 083 440 2213
Ph: 021 980 4969
Ive searched the archives, read the books front to back, still haven't
gotten a solution, hoping someone can help here. mysqld has been running
great for me on my RH 6.2 for 6 months. I just did something and screwed
up my tables (I went in and changed a few, ok 200 tables to type BDB from
MyISAM
Hi all.
I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
month, and around 1,000,000 records imported into it. The import process
consists of a 'load data infile' operation, followed by some updates to
extract data and dump it somewhere where it is easier to access ( in the
Not by MySQL (or it is that high it doesn't really matter). Your OS
could put a limit on it with max file size.
Just do yourself a favor and apply \n after every row so that you
can open it with an editor. Otherwise a lot of editors will complain of
line too long.
Cheers
/rudy
-Original
Hello Shazia,
Friday, July 11, 2003, 10:25:56 PM, you wrote:
This is a tipical CROSSTAB QUERY.
http://www.mysql.com/articles/wizard/print_version.html
You also can use MS Access wich automatically suports crosstab query,
to make this kind of report
SF Hi:
SF I have a table with one column as
i have a problem with the check option
for example
create table ex
(
t INT check(t4)
);
but even if i use check(t4) i can insert 5,6,7.all values!:(
why?
Ale
p.s. I'm using 4.0.12 version
Might it be worth looking at the mailing list manager software for this
list? ACCU's mailing lists use Majordomo and add this line to the rfc822
headers:
Reply-To: [EMAIL PROTECTED]
You can still see the sender's email address if you want to reply directly.
--
MySQL General Mailing List
For
Sohail Hasan [EMAIL PROTECTED] wrote:
I want to bring back my mysql original database as well as root GRANTS
as was during the installation because i installed an application that
modified my root GRANTS and now I am not able to see my mysql database
as I login from root account. I am not
Hello George,
Monday, July 14, 2003, 11:46:06 AM, you wrote:
Read this:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
GC as far as i know, mysql version 4.0 and previous, do not support subqueries.
GC Select in select doesn't work.
GC Have a look in the manual if what u r
What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody),
does not any more with mysql 3.23.56 of fink (current-stable,
for fink cf. fink.sf.net) - I am not sure, if this problem is caused
by the mysql version (some security changes between .49 and .56)
or by the fink configuration - I
Craig Westerman [EMAIL PROTECTED] wrote:
I'm trying to help a friend with this. When I run this everything is fine
SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS
NULL
The clicks table has 31 instances of url that match 5 instances of url in
the urls table.
g'day listers
i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i
get a error on the slave. the error is that it cannot insert data into a table that
does not exist. the problem is that the table its complaining about is a tmp table.
that table is created when
Yann GAUTHERON [EMAIL PROTECTED] wrote:
ID_LOGIN is an integer
Can anyone say me if this :
WHERE index1=ID_LOGIN OR index2=ID_LOGIN
must be slower than those 2 queries :
WHERE index1=ID_LOGIN
WHERE index2=ID_LOGIN
for a 20 000 rows table ?
You can rewrite the first query with
Alex82 [EMAIL PROTECTED] wrote:
i have a problem with the check option
for example
create table ex
(
t INT check(t4)
);
but even if i use check(t4) i can insert 5,6,7.all values!:(
why?
Ale
p.s. I'm using 4.0.12 version
CHECK clause does nothing. It's just parsed.
--
For
George Georgeus [EMAIL PROTECTED] wrote:
does anybody know how to copy a record within one
table? I am looking for some simple method similair to
INSERT INTO orders SELECT * FROM orders WHERE
Order_ID=256; Actually, this method does not work and
I can not believe that MySQL does not offer
|+--
|| Victoria Reznichenko|
|| [EMAIL PROTECTED]|
|| sita.net |
|| |
|| 2003-06-05 11:31|
Thanks for taking time to read my email.
This is to announce the launch of a new Linux support forum,
Bringing the power of the Linux community to the African content.
It's free. The resourcese are there to be shared. All you have to do is
register.
Registration is a mere formality to prevent
An idea; Did you try to set user name with ip address of the computer
you are running instead of localhost? I think it is worth to try and
hope it helps.
grant all on myFineDb.* to [EMAIL PROTECTED] identified by abcpass;
[EMAIL PROTECTED] wrote:
What works for me with mysql 3.23.49 of Debian
The MySQL manual mentions that one could specify the column and value separators and
the end of file marker explicitly in the LOAD DATA statement.
I'm looking for the syntax of this statement to import large data files (.txt)
originally exported from Microsoft SQL 7.
Example file:.
Hello group,
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth. Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought that PostgreSQL will be as good as MySQL but
Hi!
George Georgeus [EMAIL PROTECTED] wrote:
does anybody know how to copy a record within one
table? I am looking for some simple method similair to
INSERT INTO orders SELECT * FROM orders WHERE
Order_ID=256; Actually, this method does not work and
I can not believe that MySQL does not
No success either, thank you anyway.
[mac:~] reuleaux% mysql -u root -p***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql grant all on myFineDb.* to
Tom Roos [EMAIL PROTECTED] wrote:
i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i
get a error on the slave. the error is that it cannot insert data into a table that
does not exist. the problem is that the table its complaining about is a tmp table.
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth.
That's a bit of an overstatement!
Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought
Hi!
On Jul 14, Dan wrote:
Hi all.
I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
month, and around 1,000,000 records imported into it. The import process
consists of a 'load data infile' operation, followed by some updates to
extract data and dump it somewhere where
If maximum speed is critical.
It's easy to lose sight of the fact that speed is not the
only criterion
in choosing a DBMS. Features, stability, security, and so on can be
just as important or more so. No single DBMS is going to win all the
prizes; the trick is to find the one with
Marcin Blazowski [EMAIL PROTECTED] wrote:
Marcin Blazowski [EMAIL PROTECTED] wrote:
I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
to
that database. When logon with that new user and want to create a new
user
with some privileges a get an error.
How I do it:
which PostgreSQL version have you testet? If you want compare
MySQL and
PostgreSQL, than you have to use InnoDB tables. Tests with
MyISAM make no
sense. Out J2EE Application is working woth PostgreSQL 7.3.3
and MySQL
4.0.13 with InnoDB tables (we need transactions and
referencial
ahh..
http://www.mysql.com/doc/en/Replication_Options.html:
replicate-wild-ignore-table=db_name.table_name
tks alec
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 14:29
To: Tom Roos
Subject: Re: question: replication of tmp table.
Very smart your opinion, I agree at all with you.
-Mensaje original-
De: Bruce Feist [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 14, 2003 5:37 AM
Para: MySQL List
Asunto: Re: MySQL vs. PostgreSQL -- speed test
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL
If maximum speed is critical.
It's easy to lose sight of the fact that speed is not the
only criterion
in choosing a DBMS. Features, stability, security, and so on can be
just as important or more so. No single DBMS is going to win all the
prizes; the trick is to find the one with
Hi,
Is there any command or function in MySQL to find out how many records a
table has? phpMyAdmin shows the number of records ( Rows ) when shows the
structure of a table plus Row Length more information. How can we find these
table information?
Thanks
--
MySQL General Mailing List
For list
I agree with your opinion in 100%, but in my case I need DBMS with
features like subselectes/utf-8/stored procedures but the
speed is also
very important issue.
You might have to spend money!
You are saying that there is DBMS with all this features and it is as
fast as MySQL ?
--
Hi!
On Jul 14, Andreas Reuleaux wrote:
What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody),
does not any more with mysql 3.23.56 of fink (current-stable,
for fink cf. fink.sf.net) - I am not sure, if this problem is caused
by the mysql version (some security changes between .49
Hello Mojtaba,
Monday, July 14, 2003, 3:57:42 PM, you wrote:
try this:
select count(*) from TableName
MF Hi,
MF Is there any command or function in MySQL to find out how many records a
MF table has? phpMyAdmin shows the number of records ( Rows ) when shows the
MF structure of a table plus
Thanks for everybody's help!!
This way worked for me. Clever!
Chris
... and yes... even my example was messed up
:-P
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 4:15 AM
To: Christopher Knight; MySQL List
Subject: RE: grouping / sorting
Hello Mojtaba,
Monday, July 14, 2003, 3:57:42 PM, you wrote:
If you want you can use /with Windows OS/ MySQL-Front to see some
additionall information for tables and to use it for work area for
some jobs.
MF Hi,
MF Is there any command or function in MySQL to find out how many records a
MF
I agree with your opinion in 100%, but in my case I need DBMS with
features like subselectes/utf-8/stored procedures but the
speed is also
very important issue.
You might have to spend money!
You are saying that there is DBMS with all this features and it is as
fast as MySQL ?
I don't
SELECT COUNT(*) FROM table_name;
[EMAIL PROTECTED] wrote:
Hi,
Is there any command or function in MySQL to find out how many records a
table has? phpMyAdmin shows the number of records ( Rows ) when shows the
structure of a table plus Row Length more information. How can we find these
table
Hi Krasimir,
I used this query and it helped me:
SHOW TABLE STATUS LIKE 'mytable'
the query that you told me is good if I want to find the number of records
in a subset of a table. I can use it in somewhere else. thanks a lot for
your help.
- Original Message -
From:
Hi!
On Jul 14, Marcin Blazowski wrote:
mysql grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo'
with grant option;
mysql grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo';
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Henry Hank [EMAIL PROTECTED] wrote:
The explain plan isn't anything I wouldn't ordinarily expect - a full table
scan:
+---+--+---+--+-+--+-+-+
| table | type | possible_keys | key | key_len | ref | rows| Extra
|
I would like to change the sort_buffer variable but
that variable doesn't seem to be configurable.
i.e.
I get the following when doing mysql --help.
Don't understand why only these variables are configurable.
Using db version 3.23.51.
Possible variables for option --set-variable (-O) are:
I agree with your opinion in 100%, but in my case I need DBMS with
features like subselectes/utf-8/stored procedures but the
speed is also
very important issue.
You might have to spend money!
You are saying that there is DBMS with all this features and it is as
fast as MySQL ?
I don't
Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM
tables... For innoDB only the structure is saved but not the data
Thanks for some answers,
Moritz
Anthony,
Try adding this to the my.cnf file
set-variable =sort_buffer=30M
walt
arobins wrote:
I would like to change the sort_buffer variable but
that variable doesn't seem to be configurable.
i.e.
I get the following when doing mysql --help.
Don't understand why only these variables
Hello There,
I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have
installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.
Follow the Steps.
1- Dowload from http://www.mysql.com/downloads/mysql-4.0.html in the
SOURCE DOWNLOADS Tarball(tar.gz)
You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04;
oe=UTF-8output=gplain
Cheers,
Jim
-Original
walt,
i get the same issue.
I see the same output when doing mysql -D db as i do when doing
mysql --help.
i.e. its telling me that the variable for some reason cannot be configured.
-- anthony
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
walt
Sent:
On Sun, Jul 13, 2003 at 08:51:15AM -0700, Henry Hank wrote:
I have the following SQL. The source table has 8.1 million rows, and the
resulting table will have about 7.9 million rows. I know that's not much of a
decrease, but the logic is correct as I've tested it on smaller sets. The
Hello all,
Is it possible to LEFT JOIN a table to itself?
I want to see all records in a table where the year of the sales date is
2003 and where the salesman sold an item to a customer to which he did not
sell that item to in 2002.
The following is an example table (SALES):
Is there a step by step startup for dummies out there anywhere? Or can someone help
me with the following?
I am attempting to get started. I have run setup for MySQL 4.0.13 and MySQLCC 0.9.2
and am trying to initialize a server. I am running Windows 2000. Is there a naming
convention? I
Hi
Let me take a stab at it. I don't think you need a join at all. Check
the syntax but I think you can do it like this.
SELECT *,concat(slm,item,cust,year) as result1,concat(slm,item,cust,2003) as
result2 from sales where result1!=result2 AND date2001
year would be taken from your date
4 5 6
-Original Message-
From: Tom Roos [mailto:[EMAIL PROTECTED]
Sent: Montag, 14. Juli 2003 11:48
To: [EMAIL PROTECTED]
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / /
Steve Marquez wrote:
Does anyone know how to export a FileMaker Pro Database so that MySQL can
use it? Anyone ever do something like this?
If you want a one-time transfer, the simple and cheap way is through
some sort of text file; CVS or tab-delimited, for example.
If you want the two databases
Check out http://www.fmpdev.com/fmp2mysql.html, found in Google search for
filemaker to mysql
David Shugarts
To perform a self-join you just have to alias one or both tables.
In your case, you want to join on ( I guess) the SLM + CUST + ITEM,
restricting the tables to, respectively, 2003 and 2002. Further, you
want to filter out any rows where there's a match in 2002.
I believe the following does it:
When I benchmarked PostgreSql against MySql for my application, MySql was 15
times faster, so 18% wouldn't make much difference for me!
Andy
-Original Message-
From: Robson Oliveira [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:35
To: [EMAIL PROTECTED]
Subject: Re: MySQL vs.
Moritz Steiner [EMAIL PROTECTED] wrote:
Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM
tables... For innoDB only the structure is saved but not the data
mysqlhotcopy works only with ISAM/MyISAM tables.
--
For technical support contracts, goto
arobins [EMAIL PROTECTED] wrote:
I would like to change the sort_buffer variable but
that variable doesn't seem to be configurable.
i.e.
I get the following when doing mysql --help.
Don't understand why only these variables are configurable.
Using db version 3.23.51.
Possible
Gijsbert Noordam [EMAIL PROTECTED] wrote:
As a newcomer to this mailing list -- and to the MySQL database environment
-- my main field of interest is the use of Spatial data. Before I start
dropping my questions (a have a few) all over this list, two quick ones to
start with:
1) For now,
I am getting the following error after trying to flush the master:
mysql flush master;
ERROR 1186: Binlog closed, cannot RESET MASTER
I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc)
Does anyone know what this might be?
Thank you in advance,
Leo.
--
MySQL General Mailing
thanx. works now.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: Re: can't set variable (sort_buffer)
arobins [EMAIL PROTECTED] wrote:
I would like to change the sort_buffer variable but
that
On Mon, Jul 14, 2003 at 03:14:33PM +0200, Sergei Golubchik wrote:
...
You could've noticed that it tries to access different database. You
granted access to 'myFineDb', but you weren't able to access 'myfinedb'.
So, it's case sensitivity issue. On Debian everything is ok, of course,
on Mac
On Mon, Jul 14, 2003 at 11:11:04AM +0100, Phil Bitis wrote:
Might it be worth looking at the mailing list manager software for this
list? ACCU's mailing lists use Majordomo and add this line to the rfc822
headers:
Reply-To: [EMAIL PROTECTED]
You can still see the sender's email address if
The documentation states that MyISAM tables can be used with more than 32
keys, but I can't get mysql to accept more than 32.
Also, is it possible (advisable) to build a version of the MyISAM tables
that exceed the 64 key limit? If so, how is this done?
Tom Sundquist
Circus Software, LLC
Hello everyone,
Im extremaly newbie with using MySQL under Linux.
Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
(i386) - ( btw - should i uprgade this or its enough to learn ? )
My question is:
How to start mysql deamon?
When i type: mysqld
then apear:
ERROR 2002: Can't
Heikki Tuuri wrote:
On September 15th, 2003 you will be able to put every InnoDB table into its
own file. That should alleviate this kind of problem.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order
LOAD DATA INFILE data.txt INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 5:13
so what can i do to make a column accetp only certain values...there are any
other solutions?
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 1:58 PM
Subject: Re: check
Alex82 [EMAIL PROTECTED] wrote:
i have a problem with the
Hello everyone,
Im extremaly newbie with using MySQL under Linux.
Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
(i386) - ( btw - should i uprgade this or its enough to learn ? )
My question is:
How to start mysql deamon?
When i type: mysqld
then apear:
ERROR
What's wrong with the following query? The application used to use Access via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s ON
I can't use itfor example i have to create a column that accept values
between 1 to 120...i can't enumerate all of themor i have to accept a
value different from NULL if an other column has a certain values, otherwise
the first must be NULL, it's impossible to use enum to do this!
-
Yeah, put LIMIT 20 on the end.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
What's wrong with the following query? The application used to use Access
via
ODBC, now running MySQL 3.23.xx, MyISAM
On Mon, 2003-07-14 at 17:16, Alex82 wrote:
I can't use itfor example i have to create a column that accept values
between 1 to 120...i can't enumerate all of themor i have to accept a
value different from NULL if an other column has a certain values, otherwise
the first must be NULL,
SELECT h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s ON h.serverid = s.serverid
WHERE h.employeeid = 9
ORDER BY h.historyid DESC limit 20;
^
You probably mean LIMIT to limit.
On Mon, 2003-07-14 at 17:12, Jim McAtee
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote:
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Actually, LIMIT x will return the first x rows of a query, not random
records. In fact, you can even combine ORDER BY and LIMIT if you want
to get the
What's wrong with the following query? The application used to use
Access via ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via
MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname FROM
history h
INNER JOIN servers s ON
Sure Woody and Phil are right; just take out TOP 20 and put LIMIT 20 at
the end of your SQL. If you care for the docs, the page is at
http://www.mysql.com/doc/en/SELECT.html
Peter
Eternal Designs
Phil Bitis wrote:
Yeah, put LIMIT 20 on the end.
- Original Message -
From: Jim McAtee
William R. Mussatto wrote:
Hello everyone,
Im extremaly newbie with using MySQL under Linux.
Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
(i386) - ( btw - should i uprgade this or its enough to learn ? )
My question is:
How to start mysql deamon?
When i type: mysqld
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 14 Jul 2003,
Jake Johnson wrote:
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On
Quick one... is this program just for Linux?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 103 matches
Mail list logo