User Stephen Senkomago Musoke

20 votes

Accepted

How is INDEX on Composite Primary Key in mysql?

answered Mar 2, 2012 at 11:34

14 votes

Mysql int vs varchar as primary key (InnoDB Storage Engine?

answered Apr 1, 2012 at 7:52

12 votes

Accepted

while restoring mysql database, views changed into tables

answered Dec 20, 2012 at 13:03

11 votes

Accepted

MySQL Workbench, how to refresh EER diagram?

answered Oct 14, 2012 at 9:55

7 votes

Accepted

mysql workbench reverse engineer is not connecting tables graphically. How to fix?

answered Jun 23, 2012 at 6:08

6 votes

Accepted

Is a trade-in its own purchase order, or an adjustment on a sales order?

answered Jun 27, 2012 at 6:45

6 votes

How can I prevent gaps in a MySQL table AUTO_INCREMENT field?

answered Feb 29, 2012 at 6:04

5 votes

What MySQL storage engine should I choose?

answered Sep 15, 2012 at 13:31

5 votes

Accepted

Databases design decision - Mobile & Web

answered Dec 17, 2012 at 11:41

4 votes

Accepted

MySQL Workbench table organisation

answered Dec 20, 2012 at 12:14

4 votes

Is it OK to keep a value which updates in a table?

answered Jan 29, 2013 at 13:34

4 votes

Accepted

Review database schema / thought process

answered Jun 16, 2014 at 6:34

4 votes

Is one-to-one relationship normalized?

answered Mar 22, 2012 at 15:36

3 votes

Best practices for change management with indexes

answered Mar 2, 2012 at 16:51

3 votes

How to prevent redundant relationships in data?

answered Jun 29, 2012 at 7:26

3 votes

Is SELECT COUNT GROUP BY more efficient than counting a result set?

answered Apr 18, 2012 at 5:26

3 votes

How to display database structure in phpMyAdmin?

answered Mar 26, 2012 at 5:45

3 votes

Accepted

Is it normal to use many Triggers?

answered Apr 6, 2012 at 8:39

2 votes

mysql products db design

answered Apr 11, 2012 at 18:02

2 votes

Look for software that can convert sql (mysql) to erd

answered Mar 26, 2012 at 5:32

2 votes

Two-sided UNIQUE INDEX for two columns

answered Feb 29, 2012 at 5:55

2 votes

how to design movies with show times database structure

answered Mar 22, 2012 at 15:46

1 vote

What type of datastore should I use for high volume time series data?

answered Mar 23, 2012 at 9:39

1 vote

Is my ER Diagram correct? Why use relationships?

answered Mar 16, 2012 at 5:09

1 vote

Inventory database structure when inventory items have varying attributes

answered Mar 17, 2012 at 6:58

1 vote

Accepted

Can I use the "import" tool on PHPMyAdmin multiple times?

answered Mar 5, 2012 at 18:04

1 vote

Impact of miss-ordered fields in a composite, clustered primary key?

answered Mar 6, 2012 at 5:33

1 vote

MySQL subquery slows down drastically, but they work fine independently

answered Mar 7, 2012 at 17:35

1 vote

Synchronise two databases (but not really)

answered Feb 27, 2012 at 11:18

1 vote

Move Oracle data to and from MySQL with the help of PHP?

answered Feb 27, 2012 at 11:23

Stack Exchange Network

60 Answers

How is INDEX on Composite Primary Key in mysql?

Mysql int vs varchar as primary key (InnoDB Storage Engine?

while restoring mysql database, views changed into tables

MySQL Workbench, how to refresh EER diagram?

mysql workbench reverse engineer is not connecting tables graphically. How to fix?

Is a trade-in its own purchase order, or an adjustment on a sales order?

How can I prevent gaps in a MySQL table AUTO_INCREMENT field?

What MySQL storage engine should I choose?

Databases design decision - Mobile & Web

MySQL Workbench table organisation

Is it OK to keep a value which updates in a table?

Review database schema / thought process

Is one-to-one relationship normalized?

Best practices for change management with indexes

How to prevent redundant relationships in data?

Is SELECT COUNT GROUP BY more efficient than counting a result set?

How to display database structure in phpMyAdmin?

Is it normal to use many Triggers?

mysql products db design

Look for software that can convert sql (mysql) to erd

Two-sided UNIQUE INDEX for two columns

how to design movies with show times database structure

What type of datastore should I use for high volume time series data?

Is my ER Diagram correct? Why use relationships?

Inventory database structure when inventory items have varying attributes

Can I use the "import" tool on PHPMyAdmin multiple times?

Impact of miss-ordered fields in a composite, clustered primary key?

MySQL subquery slows down drastically, but they work fine independently

Synchronise two databases (but not really)

Move Oracle data to and from MySQL with the help of PHP?