Database Archives - Page 42 of 44

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so ...

I haven’t been able to fully grasp the differences. Can you describe both concepts and use real world examples? 15 s 15 An ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

My table is: id home datetime player resource 1 10 04/03/2009 john 399 2 11 04/03/2009 juliet 244 5 12 04/03/2009 borat 555 ...

I have a table with a varchar column, and I would like to find all the records that have duplicate values in this ...

Per the MySQL docs, there are four TEXT types: TINYTEXT TEXT MEDIUMTEXT LONGTEXT What is the maximum length that I can store in ...

I’ve got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (all integer types) ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my ...

I have 2-3 different column names that I want to look up in the entire database and list out all tables which have ...