Zebra Database Example

001

Table 'world.countrylanguageincorrect' doesn't exist

SELECT
    Language,
    IsOfficial,
    Percentage
FROM
    countrylanguageINCORRECT
WHERE
    CountryCode = 'USA'
ORDER BY
    Percentage DESC

File	Function	Line
/path/to/Zebra_Database/examples/example.php	query()	109

001

SET
    NAMES "utf8" COLLATE "utf8_general_ci"

File	Function	Line
/path/to/Zebra_Database/Zebra_Database.php	query()	4067
/path/to/Zebra_Database/examples/example.php	set_charset()	64

002

SELECT
    Code
FROM
    `country`
WHERE
    Name = 'United States'
LIMIT
    1

Code
USA

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	country		ALL					239	10.00	Using where

File	Function	Line
/path/to/Zebra_Database/Zebra_Database.php	query()	1271
/path/to/Zebra_Database/examples/example.php	dlookup()	70

003

SELECT
    Name
FROM
    city
WHERE
    CountryCode = 'USA'
ORDER BY
    Name

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	city		ref	CountryCode	CountryCode	12	const	274	100.00	Using index condition; Using filesort

File	Function	Line
/path/to/Zebra_Database/examples/example.php	query()	82

004

SELECT
    Language,
    IsOfficial,
    Percentage
FROM
    countrylanguage
WHERE
    CountryCode = 'USA'
ORDER BY
    Percentage DESC

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	countrylanguage		ref	PRIMARY,CountryCode	PRIMARY	12	const	12	100.00	Using where; Using filesort

File	Function	Line
/path/to/Zebra_Database/examples/example.php	query()	96

001	$_REQUEST NULL

001	$_POST array ( )

001	$_GET array ( )

001	$_FILES array ( )