# LMLSQL

**Repository Path**: leiminglin/LMLSQL

## Basic Information

- **Project Name**: LMLSQL
- **Description**: command line sql
- **Primary Language**: PHP
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 7
- **Forks**: 0
- **Created**: 2016-02-15
- **Last Updated**: 2025-05-10

## Categories & Tags

**Categories**: database-dev

**Tags**: None

## README

# LMLSQL
command line sql

## How to use?

### requirements

```
php5 pdo pdo_mysql
```

### create soft link

```
sudo ln -s /path/to/LMLSQL/lmlsql /usr/bin/lmlsql
```

### config identifier in dbconfig.php

```
<?php

return $dbconfig = array(

    'dev' => array(
        'hostname' => '192.168.169.12',
        'hostport' => '3306',
        'username' => 'username',
        'password' => 'password',
        'database' => 'database',
        'charset' => 'utf8',
        'persist' => false,
        'dbprefix' => '',
    ),

);
```

### query sql like this

```
lmlsql /dev "show create table db.tablename"

or

lmlsql dev "show create table db.tablename"
```