Databases

MySQL: Text field can only store 65535 characters

I am using a field of data type "TEXT" in my MySQL database to save texts. Unfortunately, I realized now that a field of type TEXT can only hold...

Question | 1 Answer

MySQL: What is an index needed for?

I do not know much about databases and MySQL, but I am currently working on my first Internet projects. Now and again I come across the idea that it...

Question | 1 Answer

Firebird: INSERT with ON DUPLICATE KEY UPDATE

I would like to either insert some data into a Firebird database or, if the corresponding ID already exists, update the record with that ID. I would...

Question | 1 Answer

phpMyAdmin: Increase File Size Limit for Import

I want to import a quite large SQL file into my database via phpMyAdmin. However, on the import tab of phpMyAdmin, where you can select a file to...

Question | 1 Answer

SQLite: Exclude duplicate records from result

Is SQLite offering any possibility for excluding all double data records from the result of a query? I am using some usual SELECT-request like this...

Question | 1 Answer

SQLite: Error "no such function: INSTR"

I am getting a strange error when using the function INSTR() in SQLite. When executing a query like SELECT id FROM tab WHERE INSTR(txt,...

Question | 1 Answer

Compi: I didn't even know that this is possible! While I used MySQL only as a pure medium for saving values in the past, it becomes more and more clear to...

Tip | MySQL: Search and Replace directly in MySQL database

Guest: Or you can simple use for literals the expression since sqlite 3.8.4 printf('%0nd', <column>) where n = number of padding...

Info | SQLite: RPAD and LPAD in SQLite - Fill string with characters left or right

Compi: Since this is a limitation of MySQL, which is also stated in the documentation, I assume that this is not possible. Otherwise this possibility would...

Question | MySQL: Maximum Length of a Column and Table Name

Guest: Is it possible to increase the number of characters in the names of the tables? So, from 64 characters to 100 characters, for...

Question | MySQL: Maximum Length of a Column and Table Name

Stefan Trost: There are several TEXT data types in MySQL that can store different text lengths. Here is a small overview: Type Characters (Max) Size (Max) ...

Question | MySQL: Text field can only store 65535 characters

Guest: You can also use the IFNULL() function: 1. SELECT IFNULL(1,0); -- returns 1 2. SELECT IFNULL('',1); -- returns '' 3. SELECT...

Question | MySQL: How to check if Field is NULL or EMPTY