Easy enough to rectify
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
ALTER TABLE `tbl_xyz` ADD COLUMN `updated_on` TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `prod_id`;
Personally I put a 'created_on' and an 'updated_on' column for mostly every
Use something like SQLYog, load your .sql file into the editor, run all the
commands one at a time, or in bulk. Look at the info window for what
line failed.
-Original Message-
From: Sydney Puente [mailto:sydneypue...@yahoo.com]
Sent: Tuesday, May 25, 2010 2:39 PM
To:
-Original Message-
From: Nurudin Javeri [mailto:nsjav...@idh.com]
Sent: Sunday, April 18, 2010 9:25 AM
To: mysql@lists.mysql.com
Subject: How to corrupt a database please???
Hi all, I am hiring a few new junior DBA's and I want to put
them thru a
simple db repair training.
-Original Message-
From: Dan Nelson [mailto:dnel...@allantgroup.com]
Sent: Wednesday, April 14, 2010 7:23 AM
To: David Florella
Cc: mysql@lists.mysql.com
Subject: Re: Make delete requests without impact on a database
In the last episode (Apr 14), David Florella said:
I am using
-Original Message-
From: Elim PDT [mailto:e...@pdtnetworks.net]
Sent: Monday, March 29, 2010 5:57 PM
To: mysql@lists.mysql.com
Subject: timezone questions
data from one server in timezone A ported to another server
in timezone B, what will happen for the records with datetime
http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-t
raffic-cameras
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Not sure if this well help, but SQLYog (the best mysql GUI EVER) has an
option that will take two databases and create a schema difference (ALTER
statements, etc.) as well as I think data maybe?
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Wednesday, March
c3pO really? as in Starwars?? ;-)
/me rolls eyes.
-Original Message-
From: Peter Chen [mailto:peter.c...@aicent.com]
Sent: Thursday, March 11, 2010 3:25 AM
To: Mattia Merzi
Cc: mysql@lists.mysql.com
I use Hibernate to access Mysql, the connection poll is
c3p0-0.9.0, can I just
This isn't surprising, especially if you have foreign keys or indexes, as
each DELETE will cascade and require a rebuild of the indexes (just as an
INSERT does).
Make sure that for each DELETE you are using LIMIT 1; if it's in a loop
(and you're not deleting via PK, but it's a good habit to get
Why are you using special characters!? You're just asking for trouble.
Just use letters, numbers, underscores for database names, table names and
column names.
In fact, you should probably use lowercase as well.
http://www.learn-mysql-tutorial.com/Identifiers.cfm
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Thursday, January 28, 2010 2:16 PM
To: mysql@lists.mysql.com
On 1/28/2010 3:21 AM, changuno wrote:
Read a blog which states 50 things to know before migrating
from Oracle to MySQL. Any comments on
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
-Original Message-
From: Dan Nelson [mailto:dnel...@allantgroup.com]
Sent: Monday, January 25, 2010 11:42 PM
To: Daevid Vincent
For a hosted environment (or a restricted corporate
environment), it means you don't have to give your users
shell accounts; they can schedule table
I don't get it... I mean, I get the concept -- it's a crontab; but why
would someone opt to put these events here instead of in the God-given
CRONTAB as everything else in the system uses? This just seems like one
more place to forget about a query/code and have unexpected things
happen.
We
De
Meersman
Sent: Friday, January 22, 2010 1:06 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Price, Randall
Subject: Re: Best way to synchronize two database schemas
Simple: prefix the change files with mmddhhmm formatted timestamps, so
they sort correctly :-)
On Thu, Jan 21, 2010 at 11
Exactly what Johan said.
I keep structure like so:
develo...@mypse /var/www/dart2/UPDATES $ ll
-rw-rw-rw- 1 developer developer 551097 2009-12-22 23:16
airports_city_country.sql
drwxrwxrwx 2 developer developer 4096 2010-01-21 04:51 CVS
-rw-rw-rw- 1 developer developer 3063 2009-07-15 01:40
-Original Message-
From: John Meyer [mailto:john.l.me...@gmail.com]
Sent: Monday, January 18, 2010 5:04 PM
To: co...@obviouslymalicious.com; mysql@lists.mysql.com
Subject: Re: Record old passwords ?
Although, on an OT, forcing people to not use a password that they
have
Peter, this only addresses a sub-select scenario, which doesn't surprise me
it would be slow. How does IN() fare if you populate it with the ID's
directly? For example: IN(1,3,6,8,19,45,54...) ?
In the example, on the web page, we could have run this as two separate
queries. One for the 'inner'
http://www.greggdev.com/web/articles.php?id=6
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Thursday, January 07, 2010 12:10 PM
To: mysql@lists.mysql.com
Subject: Probability Selects
I've tried Googling till my brain is fried and I'm obviously missing
http://isc.sans.org/diary.html?storyid=7900
http://isc.sans.org/diary.html?storyid=7900
Possible new MySQL 0day
Published: 2010-01-06,
Last Updated: 2010-01-06 21:46:51 UTC
by Toby Kohlenberg (Version: 1)
http://intevydis.com/ Intevydis has published a flash video showing what
appears to be
Perhaps the examples here would help you:
http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html
-Original Message-
From: Noel Butler [mailto:noel.but...@ausics.net]
Sent: Saturday, December 26, 2009 6:47 PM
To: mysql@lists.mysql.com
Subject: anniversary selects
Hi,
Hope
I got an alert that one of the drives was filling up (3% free). So I
figured out that a large chunk was from /var/log/mysql
r...@pse10:~# find / -type d -print0 | xargs -0 -n1 du -sk | sort -rn |
head -n20 ~/dir-sizes.txt
r...@pse10:~# cat ~/dir-sizes.txt
159121012 /
70442396 /var
70127764
this and
depending how busy is your master)
grab the master status (position)
change the slave to point to the master new position
start the slave
Hope this helps.
Carlos
On 12/23/2009 2:20 PM, Daevid Vincent wrote:
I got an alert that one of the drives was filling up (3%
free). So I
Maybe I'm not understanding something, but I tried your online demo (NBA
database), I set Home like Boston% which shows two records. Now what?
Where is the PHP code that was supposedly generated to make this query?
Isn't that what your tool does? Makes the actual PHP code and SQL query
code for me
Yeah, plus just think about all those job sites and resumes that would
have to change from LAMP Developer to LAxP Developer
if MySQL forked and changed names! Myself included. All those poor
recruiters would need to be trained to know that dbXYZ == MySQL. LOL.
How many LADP Developsers do you
Will this work in 5.0?
If I'm reading this right, it seems like this is some kind of trick or
loophole then right? If it works and solves my dilemna, I'm fine with that,
but I'm just curious.
How fast is this? I mean, if I have an 80GB database, is it like a real
unix 'mv' command where it
as the experiment.
- michael dykman
On Fri, Dec 11, 2009 at 4:40 PM, Daevid Vincent
dae...@daevid.com wrote:
Will this work in 5.0?
If I'm reading this right, it seems like this is some kind
of trick or
loophole then right? If it works and solves my dilemna, I'm
fine
How can it possibly be that mySQL doesn't allow you to rename a database? I
can't fathom how this can be a difficult task at all to do. Aren't mySQL
databases stored in a directory of the DB name? And for INNODB, can't you
just find the spot in the ibdata file and alter whatever needs to be
Sudhir, please remove the || from your name in your email: || Sudhir
Nimavat ||
We have about 1 BILLION rows of data here and we do a few tricks which may
or may not be of interest to you.
For starters, setup replication and write to a master and have at least 2
slaves. This makes backups MUCH
ALTER TABLE articles ADD INDEX date_idx (date);
-Original Message-
From: Ian [mailto:barnrac...@gmail.com]
Sent: Thursday, October 08, 2009 12:23 PM
To: mysql@lists.mysql.com
Subject: Trying to index a table - cant figure out best way
Hi,
I have a table that stores article
+2
-Original Message-
From: Brent Baisley [mailto:brentt...@gmail.com]
Sent: Friday, September 04, 2009 6:21 AM
To: AndrewJames
Cc: mysql@lists.mysql.com
Subject: Re: a better way, code technique?
You should store the current user id in a session variable. Then you
don't have
While not python, maybe this bash script will give you some clues?
http://daevid.com/content/examples/daily_backup.php
Also, please don't cross post to multiple lists. Not everyone on this mySQL
list is on the python list and vice versa. It's just bad netiquette.
-Original Message-
: Wednesday, September 02, 2009 1:43 PM
To: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: Problem w/ mysqldump
I checked my own backup script from earlier years and
everything was good.
You know, if I could simply figure out where the data was
actually stored,
in what file, I could copy
You might consider a full disk/volume/partition encryption maybe?
http://truecrypt.com/
I use this for my private files and it's awesome. Cross platform and can do
virtual partitions on an actual physical drive.
-Original Message-
From: philip [mailto:phi...@livenet.ac.uk]
Sent:
You need a timestamp column that autoupdates upon insert.
http://dev.mysql.com/doc/refman/5.0/en/datetime.html
Then use the DATE_SUB function for x seconds.
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function
_date-sub
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user
,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants;
+-+
| mygrants|
+-+
|
How the F do you remove a user from the grant table?!!
The mysql.com site is down too by the way...
(r...@localhost) [(none)] SHOW GRANTS FOR 'madc';
ERROR 1141 (42000): There is no such grant defined for user 'madc' on host
'%'
(r...@localhost) [(none)] SHOW GRANTS FOR 'madc'@;
ERROR 1141
-Original Message-
From: Gary Smith [mailto:g...@primeexalia.com]
Sent: Monday, July 13, 2009 8:54 PM
To: Daevid Vincent; mysql@lists.mysql.com
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
InnoDB: Your database may be corrupt or you may have copied
_
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:41 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Gary Smith
Subject: Re: Copy 70GB ibdata, etc. and server won't start now
Why do the dates on the log files differ by almost a month between Old
Smith [mailto:g...@primeexalia.com]
Sent: Tuesday, July 14, 2009 2:11 PM
To: Johnny Withers; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
Johnny,
I'm less worried
-Original Message-
From: Carlos Proal [mailto:carlos.pr...@gmail.com]
Sent: Tuesday, July 14, 2009 5:13 PM
Another thing you can do is simply erase the innodb logs.
If the dbms
really was shutdown properly then the logs are useful,
they will be recreated again and you can go
Did you even look here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Monday, July 13, 2009 12:43 PM
To: Ray
Cc: mysql@lists.mysql.com
Subject: Re: MySQL GUI Tools
Yup. That was what I was looking
I have a 70GB database that I need to put on another box I'm building
(Ubuntu 9.04 w/ext4, 1TB drive). I copy these files from the existing
database (stopped it first of course) via USB HD. Doing a mysql dump/restore
isn't really realistic as it gets exponentially slower and can take from 3-5
days
-Original Message-
From: Scott Haneda [mailto:talkli...@newgeo.com]
Sent: Wednesday, July 08, 2009 9:50 AM
To: mysql@lists.mysql.com
Subject: Client deleted database, semi high priority master
slave question
A client deleted their database and did not have a slave in
place
for MySQL:
http://www.toadsoft.com/toadmysql/Overview.htm
On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent
SQLYog by Webyog is the best mySQL GUI client for
Windows. Hands down.
not even a question. I've used them all I think.
http://webyog.com/en/
There's even a free community
SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not
even a question. I've used them all I think.
http://webyog.com/en/
There's even a free community version, but honestly it's worth purchasing
the extended one for all the added features. They also release new ones all
the
[mailto:dstepli...@gmail.com]
Sent: Wednesday, June 03, 2009 8:41 AM
To: Jerry Schwartz
Cc: Jay Blanchard; Daevid Vincent; mysql@lists.mysql.com
Subject: Re: Why doesn't mySQL stop a query when the browser
tab is closedL
Hi Daevid,
You can always stop the query by running
SHOW PROCESSLIST
I just noticed a horrible thing.
I have a query (report) that can take 15 minutes or more to generate with
mySQL. We have 500 Million rows. This used to be done in real time when we
had less rows, but recently we got a big dump of data that shot it up.
So, noticing via myTop the query taking
Wondering which of these will work or not?
(no quotes)
GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY
PASSWORD 'secret';
(backticks)
GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED
BY PASSWORD 'secret';
(single quotes)
GRANT ALL PRIVILEGES
and like I specifically said in my grant statement
up above??!
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Tuesday, May 26, 2009 4:49 PM
To: 'mysql@lists.mysql.com'
Subject: GRANT and ticks or no ticks...
Wondering which of these will work or not?
(no quotes
I'm a little concerned and disappointed that the GRANT command doesn't do
any sort of checking (like a foreign key for example) to verify that the
database and table exist?!
I get the case of *.* but it seems crazy to me that it would allow foo.bar
when neither a database named 'foo' nor a table
We have a master / slave setup and as you know, one bad query can ruin your
whole day. Or if you accidentally write to the slave when you meant to write
to the master, or any number of other things that break the fragility of a
replication setup.
The magic incantation to get them synched again
To: Claudio Nanni; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: mySQL slave IO Running and SQL Running
Please note that this is *NOT* a way to get them synched again
In fact if you have to skip a replication statement on the
slave then it is usually a sign your slave has different
:
NNN.NNN.NNN.NNN (spaces are okay).
* @since3.0
* @author Daevid Vincent [dae...@]
* @date 10.13.03
*/
function deduceRange($iprange)
{
//check if we're in / notation (CIDR)
if ( strstr($iprange, /) )
{
list($myIP,$mySlash) = preg_split
Have I been in a coma or something?
WTF happened to 5.2 and 5.3? Hell, we're still on 5.0.51 and 5.1 just came
out a month or two ago right?
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Thursday, April 30, 2009 7:40 AM
To: mysql@lists.mysql.com
Subject: Is there a
http://www.daevid.com/content/examples/snippets.php
scroll down to Automatic Monitoring of remote servers
You'll need Gnome, ssh keys (for remote execution), .mytop file, wmctrl and
xtrlock.
To: Daevid Vincent dae...@daevid.com
Cc: mysql mysql@lists.mysql.com
Subject: Re: Separate customer databases vs all in one
Date: Tue, 17 Mar 2009 21:17:00 -0400
Are these databases identical or merely similar? If they are structurally
identical, I'd go for one database per customer. Then you
I'm writing a report tool wherein we have many customers who subscribe
to this SaaS. There are millions of rows of data per customer. All
customers are islands from each other (of course).
Are there any major issues or benefits between storing each customer in
their own database (with their own
Someone sent me a huge SQL query today that used instead of AND
all over the place. I was a bit surprised that it is legal mySQL, but I
was always under the impression that is not proper. Can anyone confirm
or deny this? Like will ALL SQL RDBMS support that syntax?
I'm really confused. First, I don't understand why quoting my IN()
values here caused them to run significantly slower than the non-quoted
versions... on just this simple contrived example it can be as much as
2.2 seconds vs. 0 seconds to return on a table that has 2.5M rows.
The problem I'm
I thought this article was really good at explaining the differences of
relational DBs and Key/Value stores and some other models coming down
the pipe (i.e. the new buzzword Cloud Computing).
http://www.readwriteweb.com/archives/is_the_relational_database_doomed.php
Will mySQL be adaptable to
When our database reaches the 10-100TB range, we may need to consider
non-relational databases. Relational databases like MySQL tend to
heavily rely on random access, which is governed by the slow disk seek
rates. On the other hand, non-relational database pioneered by Google's
Map/Reduce
While SSD's (Solid State Disks) have traditionally not been the best
hardware to use for rewrite-intensive operations like databases, over
the last few months, some leading Linux kernel engineers have been
raving about next generation Intel SSD's that are close to 20x faster
than the fastest disk
Monty leaves Sun; this time for sure:
http://monty-says.blogspot.com/2009/02/time-to-move-on.html
Incidentally a friend of mine met Ted Leung of Sun (local geek celebrity
and author of a few books) at the UW Python mini-conference last
Saturday. Sun seems very keen on supporting dynamic
I downloaded this for Ubuntu and installed (after installing libzip1
which was required BTW)
So, Workbench loads, but I don't see any way to connect to my mySQL
server (I'm not running my DB locally as it has 1/2 Billion rows).
I did a quick search and found this rather disappointing page:
:
#!/bin/bash
# written by Daevid Vincent on 01/22/09
# This will harvest all the 'mysql' tables schema and data from each
$MYSQLRDBMS
# make sure we're running as root
if (( `/usr/bin/id -u` != 0 )); then { echo -e \e[00;31mSorry, must be
root. Exiting...\e[00m; exit; } fi
USERNAME
We have some INNODB tables that are over 500,000,000 rows. These
obviously make for some mighty big file sizes:
-rw-rw 1 mysql mysql 73,872,179,200 2009-01-22 02:31 ibdata1
This can take a good amount of time to copy even just the file, and a
mysqldump can take hours to export and import
On Wed, 2009-01-21 at 13:36 +0800, mik...@qualityadvantages.com wrote:
Hello mysql,
I would like to run a PHP script to perform a CRON Database backup to
avoid passing database credentials to the CRON process. Does this make
sense?
What are the recommended MySQLDump options that should
, ddevaudre...@intellicare.com wrote:
Daevid Vincent dae...@daevid.com wrote on 01/15/2009 09:57:19 PM:
you misunderstand me. I have three servers (dev, test, prod) that all
have maybe 3 databases EACH that have all these eventum* tables in them.
don't ask. a simple trickle won't do. I'm writing
I've been tasked with cleaning up a bunch of 'eventum' tables that got
accidentally dumped into several databases and then replicated.
I'm wondering if I can just go through with a simple command to blow
these all away:
find /var/lib/mysql/ -name eventum*
Or is there some other magic that a
its a simple case of drop the tables on the master and let
replication do the rest!
John Daisley
On Thu, 2009-01-15 at 17:44 -0800, Daevid Vincent wrote:
I've been tasked with cleaning up a bunch of 'eventum' tables that got
accidentally dumped into several databases
http://developers.slashdot.org/article.pl?sid=08%2F12%2F09%
2F0047225from=rss
Sun's Mickos Is OK With Monty's MySQL 5.1 Rant
Back on November 29, MySQL developer Michael Widenius trashed Sun's
decision to give MySQL 5.1 a 'generally available' designation in a
now-infamous blog post. Widenius
Do you seriously have a column named 0020,0032 ?!!?
And don't even get me started on the actual name of these images (column
data).
Wow. That makes my head hurt.
I think mySQL is just punishing you for both of those offenses. *hee
hee* ;-p
But if I were to venture a guess, and RTFM...
Also, I realize you're trying to 'encode' some sort of X\Y\Z coordinates
in that column, so perhaps a different delimiter such as the pipe |
character or , would be more appropriate than a \ which has special
meanings?
Or possibly just split them out into separate X, Y, Z columns rather
than
If this is a web app, then it should be making a new connection every
time a page is loaded (where applicable). At least that's how every PHP
site I've ever made works...
If this is a stand alone app, if your language has threads you could
(hackily) have a thread that does some NO-OP every hour
On Thu, 2008-12-04 at 08:27 +0700, sangprabv wrote:
Hi,
I get stuck to build a query to select records between curdate() and the
last 4 weeks and groupped by week. I tested with:
SELECT *
FROM momtbak
WHERE insertdate
BETWEEN curdate( )
AND curdate( ) - INTERVAL 4 week
It doesn't
Monty Widenius (MySQL co-founder who recently left Sun), on the other
hand, doesn't cast a very favorable light on 5.1 for production use.
Good read:
If you plan to use any of the new features of MySQL 5.1, regard
these as if they would be of beta quality.
Do a quick google search for Monty Widenius left sun and behold...
On Mon, 2008-12-01 at 13:45 -0600, David Giragosian wrote:
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Monty Widenius (MySQL co-founder who recently left Sun)...
What's the news on this?
David
I want to remove all records from 'feed_tag' where the feed_id foreign key
doesn't have any corresponding records in feed.
For instance I may have a record in feed_tag that is like (23, 10, 4543,
'... (some date)').
Then lets say there is no record in feed that has a primary id key of 10.
I
-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 9:05 PM
To: Daevid Vincent; MYSQL General List
Subject: Re: Deleting duplicate rows via temporary table
either hung or taking way way too long
Daevid Vincent wrote:
DROP TABLE
Having a bit of trouble deleting 8645 duplicate rows...
#//mySQL is broken and you can't reference a table you're deleting from in a
subselect.
#//http://www.thescripts.com/forum/thread490831.html
#// you can't even update said table, so this elegant solution fails too...
#// update buglog set
stupid enough to then start trying to
connect my PHP application to localhost via 127.0.0.1 or something equally
assinine.
Please tell me this isn't the case.
_
From: Moon's Father [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 1:44 AM
To: Sebastian Mendel
Cc: Daevid Vincent
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz
Sent: Tuesday, January 15, 2008 1:49 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: does 'disable networking' make mySQL faster?
On Jan 14, 2008 7:00 AM, Daevid
I saw this on the PHP list and was wondering if there is any merit to it?! I
would be surprised if disabling networking made a difference. I'm only
concerned about the added speed. I get the security benefit of course.
-Original Message-
From: Manuel Lemos [mailto:[EMAIL PROTECTED]
Do it anyways. Release it as Open Source. IBM is big into the FOSS
community, and I seriously doubt they will persue this.
Just because they have a patent, you can always build a better mouse trap.
You are allowed to improve upon an idea that is patented, or do it a
slightly different way the
questions are in this freakin' survey! i'm on #32 and many
are multipart!!!
I'm done dude. I've got no more time to be wasting on this.
UGHHH!!!
_
From: MySQL [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 11:02 AM
To: Daevid Vincent
Subject: MySQL Customer Survey
New
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 1:54 PM
To: Jeremy Cole; Daevid Vincent
Cc: mysql@lists.mysql.com; 'MySQL'
Subject: Re: MySQL Customer Survey :: an exercise in frustration
At 13:19 -0800 3/12/07, Jeremy Cole wrote:
I just finished it. There were 56 questions
I'm baffled as to why this isn't working...
I am 'root'. I have full perms and all that stuff. I use these DBs every
day. Yesterday, I deleted a table that had FKs because I wanted to change a
column name, but couldn't because of the restraint *sigh*. After that I
couldn't re-create the table
When will I be able to do something seemingly so basic as this re-use of an
alias?
SELECT DATE_ADD('2007-10-23', INTERVAL user_access_hours HOUR)
AS group_duration_date,
UNIX_TIMESTAMP(group_duration_date)
AS group_duration_date_timestamp
FROM
]
Sent: Tuesday, October 23, 2007 5:39 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Why can't I still not use an ALIAS in the SELECT
portion of an SQL statement?
When will I be able to do something seemingly
so basic as this re-use of an alias?
Do you know
Is there a way to know how many rows were used in a computation?
I tried this 'trick' but I still get 1, when I know that there are 3 rows
used...
SELECT SQL_CALC_FOUND_ROWS
MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours
HOUR)),
MAX(access_expire)
FROM
I'm trying to get some 'release/version numbers' to sort properly.
mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecified |
|20
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Friday, October 12, 2007 2:07 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Need help with a natural sort order for
version numbers and release code names
Daevid Vincent wrote:
I'm trying
A wise man once taught me, organization is the key to success.
Put all the data in the same table you have. 200k people is nothing for
mySQL to handle, and the cost of an extra JOIN is going to be a nightmare to
deal with all the time.
I thought I learned/read somewhere a long time ago that
This has been asked for many many times on this list, not sure why mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do, as they
already have a SQL parser! I can't tell you how many times our daily
It's not free in that you have to buy the product, but it is free in
that you make ONE report and get multiple export modules that you don't have
to write yourself. That alone is awesome!
http://www.jaspersoft.com
:)
-Original Message-
From: chombee [mailto:[EMAIL PROTECTED]
Sent:
From: Matt Gordon
Sent: Friday, September 14, 2007 6:37 PM
To: Daevid Vincent
Subject: Trailing space thing to post to mysql list
I searched Google and didn't find anything obvious.
Here is minimal SQL to reproduce the problem.
#
# Running mysql 5.0.41
-Original Message-
I need to select a max value for a group of records and I
also need the
primary key for that record.
I am wondering if this can be done with a single query? e.g
Table_x
id count cat_id
110 1
220 2
335 2
415
Just do this...
create table temp (
id int not null primary key auto_increment,
data varchar(100),
inserted timestamp default 0,
lastupdated default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
And just use
Insert into temp (inserted ) values (NOW());
You're only inserting once, so
101 - 200 of 386 matches
Mail list logo
