Databases

In this portal, it is all about databases. Up to now, mainly questions and topics regarding MySQL were published, because this is one of the most used type of database and nearly each web developer has to care about this database sooner or later.

But of course, also all other questions, tips and articles about other kinds of database systems are welcome and will be answered gladly.

New Topics

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

New Answers and Comments

Progger99: In phpMyAdmin there is also a function for that. The function can be found when you have selected the database under "Operations". However, there...

Tip | MySQL: Rename Name of a Database

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

Popular Topics

SQLite: Reset AUTOINCREMENT

Question | 1 Answer

Firebird: SELECT with LIMIT

Question | 1 Answer

Show more

Open Questions

Participate

Everyone can participate in Askingbox. Open your topic directly in this category:

 
If you should have any questions: That’s how it’s done.