Consultas SQL:

  1. SHOW TABLES;
  2. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'fs_users';
  3. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_users';
  4. SHOW COLUMNS FROM `fs_users`;
  5. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'fs_pages';
  6. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_pages';
  7. SHOW COLUMNS FROM `fs_pages`;
  8. SELECT * FROM fs_pages WHERE name = 'ventas_servicios';
  9. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'empresa';
  10. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'empresa';
  11. SHOW COLUMNS FROM `empresa`;
  12. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'fs_vars';
  13. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_vars';
  14. SHOW COLUMNS FROM `fs_vars`;
  15. SELECT * FROM fs_vars;
  16. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'divisas';
  17. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'divisas';
  18. SHOW COLUMNS FROM `divisas`;
  19. SELECT * FROM divisas ORDER BY coddivisa ASC;
  20. SHOW TABLE STATUS FROM `c3erpdb` LIKE 'fs_extensions2';
  21. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_extensions2';
  22. SHOW COLUMNS FROM `fs_extensions2`;
  23. SELECT * FROM fs_extensions2 ORDER BY name ASC;