SQL

From Alessandro's Wiki
Jump to: navigation, search

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