MiniSgbd Run SQL
Free App
Advertisements
About MiniSgbd Run SQL
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.
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.
All Application Badges
Free
downl.
downl.
Android
4.0+
4.0+
Bug
buster
buster
Android app
App History & Updates
What's Changed
- 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'
- 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'
Version update MiniSgbd Run SQL was updated to version 1.2
More downloads MiniSgbd Run SQL reached 5 000 - 10 000 downloads
What are users saying about MiniSgbd Run SQL
D
by D####:
by D####:
Very useful app and I enjoy it good job
D
by D####:
by D####:
Some tags are not working Ex- create table Also Can't use "Int()",
W
by W####:
by W####:
Please add more commands like concat, char, ltrim, rtrim, ucase, lcase, trim and many other more.
M
by M####:
by M####:
Create table command is not working
D
by D####:
by D####:
'Create table' command is not working
S
by S####:
by S####:
Create table is not working
T
by T####:
by T####:
Not working properly
D
by D####:
by D####:
An almost perfect application.I loved it very much. Please check it once.
D
by D####:
by D####:
Very helpful...thnx but please add alter table function in it please
D
by D####:
by D####:
Time west app
D
by D####:
by D####:
Create table is not working.....
D
by D####:
by D####:
Thankyou so much. Keep making great apps.
D
by D####:
by D####:
Very well...easy and portable
D
by D####:
by D####:
Nice
S
by S####:
by S####:
Best
F
by F####:
by F####:
Alter table add or modify does not work..... this is not efficient...... Plus make the changes in it
D
by D####:
by D####:
Including auto_increment
D
by D####:
by D####:
Cannot response any commands in my Xiaomi Redmi 3 pro, please fix it
D
by D####:
by D####:
Very much helpful.. Its just amazing..... Thanku
X
by X####:
by X####:
Now able to create table
D
by D####:
by D####:
Works great for me!!
L
by L####:
by L####:
Wasted time
T
by T####:
by T####:
Great app
D
by D####:
by D####:
The app is really very good, but I'm having a problem with the create table command. When I'm mentioning the last attribute to my table and mark the end of the table by using ');' , it says that my command is an invalid one and my table does not exist
D
by D####:
by D####:
What a prank
D
by D####:
by D####:
This app was very helpful for me to prepare for my computer exam
M
by M####:
by M####:
It is not yet all getting download....
D
by D####:
by D####:
its a very usefull app no need of computer programming
D
by D####:
by D####:
It's to good for mysql
C
by C####:
by C####:
Hope this works good
Q
by Q####:
by Q####:
Super
D
by D####:
by D####:
Fab
D
by D####:
by D####:
Weellllllll
C
by C####:
by C####:
nice app
J
by J####:
by J####:
Good
by D####:
The app is cool, supports almost commands and is fast, just like the real SQL query tool. Love this app!!