timeout?

2003-08-14 Thread Maciej Bobrowski
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

Re: mysqldump from the 4.1.0-alpha

2003-08-01 Thread Maciej Bobrowski
> --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

mysqldump from the 4.1.0-alpha

2003-08-01 Thread Maciej Bobrowski
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 --

Re: specific records

2003-07-02 Thread 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<

Re: specific records

2003-07-02 Thread Maciej Bobrowski
'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]

specific records

2003-07-02 Thread Maciej Bobrowski
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]

restrictions?

2003-07-01 Thread Maciej Bobrowski
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 --

Re: importing data from pervasvie to MySQL

2003-03-02 Thread 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

SSL connection from client

2003-02-19 Thread Maciej Bobrowski
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

InterBase vs. Mysql

2003-02-18 Thread Maciej Bobrowski
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

SSL connection from client

2003-02-17 Thread Maciej Bobrowski
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