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: 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 usua...
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
SQLite: Reset AUTOINCREMENT
I have an ID-column in my SQLite database in which I am automatically increasing the integer value with the help of AUTOINCREMENT...
Question | 1 Answer

New Answers and Comments

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?
NetGuy: After all, even in Firebird you can do an "ON DUPLICATE KEY UPDATE" INSERT. However, in Firebird the syntax is a bit different. Instead of...
Question | Firebird: INSERT with ON DUPLICATE KEY UPDATE
Stefan Trost: You can not change the maximum file size in the phpMyAdmin settings, because the values ​​are taken directly from your PHP...
Question | phpMyAdmin: Increase File Size Limit for Import
Computer Expert: The easiest way to do this, is just to use the same query but output them rotated. For example, if using PHP, you can load the result...
Question | MySQL: GROUP BY Day, Month and Year
Guest: After group by using month, year and day the data shows as vertical list data... Is it possible we can transform into horizontal list...
Question | MySQL: GROUP BY Day, Month and Year
Computer Expert: You can just use the magic word "DISTINCT". This keyword ensures that all double records will be excluded from the results. Your...
Question | SQLite: Exclude duplicate records from result

Popular Topics

MySQL: How to check if Field is NULL or EMPTY
Question | 3 Answers
SQLite: String and Column Concatenation using SQLite
Info | 0 Comments
SQLite: Creating an Index on one or more Columns
Info | 0 Comments
MySQL: GROUP BY Day, Month and Year
Question | 3 Answers
SQLite: Reset AUTOINCREMENT
Question | 1 Answer
MySQL: Line breaks in MySQL
Tip | 0 Comments
MySQL: Group Timestamp Column by Month and Year
Tip | 0 Comments
Show all

 

Unanswered Questions

Participate

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

 

If you should have further questions: How to do.