($result,0,used_price),2)); ?
This seems rather convoluted to me and I've been struggling with it all
day. Any help would be greatly appreciated!
Thank you so much!
Angela
Schema
NameTypeNULLDefault
startingd textYes NULL
how to break the table into 100,000 chunks?
thanks
From: Claudio Nanni claudio.na...@gmail.com
To: Angela liu yyll2...@yahoo.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, December 1, 2011 2:24 PM
Subject: Re: best way to copy a innodb
In mysql 5.0 ,how to check how big a database is?
Thanks
Thanks, this is really helpful.
From: Peter Brawley peter.braw...@earthlink.net
To: mysql@lists.mysql.com
Sent: Tuesday, November 15, 2011 12:41 PM
Subject: Re: how to check how big a database is
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how
pHi friend...brI wish I had been more prepared this helped me get back on
my feet miracles really do exist imagine what you could dobra
it refers to free innodb tablespace.
From: Rozeboom, Kay [DAS] kay.rozeb...@iowa.gov
To: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, November 10, 2011 10:03 AM
Subject: InnoDB free - What does it really mean?
In the show table status output,
Hi, Folks:
Have any idea how to monitor Locked queries with Nagios?
Thanks
Yeah, I think adjusting max packet size may be helpful, remember change that
value in both server and client
From: Johnny Withers joh...@pixelated.net
To: Neil Tompkins neil.tompk...@googlemail.com
Cc: [MySQL] mysql@lists.mysql.com
Sent: Monday, October 10, 2011
Hi, Folks:
I have questions regarding how MyISAM handles auto_increment clolumn?
1. is there a auto_increment counter for MyISAM to assign a new value to
auto_increment columns?
2. if MyISAM has the counter, is the counter stored in memory or disk?
Thnaks
Thanks, what about if mysqld restart, does auto_increment gets reset ?
I saw this happened to Innodb, if table is empty and server restart,
auto_incremnet gets reset to 0
From: mos mo...@fastmail.fm
To: mysql@lists.mysql.com
Sent: Monday, October 3, 2011 3:01
Angela
Hi, Folk:
I have two questions about the DBA certification exam:
1.how many questions ?
2: how long is the exam?
3.what's the pass score?
I could not find the answers on mysql web
anybody knows?
Thanks a lot
HI, Folks:
Can Isolation levels be set per transaction? I know isolation levels can be
set per session or globally, but not sure at transaction level.
if so , can anybody give me an example?
Thanks a lot
Hi,
Anybody knows:
Is MySQL Administrator still available for MySQL 5.1 and 5.5?
Folks :
two questions:
1. can Innodb create per database table space , not per table table space?
2. can we store table on specific tablespace like Oracle or DB2 when creating
table?
Many thanks.
...@gmail.com wrote:
From: Eric Bergen eric.ber...@gmail.com
Subject: Re: Innodb table space questions
To: Angela liu yyll2...@yahoo.com
Cc: mysql@lists.mysql.com
Date: Monday, January 17, 2011, 10:09 PM
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu yyll2...@yahoo.com wrote:
Folks
) where
phonebin.icao=new_stations.icao
That worked once, for the very first update, but subsequent runs affect no
rows at all.
I could use a perl script to first fetch data and decide which row and
column to update but there has to be an SQL way - doesn't there?
All help appreciated!!
Angela
,
Angela.
of errors in JBoss, such as : could not enlist xa-resource ecc..
Where can I find MysqlXaDataSource class?
Thanks in advance, sorry for bothering you...
Angela Fogarolli.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
?
Are there any thoughts on how to solve this? Is it a MyODBC problem or a
MS problem?
Thanks for your time and effort!
Angela Olmeijer
generations of child rows. Oracle first
selects the children of the rows returned in step 2, and then the
children of those chilren and so on.
Thank you for your time.
Angela Olmeijer
Hi
I am having problems generating the mysqldump file. I have tried a range of
options and carefully studied several tutorials I have on using this
command. Each time I get the following errror.
ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p
adrienne netno_db
,
Angela
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED
:
SELECT column, ... , RAND() AS random FROM table ORDER BY random
I get different random values, but it does not work in combination with
ORDER BY - it's just not sorted.
So is there any solution for this?!
Thanks in advance,
Angela
I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off
this list
but am still on it. Can somebody help me out? I got 779 e-mails today.
Thanks, Angela
Gerald Clark wrote:
I don't recall you identifying the file you are installing from, but
it sounds like
: http://maccentral.macworld.com/news/0106/04.mysql.shtml
Thanks,
Angela
Apple releases MySQL update
Staff Report, [EMAIL PROTECTED]
June 4, 2001, 4:25 pm ET
If you're using a Mac configured with Mac OS X Server and MySQL, you
should be aware of a new update in circulation. Apple's Software
://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Angela Curtis
Innovative Business
I think I'd be buying one of those hybrid cars if I were you. They get
something like 60 miles per gallon. I think I'd be riding my bike more
too...
Oh, and last I checked, gas here in Ohio is $1.28/gallon today.
:)
-Angela
Redvers Davies wrote:
By now you're probably thinking gasoline
Shouldn't the first query have parenthesis? As in:
DELETE FROM test WHERE userID=X AND (testID20 OR
testID80);
Even if it works the other way, parenthesis make it more clear what
you're trying to accomplish.
-Angela
Michael Griffith wrote:
When using mySQL I've learned to avoid
:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Angela Curtis
DELETE FROM news WHERE newsdate=DATE_ADD(CURRENT_DATE, INTERVAL -14 DAY)
Above is the code that I would use to do that job. Hope this helps.
-Angela
Thomas Katsampes wrote:
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than
off the LIMIT 0,1 part. Hope this helps
-Angela
Richard Reina wrote:
I've tried the manual (and the Oreily MySQL book) and played around with
MAX() and GREATEST() but could not figure it out.
|ID |NAME |RATING |
|213|McCallen 12| 9 |
|214|Glenmorangie | 8
if this is
what you're looking for.
-Angela
Arthur Radulescu wrote:
Hi!
I have 2 questions!
1.What is more eficient to keep some images into a table or to keep their names in
the table and images separated in a directory?
2.How can I join to big tables and verify if there are any duplicat
33 matches
Mail list logo