Reputation
5,751
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
10 27
Newest
 Custodian
Impact
~294k people reached

Apr
9
revised COUNT(*) on InnoDB whenever phpMyAdmin loads
Fixed broken link. Quoted source.
Jul
22
revised Constraint on Composite Type
Documented to work in 8.0+
Jul
21
revised How do I know what indexes to create for a table
added 91 characters in body
Jul
9
revised Indexes and Optimizations for Logging System
MySQL writes to the sort buffer.
Jul
2
revised what is the best practice when making changes to the the application and database?
TSQL is software development.
Jun
27
revised MySQL system date change impact
Link to docs
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Sum minutes to calc elapsed hours.
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Added output.
Jun
20
revised Good explanation of cascade (ON DELETE/UPDATE) behavior
Added interpretation.
Apr
15
revised Proper indexes or anything else to optimize
Faster hardware.
Apr
14
revised Database design: Dividing multiple identical tables, good or bad?
Extended examples.
Apr
14
revised Database design: Dividing multiple identical tables, good or bad?
Extended examples.
Apr
8
revised How to enforce full integer (no floating point)?
Cite 1992 SQL standard.
Apr
8
revised How to enforce full integer (no floating point)?
Added DDL.
Apr
6
revised Defining constraints in `CREATE TABLE` statements
Note re version control.
Apr
2
revised Foreign Keys with Composite Key
Unique constraint syntax
Feb
24
revised Add Check Constraint On Varchar Column to enforce no duplicates
added 191 characters in body
Jan
16
revised Is there any way to get recently inserted value in a table without using aggregate functions?
Cut the closing thanks.
Jan
12
revised Group By on column from joined table
Ideas for testing.
Jan
11
revised Group By on column from joined table
Link to docs about optimizing limit queries.