Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Certification Debugging MySQL applications

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

SHOW count(*) WARNINGS;

Front

1 / 9

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (9)

Section 1

(9 cards)

SHOW count(*) WARNINGS;

Front

What is the syntax to return how many warnings are available?

Back

perror

Front

What utility is used to get more information about errors?

Back

SHOW ERRORS [LIMIT offset, records];

Front

What is the command to show the previous errors

Back

SHOW WARNINGS [LIMIT offset, records];

Front

What is the command to show the previous warnings

Back

Errors Warnings Notes

Front

What are the 3 different levels of warnings?

Back

SHOW count(*) ERRORS;

Front

What is the syntax to show how many errors have occurred?

Back

False warnings have a limited lifespan.

Front

Warnings exist until they are cleared?

Back

A MySQL-specific error code. An SQLSTATE error code. These codes are defined by standard SQL and ODBC. A text message that describes the problem.

Front

What are the 3 parts of an error message?

Back

SET sql_notes = 0;

Front

How do you turn off notes being generated?

Back