MySQL Server

46K

Solutions

54

Articles & Videos

20K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Refine results

I have the need for a complex query.

I want to select all entries from table_1 where zones = 6 and cw = "city". See attached image table_1.jpg.

Then select all entries from table_2 where custnum…

215 views
What is SQL Server and how does it work?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Hello Experts,

I have loaded the basic MySQL data (i.e. data from the multiple tables using LEFT OUTER JOIN) into Tableview (VB.NET). Simultaneously, now I need to load the clubbed data (i.e. total…

38 views

I  have setup a test LAMP site on VMware Workstation 12 using Centos 6.  I found out I have a problem by trying to update a field and the update not being honored.  Looking at the logs this is what it…

711 views

I have been attempting to create a simple function in phpMyAdmin for the better part of an hour now with absolutely no success.  The function is simple, nothing more than a select from a table where a…

813 views

Here is my query, the explain result and the indexes are attached.

At the where the query is searching from a big table (CFV.VALUE=18809), To speed up the query I have added the VAL index to table …

1047 views

I have a query that has worked fine for a long time, but our database had a recent influx of new entries. I'm now getting this warning.
 Allowed memory size of 134217728 bytes exhausted (tried to …

625 views

Here's my SELECT:

select pymt.*, pgm.program,
pgm.amount
FROM
payment pymt INNER JOIN programs pgm ON
pymt.id=pgm.payment_id
WHERE
(pgm.program='After School' or pgm.program='Camp')

636 views

I'm trying to do an inplace upgrade to my MySQL 5.5 instance on Windows 2008 R2 to 5.6 via these instructions https://dev.mysql.com/doc/refman/5.6/en/upgrading.html#upgrade-procedure-inplace .  …

1325 views

Environment :
Mysql Server 5.7
Win 10
Coldfusion

I am able to backup a mysql database from the mysql server. It gets backed up to  C:\mysql_backups\office.sql. I do this utilizing <cfexecute> …

728 views

Hi Experts

Couls you point a way to make Codeigniter to consider the UTF-8 characters in config.php?

(CODE)

Thanks in advance!

1441 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Saving Data</title>
    <a href="showDetails.php">Show All User's Profile</a>
</head>
<body>
<?php
$fName …

735 views

The MySQL Memory keeps getting into a cycle. It steadily increases and hits a max and then all of a sudden drops way back down only to repeat the cycle again.  See the attached image showing 7 days of…

435 views

Morning, EE!

I've got an interview this morning and the potential employer describes the contract to my recruiter like this:

SQL injection remediation
Retrofit for existing web services
PDO …

452 views

Hello,

I have a similar Sql:

Select t.*, a.allquantity
FROM
  t

left join(select productnumber,
case t.isLength
 when 0 then sum(quantity)
 else sum(otherfield)
end allquantity

from …

1050 views

The MySQL log contains 1000s of statements like this:

“[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because …

628 views

Dear Experts,
I use php and mysql

I need to encrypt  a letter, number combination like this LCKR242sdfasT and decrtpy it again.

I want to save the data encrypted on my server, when I need the …

326 views

Hello experts!

I am trying to display images from BLOB type.

I tried tons of different ways and none of them work.

Look my function that displays my image:

(CODE)
And i tried to use the …

928 views

Hi Experts

Could you point what's necessary to make PHPExceel to consider special characters when saving the sheets?

For example:
If I use the word: Leão in a where clause
... WHERE name LIKE …

638 views

Hi all,

I'm experiencing a sudden change in performance when updating records in my mysql databases. I do this through classic asp.

I have no problems when inserting records - only when …

622 views
Efficient way to get backups off site to Azure
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

I am able to create/restore a mysql database from an sql file using the cmd environment :

C:\DUMPS>"c:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root -p office < …

536 views

I have records in the database written as:

2016-11-28 10:09:19
2016-11-29 12:09:19
2016-11-30 10:30:28
2016-11-30 14:09:19

I want to pull the records between these 11/28 and 11/30 but I only …

1430 views

Dear Experts,

I have been looking to create my own online database, and started to add MySQL database to my hosting service accounts. (Plesk platform)
I can create basic database using their …

756 views

Hi Experts

Could you point what is avoiding the PHPExcel library to fill the sheet?

Accordingly to:
(CODE)


The query produces data in MySQL


But Excel sheet is clean:


Thanks in …

835 views

I have a database called office on mysqlserver.  I need to have a user friendly backup facility - ie the user can click a link and the backup will be created - ie office.sql and inserted into a …

937 views

Do we have any techniques or tools to convert ER to Activity diagram.
If so, how?

217 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. PHP
    (117,724)
  2. Databases
    (53,700)
  3. Query Syntax
    (47,606)
  4. MS SQL Server
    (157,558)
  5. Linux
    (64,642)
  6. Apache Web Server
    (19,641)
  7. MS SQL Server 2005
    (71,562)
  8. Web Development
    (73,242)
  9. MS Access
    (216,157)
  10. MS SQL Server 2008
    (49,070)