Learn SQL for MySQL 4+
Paulo Narra
-
- 8,99 €
Slike zaslona
Opis
Will you start learning SQL in MySQL?
Did you forget the statements many times?
Do you no longer remember the syntax and the result of an statement?
Developed to easily learn SQL Programming for MySQL
. . . . . . . . . . . . . . . . . . . . .
This App acts as a reference for the SQL language
Learn DML & DDL statements with description, syntax, notes and examples
For each statement is presented:
Detailed description of the statement/command purpose
Syntax of the statement with various options
Two examples executed from a real table (Automobile Table)
Provides:
. . . . . . . . . . . . . . . . . . . . .
1. GENERAL
1.1 - Comments
1.2 - Data Types
2. (DML) Data Manipulation Language
2.1 – SELECT
- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Limit, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union (Any & All)
- Subqueries
- Joins (Inner, Right, Left)
- Select Into
2.2 - INSERT
- With Columns names
- Without Column names
- Rules
- Insert Into ... Select
2.3 - DELETE
- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity
2.4 - UPDATE
- Update All Rows
- Update ... Where
- Rules
3. (DDL) DATA DEFINITION LANGUAGE
3.1 - CREATE
- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN)
3.2 - ALTER
- Alter Columns
- Add Constraints
- Drop Constrains
3.3 - DROP
- Drop Table
- Drop Database
- Drop Index
3.4 - TUNCATE
- Delete Versus Truncate
Novosti
Verzija 3
App update to support new MacOS version
Privatnost aplikacije
Developer Paulo Narra naznačio je da prakse privatnosti aplikacije mogu obuhvaćati rukovanje podacima kako je ispod opisano. Za dodatne informacije pogledajte pravila privatnosti developera.
Podaci se ne prikupljaju
Developer ne prikuplja nikakve podatke iz ove aplikacije.
Prakse privatnosti mogu varirati, primjerice, na temelju značajki koje koristite ili vaše dobi. Saznajte više
Informacije
- Pružatelj usluga
- Paulo Narra
- Veličina
- 23,1 MB
- Kategorija
- Razvojni alati
- Kompatibilnost
-
- iPhone
- Zahtijeva iOS 13.0 ili noviji.
- iPod touch
- Zahtijeva iOS 13.0 ili noviji.
- Mac
- Zahtijeva macOS 11.0 ili noviji.
- Apple Vision
- Zahtijeva visionOS 1.0 ili noviji.
- Jezici
-
engleski, pojednostavnjeni kineski, portugalski, tradicionalni kineski, španjolski
- Dobna granica
- 4+
- Autorsko pravo
- © Paulo Narra 2024
- Cijena
- 8,99 €
Podrška
-
Dijeljenje s obitelji
Uz omogućeno Dijeljenje s obitelji aplikaciju može koristiti do šest članova obitelji.