You should send that one to The Daily WTF... http://thedailywtf.com/
Jay Blanchard wrote:
[snip]
I recently last week Had and experience with an Very small Company,
where as
they had around 15 Machines all hooked "Star topology" and a central iis
ASP
Web server that only showed the date, and a
Hi,
Try,
mysql> delete from GbEntries where sender not in (select * from Accounts);
Thanks
ViSolve DB Team.
- Original Message -
From: "Christian Parpart" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 20, 2006 3:11 PM
Subject: howto query DELETE
--
MySQL General Mailing List
There is a oracle SQL:
SELECT employee_id, salary, hire_date, STDDEV(salary)
OVER (ORDER BY hire_date) "Std Deviation of Salary"
FROM employees WHERE job_id = 'ST_CLERK';
The result is:
EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary
--- -- --
How to transfer the oracle function PERCENT_RANK to mysql?
oracle example:
SELECT PERCENT_RANK(11000) WITHIN GROUP
(ORDER BY salary DESC) "Rank of $11,000 among managers"
FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
How to transfer the oracle function PERCENT_RANK to mysql?
oracle example:
SELECT PERCENT_RANK(11000) WITHIN GROUP
(ORDER BY salary DESC) "Rank of $11,000 among managers"
FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
There is a oracle SQL:
SELECT employee_id, salary, hire_date, STDDEV(salary)
OVER (ORDER BY hire_date) "Std Deviation of Salary"
FROM employees WHERE job_id = 'ST_CLERK';
The result is:
EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary
--- -- --
hi
I have this error on mysql engine Could not connect: Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
is there any suggestion my version is 3.23.58
BR
Replying to myself again...
OK, some more light on the subject. I did a complete dump of the
master and reloaded the slave thinking maybe I had corrupt tables or
something. Having started the slave with skip-start-slave, I found
that I could stop mysqld on command line using mysqladmin
I left out URL to source compilation procedure and flags in original
message. Here it is:
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/
index.html
ANy advice would be really appreciated.
Regards, Kieran
On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:
I have MySQL 4
Regarding the format of TIMESTAMP columns, one of the user comments on
http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html
offers the solution below:
Posted by Kjell Arne Rekaa on April 14 2005 11:11pm
If you want the same view of a timestamp field in 4.1.x as it was in
in earlier mysql ver
I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo Mac
Mini running OS X Server 10.4.8. It is a slave replicating to a
master over ssl. Replication works fine, however I get this error
always if I execute the STOP SLAVE statement
([EMAIL PROTECTED]) (none)> stop slave;
ERROR 20
Raj,
Normally, if you have problem with your configurations, I suggest recreate
your databases :
1) backup all your database using mysqldump
*$ mysqldump --opt --user=root --password= --databases db1 db2 db3
db4 > /your/directory/of backups/backup.databases.dmp*
**
**
2) delete your databa
Optimize table does not reclaim space for InnoDB tables in the shared
tablespace, FYI - only for those that live independently when using
the 'innodb_file_per_table' option.
On 12/20/06, Raj Shekhar <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> In my configuration file there was a line
[EMAIL PROTECTED] wrote:
> In my configuration file there was a line that said:
> innodb_data_file_path = ibdata1:10M:autoextend:max:1900M
>
> This refers to the data file that contains all of my databases. The
> number
> 1900M is close to the 2G filesize limit on my linux server. With all of
>
> On 12/19/06, Bing Du <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386
>> (Source distribution). /etc/my.cnf has the following configurations.
>>
>> ==
>> [mysqld]
>> datadir=/var/lib/mysql
>> socket=/var/lib/mysql/mysql.sock
>> # Default
The following statement should do the trick:
delete from GBEntries t1 where (select count(*) from Accounts nt1 where
nt1.ID=t1.Sender)=0
Performance of this query will be significantly improved if there is an
index on Accounts.ID.
HTH,
Panos.
On 12/20/06, Christian Parpart <[EMAIL PROTECTED]>
Hi all,
there is a live before foreign keys, but now I'm using mysql 5.0 ;)
how where I'm about to convert my db schema to make use of foreign keys (via
innodb) I am enforced to delete all invalid entries before.
however, I can do this using a huch select loop with a test within to delete
all w
Hi all,
there is a live before foreign keys, but now I'm using mysql 5.0 ;)
how where I'm about to convert my db schema to make use of foreign keys (via
innodb) I am enforced to delete all invalid entries before.
however, I can do this using a huch select loop with a test within to delete
all w
Hi! I would like to upgrade the database of my organisation from
mysql4.0.22 from 4.1. We use Debian.
I've read info in the manual, but i don't have things clear.
We process data of DB with scripts, and I'm annoyed because the change
of format of timestamp, is there any command in 4.1 to obtain
19 matches
Mail list logo