Dear all
Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed
that I cannot grant privileges any more. Any hint how I can undo
that?
Thanks, W. Bauer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
into counts(n)
select count(*) from mytable group by col1;
select n,count(*) from counts group by n;
drop table counts;
Thanks for a hint,
W. Bauer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear all
I have a table with more than 100'000 records for a single product. At
the end, I will have tables for 26 prodcuts. There is basically no
dependence on other tables.
Somewhere I read that one should avoid a large number of tables in
a database. Is it more recommendable to have a singl
Dear all
When I run a query on a table with about 22 Mio records and three columns of
type bigint, I get a Error 2013 Lost connection to MySQL server during
query. If I use limit x it works fine as long x<70.
Is there anything I can do to circumvent this error?
Thanks, W. Bauer
--
NEU
Dear all
When I use
Insert into table tabl1 (col1)
select ...
to insert about 2 mio. rows into tabl1 I get the error message 2013
connection lost.
When I just run the query, pipe the output into a text file, and use the
load data local infile into table tbl1, it works. How can I chang
I have to correct my previos mail: using load data infile, all rows are
correctly loaded into the table. Yet, the control center displays a
smaller number of total records than the true number, which is
correctly displayed by count(*). What does the display in the control
center mean?
Wolfgang
Hi,
I have a text file with 120'000 lines. When I do a
load data local infile
only 85'416 records are loaded. There is no message of the sort
Query OK, X rows affected
just the next prompt is displayed.
I'll be glad for any hint what could cause this behavior. I'm using
versi