select * from table_name where movid = max(movid);
why the sql above can't work?
Shall I use a sub-select instead?
select * from table_name where movid = (select max(movid) from table_name) ?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
My mysql table has been created for long time, it increases day by day,
and become huge.
Right now a full scan to the table for the first time is very slow.
So I was thinking to optimize it.
This table is stored in many non-sequential disk fragments I think.
I want to make this table to be
hello,
I try to execute this sql in mysql shell,but got error as:
mysql select * from (select uin,count(*) as dd from active_users where
date = date_add(curdate(),interval -30 day) group by uin) where dd =3;
ERROR 1248 (42000): Every derived table must have its own alias
But I can execute
Add an alias for the subquery
select * from ( select ) my_alias where dd = 3;
Better, use a having clause and eliminate the subquery. Odds are it
will be more efficient in MySQL.
How to replace the original one with a having statement?
Thanks again.
Get the name you
Hello members,
I have two mysqld run on the same host (redhat linux OS with 2.4 kernel).
the two mysqld are in different versions, one is 4.0.20,another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default
3306 port.
the mysql 5.0.45 uses /etc/mysql5.cnf as its
try:
uname -a
to see if your OS is 64bit or not.
Gu Lei
-原始邮件-
发件人: Jen mlists [mailto:[EMAIL PROTECTED]
发送时间: 2007年8月15日 9:46
收件人: mysql@lists.mysql.com
主题: Re: run out of memory
2007/8/15, B. Keith Murphy [EMAIL PROTECTED]:
What operating system are you running and is it 32 or 64
Hi,
We'd like to be able to move certain innodb databases between machines
(some, but not all). This would help greatly with resyncing slaves and
for fast backups. I know that we can create table-spaces on a per-table
basis as described here.
Enterprise Storage Enhance | Technology
February 2005 vol. 1
The Enhance Technology 3U 16-drive storage systems are the true enterprise
class systems within the peer group. The UltraStor RS3160SA opens the door to
the world of high performance computing by integrating emerging SATA disk
Hello all,
i want to compile the development tree source from
bk://mysql.bkbits.net/mysql-4.1 on SuSE 8.2 Linux. The compiling of the
mysql-4.1 without the ndb-cluster works fine.
When set the configuration-option --with-ndbcluster, the compilation
fails with the error:
I hope someone can help, I am a newbe as sql and need a some help
I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog
where ACCTSESSIONTIME='0';| get a list that I then need to delete
but when I used the following I keep get errors
delete from radiuslog where
until version 4.1?
Try splitting the delete into multiple steps 1) populate a temp table with
the id's you want to delete then 2) use the temp table data to delete the
rows.
- Original Message -
From: tech [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:16 AM
I have been having a lot of trouble configuring mysql to do just the
simplest replication. Its a standard RedHat 8.0 install, I have followed
the directions on http://www.mysql.com/doc/en/Replication_HOWTO.html to the
letter half a dozen times now and still, the slave server crashes repeatedly
as
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to MySQL server during query.
Have even tryed replacing IP with a host name and
i downloaded mysql-4.0.8-0.src.rpm off of the mysql web-site and have tried
to compile it on several different redhat 8.0 boxes. the same error happens
whether compiling latest mysql 3.23 or 4.0 source rpms. the build moves
along for about fifteen minutes (long after i begin to believe it will
automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined
in `configure.in'
automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not
defined in `configure.in'
error: Bad exit status from /var/tmp/rpm-tmp.37688 (%build)
RPM build errors:
Bad exit status from
2.4.x, either
Suse or Gentoo, gcc 2.95.3 or 3.2.1, MySQL version 3.23.x or 4.0.4 and
4.0.6.
--
Nicolas MONNET (Tech) [EMAIL PROTECTED]
Carpe Diem
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
, for pc-linux (i686)
# /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.5a-beta for pc-linux on i686
--
Nicolas MONNET (Tech) [EMAIL PROTECTED]
Carpe Diem
-
Before posting, please check:
http
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote:
(...)
Nevermind. This was due to an error in the replication; but nonetheless,
it is impossible to shutdown mysqld cleanly if it's waiting for relay
logs to be freed.
--
Nicolas MONNET (Tech) [EMAIL PROTECTED]
Carpe Diem
No matter what I do on the command line for mysqld, or in my.cnf, ALL
logs get activated!
I'm using the Gentoo ebuilds, with mysqld started from an svscan run
script for supervision.
Any ideas? I'm lost here!
--
Nicolas MONNET (Tech) [EMAIL PROTECTED]
Carpe Diem
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote:
--- Simon Green [EMAIL PROTECTED] wrote:
MySQL uses memory and HDD the most and so processor
speed is not so
important.
Well, processor speed is also important, on some of
our servers processors are almost 100% occupied.
If your
On Mon, 2002-11-18 at 15:06, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and
Fabrizio Marini
E-mail: [EMAIL PROTECTED]
E-mail: [EMAIL PROTECTED]
K-Tech S.r.l.
Company Partner
Via Tibullo, 13
00193 - Rome (RM) - Italy
Phone: +39 (0) 6 68301467
http://www.k-tech.it
http://www.javaportal.it
-
Before posting
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote:
Pada Mon, 4 Nov 2002 11:55:59 +0100
Toni [EMAIL PROTECTED] menulis:
Hello
I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
problems, until now that consumes nearly all available CPU.
Also, I am
Hi there,
Does any of you know of a utility to pretty print mysql table
structures? I have a pretty big and messy DB I need to work on, and I
would like to be able to print the table structures with nice tables.
Any pointers?
On Fri, 2002-10-11 at 17:07, Ed Carp wrote:
Should'nt be too hard to do thanks to PODFUK® AKA uservfs:
Just goes to show you that Linux is so flexible, any hare-brained idea can be
implemented in software sigh. But you didn't answer
my question - why would you want to do such a thing?
On Fri, 2002-10-11 at 10:06, Ed Carp wrote:
At 12:58 +0200 10/10/02, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
What does that mean?
I think he wants to mount a MySQL database as a filesystem, like CFS with the
loopback driver.
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a
user ODBC@localhost fixed it.
all off a sudden i need a user named ODBC@localhost, and last i checked, i'm
the only one here that knows anything about how to use mysql here at the
office. so what might have been
mysql select user();
+---+
| user()|
+---+
| [EMAIL PROTECTED] |
+---+
mysql show grants for [EMAIL PROTECTED];
ERROR 1141: There is no such grant defined for user 'root' on host
'192.168.0.17'
mysql show grants for user();
ERROR 1064:
is there a place to get the manual that is split a bit more then the current
manual_split.
these are the 2 pages i end up reading the most
even though its usually for just the grant, create, insert syntax (human in
need of memory upgrade)
416k Sep 26 2001
manual_Reference.html#CREATE_TABLE
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
is there a way or possibly a command line tool for querying a remote file and
having it dump the select into a local outfile.
it does exacly what i want from the server, but only to create a file on the
server. and just adding local doesn't/hasn't work.
and mysqldump outputs sql, which isn't
hi,
I was looking for an SQL statement or script that whould allow me to compare
data when it was entered into a mysql-php field on a web page so that it
checks whether the data entered has not been used before in the database..
In short, when data needs to be entered, the statement/script must
Hello,
The binary distribution of mysql 3.23.49 seems to be non-functional under
slackware 8.0, unable to find the user the database is configured to run
as
Fatal error: Can't change to run as user 'mysql' ; Please check that the
user exists!
root@mysql:~# id mysql
uid=27(mysql)
This is going to be a very basic question, so please excuse me.
I have a MySQL server running, but when I added users I inadvertently
gave them all permissions to everything. They can all access every one
else's databases and make what ever changes they want and even delete.
How do I lock it
I want to build a VB application that connects to mysql (over the internet)
running on linux. i have mysql currently running on LAMP system fine, but do
i just need to install MyODBC for linux on the mysql server or what?
also, are there any major security issues to this i should know about? any
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
I'm trying to compile the mysqlgui source currently available on mysql.com
(version 1.7.5). I've successfully compiled/installed the packages
fltk-1.0.11 and flek-0.1.1 (as suggested by the doc/README.TXT file
supplied with mysqlgui), as well as the fl_editor-0.4 package. The test
programs
are highly appreciated.
Thank you very much indeed.
TK Tech
(Linux Newbee)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
-Original Message-
From: Khuon Tech [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:10 AM
To: MySQL forum
Subject: Newbee Question !
Dear lists members,
I gonna download MySQL and PHP to install on my machine.
But the problem is that I don't know which
-Original Message-
From: Khuon Tech [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:10 AM
To: MySQL forum
Subject: Newbee Question !
Dear lists members,
I gonna download MySQL and PHP to install on my machine.
But the problem is that I don't know which
40 matches
Mail list logo