Last Replyboth are the best top databases but it depends on what you want to do and what your application does. --Abhishek Mod Edit: Spam link removed. Al... Abhishek,
both are the best top dat...
Last ReplyCassandra can handle massive amounts of unstructured data. In cases where your database needs to rapidly scale with minimal increase of administr... Univa,
Cassandra can handle mass...
Last ReplyDATETIME2 has a date range of "0001 / 01 / 01" through "9999 / 12 / 31" while the DATETIME type only supports year 1753-9999. Also, if you need to,... Univa,
DATETIME2 has a date rang...
How to fix "Every derived table must have its own alias"?
Answers in Databases | By Some Guy
Published
Last ReplyImagine a table called purchases that records purchases made by customers at stores, i.e., it's a many to many, and the software needs to know which c... Univa,
Imagine a table called pu...
[Dreamhost Error] How to fix "MySQL 504 Gateway Time-out; The server didn't respond in time?"
Answers in Databases | By Some Guy
Published
Last Reply504 Gatetimeout is an HTTP Error, not a database error. The database takes too long to collect your data. You probably have to increase max_execution_... Univa,
504 Gatetimeout is an HTT...
Last ReplyThis error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c... Univa,
This error can occur if y...
What do I do "Access denied for user 'root'@'localhost'"? Help needed
Answers in Databases | By Some Guy
Published
Last ReplyTry out the following steps to overcome this issue: Find mysql related entries from system sudo find / -name mysql Remove all mysql related en... Univa,
Try out the following ste...
Last ReplyUSE database_name; August R. Garcia,
USE database_name;
TL;DR: Here is a one-line command to run...
MoreTL;DR: Run this command from your local machine: mysql -u root -p yourdatabase -e "select * from table_name;" > file.csv How to export a...Last ReplyOn Windows, use the Oracle Universal Installer. Extract the downloaded zip. Open the setup.exe file. Select the Oracle Database 11g and click Next. Us... roxblade,
On Windows, use the Oracl...
Last ReplyYes, phpMyAdmin is the universal option. But more often than not, you might requre a GUI/native software.In that case, it depends on taste really. Als... roxblade,
Yes, phpMyAdmin is the un...
What are the differences between MariaDB and MySQL (sine MariaDB is a fork)?
Answers in Databases | By Some Guy
Published
Last ReplyYes, it's a fork in some ways. Michael "Monty" Widenius was the person behind it. He also was in the original team that developed MySQL and also the c... roxblade,
Yes, it's a fork in some...
What does key MUL mean in MySQL? Also, how to remove a MUL key?
Answers in Databases | By Some Guy
Published
Last ReplyMultiple occurrences of the same value are allowed in MUL keys. So, there are two primary kinds of keys -- PRI and UNI. PRI are primary keys and UNI i... roxblade,
Multiple occurrences of t...
How can I count the number of unique IP addresses in my database?
Answers in Databases | By Some Guy
Published
Last ReplyAssuming you're asking for a raw query to run on a MariaDB or MySQL database: Get a list of all of the unique IP addresses:... August R. Garcia,
Assuming you're askin...
Last ReplyYou're probably trying to get the value from an array with object syntax. Most database data is handled in arrays, not objects. If you are d... Hash Brown,
You're probably tryin...
Last ReplyThese errors are kind of generic and don't point to anything specific. In general you want to start off: Make sure you're using the c... Hash Brown,
These errors are kind of...
Fixing "MySQLi_real_connect(): (hy000/2002): no such file or directory?"
Answers in Databases | By Some Guy
Published | Last Update
Last ReplyGo into your script or config file and find your database credentials. Look for "localhost" and replace it with "127.0.0.1".... Hash Brown,
Go into your script or co...
Can SQLite and PostgreSQL be used for the same type of sites?
Answers in Databases | By Some Guy
Published
[PostgreSQL vs MySQL] What syntax differences should I know about?
Answers in Databases | By Some Guy
Published
PostgreSQL vs MariaDB: Which is better for a dentist's website?
Answers in Databases | By Some Guy
Published
PostgreSQL vs MsSQL / SQL Server: Which should I use for a website on the Information Superhighway?
Answers in Databases | By Some Guy
Published
[SQL Server] What is the difference betweewn a clustered and nonclustered index?
Answers in Databases | By Some Guy
Published
Fix for "Host is not allowed to connect to this MariaDB server?"
Answers in Databases | By Some Guy
Published