RE: LOAD DATA warnings

2003-10-28 Thread P.Gertman 
  mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO 
 TABLE quantis_mkr;
  Query OK, 271392 rows affected (4 min 2.95 sec)
  Records: 271392  Deleted: 0  Skipped: 0  Warnings: 61
  
  How can I see those warnings? 
  I checked the error log but nothing shows up there.
  
 
  From version 4.1.1 you can use SHOW WARNINGS command:
   http://www.mysql.com/doc/en/SHOW_WARNINGS.html

What about earlier versions? I'm using 4.0.13
Can I see those warnings in 4.0.13?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to import Paradox data to MySQL?

2003-09-24 Thread P.Gertman 
Is there a painless way to import Paradox data and database structure to MySQL? 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Import from Paradox

2003-09-17 Thread P.Gertman 
Greetings!
Is there a relatively painless way to import database structure from Paradox db?
Can MySQL support be inserted instead of BDE into Delphi application 
without rewriting large part of it?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Import from Paradox

2003-09-17 Thread P.Gertman 
Is there a relatively painless way to import data and database structure from Paradox 
to MySQL.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: RE: own privileges

2003-08-27 Thread P.Gertman 
User can use SHOW GRANTS command:

Thank you!
But one more question: what privileges user should have to issue this command? I've 
got a user who has rights only to SELECT from certain db. What should i GRANT to him 
to allow use of SHOW GRANTS?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

own privileges

2003-08-25 Thread P.Gertman 
Is there a way for a user to get knowledge about his own privileges?
For example can a user know if he/she has rights to INSERT INTO some table?
I'm using PHP4

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]