256 Kilobytes

Type All Category DatabasesDiscuss database design and development, such as relational and NoSQL technologies like MySQL, MariaDB, and MongoDB. Tag All

Profile Photo - Some Guy

[PostgreSQL vs MySQL] Which DB has the best performance?

Answers in Databases | By Some Guy

Published

Profile Photo - Default

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

Mon, 17 Feb 2020 09:02:00 -08004 months ago1
🗨 1
🐏 0
👁 358
Profile Photo - Some Guy

When to Use Apache Cassandra vs MongoDB?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

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

Sat, 01 Jun 2019 08:28:40 -07001 year ago1
🗨 1
🐏 0
👁 351
Profile Photo - Some Guy

[SQL Server] Difference between datetime and datetime2?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

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

Wed, 08 May 2019 08:08:40 -07001 year ago1
🗨 1
🐏 0
👁 322
Profile Photo - Some Guy

How to fix "Every derived table must have its own alias"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

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

Sun, 05 May 2019 03:27:34 -07001 year ago1
🗨 1
🐏 0
👁 348
Profile Photo - Some Guy
Profile Photo - Univa

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

Sun, 05 May 2019 02:47:36 -07001 year ago1
🗨 1
🐏 0
👁 406
Profile Photo - Some Guy

How to fix "Operand should contain 1 column(s)"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

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

Thu, 18 Apr 2019 07:57:10 -07001 year ago1
🗨 1
🐏 0
👁 349
Profile Photo - Some Guy
Profile Photo - Univa

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

Fri, 12 Apr 2019 11:34:06 -07001 year ago1
🗨 1
🐏 0
👁 365
Profile Photo - Some Guy

Selicting database with the MySQL command line?

Answers in Databases | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyUSE database_name; August R. Garcia,

USE database_name;

Fri, 05 Apr 2019 15:13:49 -07001 year ago1
🗨 2
🐏 0
👁 323
Profile Photo - August R. Garcia

How to export a MySQL or MariaDB Query to a CSV

Articles in Databases | By August R. Garcia

Published

Profile Photo - August R. Garcia

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...
🗨 0
🐏 0
👁 691
Profile Photo - Some Guy

How do I install Oracle 11g?

Answers in Databases | By Some Guy

Published

Profile Photo - roxblade

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

Mon, 18 Feb 2019 09:21:18 -08001 year ago1
🗨 1
🐏 0
👁 330
Profile Photo - Some Guy

Best MariaDB/MySQL GUI?

Forum in Databases | By Some Guy

Published

Profile Photo - roxblade

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

Sat, 02 Feb 2019 06:53:51 -08001 year ago1
🗨 2
🐏 0
👁 352
Profile Photo - Some Guy
Profile Photo - roxblade

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

Sat, 02 Feb 2019 06:25:38 -08001 year ago1
🗨 1
🐏 0
👁 323
Profile Photo - Some Guy

What does key MUL mean in MySQL? Also, how to remove a MUL key?

Answers in Databases | By Some Guy

Published

Profile Photo - roxblade

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

Sat, 02 Feb 2019 06:17:18 -08001 year ago1
🗨 1
🐏 0
👁 834
Profile Photo - Some Guy

How can I count the number of unique IP addresses in my database?

Answers in Databases | By Some Guy

Published

Profile Photo - August R. Garcia

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

Wed, 30 Jan 2019 23:06:22 -08001 year ago1
🗨 1
🐏 0
👁 306
Profile Photo - Some Guy

Solve "trying to get property of non-object"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

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

Sun, 20 Jan 2019 18:29:51 -08001 year ago1
🗨 1
🐏 0
👁 330
Profile Photo - Some Guy

Solve "sqlstate[hy000] [2002] connection refused"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

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

Sun, 20 Jan 2019 18:05:00 -08001 year ago1
🗨 1
🐏 0
👁 385
Profile Photo - Some Guy

Fixing "MySQLi_real_connect(): (hy000/2002): no such file or directory?"

Answers in Databases | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

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

Mon, 14 Jan 2019 14:00:03 -08001 year ago1
🗨 1
🐏 0
👁 3,699
Profile Photo - Some Guy

Can SQLite and PostgreSQL be used for the same type of sites?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI've recently been hired to help create databases for this new site. In my previous occupation, we used SQLite and PostgreSQL to do a lot of the...
🗨 0
🐏 0
👁 280
Profile Photo - Some Guy

[PostgreSQL vs MySQL] What syntax differences should I know about?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI have recently been working on using the databases PostgreSQL and MySQL. As I am a new user to these platforms, are there any important syntax differ...
🗨 0
🐏 0
👁 312
Profile Photo - Some Guy

How to Take a Screenshot on a Mac?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI just got a new mac computer and I love it however I can't seem how to figure out the Screenshot feature yet. Is there something I am missing, h...
🗨 0
🐏 0
👁 346
Profile Photo - Some Guy

PostgreSQL vs MariaDB: Which is better for a dentist's website?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreHello, I am a dentist who is starting a new practice, and I want to figure out the best program to use for my website. I've narrowed it to betwee...
🗨 0
🐏 0
👁 308
Profile Photo - Some Guy

[MongoDB vs PostgreSQL] Which DB has better performance?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreIt has been a while since I've worked with databases, and I'm setting up a new one for myself. So I was wondering if anyone knows which data...
🗨 0
🐏 0
👁 300
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreIn the database, which should I use for a website on the Information Superhighway, PostgreSQL vs MsSQL / SQL Server database?
🗨 0
🐏 0
👁 278
Profile Photo - Some Guy

[SQL/MySQL/MariaDB] Can you query from a query result?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreOK, so I've been trying to learn SQL for my new job, and I was wondering if it's possible to run a query from a previous query result? My co...
🗨 0
🐏 0
👁 282
Profile Photo - Some Guy

[MySQL] Count by unique composite key?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI am having some problems with SQL databases. Anyone have experience with this? My SQL count by unique composite key is giving me a lot of trouble and...
🗨 0
🐏 0
👁 330
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm new to Databases having been on the web development side. Have a question for you experts: On a SQL Server, what is the difference between a...
🗨 0
🐏 0
👁 299
Profile Photo - Some Guy

How to install MariaDB?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI'm trying to setup a new website and I would to use the open source MariaDB package. Can anyone tell me how to install it?
🗨 0
🐏 0
👁 299
Profile Photo - Some Guy

How to install MariaDB on CentOS 7?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreI am doing a lot of work with databases. I use CentOS 7 and would like to install MariaDB. Is there a set of directions on how to install it?
🗨 0
🐏 0
👁 311
Profile Photo - Some Guy

How to migrate from MySQL to MariaDB?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreOK, so I'm pretty experienced with MySQL, but for my new job, I need to use MariaDB. Does anyone have any tips for migrating to MariaDB? I'm...
🗨 0
🐏 0
👁 283
Profile Photo - Some Guy

Fix for "Host is not allowed to connect to this MariaDB server?"

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreWe just got a new server at work, and I'm really struggling to pick it up. Today, I got this weird message: "Host is not allowed to connect...
🗨 0
🐏 0
👁 365