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...

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...

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...

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...

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...

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...

Question | 1 Answer

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 ...

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: ...

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...

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

Stefan Trost: I would like to explain the index with a simple example: Example Imagine you have a phonebook and you want to find a number...

Question | MySQL: What is an index needed for?