Database information_schema - table ROUTINES

[ Browse ]    [ Select ]    [ Insert ]    [ Empty ]

• Print view
• Run SQL query/queries on database information_schema [Documentation] :
  

  SELECT * FROM `ROUTINES` WHERE 1
    Show this query here again
  
• Browse -  Select -  Insert -  Empty
  
• Add new field : At End of Table At Beginning of Table After SPECIFIC_NAME After ROUTINE_CATALOG After ROUTINE_SCHEMA After ROUTINE_NAME After ROUTINE_TYPE After DTD_IDENTIFIER After ROUTINE_BODY After ROUTINE_DEFINITION After EXTERNAL_NAME After EXTERNAL_LANGUAGE After PARAMETER_STYLE After IS_DETERMINISTIC After SQL_DATA_ACCESS After SQL_PATH After SECURITY_TYPE After CREATED After LAST_ALTERED After SQL_MODE After ROUTINE_COMMENT After DEFINER
• Alter table order by : SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER  (singly)
• Insert textfiles into table
• View dump (schema) of table
  

  Structure only   Structure and data   Data only   CSV for Ms Excel data   CSV data :       Fields terminated by           Fields enclosed by           Fields escaped by           Lines terminated by	Add 'drop table' Complete inserts Extended inserts Use backquotes with tables and fields' names Send ( "gzipped"  "bzipped" )
  Data : Offset   -- No. Of records

• Rename table to :

  Copy table to (Database.table) :  .  Structure only   Structure and data

• Table comments :     
• Table type :  MyISAM Heap Berkeley DB INNO DB Merge  
• Drop table ROUTINES