syntax error!

[Jassim Rahma]

Hi, why this statement returns error on mysql?!

SELECT schema_name, CAST(sum(data_length) / 1024 AS UNSIGNED) AS db_size FROM information_schema.schemata INNER JOIN information_schema.tables ON information_schema.schemata.schema_name = information_schema.tables.table_schema GROUP BY information_schema.schemata.schema_name

[Pete OHanlon]

It worked perfectly for me - MySQL version 5.1.45.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

[Lost User]

jrahma wrote:

why this statement returns error on mysql?!

It'd help if you'd post an error-message :)

I are Troll :suss: