Databases

Create Content

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

[SQL Server] Difference between datetime and datetime2?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:40:36 -0800

Last Reply DATETIME2 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 -0700 1 week ago ⇒

🗨

🐏

👁

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

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:40:15 -0800

Last Reply Imagine 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 -0700 2 weeks ago ⇒

🗨

🐏

👁

[Dreamhost Error] How to fix "MySQL 504 Gateway Time-out; The server didn't respond in time?"

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:16 -0800

Last Reply 504 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 -0700 2 weeks ago ⇒

🗨

🐏

👁

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

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:41:02 -0800

Last Reply This 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 -0700 1 month ago ⇒

🗨

🐏

👁

What do I do "Access denied for user 'root'@'localhost'"? Help needed

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:43:10 -0800

Last Reply Try 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 -0700 1 month ago ⇒

🗨

🐏

👁

Selicting database with the MySQL command line?

Answers in Databases | By Some Guy

Published 3 months agoWed, 06 Feb 2019 14:25:32 -0800

Last Reply USE database_name; August R. Garcia,

USE database_name;

Fri, 05 Apr 2019 15:13:49 -0700 1 month ago ⇒

🗨

🐏

👁

How to export a MySQL or MariaDB Query to a CSV

Articles in Databases | By August R. Garcia

Published 2 months agoFri, 08 Mar 2019 16:39:12 -0800

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

🗨

🐏

👁

148

How do I install Oracle 11g?

Answers in Databases | By Some Guy

Published 3 months agoWed, 06 Feb 2019 14:01:19 -0800

Last Reply On 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 -0800 3 months ago ⇒

🗨

🐏

👁

Best MariaDB/MySQL GUI?

Forum in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:36:36 -0800

Last Reply Yes, 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 -0800 3 months ago ⇒

🗨

🐏

👁

110

What are the differences between MariaDB and MySQL (sine MariaDB is a fork)?

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:26 -0800

Last Reply Yes, 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 -0800 3 months ago ⇒

🗨

🐏

👁

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

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:38:36 -0800

Last Reply Multiple 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 -0800 3 months ago ⇒

🗨

🐏

👁

126

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

Answers in Databases | By Some Guy

Published 3 months agoWed, 30 Jan 2019 22:58:21 -0800

Last Reply Assuming 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 -0800 3 months ago ⇒

🗨

🐏

👁

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

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:43:24 -0800

Last Reply You'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 -0800 4 months ago ⇒

🗨

🐏

👁

108

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

Answers in Databases | By Some Guy

Published 5 months agoSun, 16 Dec 2018 09:37:22 -0800

Last Reply These 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 -0800 4 months ago ⇒

🗨

🐏

👁

109

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

Answers in Databases | By Some Guy

Published 4 months agoSun, 13 Jan 2019 04:37:06 -0800 | Last update 4 months agoMon, 14 Jan 2019 13:57:45 -0800

Last Reply Go into your script or config file and find your database credentials. Look for "localhost" and replace it with "127.0.0.1".... Hash Brown,