Tecnisol Telecomunicaciones S.L.U.
¿Has olvidado la contraseña?


Tema basado en AdminLTE, licencia MIT.

Consultas SQL:

  1. SHOW TABLES;
  2. SHOW TABLE STATUS FROM `jantonio_facturacion` 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 `jantonio_facturacion` 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 = 'admin_home';
  9. SHOW TABLE STATUS FROM `jantonio_facturacion` 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. SELECT * FROM empresa;
  13. SHOW TABLE STATUS FROM `jantonio_facturacion` LIKE 'fs_vars';
  14. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_vars';
  15. SHOW COLUMNS FROM `fs_vars`;
  16. SELECT * FROM fs_vars;
  17. SHOW TABLE STATUS FROM `jantonio_facturacion` LIKE 'divisas';
  18. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'divisas';
  19. SHOW COLUMNS FROM `divisas`;
  20. SELECT * FROM divisas ORDER BY coddivisa ASC;
  21. SHOW TABLE STATUS FROM `jantonio_facturacion` LIKE 'fs_extensions2';
  22. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_extensions2';
  23. SHOW COLUMNS FROM `fs_extensions2`;
  24. SELECT * FROM fs_extensions2 ORDER BY name ASC;