SQL
From Alessandro's Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
this is pure code notes, check out mysql also
statements
- get Database size in kilobytes:
SELECT sum( data_length + index_length ) / 1024) 'DB Size in MB' FROM information_schema.TABLES WHERE TABLES.TABLE_SCHEMA='<database name>' GROUP BY table_schema
convert an INT field to BIN
SELECT CONV( int_field, 10, 2) FROM table;
errors
- SQL Error 10060 :
- port filtered