- Original Message -
> From: sono...@fannullone.us
>
> Yes. That's all I did.
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 serv
- Original Message -
> From: "Claudio Nanni"
>
> how do you load data? is it naturally ordered in any way?
Also, what's the record structure, and what are the criteria you use to check
if a record exists?
If you only need to know wether a given record exists, your best bet is
probab
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a table that has  two columns
>> "country" and "pers
Why not GROUP BY?
On Jun 7, 2011, at 10:06 PM, joe j wrote:
> Dear all,
>
> I wish to create a new table from a table that has two columns
> "country" and "person_name". Thus from the table below, I'd like to
> select all the records of those countries that have person names 'Tom'
> and 'Kevi
Dear all,
I wish to create a new table from a table that has two columns
"country" and "person_name". Thus from the table below, I'd like to
select all the records of those countries that have person names 'Tom'
and 'Kevin'.
"country" "person name"
US Antony
US
> On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
> > What exactly do you mean by "removing the NULL default"? Did you set
> > your colums NOT NULL?
>
> Yes. That's all I did.
In stead of getting info drop-by-drop, you might want to share the output of
SHOW CREATE TABLE...,, but my
On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
> What exactly do you mean by "removing the NULL default"? Did you set your
> colums NOT NULL?
Yes. That's all I did.
Marc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
Hi Anupam,
how do you load data? is it naturally ordered in any way?
Claudio
2011/6/7 Anupam Karmarkar
> Hi All,
>
> We have very big table with few column contains nearly 10 million records,
> We need to tune this table for simple select statement where we check record
> exists in table or no
Hi All,
We have very big table with few column contains nearly 10 million records, We
need to tune this table for simple select statement where we check record
exists in table or not and requirement is response time should be less than 10
million second for nearly 1000 concurrent requests, wha
- Original Message -
> From: "Adarsh Sharma"
>
> Not getting U'r point marked as bold & Underline
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the files.
Given that MyISAM doesn't supp
Johan De Meersman wrote:
- Original Message -
From: "Claudio Nanni"
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM ta
12 matches
Mail list logo
