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...
Question | 1 Answer
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
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
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
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
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
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
New Answers and Comments
Compi: Since this is a limitation of MySQL, which is also stated in the ...
Question | MySQL: Maximum Length of a Column and Table Name
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
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
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
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?
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
Question | Firebird: INSERT with ON DUPLICATE KEY UPDATE
Popular Topics
Show more
Unanswered Questions
Participate
Everyone can participate in Askingbox. Open your topic directly in this category: