client
if he was still connected and didn't do anything. Is there any variable
which could define something like timeout or I should add something to the
my.cnf?
In previous mysql releases we didn't have such a problem..
Regards,
Maciej Bobrowski
--
MySQL General Mailing List
For list arch
> --opt Same as --add-drop-table --add-locks --all --quick
> --extended-insert --lock-tables --disable-keys. Enabled
> by default, disable with --skip-opt.
Fine, --skip-opt works great.
Tkanks a lot,
regards,
Maciej
--
MySQL General Mailing List
For
VALUES (values2);
...
INSERT INTO table VALUES (valuesN);
Of course I can write a script which will do it, but meybe there is an
option to the mysqldump? I tried --complete-insert and omitted the
--extended-insert option, but it doesn't work.
How can I do this?
Regards,
Maciej Bobrowski
--
O.K. I found the way:
select * from tablename limit 5,6;
it will select 6 records counting from 6.
>> Let's say I have 1000 records in a 'table'. I want to select rows from6
>> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<
'id' column to the table, then when I will remove
some records from the middle part o the table I will have holes, and
the next select will give me wrong data.
Regards,
Maciej Bobrowski
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Let's say I have 1000 records in a 'table'. I want to select rows from 6
to 11. How can I do this?
Regards,
Maciej Bobrowski
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lar table definitions I
will not be able to insert such a data.
Is there a way to restrict it hurder, that when I say that in this column
in this table there can not be any NULL values? And I will not be able to
insert any data into the table with NULL values?
Regards,
Maciej Bobrowski
--
hich I can get the data
> from Pervasive?
Try Perl. You can do everything You need.
Best regards,
Maciej Bobrowski
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Maybe I should change their values for a user?, and then what? ..
- watch how many SSL connections were established.
O.K. Can anybody help me?
Best regards,
Maciej Bobrowski
-
Before posting, please check:
http://www.mysql
o use it very
intensive through the whole day 7 days a week).
Best regards,
Maciej Bobrowski
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
d
an access to files with the keys and certificates?
- watch how many SSL connections were established.
- make that some of users will not have to use SSL to connect to data
base ( actually it is inconsistent with the 1-st point :) )
O.K. Can anybody
11 matches
Mail list logo