Search Results for "mysql table"

sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). You can use sq diff to compare tables, or entire databases. sq has commands for common database operations to copy, truncate, and drop tables.

JsonSQL is a lightweight, flat-file database engine for PHP, designed to store and manage data in structured JSON files using an intuitive, SQL-like syntax. JsonSQL empowers developers to build data-driven applications without the overhead and complexity of traditional database servers. Whether you're prototyping, creating embedded systems, or developing small to medium-sized web applications, JsonSQL provides an efficient, portable, and human-readable solution for managing your data....

Work with: MySQL, PostgreSQL, FirebirdSQL. Use PHP, and ExtJS. Browse in Tree: db,table,column,constraint,trigger,view,proc. Has history, and fragments panel. Editor has autocomplete, autoindent. Easy install, unpack in webroot and edit "set.php"