How to export a MySQL or MariaDB Query to a CSV
Articles in Databases | By August R. Garcia
Published 2 weeks 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:How do I install Oracle 11g?
Answers in Databases | By Some Guy
Published 1 month 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...
Selicting database with the MySQL command line?
Answers in Databases | By Some Guy
Published 1 month agoWed, 06 Feb 2019 14:25:32 -0800
MoreI've started learning PHP and I got mySQL up and running, Im trying to access a database I m
Best MariaDB/MySQL GUI?
Forum in Databases | By Some Guy
Published 2 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...
What are the differences between MariaDB and MySQL (sine MariaDB is a fork)?
Answers in Databases | By Some Guy
Published 2 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...
What does key MUL mean in MySQL? Also, how to remove a MUL key?
Answers in Databases | By Some Guy
Published 2 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...
How can I count the number of unique IP addresses in my database?
Answers in Databases | By Some Guy
Published 1 month 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...
Solve "trying to get property of non-object"?
Answers in Databases | By Some Guy
Published 3 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...
Solve "sqlstate[hy000] [2002] connection refused"?
Answers in Databases | By Some Guy
Published 3 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...
Fixing "MySQLi_real_connect(): (hy000/2002): no such file or directory?"
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:37:06 -0800 | Last update 2 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,
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 2 months agoSun, 13 Jan 2019 04:41:56 -0800
MoreI've recently been hired to help create databases for this new site. In my previous occupati
[PostgreSQL vs MySQL] What syntax differences should I know about?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:41:46 -0800
MoreI have recently been working on using the databases PostgreSQL and MySQL. As I am a new user to t
How to Take a Screenshot on a Mac?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:41:36 -0800
MoreI just got a new mac computer and I love it however I can't seem how to figure out the Scree
[PostgreSQL vs MySQL] Which DB has the best performance?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:41:26 -0800
MoreI am trying to determine which database has the best performance. Is PostgreSQL or MySQL a
PostgreSQL vs MariaDB: Which is better for a dentist's website?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:41:16 -0800
MoreHello, I am a dentist who is starting a new practice, and I want to figure out the best program t
[MongoDB vs PostgreSQL] Which DB has better performance?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:41:06 -0800
MoreIt has been a while since I've worked with databases, and I'm setting up a new one for
PostgreSQL vs MsSQL / SQL Server: Which should I use for a website on the Information Superhighway?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:56 -0800
MoreIn the database, which should I use for a website on the Information Superhighway, PostgreSQL vs
When to Use Apache Cassandra vs MongoDB?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:46 -0800
MoreI know I've needed a database solution for my website for some time. Now that I'm final
[SQL Server] Difference between datetime and datetime2?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:36 -0800
MoreHi, so I've been recently learning SQL for my job, but there's some quirks that I still
[SQL/MySQL/MariaDB] Can you query from a query result?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:26 -0800
MoreOK, so I've been trying to learn SQL for my new job, and I was wondering if it's possib
[MySQL] Count by unique composite key?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:16 -0800
MoreI am having some problems with SQL databases. Anyone have experience with this? My SQL count by u
[SQL Server] What is the difference betweewn a clustered and nonclustered index?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:40:06 -0800
MoreI'm new to Databases having been on the web development side. Have a question for you expert
How to install MariaDB?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:56 -0800
MoreI'm trying to setup a new website and I would to use the open source MariaDB package. Can an
How to install MariaDB on CentOS 7?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:46 -0800
MoreI am doing a lot of work with databases. I use CentOS 7 and would like to install MariaDB. Is the
How to migrate from MySQL to MariaDB?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:36 -0800
MoreOK, so I'm pretty experienced with MySQL, but for my new job, I need to use MariaDB. Does an
Fix for "Host is not allowed to connect to this MariaDB server?"
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:26 -0800
MoreWe just got a new server at work, and I'm really struggling to pick it up. Today, I got this
[MariaDB] Fix for "access denied for user 'root'@'localhost'?"
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:16 -0800
MoreI am working in MariaDB and I am getting an error that says: "access denied for user 'r
[MariaDB] How to create a database?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:39:06 -0800
MoreI'm just starting MariaDB and really want to learn it well. How do I actually create a datab
How to install MariaDB on Ubuntu?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:38:56 -0800
MoreI am having an issue with one of my databases, how would I install MariaDB on Ubuntu? I keep gett
Is it possible to reset the root password for MariaDB?
Answers in Databases | By Some Guy
Published 2 months agoSun, 13 Jan 2019 04:38:46 -0800
MoreDoes anyone know if it's possible to reset the root password for MariaDB, and can you tell m