current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help

MySQL


66 Topics

32 requests active popular

Getting started with MySQL Introduction Topic

4
Getting Started
0 improvement requests
0 proposed changes
edited Oct 27 at 3:59

Table Creation All Versions

28
Table creation with Primary Key
15
Basic table creation
5 more examples
0 improvement requests
0 proposed changes
edited Nov 10 at 13:58
+29

SELECT All Versions

10
SELECT with DISTINCT
8
SELECT by column name
7 more examples
0 improvement requests
0 proposed changes
edited Nov 15 at 12:36
+11

INSERT All Versions

8
INSERT, ON DUPLICATE KEY UPDATE
5
Inserting multiple rows
4 more examples
0 improvement requests
0 proposed changes
edited Nov 13 at 0:51
+12

Backup using mysqldump All Versions

7
Specifying username and password
2
Creating a backup of a database or table
6 more examples
1 improvement request
0 proposed changes
edited Nov 2 at 15:23
+9

Arithmetic All Versions

1
Absolute Value and Sign (ABS, SIGN)
1
Arithmetic Operators
6 more examples
0 improvement requests
0 proposed changes
edited Nov 25 at 18:09
+3

Error codes All Versions

4
Error code 1064: Syntax error
2
Error code 1175: Safe Update
9 more examples
0 improvement requests
0 proposed changes
edited Dec 4 at 23:22
+4

JSON 5.7

3
Create simple table with a primary key and JSON field
2
Insert a simple JSON
2 more examples
0 improvement requests
0 proposed changes
edited Sep 26 at 8:56
+1

VIEW 5.7

5
Create a View
1
A view from two tables
2 more examples
0 improvement requests
0 proposed changes
edited Oct 9 at 3:52
+6

Configuration and tuning All Versions

4
What can be tuned in my.cnf
1
Parameter to allow huge data to insert
3 more examples
0 improvement requests
0 proposed changes
edited Nov 1 at 22:00

Stored routines (procedures and functions) 5.0–5.7

3
Stored procedure with IN, OUT, INOUT parameters
2
Create a Function
4 more examples
0 improvement requests
0 proposed changes
edited Sep 24 at 0:42
+3

Limit and Offset 4.1–5.7

2
Infinite rows: Offset only (without constraint)
2
Limit and Offset relationship
1 more example
0 improvement requests
0 proposed changes
edited Aug 4 at 13:43
+5

LOAD DATA INFILE All Versions

3
Load data with duplicates
1
using LOAD DATA INFILE to load large amount of data to database
2 more examples
0 improvement requests
0 proposed changes
edited Nov 13 at 20:57

Log files All Versions

2
Slow Query Log
1
A List
2 more examples
0 improvement requests
0 proposed changes
edited Aug 6 at 14:05

Drop Table All Versions

3
Drop Table
0
Drop tables from database
0 improvement requests
0 proposed changes
edited Nov 14 at 14:57
+2

ALTER TABLE All Versions

1
ALTER COLUMN OF TABLE
1
Change auto-increment value
8 more examples
0 improvement requests
0 proposed changes
edited Sep 13 at 20:52
+2

Creating databases All Versions

3
Create database, users, and grants
0
Creating and Selecting a Database
2 more examples
0 improvement requests
0 proposed changes
edited Oct 10 at 16:11
+1

Joins All Versions

2
Joins visualized
1
JOIN with subquery ("Derived" table)
4 more examples
0 improvement requests
0 proposed changes
edited Sep 15 at 21:18
+2

UPDATE All Versions

2
Basic Update
1
Update with Join Pattern
3 more examples
0 improvement requests
0 proposed changes
edited Oct 7 at 2:13
+2

TRIGGERS All Versions

1
Basic Trigger
1
Types of triggers
0 improvement requests
0 proposed changes
edited Nov 17 at 23:58
+1
1 2 3 4

Introduction Topic

 Getting started with MySQL