Explore MySQL on Experts Exchange

Expert Solutions for Your Tech Problems

MySQLMySQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired...

Read more
  • 48K Content
  • 9.4K Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Mariadb blew up... why? What is causing this?

byMike
207

We've been chasing a mariadb problem for months and eliminated all we could to the point of staring

Article

3 Ways to Speed Up MySQL

35

There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these

Video
Post
Article

PHP Client Registration, Login, Logout and Easy Access Control

47
Foreword
In the years since this article was written, numerous hacking attacks have targeted…
Troubleshooting Solution

Can We Persuade MariaDB to treat 64 hex string as 32 byte Varbinary during CSV Import?

34

I've finally got back to what I was working on when I asked this question


The problem is the same

Article

Handling Date and Time in PHP and MySQL - Procedural Version

8

Introduction

This article is very old, and while most of its principles are sound, PHP programming

Troubleshooting Solution

Where should my code be corrected so that the information is inserted into the table?

14

I am attempting to insert some user information into a database table called "notices" but the

Troubleshooting Solution

Retrieve the name of a user according to two LEFT JOIN

25

Hi,

I am facing a problem retrieving values in my table.
Here is my whole code:

The objective is to

Troubleshooting Solution

MariaDB database performance test

23

What should I watch out for in MariaDB UAT envn during performance load test to have a baseline? 

Troubleshooting Solution

Best use of NVMe with Mysql?

byMike
15

I'm using freebsd to run dedicated mysql servers on hardware, no virtual machines.

When installing

Troubleshooting Solution

Query to pull finale grades from one large table, each grade will be calculated from two exams on one subject, first 60% and second 40% of final grade.

25

Need MySQL query to get final grade for each student:

I have one long table that holds students id's

Troubleshooting Solution

Bulk Load Into Mysql DB Using Load Data Infile

19

How would you configure multiple columns with Timestamp Default not null using Load Data Infile to

Research Solution

I need a Nodal Database. Got one?

10

I need a Nodal Database. Got one?


I am building a multi-level marketing company (not a pyramid) and

Video
Troubleshooting Solution

How to config/bring up freebsd galera cluster?

byMike
25

I urgently need to start testing a galera cluster to be brought into production use. I've built one

Article
Troubleshooting Solution

SQL query to create rows in a table, linked to other rows in another table

12

Hello. I'm dabbling with SQL, total newbie. I want to do something like this: find all items from

Troubleshooting Solution

MS Access and MySQL: Run-time Error 3197 When trying to Update more than one field

23

Thank you for looking at my question

Using an MS Access front end for a MySQL database, looking to

Troubleshooting Solution

Update outdated PHP code

9

I have some outdated PHP code. Can you please assist me in updating for the latest version of PHP?


Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more