256 Kilobytes

All Content > MySQL

Type All Category All Tag MySQL

Profile Photo - August R. Garcia

How to export a MySQL or MariaDB Query to a CSV

Articles in Databases | By August R. Garcia

Published 1 week agoFri, 08 Mar 2019 16:39:12 -0800

Profile Photo - August R. Garcia

TL;DR: Here is a one-line command to run...

MoreTL;DR: Run this command from your local machine:
🗨
0
🐏
0
👁
52
Profile Photo - Some Guy

Selicting database with the MySQL command line?

Answers in Databases | By Some Guy

Published 1 month agoWed, 06 Feb 2019 14:25:32 -0800

Profile Photo - Some Guy

MoreI've started learning PHP and I got mySQL up and running, Im trying to access a database I m
🗨
0
🐏
0
👁
38
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI was working on my computer and I got the error "your PHP installation appears to be missin
🗨
0
🐏
0
👁
30
Profile Photo - Some Guy

Best MariaDB/MySQL GUI?

Forum in Databases | By Some Guy

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

Profile Photo - roxblade

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 1 month ago
🗨
2
🐏
0
👁
66
Profile Photo - Some Guy
Profile Photo - roxblade

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 1 month ago
🗨
1
🐏
0
👁
51
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 2 months agoSun, 13 Jan 2019 04:38:36 -0800

Profile Photo - roxblade

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 1 month ago
🗨
1
🐏
0
👁
62
Profile Photo - Some Guy

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

Profile Photo - Hash Brown

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 1 month ago
🗨
1
🐏
0
👁
65
Profile Photo - Some Guy

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

Profile Photo - Hash Brown

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

Mon, 14 Jan 2019 14:00:03 -0800 2 months ago
🗨
1
🐏
0
👁
134
Profile Photo - Some Guy

[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

Profile Photo - Some Guy

MoreI have recently been working on using the databases PostgreSQL and MySQL. As I am a new user to t
🗨
0
🐏
0
👁
48
Profile Photo - Some Guy

[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

Profile Photo - Some Guy

MoreI am trying to determine which database has the best performance. Is PostgreSQL or MySQL a
🗨
0
🐏
0
👁
49
Profile Photo - Some Guy

[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

Profile Photo - Some Guy

MoreOK, so I've been trying to learn SQL for my new job, and I was wondering if it's possib
🗨
0
🐏
0
👁
25
Profile Photo - Some Guy

[MySQL] Count by unique composite key?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:40:16 -0800

Profile Photo - Some Guy

MoreI am having some problems with SQL databases. Anyone have experience with this? My SQL count by u
🗨
0
🐏
0
👁
31
Profile Photo - Some Guy

How to migrate from MySQL to MariaDB?

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreOK, so I'm pretty experienced with MySQL, but for my new job, I need to use MariaDB. Does an
🗨
0
🐏
0
👁
23
Profile Photo - Some Guy

How to check the query_cache_type value/setting for MariaDB/MySQL?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:38:26 -0800

Profile Photo - Some Guy

MoreI need to check the query_cashe_type value/setting for my database. How do you do that in MariaDB
🗨
0
🐏
0
👁
22
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreHi, I'm a bit new to SQL so this might seem like an overly simple question, but any help wou
🗨
0
🐏
0
👁
21
Profile Photo - Some Guy

[MariaDB/MySQL] Count results by date and include empty dates?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:38:06 -0800

Profile Photo - Some Guy

MoreI have a database question and was wondering if anyone else had encountered it before? In regards
🗨
0
🐏
0
👁
26
Profile Photo - Some Guy

[MySQL/MariaDB] How to improve performance when querying over 10000 rows?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:37:56 -0800

Profile Photo - Some Guy

MoreI am creating a spreadsheet for work and I am running into performance issues when working with o
🗨
0
🐏
0
👁
21
Profile Photo - Some Guy

How to modify a datetime in a SQL query?

Answers in Databases | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:37:46 -0800

Profile Photo - Some Guy

MoreHi everyone! I'm a bit inexperienced at SQL (just starting to learn it for a new job yikes)
🗨
0
🐏
0
👁
19
Profile Photo - Some Guy

How to set a MySQL/MariaDB variable equal to the result of query?

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreI'm a bit new to MySQL, so sorry if this question seems basic. But how can I set a MySQL var
🗨
0
🐏
0
👁
21
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm using Dreamhost and I'm getting an MySQL error that's preventing me from doing
🗨
0
🐏
0
👁
34
Profile Photo - Some Guy

Fixing "SQLstate[hy000] [1045] access denied for user?"

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreI am getting this error in my database: "SQLstate[hy000] [1045] access denied for user"
🗨
0
🐏
0
👁
28
Profile Photo - Some Guy

Fix for "SQLstate[hy000] [2002] connection refused?"

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

MoreI am working on a project and need to use my database, but I'm getting this message "SQ
🗨
0
🐏
0
👁
33
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreSo I just got a new job, and they all use MySQL and I've been trying to get used to it, but
🗨
0
🐏
0
👁
93
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm trying to create a procedure but I'm getting an error that the procedure already ex
🗨
0
🐏
0
👁
55
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last Reply If you are getting this error while connected to a remote terminal via SSH (such as to a web host), there may be a non-root account that you are meant... August R. Garcia,

If you are getting this e...

Sat, 22 Dec 2018 08:22:52 -0800 2 months ago
🗨
1
🐏
0
👁
45
Profile Photo - Some Guy

Solve "Column count doesn't match value count at row 1"?

Answers in Databases | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:40:57 -0800

Profile Photo - August R. Garcia

Last Reply This error can occur if you are missing If your insert statement does not specify the number of columns correct. Example of incorrect statement:... August R. Garcia,

This error can occur if y...

Thu, 20 Dec 2018 01:18:24 -0800 3 months ago
🗨
1
🐏
0
👁
60
Profile Photo - Some Guy

How to fix "unknown 'column name' in 'field list'"?

Answers in Databases | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:27:33 -0800 | Last update 3 months agoWed, 19 Dec 2018 08:22:09 -0800

Profile Photo - Hash Brown

Last Reply Hello, This is really easy, the column name you have refferenced (rabbit_name) does not exist. Check the spelling, or add the column to the tabl... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:22:55 -0800 3 months ago
🗨
1
🐏
0
👁
32
Profile Photo - Some Guy

What is "mysqli_fetch_assoc"?

Answers in Databases | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:26:40 -0800

Profile Photo - Hash Brown

Last Reply Hello, Firstly and most importantly, mysqli is dead. It's very easy to mess up and ship code with security issues. You should look at PDO (PHP... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:19:40 -0800 3 months ago
🗨
1
🐏
0
👁
39
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

My new job using MySQL and I've bee...

MoreMy new job using MySQL and I've been trying to get used to it. But I keep running into an ac
🗨
0
🐏
0
👁
30
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

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

Profile Photo - Some Guy

I am using MySQL to manage a database of...

MoreI am using MySQL to manage a database of student information. I am trying to use a query to sele
🗨
0
🐏
0
👁
30