MiniSgbd Run SQL

Osvaldimar Costa
Dec 21, 2016
  • 2.0

    1 리뷰

  • 1.3 MB

    파일 크기

  • Android 4.0+

    Android OS

MiniSgbd Run SQL 정보

Mini SGBD (DBMS) Performs commands in the SQL language by command line.

MiniSGBD Execute SQL (DBMS), is an educational application to assist or learn the SQL language. The application runs the basic SQL commands through a command-line interface (Terminal), commands and queries are basically a first-time view with MySQL when executed by the command line. The data is saved and can be queried, also have a list of previous commands executed. Here is a list of possible operations.

Examples:

create database world;

use world;

show databases;

show tables;

create table people (id integer primary key not null, name varchar(40));

describe people;

insert into people values (1, 'Jhon');

select * from people;

select id, name from people;

select t1.id, t2.id from table as t1 join table as t2 on t1.id = t2.id;

select all from people order by id;

select * from people where id = 1 and name like '%jho%';

delete from people where id = 1 and ... or ...;

update people set name = 'Jack' where id = 1 and ...;

drop table people;

drop database world;

Type data = [integer, double, char, varchar(xx), date yyyy-mm-dd]

Type data = [null, not null, unique, primary key]

Exit the program = [exit ou quit]

Help = [help; ou h; ou ?;] for help.

더 보기접기

What's new in the latest 1.2

Last updated on 2016-12-21
- Fixed internal storage error on 'create database'.
- Fixed code to accept data of type null in the command 'insert table values'.

- Corrigido erro de armazenamento interno em 'criar banco de dados'.
- Corrigido o código para aceitar dados do tipo null no comando 'inserir valores de tabela'

더 보기접기

MiniSgbd Run SQL의 오래된 버전

APKPure 앱을통한매우빠르고안전한다운로드

한번의클릭으로 Android에 XAPK/APK 파일을설치할수있습니다!

다운로드 APKPure