Little Query: Query and Export Data from mySQL

This tool is designed to assist SQL users. It provides templates for quick writing of SQL commands and can be used for exporting queried table.

Little Query is a database management tool (an interface for connecting to your server). You can view it as an alternative to phpMyAdmin or SQLyog. You need to have SQL server installed first.


Download (Official Version)
:
Microsoft Store
Requirements: Windows 10+, MySQL Database

Download (Portable Version): ver1.0.2 (~1 MB) (less features)
Requirements: Windows (any), MySQL Database
Older Versions: ver1.0 (~1 MB)

Discussions: discussions about Little Series
Privacy Policy: read


Quick Guides

  • Configurations for Database Connection are stored in ..\Documents\LittleQuery\Data\database.txt.
    This file will be generated automatically if it is not existed; a template of connection configuration is given.

    ** there was a problem on accessing this file in a new version of Windows, we have fixed this. please wait for app update (2021/01/21) **
  • All queries connect to a database specified in Serv (on pressing button Query)
  • Clicking ⯈ is optional. By clicking this button, names of tables and their columns will be loaded to Quick Add menus.
  • After INSERT, UPDATE, or DELETE operation. Table specified on the first row of the cmd box will be queried and displayed.
  • You can export the table being displayed as a CSV or Excel file
  • You may test this app on this sample database (this file is embedded in portable version). There are several ways to import this .sql file to a database server. One simple way is to execute codes in this file as an SQL command.
Format of Connection Configuration:
Server='127.0.0.1';Database='DATABASE_NAME';uid='USERNAME';password='PASSWORD';Port='3306';CharSet='utf8';


Demo VDO



 


Preview
 

Export Excel





New Feature

Design for inserting data from a CSV file to SQL database

 



Common Problems and Solutions

Unable to convert MySQL date/time value to System.DateTime.

Solution

Adding convert zero datetime=True to the connection string will automatically convert 0000-00-00 Date values to DateTime.MinValue().

Example: server=localhost; database=luttop; user=root; password=1234; pooling = false; convert zero datetime=True

source: https://stackoverflow.com/questions/2934844/unable-to-convert-mysql-date-time-value-to-system-datetime

[collapse]

 

Don`t copy text!