256 Kilobytes

All Content > MySQL

Type All Category All Tag MySQL

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 -08001 year ago1
🗨 1
🐏 0
👁 529
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

See screenshot. Here's the solution:<br...

MoreSee screenshot. Here's the solution: Login to DreamHost Go to More > MySQL Databases Find the database user who you want to connect to th...
🗨 0
🐏 0
👁 431
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Regular indexes are basically irrelevant...

MoreRegular indexes are basically irrelevant if you need string matching within arbitrary positions in a string (rather than only at the start). The...
🗨 0
🐏 1
👁 439
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 -07002 years ago1
🗨 1
🐏 0
👁 517
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 -07002 years ago1
🗨 1
🐏 0
👁 708
Profile Photo - Some Guy
Profile Photo - Default

Last ReplyLinting 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 -07002 years ago1
🗨 1
🐏 0
👁 4,287
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 -07002 years ago1
🗨 1
🐏 0
👁 537
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published

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 -07002 years ago1
🗨 1
🐏 0
👁 539
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 -07002 years ago1
🗨 2
🐏 0
👁 503
Profile Photo - Some Guy
Profile Photo - Zhaybib

Last ReplySince 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 -07002 years ago1
🗨 1
🐏 0
👁 513
Profile Photo - K. Crezcheezy

How to start MySQL server?

Answers in Servers and Networks | By K. Crezcheezy

Published

Profile Photo - TomGreller

Last ReplyFirst, 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 -07002 years ago1
🗨 1
🐏 0
👁 428
Profile Photo - NelsAmmo

How can I start MySQL server on Windows 10?

Answers in Computer Software | By NelsAmmo

Published

Profile Photo - FrostyMlttenJob

Last ReplyThis 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 -07002 years ago1
🗨 1
🐏 0
👁 388
Profile Photo - PPSH1111

What are some common MySQL interview questions?

Answers in Local and Offline Businesses | By PPSH1111

Published

Profile Photo - Jemgrip

Last ReplyI 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 -07002 years ago1
🗨 2
🐏 0
👁 345
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
👁 1,527
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 -08002 years ago1
🗨 2
🐏 0
👁 512
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 -08002 years ago1
🗨 1
🐏 0
👁 466
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 -08002 years ago1
🗨 1
🐏 0
👁 1,868
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 -08002 years ago1
🗨 1
🐏 0
👁 487
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 -08002 years ago1
🗨 1
🐏 0
👁 4,163
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
👁 440
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
👁 400
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
👁 469
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
👁 410
Profile Photo - Some Guy

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

Answers in Databases | By Some Guy

Published

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

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

Answers in Databases | By Some Guy

Published

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

How to modify a datetime in a SQL query?

Answers in Databases | By Some Guy

Published

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

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

Answers in Databases | By Some Guy

Published

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

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

Answers in Databases | By Some Guy

Published

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
👁 306