Table Of Contents
Latest update [menu]
- 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'
Description [menu]
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.
How to install MiniSgbd Run SQL APK for Android [menu]
Download MiniSgbd Run SQL APK file (br.com.minisgbd_2_1326326.apk) from APKPure.live, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (br.com.minisgbd_2_1326326.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
How to install MiniSgbd Run SQL APK on Windows 7/8/10 or MAC PC? [menu]
Download MiniSgbd Run SQL APK file(br.com.minisgbd_2_1326326.apk) from APKPure.live to your PC (ex: /Users/xxx/Downloads/(br.com.minisgbd_2_1326326.apk)), then follow these steps:
Using Emulator:
- Download And Install one Emulator Softwares (Ex: Bluestacks, GenyMotion, NoxPlayer)
- Simple install APK on PC by drag and drop file br.com.minisgbd_2_1326326.apk on Emulator screen
MiniSgbd Run SQL APK Pros & Cons [menu]
Pros
- This app is safe, it's not require high risk permissions
- Compatible with 32 bit device (most Emulator using 32bit arch CPU)
- Compatible with 64-bit device (some android device and current Bluestacks)
Cons
Everything is good.