Hi,
We
are running on opensuse that defaults to a mariadb instead of mysql
install, so we were running icinga 1.9.2 / idoutils 1.9.2 on a opensuse
ppc system, with mariadb 5.5.33. This generated a lot of errors in de
database (with restarts):
InnoDB: Assertion failure in thread
http://findheight.com/hczs/toshghzljndjkmwnw
ruixian.bao
7/22/2013 3:39:19 AM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi ,
count() function is a group function so use group by clause in your select
statement if you are selecting more than one column data..
here is some sample query related to help you,
select count(*) from trndisburse:
output:1467
select count(*),pkdisburseid from trndisburse_TMP m
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, October 07, 2011 12:21 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL Indexes
but could this not be called a bug?
[JS] No.
Think of two telephone books: one is sorted by first name, last name and the
That cleared it up for me. Thanks!
On 10/07/2011 03:06 PM, Jerry Schwartz wrote:
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, October 07, 2011 12:21 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL Indexes
but could this not be called a bug?
Here’s an email from a good friend of mine that may be of interest. It is done
in Ruby.
From: Brad Robel-Forrest [mailto:b...@gigglewax.com]
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
Remember a long while back I was bitching about the need
2011/04/28 15:28 -0400, Jerry Schwartz
No takers?
And this is not real taking, because the algorithm of which I am thinking, the
edit-distance (Levens(h)tein-distance) algorithm costs too much for you (see
the Wikipedia entry). The obvious implementation takes as many steps as the
product of
2011/04/28 15:28 -0400, Jerry Schwartz
No takers?
And this is not real taking, because the algorithm of which I am thinking, the
edit-distance (Levens(h)tein-distance) algorithm costs too much for you (see
the Wikipedia entry), but it yields, I believe, much more nearly such answer as
you
No takers?
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Monday, April 25, 2011 2:34 PM
To: 'Mailing-List mysql'
Subject: Join based upon LIKE
I have to match lists of new publications against our database, so that I can
replace the existing publications in our
I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of
openning innodb tables even after I copied the back-up files of few months ago.
I don't have many innodb tables and so this not causing too much trouble.
I don't know what to do for restoring those tables, and not even
To: mysql@lists.mysql.com
Subject: RE: FW: [USN-1017-1] MySQL vulnerabilities
I don't think you understand how many exploits work. Through some social
engineering or plain brute force or rainbow tables I can get the user/pass
for many typical users. I could also give you some code and tell you
.
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Saturday, November 13, 2010 1:33 PM
To: mysql@lists.mysql.com
Subject: RE: FW: [USN-1017-1] MySQL vulnerabilities
From: Daevid Vincent dae...@daevid.com
my point exactly. there is NONE. and if you don't
then, YOUR account could be compromised too.
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Saturday, November 13, 2010 1:33 PM
To: mysql@lists.mysql.com
Subject: RE: FW: [USN-1017-1] MySQL vulnerabilities
From: Daevid Vincent dae...@daevid.com
my point exactly
On Fri, Nov 12, 2010 at 3:23 PM, Gael gael.marti...@gmail.com wrote:
On Fri, Nov 12, 2010 at 4:12 PM, Daevid Vincent dae...@daevid.com wrote:
my point exactly. there is NONE. and if you don't patch your mysql as
needed, then you will need a lot more help when you're hacked. ;-p
From: Daevid Vincent dae...@daevid.com
my point exactly. there is NONE. and if you don't patch your mysql as
needed, then you will need a lot more help when you're hacked. ;-p
I note that the impact of every single one of these vulnerabilities was An
authenticated user could exploit this to
How come these kinds of notices are not sent to the mysql list? I realize
this particular one is from Ubuntu, but the vulnerability is not ubuntu
specific, it's mysql. Why aren't the mysql, er um, Oracle people more
pro-active about letting us know these things?
-Original Message-
From:
I suspect that that is because this is not a security list, but a general
help list. If you want those things, you'll get them from either your
vendor, bugtraq, or the mysql security-specific mailing list that
undoubtedly exists somewhere. Don't ask me where, though - I'm not on it
either :-)
On
:18 PM
To: Daevid Vincent
Cc: mysql
Subject: Re: FW: [USN-1017-1] MySQL vulnerabilities
I suspect that that is because this is not a security list, but a general
help list. If you want those things, you'll get them from either your
vendor, bugtraq, or the mysql security-specific mailing list
On Fri, Nov 12, 2010 at 4:12 PM, Daevid Vincent dae...@daevid.com wrote:
my point exactly. there is NONE. and if you don't patch your mysql as
needed, then you will need a lot more help when you're hacked. ;-p
http://lists.mysql.com/
Daevid,
You may want to read
-Original Message-
From: Christoph Boget [mailto:christoph.bo...@gmail.com]
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.
html#function_mod
SELECT MOD( X, 2 )
where X is your number (or column name). If 0, it's even if
1 it's odd.
I think you mean, if it
where X is your number (or column name). If 0, it's even if
1 it's odd.
I think you mean, if it is non-zero, then it is odd.
If you're MODding using 2 as the second argument, it's always going to
be 0 or 1. 2 either divides in to the number evenly, having a
remainder of 0, or it'll have a
My apologies. With your example; SELECT MOD( X, 2 ), it will do exactly as you
say it will do.
-Original Message-
From: Christoph Boget [mailto:christoph.bo...@gmail.com]
Sent: Tuesday, August 31, 2010 2:26 PM
To: Coll-Barth, Michael
Cc: mysql@lists.mysql.com
Subject: Re: FW: Even
Hi,
I'm beginner to try to fix a mysql bug by myself,
but i got a trouble that mysqltest: set debug_sync= 'RESET'' failed: 1193:
Unknown system variable 'debug_sync'
Could someone know that?
Thank you very much..
mysql@lists.mysql.com
Sent: Thu, 22 April, 2010 2:17:29 AM
Subject: Re: Fw: BIN LOG Error when use Begin Trans in Replication.
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A vikkiatb...@yahoo.in
Hi Hao Ding,
I attached in my request mail it self. Please
VIKRAM
From: Max Bube maxb...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Thu, 22 April, 2010 2:17:29 AM
Subject: Re: Fw: BIN LOG Error when use Begin Trans in Replication.
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A vikkiatb...@yahoo.in
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
--
*From:* hao ding fire9di...@gmail.com
*To:* Vikram A
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
From: hao ding fire9di...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Sent: Wed, 21 April, 2010 7:25:05 PM
Subject: Re: BIN LOG Error when use Begin Trans in
sorry the link i given is wrong. Please follow this
http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
- Forwarded Message
From: Vikram A vikkiatb...@yahoo.in
To: MY SQL Mailing list mysql@lists.mysql.com
Sent: Sat, 30 January, 2010 7:04:01 PM
Subject: IMAGE STORE @
To ensure delivery directly to your inbox please add
repl...@oracle-mail.com to your address book today.
Oracle Corporation
http://www.oracle.com/dm/global_images/oracle_white2.gif
http://www.oracle.com/dm/10h2corp/o_sun_redbox_clr.gif
We are pleased to announce that Oracle
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if
On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards machiel.richa...@gmail.com
wrote:
Hi guys,
Can you please assist me in rewriting this query in order to run this
against a mysql database?
It seems that the
Thank you for the link but seeing that I am still new with MySQL , this does
not mean anything to me.
From: prabhat kumar [mailto:aim.prab...@gmail.com]
Sent: 08 January 2010 4:22 PM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: FW: MySQL export and import into Oracle
http
Guys,
That's a great response. Thanks.
I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto
/etc/my.cnf and restarted.
However I can no longer log on via the command line from the database box,
I can still log via a remote client
So I presume the problem is related to the
H I wouldn't use that my-huge.cnf file unless that machine is a
dedicated mysql server with plenty of ram and even then I wouldn't use it
without modification.
Are you sure you have the password correct? A % under host is a synonym
for 'any host'.
Regards
John
Guys,
That's a great
Its a very simple table that will store messages.
Each message would have subject, body,to_user_id,
from_user_id,is_deleted,date_sent and may be one or two more column
There would be frequent read operation and slow write operation.
Thanks
SN
Personally I'm always ready to learn,
Sudhir: do yourself a favr and split the blobs (=body) off to a
different table. Most fo the time bodies are not used, only when the
actual email needs to be shown. That means that you can keep the
frequently used fields together in a table for much quicker access.
cheers,
Walter
On Mon, Nov 2,
Mari capai impian anda bersama kami.
Sila Klik Link berikut :-
www.mesti.my/1malaysia
Terima Kasih...moga anda berjaya seperti kami.
__
Get more social and
I am trying to move my cache into ndb but when I use the ndb engine the
query time is 4 min versus myisam which is 7 seconds. This is due to the
fact it is doing a full table scan on ndb and an index on myisam. I was
hoping someone could help me fix this or at least explain why this is
happening.
Forwarded response from Micheal. I haven't tested it yet (have to wait till
I have more data to move), but this sounds about right.
Thanks!
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Thursday, July 09, 2009 1:22 PM
To: Walton Hoops
Subject: Re: Lock
Nope, Nathan is right: INSERT...SELECT is a locking statement due to
statement-based replication. There's lots of info on this if you
google it. The common solution is to dump to disk and load back in
with SELECT INTO OUTFILE and LOAD DATA INFILE.
- Perrin
On Thu, Jul 9, 2009 at 3:55 PM,
- Forwarded Message
From: MySQL Web Team webmas...@mysql.com
To: christudas_...@yahoo.com
Sent: Wednesday, July 8, 2009 3:46:09
Subject: Re:General MySQL Question
Thank you for contacting MySQL,
You are likely to get a more detailed response to your question if you
ask on the forums
Now I'm really confused.
I just did this:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%';
GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD
'secret';
and then I get this:
SHOW GRANTS FOR 'user'@'10.10.10.%';
Start the server with --skip-grants-table. That will disable logins.
Then do delete from mysql.user and restart :)
Walter
On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent dae...@daevid.com wrote:
Now I'm really confused.
I just did this:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM
On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent dae...@daevid.com wrote:
So why mySQL is putting back ticks in there even though I didn't,
Because it doesn't save your original statements, but recreates an
appropriate set from the grant tables.
and more importantly why doesn't the second
Sorry for the bad end of lines in the first message!
I am trying to set up MySQL on a GNU/Linux box with this script:cd
/home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure
- Original Message -
From: Darryle Steplight [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, September 09, 2008 6:59 PM
Subject: Re: Weird problem with mysql_query
Hi G,
There is nothing weird about your results. When you do a Count(*)
Sum() is driven by the group by.
I need it to be equivalent to this:
Select company, state, sales, sales / (select sum(sales) from sales) as
percent from sales
Which of course I could just use that, but the select I'm actually working
with isn't that simple and if there was some way to do what I
Why? Because it's Friday and I'm feeling silly :)
mysql SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
Hi,
This is regarding MySQL license we had bought for Bharti Jersey
Project.
Could you please let me know the Warranty period for the same. Also,
please let me know if we have any Maintenance and Support contract with
MySQL against this license.
If not, please provide me the quotation for
Well, if your particular problem has a well defined maximum minimum and minimum
maximum (Ie the max(q) 4294967296, because q is a 32 bit unsigned int, and
min(q) -1) then you can do it without any extra joins or sub selects.
select
a,
b,
min(IF(date 100, q, 4294967296)) as min_q,
a
Database as a RDBMS, anyway, MYSQL IS GREAT!
Aloha!
Claudio Nanni
-Messaggio originale-
Da: news [mailto:[EMAIL PROTECTED] Per conto di Thufir
Inviato: mercoledì 5 marzo 2008 12.09
A: mysql@lists.mysql.com
Oggetto: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar
: Re: FW: Re: what is a schema? what is a database?
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio [EMAIL PROTECTED] wrote:
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father [EMAIL PROTECTED] wrote:
Schema is a collection of databases.
A schema is a definition of tables fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
:[EMAIL PROTECTED] Per conto di Thufir
Inviato: mercoledì 5 marzo 2008 12.09
A: mysql@lists.mysql.com
Oggetto: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS
Release: mysql-5.0.18 (Source distribution)
C compiler:gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
C++ compiler: gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
Environment:
machine, os, target, libraries (multiple lines)
System: FreeBSD technomet.poltava.ua
Release: mysql-5.0.18 (Source distribution)
C compiler:gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
C++ compiler: gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
Environment:
machine, os, target, libraries (multiple lines)
System: FreeBSD technomet.poltava.ua
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS is different in this regard. Microsoft's SQL Server works like
this:
A SQL Server instance (server) can have many databases.
A database can have many
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS is different in this regard. Microsoft's SQL Server works like
this:
A SQL Server instance (server) can have many databases.
A database can have many schemas, schema simply being a grouping for
objects in a database. In a
mysql@lists.mysql.com
- Original Message -
From: Sebastian Mendel [EMAIL PROTECTED]
To: Richard [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, October 31, 2007 3:11 PM
Subject: Re: Inserting a value in an autoincrement list?
Richard schrieb:
I want to have a list of
Sorry if this was already posted, but I don't recall seeing it, and I read the
list every day.
I also checked here: http://lists.mysql.com/mysql and didn't see any mention.
This makes me a little concerned. Why aren't these security issues being posted
to the list? This is at least the third
Thanks Baron, that hit the spot.
Thanks again.
Jonathan
- Original Message -
From: J Trahair
To: MySQL General
Sent: Saturday, May 05, 2007 9:00 PM
Subject: Error message on trying to start service
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
, but then Oracle costs a little more.
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, April 26, 2007 11:53 PM
Subject: Re: FW: MySQL patches from Google
This sounds a lot like what I'm attempting. I tried a proprietary database and got around 30k
O'Krongli
Acorg Inc
- Original Message -
From: David T. Ashley [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: April 25, 2007 10:20 PM
Subject: Re: FW: MySQL patches from Google
On 4/25/07, mos [EMAIL PROTECTED] wrote:
At 02:36 PM 4/25/2007, you wrote:
On 4/25/07, Daevid Vincent
On 4/26/07, Mike OK [EMAIL PROTECTED] wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news et al...
--
Kevin.
--
This sounds a lot like what I'm attempting. I tried a proprietary database
and got around 30k queries/second, compared to MySQL's of only 1-1.5k
queries /second. I'm torn between using the Windows proprietary database
(still has some minor buggy parts) on each webserver or going with MySQL
Kevin Spencer wrote:
On 4/26/07, Mike OK [EMAIL PROTECTED] wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news et
: mysql@lists.mysql.com
Subject: Re: FW: MySQL patches from Google
Kevin Spencer wrote:
On 4/26/07, Mike OK [EMAIL PROTECTED] wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover clusters, it's Google -- so I have every confidence
their
On 4/25/07, Daevid Vincent [EMAIL PROTECTED] wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover
At 02:36 PM 4/25/2007, you wrote:
On 4/25/07, Daevid Vincent [EMAIL PROTECTED] wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission
On 4/25/07, mos [EMAIL PROTECTED] wrote:
At 02:36 PM 4/25/2007, you wrote:
On 4/25/07, Daevid Vincent [EMAIL PROTECTED] wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons
of
failover/replication and would be eager to see mySQL implment the Google
patches in the
oh,yes.
There is a blob column in mytable.So i use dumpfile instead of outfile.
There are more than 100 rows in mytable.
The follow sql is successful: select * into dumpfile '/home/wangxu/test4.data'
from mytable where id=1 or id=2;
Why it is false that select all rows in mytable?
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
version 4 however they work with my version of mySQL 3.23 ?
Neil
From: Neil Tompkins [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Sat, 10 Mar 2007 18:24:19 +
Strange the DES_ENCRYPT
I just tried and it appears the functions DO NOT work in version 3.23
From: Neil Tompkins [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Mon, 12 Mar 2007 09:28:27 +
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
version 4 however
Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of mySQL
3.23
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 18:20:43 +
DES_ENCRYPT/DES_DECRYPT appears to be what we require.
Thanks
Okay but after I patch OS do I still need to load time zone tables with
following command:
shell mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Is this still necessary?
___
Dzenan Causevic
Web Applications Developer
NaviSite, Inc.
315-453-2912 x5346
- Original Message -
From: Devi [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 12, 2007 5:34 PM
Subject: Re: Update failing with error 1062
Hi MySQLeers,
How can I setup multiple daemons, One daemon for one database? So that
they can act independenly. What
Hi Mark
I would appreciate if we can define Under_extreme_conditions as you
have mentioned in this link below
http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html
I would appreciate if you can give us a workaround for this, which
can eliminate this set autocommit =1 command being
I optimized every table after I first imported the data. The tables
were probably in use, off and on for testing, for about a week after the
optimize table was ran on every table before I noticed this problem.
I'm not saying the problem didn't exist within that week, I'm just
saying I didn't
I have atable which contains the number and name of the photo galleries and
'thumnails' the images that are conenected to the galleries.
I am trying to create a 'pick a gallery' screen where it selects all the
galleries and then output the first thumbnail image associated with that
gallery.
I have a database with several tables that can have up to 100 000 rows
there is ~100 updates every seconds and ~100 select query on the same
table using locks.
The update is always on the same field a varchar(15), I believe it will
be recommended to change it to char(15) to improve performance
Hi,
For Info about the 'expire-logs-days' bug fix and new release,
http://www.developertutorials.com/mysql-manual/manual_News.html
Thanks
ViSolve DB Team.
- Original Message -
From: Visolve DB Team [EMAIL PROTECTED]
To: George Law [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent:
- Original Message -
From: Renish [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, October 19, 2006 10:28 AM
Subject: Import oracle
Can anyone tell me how can I import the *.gra (oracle db file) files to
Navicat or Acess. Pls let me know in steps as I am v new to this
- Original Message -
From: Renish [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, October 19, 2006 1:08 PM
Subject: Fw: Import oracle
- Original Message -
From: Renish [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, October 19, 2006 10:28 AM
For your information, I updated my ODBC driver for mySQL to the latest version
3.51.12 and the slow connection problem has disappeared.
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: RE: Slow Access When Inserting
RecordsDate: Thu, 12 Oct 2006 19:01:08 +
Hi, I've tested the exact same ASP
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 09, 2006 5:02 PM
Subject: Fw: simple database query
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 06, 2006 12:55 PM
Subject
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 09, 2006 4:56 PM
Subject: Fw: simple database query
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 05
- Original Message -
From: Renish
To: Visolve DB Team ; mysql@lists.mysql.com
Sent: Tuesday, October 10, 2006 12:35 PM
Subject: Fw: Query Help plss
- Original Message -
From: Renish
To: mysql@lists.mysql.com ; Visolve DB Team
Sent: Tuesday, October 10, 2006 12:34 PM
Assuming your MySQL version supports sub queries you do like this. I have
never done sub queries my self, but I know the theory :)
SELECT * FROM table WHERE id = (SELECT id FROM table ORDER BY id DESC) ORDER
BY date
/Peter Lauri
www.lauri.se - personal
www.dwsasia.com - company (Web Development
I have a SQL challenge I'm not sure how to solve. But it's so common, I feel
kind of stupid asking this...
I have a 'user' table with 'login_date' which is an auto updated DATETIME
column and a 'created_on' which is a DATETIME (but not updated after the
record is created the first time)
I want
You could add an extra field called last_login_date which you'd set only
once per session - at login time. At login time you'd set this to the
value that exists in login_date. Then use that for comparison against
created_on.
Daevid Vincent wrote:
I have a SQL challenge I'm not sure how to
:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 5:35 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: FW: How do I find all the users that are new
since my last login (repost)
You could add an extra field called last_login_date which
you'd set only
once per session - at login
Sorry, forgot to send to the list aswell. My reply is at the bottom.
-Original Message-
From: Ian Barnes [mailto:[EMAIL PROTECTED]
Sent: 08 June 2006 09:58 PM
To: 'Kishore Jalleda'
Subject: RE: Importing 3Gb File
-Original Message-
From: Kishore Jalleda
Ian, I ran into a similar situation not too long ago when setting up
replication. I don't recall if the error message was identical but was
certainly close.
My problem was that we had customized our original server (and
mysqldump) to allow 16 MB packets, which is essentially a setting
On 2006-05-01 11:55 AM, Robert DiFalco [EMAIL PROTECTED] wrote:
Well, normally a DISTINCT has to do a type of sort and is slower than
non-DISTINCT queries. Each field of the result set is considered in the
DISTINCT logic. Can you modify the query so that it does not require the
DISTINCT? Can
I'm putting this back on the list where it belongs; that enables everyone to
help and to learn from the discussion, either now or in the future via the
list archive.
--
Ahh, so you've tried to re-create the database after it appeared to be
safely dropped! You didn't say that in your note so
'
Subject: RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)
I was using SQLYog 5.03 RC1.
vmware ~ # mysql --version
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
5.1
But just to sanity check. I ssh'd in and tried this at the mysql command
line
From: He, Gang
Sent: Wednesday, April 12, 2006 8:43 PM
To: '[EMAIL PROTECTED]'
Subject: Mysql C API character set
Hi,
I install MySQL server 4.1.12 in Redhat Linux in Japanese environment (
env LANG=ja_JP.UTF-8 ),
I setup MySQL server utf8
I don't have a 5.0+ server to test with right now but this should work
--- Daevid Vincent [EMAIL PROTECTED] wrote:
I was using SQLYog 5.03 RC1.
vmware ~ # mysql --version
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using
readline 5.1
But just to sanity check. I ssh'd in and
I'm putting your question back on the mailing list where it belongs. That
enables others to help and to learn from the discussion, either now or in
the future via the archives.
--
Rhino
- Original Message -
From: H L [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 12,
This may have been lost, so I'm reposting hoping for a clue as to why the
mySQL example onlie gives me errors...
-Original Message-
Sent: Sunday, April 09, 2006 7:41 PM
I'm trying to follow the example in the manual to create a trigger:
1 - 100 of 857 matches
Mail list logo