Why not just:
SELECT MAX(id) AS max_id FROM yourtable;
Then run another select to get the record?
Or, if you want the last record:
SELECT * FROM yourtable ORDER BY id DESC LIMIT 1;
maybe.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original M
On Thu, Sep 06, at 11:05pm, Chris Bolt ([EMAIL PROTECTED]) wrote:
> SELECT * FROM yourtable WHERE id = LAST_INSERT_ID();
But that will only work if it was the same thread that inserted the last record in
the table. If this is running from say .. a script that just wants the last
inserted record
Hi List,
I'm a little bit confused.
I do the following:
Create a table with 1 int and two floats.
mysql> create table testfloat(z int, ll float, ul float);
Query OK, 0 rows affected (0.00 sec)
inserting one row into the table
mysql> insert into testfloat values(1,-0.1,0.1);
Query
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> now,what statement do I use to put the sysdate into the column today?
> this is NOT working
> insert into datee values(select DAYOFMONTH(sysdate()));
Of course not. "insert into datee values (Now())" will, though. Just feed it
to mysql ... ;)
Here
Jeremy Zawodny wrote:
>
> On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> >
> > I'm quite surprised that this level of performance is available from
> > such standard (well, not standard as in 'common', but y'know what I
> > mean...) hardware. The last I heard, 1K+ queries/sec
Terje Kristensen wrote:
>
> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
> (hppa2.0w),
> Apache/1.3.20.
>
> The load are rather high, and "Queries per second avg: 94.859"
> This is an local B2B installation som we are really not getting any traffic
> between 4PM and
Hi
First of all try to use datetime column for date&time storage porpouses.
create table datee(datetime today);
And then:
insert into datee(today) values(now());
After all of this, please RTFM :)). It's all written there.
Regards
Daniel Łaś
e-direct Polska s
Deryck Henson ([EMAIL PROTECTED]) writes:
> I need to make about 15 tables that use the same template as the first one.
> Please help.
Please post more information. Platform, software, etc. This is like saying, "I want to
get from point A to point B. Please help."
OK, I've got that out of my
Hi,
I my name is ryan and I own a small site which has a mysql database and servlet
support.
I have a simple query to all you mysql gurus...
my table is very simple, i created a table with the following
create table datee(int today);
now,what statement do I use to put the sysdate into the colu
%% Chadrick Mahaffey <[EMAIL PROTECTED]> writes:
cm> How do I start the server and create a database in plain English. I'm not
cm> familiar with:
cm> SECTION 4.16 - Documentation
shell> ./scripts/mysql_install_db
shell> cd mysql_installation_directory
shell> ./bin/safe_mysqld --u
-Original Message-
From: Jean Paterson [mailto:[EMAIL PROTECTED]]
Sent: 07 September 2001 14:34
To: '[EMAIL PROTECTED]'
Subject: Problems retrieving tables
Can anyone help- I am new to MySQL.
I am using Ultradev. I have installed MyODBC on my PC and set it up
connect to my ISPs MySQL
Hello!
Is it possible to get the total number of records when doing a select with
LIMIT?
For example, if I do:
SELECT * FROM tbl LIMIT 0,10
I would like to get the total number of records in tbl along with the 10
first ones..
I need this to display "showing 0 - 10 of 354", and my quer
Ed Carp writes:
>
> So, is MyODBC just for MySQL, or can one use it for talking to other databases via
>ODBC also? Sorry, I'm just confused today, I guess ;)
> --
> Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applicati
hi !
thanx for your reply. now i could install mysql on my NT.
nut now when i give the command mysql-nt --install it says unable
to install.
moreover as it is in the installaton doci tried to look for the
my-example.cnf file but i cud get only a link of this name in whole of
my
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> Ed Carp writes:
> > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> >
> >
> > ODBC, or MyODBC?
>
> ODBC as an API.
>
> Then you install ODBC driver for RDBMS of your choice and configure
> ODBC likewise.
>
> But ODBC as a programming mode
[EMAIL PROTECTED] writes:
> Hello
>
> we would like to use MYSQLGUI
>
> is it allowed ?
> Id not not have any user and password to enter for download
>
> Best regards
>
> Franck Lepretre
>
It is completely free to use as much as you wish on as many computers
as you wish.
Just download
Ed Carp writes:
> Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
>
>
> ODBC, or MyODBC?
> --
> Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applications Development
> Escapade Server-Side Scripting Language Development
Hello
we would like to use MYSQLGUI
is it allowed ?
Id not not have any user and password to enter for download
Best regards
Franck Lepretre
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> If you wish to make your application transparent, you should use ODBC.
ODBC, or MyODBC?
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server
Hi,
on freshmeat.net you can find some libraries which provide same
comfort as mysql++, so try check...
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic
tel.: ++420 602 210 900, ++420 2 3337 1117, fa
Ai2s, Proyecto writes:
> Hi,
>
> I'm making an application on C++Builder5,
> which will be comunicated with MYSQL server , What do you
> MYSQL API recomend : MYSQL++ or MYODBC, I know that the
> MySQL C++ API is the official API, but can I connect to
> other SQL server whit this API?
>
> Th
Basil Hussain writes:
> Hi,
>
> I'm quite surprised that this level of performance is available from such
> standard (well, not standard as in 'common', but y'know what I mean...)
> hardware. The last I heard, 1K+ queries/sec was only being done on extremely
> high-end Sun enterprise-level machin
I need to make about 15 tables that use the same template as the first one.
Please help.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Aaron Brick writes:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happens
> somewhere in the middle. i am using 3
Giovanni Borri writes:
> hi all,
>
> i have a question. i would like to know if mysql has a sql'x' standard. my
> problem is that i would like to use UNION or MINUS or... but it seems not to
> work, another problem is that i would like to make some nested query.
>
> by
> thanks in advance.
Hi,
I'm making an application on C++Builder5,
which will be comunicated with MYSQL server , What do you
MYSQL API recomend : MYSQL++ or MYODBC, I know that the
MySQL C++ API is the official API, but can I connect to
other SQL server whit this API?
Thank you,
Vilmara
*** PDV
Campbell writes:
> Hi,
>
> a snippet from a session on a linux box running standard mysql client (2.23.33):
>
> mysql> update members_p set newscode='1' where ID='640103502408';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> update members_p set newscode='1' where ID='640103502408';
> Query
Edward Beheler writes:
> I have a couple questions regarding MySQLGUI:
>
> 1. Where is the documentation located? Help only
> offers 'about', and I am unable to find any docs on
> the mysql.com website.
>
> 2. How does one execute multiple commands at the same
> time? I know in Microsoft SQL E
Hi all,
I'm trying to build the MySQL super-smack benchmarking tools. I'm getting
the following errors on make:
make all-recursive
make[1]: Entering directory `/root/rpms/super-smack-1.0'
Making all in src
make[2]: Entering directory `/root/rpms/super-smack-1.0/src'
c++ -DHAVE_CONFIG_H -I. -I.
Hello,
I am running version 3.23.41 on windows '98. When I run winipcfg I show
that my hostname is siren.goldengate.net and
my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error
message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I tried several versions
Jeshua Lacock writes:
>
> Hello all,
>
> I have searched the archives and found various suggestions and tired
> them (and variations of them) and I cannot get "mysqld" running on Mac
> OS 10.0.4 (Darwin 1.3.7).
>
> I had previously built and run 3.23.39 on the same machine, but I cannot
> ge
Hi,
Try to extract the files before running setup.exe. If this does not work you
zip archive may be corrupt.
Regards,
Antonie
-- S C I B I T --
Antonie Neethling ([EMAIL PROTECTED])
http://www.scibit.com/mysql - MySQL related products
-- S C I B I T --
> -Or
hi all !
i am new to mysql and trying to install it onto my win NT 4.0
workstation.
but the winzip is not able to install it !
is anybody else facing the same prob?
does anybody know the cure?
sumit
-
Before posti
>Description:
There is duplication in the syntax of INSERT. Last version is special case of the
second.
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...
or INSERT [LOW_PRIORITY | D
>Description:
There is in manual_Problems.html:
That means that if you search with col_name LIKE 'a%', you will get all
column values that start with A or a. If you want to make this search
case-sensitive, use something like INDEX(col_name, "A")=0 to check a
pre
Any ideas?
/Mattias
>Hi!
>
>I've just installed (a couple of days ago) mysql.
>I will use mysql for using with hlstats. That is
>a stats-program for HalfLife Counter Strike. (game)
>
>But I got errors... I guess it's a problem with mysql
>or me not knowing how to do it.
>
>Here is some printou
On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
>
> I'm quite surprised that this level of performance is available from
> such standard (well, not standard as in 'common', but y'know what I
> mean...) hardware. The last I heard, 1K+ queries/sec was only being
> done on extremely
Hi,
> > > About a year ago, I used mysql-super-smack and was able to hit
> > > 8,000 per second on our [then new] server. The highest I've
> > > recorded on an actual production application was around 5,000.
> > > But I don't watch the numbers closely very often...
> >
> > Just out of curiosity,
Hi,
i'm using MySQL 3.23.37 on a Linux system with an average of about
20 queries/second.
First of all i have a little question how i can optimize a query.
The query is like that:
select * from tbl where key_field1 & constant1 and key_field2 &
constant2
Examine that query with explain select.
Hello,
I saw your message on the list, could you
tell me which scripting language you are
using (php, perl, java ?)
and if you have the time could you show me
your my.cnf and the result of a "show variable"
request ? I am experiencing problem with 100% CPU
load and can't figure what it is ?
Th
Hi guys,
I'm just a student, working on a project. We have to migrate a oracle
database to MySQL. In order to do that we must search for diferences between
the two and for other information that can help us. (of course we're not
allowed to just download software and convert)
Now, I've allreaddy s
Hello Terje,
Friday, September 07, 2001, 12:11:30 PM, you wrote:
TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
TK> (hppa2.0w),
TK> Apache/1.3.20.
TK> The load are rather high, and "Queries per second avg: 94.859"
TK> This is an local B2B installation som we are re
Chadrick Mahaffey wrote:
>what does all this mean? I tried to type this in my command console
changin
>/ to \ and I don't understand what is happening. I get all kinds of
errors.
It looks to me that you're trying to use the Unix install notes - don't!
Refer to section
2.1.2 in the excellent man
On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote:
>
>
> > About a year ago, I used mysql-super-smack and was able to hit
> > 8,000 per second on our [then new] server. The highest I've
> > recorded on an actual production application was around 5,000.
> > But I don't watch the
hi all,
i have a question. i would like to know if mysql has a sql'x' standard. my
problem is that i would like to use UNION or MINUS or... but it seems not to
work, another problem is that i would like to make some nested query.
by
thanks in advance.
Giovanni
It would appear that you are putting spaces between Count and the bracket
which as far as I can tell will not work hence try count(*) etc...
Chris Thorpe
- Original Message -
From: "Antonio Ortega Sancho" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, Septembe
> About a year ago, I used mysql-super-smack and was able to hit 8,000
> per second on our [then new] server. The highest I've recorded on an
> actual production application was around 5,000. But I don't watch the
> numbers closely very often...
Just out of curiosity, on what hardware? My nee
Hi,
a snippet from a session on a linux box running standard mysql client (2.23.33):
mysql> update members_p set newscode='1' where ID='640103502408';
Query OK, 0 rows affected (0.00 sec)
mysql> update members_p set newscode='1' where ID='640103502408';
Query OK, 1 row affected (0.01 sec)
All
Hi,
I have a big problem, the Running_Threads are very often too high
(max_connections is 100) and of course mysql crash with "too much
connections" ! All php3 requests begin with mysql_connect and finish by
mysql_close, our ASP said max_conection is enough high and problem is
elsewhere. We verify
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote:
>
> We have peeks where there is more than 1000 Queries per second.
> Does anyone have any experience with a higher number of queries pr
> second than this ?
About a year ago, I used mysql-super-smack and was able to hit 8,000
per
I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
(hppa2.0w),
Apache/1.3.20.
The load are rather high, and "Queries per second avg: 94.859"
This is an local B2B installation som we are really not getting any traffic
between 4PM and 7AM
We have peeks where there is more than
I have a couple questions regarding MySQLGUI:
1. Where is the documentation located? Help only
offers 'about', and I am unable to find any docs on
the mysql.com website.
2. How does one execute multiple commands at the same
time? I know in Microsoft SQL Enterprise manager, you
seperate the lin
On Thu, Sep 06, 2001 at 10:44:28AM -0700, Duc Chau wrote:
>
> Hi, can someone tell me how the index number on the bin logs are
> incremented?
They are incremented by adding one to the extension.
001 -> 002 -> 003 -> 004
and so on.
> When i update my master machine the changes are still going
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
>I'm trying to do select count (*) from table. but it doesn't work
>
> ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
> at line 1
>
> Same happens with max (column) and min (column).
No
Antonio Ortega Sancho writes:
>I'm trying to do select count (*) from table. but it doesn't work
Try count(*) instead.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it t
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
>I'm trying to do select count (*) from table. but it doesn't work
>
> ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
> at line 1
>
> Same happens with max (column) and min (column).
>
I'm trying to do select count (*) from table. but it doesn't work
ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
at line 1
Same happens with max (column) and min (column).
Do I have to install anything else or is something wrong. I'm using
redhat 7.0 wi
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote:
> Hello,
>
> We are using mySQL on over 6 servers here, we have been doing so for
> over 2 years, and we are constaly facing problems with corrupted
> tables, especially on two of our busiest servers. Tables seem to
> corrupt out of
On Thu, Sep 06, 2001 at 12:40:16PM -0700, xris wrote:
> I was just browsing through the searchable online MySQL manual,
> trying to find a list of the aggregate functions (as I don't trust
> the list in the O'Reilly book, considering the number of typos and
> missing information in other sections
Hello,
We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and
we are constaly facing problems with corrupted tables, especially on two of our
busiest servers.
Tables seem to corrupt out of the blue and we have to shut them down ( the servers )
occassionaly to f
101 - 160 of 160 matches
Mail list logo
