256 Kilobytes

All Content > MySQL

Type All Category All Tag MySQL

Profile Photo - Some Guy

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

Profile Photo - Univa

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
🗨
1
🐏
0
👁
71
Profile Photo - Some Guy
Profile Photo - Univa

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
🗨
1
🐏
0
👁
82
Profile Photo - Some Guy
Profile Photo - Default

Last Reply Linting is a term for a program to analyze code for potential errors. This just means the query can't be validated but IIRC you can still ru... JJJJJ,

Linting is a term for a p...

Wed, 24 Apr 2019 12:08:09 -0700 3 weeks ago
🗨
1
🐏
0
👁
431
Profile Photo - Some Guy

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

Profile Photo - Univa

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

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

Profile Photo - Univa

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

Selicting database with the MySQL command line?

Answers in Databases | By Some Guy

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

Profile Photo - August R. Garcia

Last Reply USE database_name; August R. Garcia,

USE database_name;

Fri, 05 Apr 2019 15:13:49 -0700 1 month ago
🗨
2
🐏
0
👁
79
Profile Photo - Some Guy
Profile Photo - Zhaybib

Last Reply Since your PHP installation is acting up, you should check out Stack Overflow's website that is right here for a solution https://stackoverflow.com/qu... Zhaybib,

Since your PHP installati...

Sat, 30 Mar 2019 16:06:41 -0700 1 month ago
🗨
1
🐏
0
👁
69
Profile Photo - K. Crezcheezy

How to start MySQL server?

Answers in Servers and Networks | By K. Crezcheezy

Published 2 months agoTue, 19 Mar 2019 08:14:26 -0700

Profile Photo - TomGreller

Last Reply First, be sure you are at a command prompt. Then enter "shell> "C:Program FilesMySQLMySQL Server 5.0inmysqld". The path may vary depending on the ins... TomGreller,

First, be sure you are at...

Sat, 30 Mar 2019 15:03:30 -0700 1 month ago
🗨
1
🐏
0
👁
34
Profile Photo - NelsAmmo

How can I start MySQL server on Windows 10?

Answers in Computer Software | By NelsAmmo

Published 2 months agoTue, 19 Mar 2019 14:17:33 -0700

Profile Photo - FrostyMlttenJob

Last Reply This is very easy method to start the SQL server. Open Run Window by Winkey + R. Then type services.msc. Next search MySQL service based on version in... FrostyMlttenJob,

This is very easy method...

Wed, 20 Mar 2019 22:56:57 -0700 1 month ago
🗨
1
🐏
0
👁
36
Profile Photo - PPSH1111

What are some common MySQL interview questions?

Answers in Local and Offline Businesses | By PPSH1111

Published 2 months agoTue, 19 Mar 2019 21:54:30 -0700

Profile Photo - Jemgrip

Last Reply I found the answer to your question on this link... https://intellipaat.com/interview-question/mysql-interview-questions/ Hope this helps. Jemgrip,

I found the answer to you...

Wed, 20 Mar 2019 07:47:56 -0700 2 months ago
🗨
2
🐏
0
👁
28
Profile Photo - August R. Garcia

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

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
👁
147
Profile Photo - Some Guy

Best MariaDB/MySQL GUI?

Forum in Databases | By Some Guy

Published 4 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 3 months ago
🗨
2
🐏
0
👁
109
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 3 months ago
🗨
1
🐏
0
👁
83
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 4 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 3 months ago
🗨
1
🐏
0
👁
126
Profile Photo - Some Guy

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

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 3 months ago
🗨
1
🐏
0
👁
107
Profile Photo - Some Guy

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

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 4 months ago
🗨
1
🐏
0
👁
775
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 these platforms, are there any important syntax differ...
🗨
0
🐏
0
👁
92
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 better database?
🗨
0
🐏
0
👁
89
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 possible to run a query from a previous query result? My co...
🗨
0
🐏
0
👁
63
Profile Photo - Some Guy

[MySQL] Count by unique composite key?

Answers in Databases | By Some Guy

Published 4 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 unique composite key is giving me a lot of trouble and...
🗨
0
🐏
0
👁
72
Profile Photo - Some Guy

How to migrate from MySQL to MariaDB?

Answers in Databases | By Some Guy

Published 4 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 anyone have any tips for migrating to MariaDB? I'm...
🗨
0
🐏
0
👁
63
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 or MySQL? Thank you so much for the help
🗨
0
🐏
0
👁
47
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 would be appreciated. I keep running into a query except...
🗨
0
🐏
0
👁
55
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 to [MariaDB/MySQL] how do you count results by date...
🗨
0
🐏
0
👁
41
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 over 10000 rows. Has anyone had success with MySQL or...
🗨
0
🐏
0
👁
38
Profile Photo - Some Guy

How to modify a datetime in a SQL query?

Answers in Databases | By Some Guy

Published 4 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) so this question may seem basic, but how do you modif...
🗨
0
🐏
0
👁
33
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 variable equal to the result of a query?
🗨
0
🐏
0
👁
37
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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". Can someone please help me figure out how to fix it...
🗨
0
🐏
0
👁
47
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published 4 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 "SQLstate[hy000] [2002] connection refused?". How d...
🗨
0
🐏
0
👁
53
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 exists, how can I solve this?
🗨
0
🐏
0
👁
99