 | | | MySQL General | | try
SELECT * from geno_260k WHERE ident IN (SELECT ident FROM geno_260k WHERE
a1 0
GROUP BY ident HAVING count(a1) >250000)
This will give you what you 're deleting first.. then if that is good. dHey all
I am stuck here (thinking wise) and need some ideas
I have this table
CREATE TABLE `geno_260k` (
`genotype_id` int(10) unsigned NOT NULL auto_increment
`ident` int(10) unsigned NOT NHi
This might be happening due to two reasons
1 The system date might not be correct.
2. Some things wrong with log postion (Incorrect log position)
Regards
Krishna Chandra Prajapati
On 8/31/07 M
> I have a column where I need to replace all instances of the text "US-
> Complete " (contained within a long sentence) with "US Complete ".
> There are probably 50 or 100 of them. I 'm really scarOn Tue 4 Sep 2007 Shawn Green wrote
> > On Tue 4 Sep 2007 Lucio Chiappetti wrote
> > For each I tested 3 cases (total 16*3 48)
> >
> > a) the query on the "virtual " table correlated with theActually I fixed the problem by generating a whole new set of SSL
certificates!
Thanks for the help!
Regards
Samy
samy-delux@(protected) schrieb
> Hey
>
> This morning the default timespan of ssl cer
Marten Lehmann napsal(a)
> Hello
>
> I have a table like this
>
> CREATE TABLE `places` (
> `name` varchar(256) collate utf8_unicode_ci NOT NULL
> PRIMARY KEY (`name`)
> ) ENGINE MyISAM DEFAUBrian Dunning wrote
> I have a column where I need to replace all instances of the text
> "US-Complete " (contained within a long sentence) with "US Complete ".
> There are probably 50 or 100 of themBrian Dunning wrote
> I have a column where I need to replace all instances of the text
> "US-Complete " (contained within a long sentence) with "US Complete ".
> There are probably 50 or 100 of themI could use the same thing... just looking through the documentation there
is a replace() function. Maybe do a backup/restore to a test database before
doing this on your live system...
UPDATE `tableI have a column where I need to replace all instances of the text "US-
Complete " (contained within a long sentence) with "US Complete ".
There are probably 50 or 100 of them. I 'm really scared to doHiya
I was backing up a 95GB InnoDB database and forever had problems. It ended up working and I never really worked out exactly what the cause was... but try using the following
--opt (does --quiI am having debugging a problem I am seeing with mysqldump.
While using mysqldump to make backups of my database I will
intermitently get the following error
mysqldump Error 2013 Lost connectioHi
Fletcher Mattox wrote
> We were recently the target of an SQL injection so I am trying to
> determine if they were successful. I have recovered the SQL commands
> from mysqld.log but the codeIf you decide to use the trigger here is the syntax
http //dev.mysql.com/doc/refman/5.0/en/triggers.html
And that table structure looks ok to me
As far as the backup goes just dump the mysql databso if trigger is used then
create table temp (
id int not null primary key auto_increment
data varchar(100)
inserted timestamp
lastupdated timestamp)
is good enough right? trigger will use nowIt looks to me that they are trying to plant a query into your queries
file. What type is column 'id '? I am guessing that they (think they)
have found a vulnerability where running a web app (prob lJust 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
There is nothing terribly wrong with the approach documented in
'http //sql-info.de/mysql/examples/CREATE-TABLE-examples.html ' but as
you no doubt have read it does mean that you have to make sure tWe were recently the target of an SQL injection so I am trying to
determine if they were successful. I have recovered the SQL commands
from mysqld.log but the code has me stumped.
INSERT INTO queris it possible to do without trigger?
i google and found this link
http //sql-info.de/mysql/examples/CREATE-TABLE-examples.html
but when i tried to combine two examples into one CREATE statement anAgreed...
Also for consistency 's sake
On 9/4/07 3 15 PM "Michael Dykman " <mdykman@(protected) > wrote
> Triggers are a fine idea but I would use a trigger for both cases..
> no point putting that lTriggers are a fine idea but I would use a trigger for both cases..
no point putting that level of housekeeping on the application when
you can set rules in the database and more or less forget aboutI would use a trigger (at least for the update)....
The first insert should work with now() and you can leave lastupdateted
empty
Olaf
On 9/4/07 3 01 PM "Hiep Nguyen " <hiep@(protected) > wrote
>Lucio Chiappetti wrote
> On Tue 4 Sep 2007 Lucio Chiappetti wrote
>
> > I 'll do some experimenting and report back.
>
> In lack of better ways of doing a tie-break I 've done the following
> tesHi list
i tried to create a table with inserted & lastupdated timestamp fields
create table temp (
id int not null primary ke auto_increment
data varchar(100)
inserted timestamp default now()
lHi
We 've recently upgrade from MySQL 4.0.18 to 4.1.20 and our applications (Websphere) its not displaying the character as its supposed to do.
But when i do a "select... " from comand the results I had a disk full error on the master MySQL (4.1.22) which was replicating to a
slave (4.1.22).
My question is how do I recover a slave replica when the master had a disk full
error space was freePerhaps if you show us the table structure and exactly what operations
you are using we might be able to provide some insight.. as it is
your report is too vague to make much sense of it.
- michaI just changed to these values
[mysqld]
datadir /var/lib/mysql
socket /var/lib/mysql/mysql.sock
wait_timeout 30
default-character-set utf8
max_allowed_packet 14M (lowered from 3000MB)
max_connect |
|
|
