current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help

MySQL


64 Topics

36 requests active popular

Table Creation All Versions

26
Table creation with Primary Key
14
Basic table creation
5 more examples
0 improvement requests
0 proposed changes
edited Sep 30 at 19:49
+28

SELECT All Versions

9
SELECT with DISTINCT
7
SELECT by column name
7 more examples
0 improvement requests
0 proposed changes
edited Oct 7 at 16:21
+11

INSERT All Versions

8
INSERT, ON DUPLICATE KEY UPDATE
5
Inserting multiple rows
5 more examples
1 improvement request
0 proposed changes
edited Sep 15 at 7:56
+10

Backup using `mysqldump` All Versions

7
Specifying username and password
3
MySQL Dump options
7 more examples
2 improvement requests
0 proposed changes
edited Oct 8 at 2:49
+7

Arithmetic 1.0–5.7

1
Absolute Value and Sign (ABS, SIGN)
1
Arithmetic Operators
6 more examples
1 improvement request
0 proposed changes
edited Sep 27 at 23:16
+1

Error codes All Versions

4
Error code 1064: Syntax error
2
Error code 1175: Safe Update
10 more examples
1 improvement request
0 proposed changes
edited Sep 29 at 21:44
+2

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 2 days ago
+6

Tuning my.cnf All Versions

4
What can be tuned in my.cnf
1
Parameter to allow huge data to insert
1 more example
0 improvement requests
0 proposed changes
edited Sep 21 at 11:10

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

Hello World All Versions

4
Hello World
0 improvement requests
0 proposed changes
edited Jul 22 at 21:38

LOAD DATA INFILE All Versions

3
Load data with duplicates
1
using LOAD DATA INFILE to load large amount of data to database
1 more example
0 improvement requests
0 proposed changes
edited Sep 15 at 2:15

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

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

Indexes and Keys All Versions

1
AUTO_INCREMENT key
1
Create composite index
3 more examples
0 improvement requests
0 proposed changes
edited Aug 4 at 22:11
+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

DELETE All Versions

1
DELETE vs TRUNCATE
1
Delete with Where clause
5 more examples
0 improvement requests
0 proposed changes
edited 2 days ago
+7

Date and Time Operations All Versions

2
SYSDATE(), NOW(), CURDATE()
1
Extract Date from Given Date or DateTime Expression
4 more examples
0 improvement requests
0 proposed changes
edited Oct 7 at 16:26
+1

Data Types All Versions

1
Integer Types
1
Introduction (numeric)
9 more examples
0 improvement requests
0 proposed changes
edited 2 days ago
1 2 3 4

Overview Topic

Hello World