MySQL Server

46K

Solutions

56

Articles & Videos

22K

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.

Related Topics

  1. PHP
  2. Databases
  3. Query Syntax
  4. Microsoft SQL Server
  5. Linux
  6. Apache Web Server
  7. Microsoft SQL Server 2005
  8. Web Development
  9. Microsoft Access
  10. Microsoft SQL Server 2008
Refine results

I am an oracle developer for last 10 years trying to get experienced with MySQL for some database conversion project.

Few questions:

1) How long do you think  it would it take to learn to write …

1016 views
Ransomware-A Revenue Bonanza for Service Providers
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

I need to run a query that will build a link, it has to loop through the data and yield all results. Problem is every time I try to join the tables I get this error:Warning: mysql_fetch_assoc() …

936 views

Hi experts,

I became the following Error when I want to get the number of rows of my query:

Fatal error: Uncaught Error: Call to undefined function msql_num_rows() in …

844 views

I have the following qry to get the amont & tax where unit_is_pharmacy = 1

Scenario 1

SELECT SUM(Amount),SUM(tax)

FROM

 (
  SELECT unit_code,unit_is_pharmacy,SUM(IF(bad_payer_type = 'A', …

117 views

Hello

I have a query and need to include the value of a javascript variable in the 'WHERE' clause. I have only posted the relevant code,but if you need to see code before or after, please ask.

2141 views

Hi,

I have a php script which is running a number of commands but then fails when I insert the following: -

(CODE)

However, when I test the SELECT query in terminal (as show below) using my …

931 views

Hello,

This is the second case with the same scenario:

-the customer uses MySql on Linux for more than 5 years without any problem
-they buy a brand new Pc (about 3 times as fast as the Linux …

1072 views

Hi!  I've been going in circles trying to resolve the issue: "Notice: Undefined index: initials on line 29"

This code has a precursor that is an HTML form where someone enters their initials, then …

539 views

Hello Experts, I need to export a particular table from MYSQL,
it has 198000 records and I am only exporting this particular table.

I right click on the table name in the left panel of MYSQL …

427 views

Hi,

Look for a steer on the above.

Using TCPDF to produce a number of PDF's but would like to add a date range to the output of the report - wondering what is the best way to do this within the…

941 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 two test tables
One with members and one with payments
I created two simple tables for the question:
member table
member_id    Fullname
1                        Name_1
2   …

1140 views

hi,

any one can tell me what is  MySQL Fabric, MySQL Router and MySQL Shell is ?

can MySQL use replication and mirroring  ?

what about the master/master and master/slave mode, any topology …

537 views

wamp Version 3.0.6 - 64bit


my localhost has folders on same directory
I click on "folder1" and url is
folder1

i want
localhost/folder1

how do i tell wamp that localhost is my base URL

846 views

Hi Guys,

i have this site http://mediastreetdirectory.com and i was wondering is there a way i can email everyone in the database the link to their own listing.

Thanks guys

568 views

(CODE)

542 views

In my ongoing effort to convert all of my company's MSSQL data to MySQL, I need more help with a mySQL variant of a php function.  

In this instance, I  have a stored procedure that takes 2 inputs …

649 views

Hello
I am using the following code to try and update/replace data in a table. However, all it does add to the table instead of replacing it. I tried using the 'LOCAL' keyword, but it errors saying …

747 views

I have user table which contains user_name, import_id, user_category

user_name   import_id   user_category
aaaaa                 1                 1
bbbbbb              1                 1
aaaaa…

640 views

Hello, I have a problem on my CentOS 6.5 server related to phpmyadmin.

If I click on Export (not for a particular database, but for all the databases) I get a 500 error, which translated into this …

5594 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hello

Probably a very simple answer to my question but here goes.

Plesk has updated phpmyadmin to V4.5.1 and when I try to import a CSV file there is no option to 'Replace table data with file'.…

1150 views

I have this code
(CODE)

My var_dump of the row is null, But when I run the same exact query on my database, there is a value, what is the problem?

343 views

I want to get the category of a student by creating a procedure which has two parameters p_student_id and p_event_id (they are also columns so I put p_).  One way is that I can join all the three …

749 views

how can I integrate a search engine on my website , using js , php and mysql ?
NB . the user can search any thing inside the site!

446 views

DELIMITER $$
CREATE FUNCTION MAXSCORE(START_STUDENT_ID INT, END_STUDENT_ID INT)
RETURNS INT
BEGIN
DECLARE MAX_SCORE INT;
BEGIN
SELECT MAX(SCORE) INTO MAX_SCORE
            FROM STUDENT ST, …

438 views

I am trying to create a function but I am getting an error. The error is:  Not allowed to return a result set from a function
And my function is

DELIMITER $$
CREATE FUNCTION …

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

MySQL Server

46K

Solutions

56

Articles & Videos

22K

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.

Related Topics

  1. PHP
  2. Databases
  3. Query Syntax
  4. Microsoft SQL Server
  5. Linux
  6. Apache Web Server