Jaime Crespo Rincón schrieb:
> 2009/10/29 Michael Dykman :
>> mysqldump is not really a data manipulation tool.. as the name
>> implies, it is a dumper.
>>
>> What you are trying to accomlish can be done rather elegantly via the
>> SELECT .. INTO OUTFILE syntax
>>
>>http://dev
2009/10/29 Michael Dykman :
> mysqldump is not really a data manipulation tool.. as the name
> implies, it is a dumper.
>
> What you are trying to accomlish can be done rather elegantly via the
> SELECT .. INTO OUTFILE syntax
>
> http://dev.mysql.com/doc/refman/5.1/en/select.html
mysqldump is not really a data manipulation tool.. as the name
implies, it is a dumper.
What you are trying to accomlish can be done rather elegantly via the
SELECT .. INTO OUTFILE syntax
http://dev.mysql.com/doc/refman/5.1/en/select.html
and then loaded into your new structu
Sorry if this is a n00b question, I did read the docs for mysqldump
before posting, but couldn't figure it out.
I'm successfully doing a mysqldump, but I want only a few of the
columns, and want them in a different order. Is this possible without
substantially slowing it down? The table has
Olga,
Would you post "SHOW CREATE TABLE taxonomic_units1\G;"?
It should give us more info on the table you are dealing with
Regards,
Mikhail Berman
Olga Lyashevska wrote:
Dear all,
I have a table which contains taxonomic data (species, genera, family,
order, class) and it is organized as a
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote:
> ... taxonomic_units1 AS O1
> LEFT OUTER JOIN taxonomic_units1 AS O2
> ON O1.tsn = O2.parent_tsn
>
> current optimizer has only one option(*): use Nested-Loops Join algorthm, with
> the outer table being the first one. That is,
Hi Olga,
On Thu, Oct 29, 2009 at 03:29:58PM +, Olga Lyashevska wrote:
> I have a table which contains taxonomic data (species, genera, family,
> order, class) and it is organized as adjacency list model.
>
> mysql> select* from taxonomic_units1 limit 5;
> +-+-
Thanks Kabel,
Not sure if this is the exact problem you're trying to solve, but
this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Yes, I have seen this article before, and it is really nice. However
they do not discuss any optimizat
Not sure if this is the exact problem you're trying to solve, but this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Dear all,
I have a table which contains taxonomic data (species, genera, family,
order, class) and it is organized as adjacency list model.
mysql> select* from taxonomic_units1 limit 5;
+-+---+-+
| tsn | name | paren
Here is how I have been doing it, for years, and I have used this to
restore from, which has always worked for me.
http://dl.getdropbox.com/u/340087/Drops/10.29.09/mysql_backup-0196a0c2-013914.txt
A quick explanation, and some caveats:
First, set the u and p variables to a mysql user and passw
11 matches
Mail list logo
