On Jun 7, 2011, at 10:43 PM, Johan De Meersman wrote:
> If that's all you did, you indeed 'removed the default NULL' but did not
> specify another default. Hence, if you don't explicitly specify a value in
> your insert statement, the insert can not happen as the server doesn't know
> what to p
2011/06/07 17:06 +0200, joe j
WHERE (`person_name` ='Tom' AND `person_name` ='Kevin' )
This is quite wrong: it is always false. Try another operator.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?u
- Original Message -
> From: "Anupam Karmarkar"
>
> select * from XYZ where key = 123;
>
> Now if i have to load data feed of 10 million once in week i need to
> consider loading time also
Yes, On InnoDB you can't disable the primary key, as the data is
index-organized. The reason why t
Hi Daniel,
you can use a workaround from the shell,
cd /path/to/your/database (e.g.: cd /var/lib/mysql/mydb)
ls -al *table** | awk '{print $8}' | awk -F"." '{print "--ignore-table=*mydb
*."$1}' | xargs mysqldump -u*root* -p*toor* *--your-flags **mydb*
It's not that beautiful but it should work
I am loading data using LOAD DATA as source is csv file.
My selection is very simple with like
select * from XYZ where key = 123;
for 1 million sample record
I created innodb table with key, to load data from csv it took nearly 1 and 1/2
hour on modest PC
I created MyISAM table with key it took
Dear all,
I am currently trying to figure-out how I could ignore multiple tables in
mysql using a simple a regex. For example I have multiple tables which have
the following structure: mytable1, mytable2, ..,mytable100. And I
would like these tables to be ignore when doing mysqldump by doi
