Re: show warnings;

' or 'drop' table statement is preceded with a 'show warnings' statement. Since this file is used to initialize a new database in mysql server, is there any reason to have warnings enabled like this? It seems the warning would be generated 100% of the time since the database did not exist before

RE: show warnings;

I hope you mean that the SHOW WARNINGS statements follow the DDL statements. If the DROP statements have the IF EXISTS modifier, then there should not be any warnings shown in the output. If there are, something (less severe than an outright error) is wrong with the CREATE statement. It might

show warnings;

Hello, I am returning to mysql after long break, so not experienced with details. I inherited a text file with the mysql DDL statements which create database and tables, etc. Each 'create' or 'drop' table statement is preceded with a 'show warnings' statement. Since this file is used

Re: show warnings;

statements which create database and tables, etc. Each 'create' or 'drop' table statement is preceded with a 'show warnings' statement. Since this file is used to initialize a new database in mysql server, is there any reason to have warnings enabled like this? It seems the warning would be generated

how to suppress the SHOW WARNINGS limit ?

hello, from the page http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html I understand that if I want to look at all the warnings with the command : show warnings; then I have first to set a limit bigger than any numbers of warnings that could happen, say : (I know that it might

show warnings.

Hi All, When i load data using LOAD DATA LOCAL INFILE, it shows Query OK, 56678 rows affected, 789 warnings (4.47 sec) Records: 56678 Deleted: 0 Skipped: 0 Warnings: 789 When i do. show warnings It display only 64 rows, can i see all the 789 warning messages as show above. Please let me

Re: show warnings.

Ananda Kumar schrieb: When i do. show warnings It display only 64 rows, can i see all the 789 warning messages as show above. http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html The maximum number of error, warning, and note messages to store is controlled by the max_error_count

Re: show warnings.

messages into a file. regards anandkl On 5/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote: Ananda Kumar schrieb: When i do. show warnings It display only 64 rows, can i see all the 789 warning messages as show above. http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html

'show warnings' is not recognized

I appologize if this is redundant for anyone who follows google groups... Here's my post: Via the tutorial at http://www.analysisandsolutions.com/code/mybasic.htm, I downloaded mySQL and have been running most things with sucess. In case it is pertinent, I used the mysqld-max-nt --install command

RES: 'show warnings' is not recognized

:56 Para: [EMAIL PROTECTED] Assunto: 'show warnings' is not recognized I appologize if this is redundant for anyone who follows google groups... Here's my post: Via the tutorial at http://www.analysisandsolutions.com/code/mybasic.htm, I downloaded mySQL and have been running most things

Re: ENC: 'show warnings' is not recognized

. -Mensagem original- De: Renato Cramer Enviada em: terça-feira, 18 de maio de 2004 10:24 Para: '[EMAIL PROTECTED]' Assunto: RES: 'show warnings' is not recognized Hi Katherine, Sometimes happens, unfortunately, things as this: http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html: Note

Re: something like show warnings?

Craig Harding [EMAIL PROTECTED] wrote: Using Mysql 4.0.12 I know that 'show warnings' isn't implemented until 4.1.* but is there something else that I can do to view warnings? You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email

Re: Can't Show Warnings

For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Can't Show Warnings

5:39 PM Subject: Re: Can't Show Warnings For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives

Re: Can't Show Warnings

Randy Chrismon [EMAIL PROTECTED] wrote: For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? You can install it from development source tree:

Can't Show Warnings

: 16374 Deleted: 0 Skipped: 0 Warnings: 69 mysql show warnings; Empty set (0.00 sec) What am I doing wrong that I can't find out what the 69 warnings are? I'm using 4.1.0 alpha. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Can't Show Warnings

' - ; Query OK, 16374 rows affected (20.83 sec) Records: 16374 Deleted: 0 Skipped: 0 Warnings: 69 mysql show warnings; Empty set (0.00 sec) What am I doing wrong that I can't find out what the 69 warnings are? I'm using 4.1.0 alpha. For LOAD DATA, it works better in 4.1.1, as indicated here: http