MySQL Server

46K

Solutions

53

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

Hi Experts

Could you point why this Codeigniter's data insertion is causing an error?

(CODE)

Thanks in advance!

The $params array:
(CODE)

The MySQL table structure where the data must …

87 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

is it possible to sort a data from a table according to which one is last date modified with sql ?

I mean I like the sort the rows from a table as date modified? like we sort it ASC, DESC
is ther…

25 views

The DB server used is MySQL 5.7.16.

I have a program using MySQL .Net connector. I notice that i can read data into a dataset in using the dataadapter's Fill method.

 
However, if I call the f…

419 views

I'm planning a MySQL database that will hold a million drivers license numbers and I want to know the best way to find a particular license.  Will MySQL be able to construct something better than star…

915 views

(CODE)I have read-only permission to a third-party SQL Server database. I need to manipulate the tables to create derived columns. To do this, I want to copy the tables to an existing MySQL database t…

514 views

I am having a tough time trying to figure out my first join. What I am trying to do is,

I have a table for service providers and in there is an ID number for their selected physical location. I ha…

1522 views

(CODE)

I have this code to insert what was in my form to here, the data passes but it just doesnt add to my database, anyone know why?

215 views

This takes more than 10 minutes to execute:(CODE)Is there a faster way to accomplish the same way

918 views

I'm trying to move my WordPress site to a different server. I am moving it from a windows server 2008 iis 7.5 to a windows server 2012 iis 8.5. I've already installed WordPress and that worked fine.  …

320 views

I use php and mysql database
I have a price table, which has price coloumn decimal(8,2),
when I select price from database, the output is like 1200.85
however I'd like to show it like 1,200.85 or 1…

211 views
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Dear Experts,

is it possible to write an sql sentence like this?

SELECT * FROM product where type!='mobil' order by id ASC

can I use not equal for where clause?

I want to select all data …

311 views

Hi, I would like to create a test site. I found a hosting service that is providing me with an option that is within budget however they are only providing me with access to 25 "1 gigabyte MYSQL datab…

823 views

Hi,

When I put  
OR  J.STATUS='J1'
at the end of the below query I got a performance problem.  As I understood from the EXPLAIN when the select sees the OR at the where section it goes over all t…

415 views

This is for an update function whereby the user can update certain aspects of their profile:

I have a database query that checks which categories have been selected when user initially chose them (…

1117 views

I am on an AWS virtual server running Centos 6 and Mysql 5.5.2.

My log shows

(CODE)

It seems the buffer pool size is incorrect but when it tries to increase it an error occurs. Please help me…

1649 views

I'm trying to figure out a query to count the IP field and tell me how many of the same IP there are in the table.  

Then I need to delete the duplicates from the table and only leave 1 record for …

733 views

See attached, I have created this table.. I need to add the SAME columns again (to the SAME table) but with a "2" replacing the "1" in each case.

Is thee a way to do this other than the obvious bru…

518 views

Guys I have a problem with SqlConnection at this code and I cant find whats missing


using System.Data.SqlClient
    (CODE)
so anyone help;

5123 views

Hi,
In my table i have several columns with the id as primary key.
I am using a query like select * from note where conversation_id in ('id1','id2',....'id300');
This is an extreme case where i wil…

739 views
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

HI,
In one of the mysql server when i run the query : select @@version;
The output is : 10.0.17-MariaDB-log
On other the output is :
5.6.23

What does these different mean ?
I am using these t…

227 views

I know this question seems abit counter intuitive but id like to work with the licensees I currently have, I have a MSSQL Enterprise 2008 and I currently have several Wordpress Sites using MySql, what…

728 views

I have some MYSQL code that looks like this:

 (CODE)

Now i want to change this code into something like

(CODE)

But i cant get it to work. I do prefer to use SET because when i have many ro…

634 views

This program is supposed to upload an Excel Spreadsheet into a MySQL table in a MySQL database:
(CODE)

This program was cloned from another similar one, I'm NOT doing anything new here.

Notice …

522 views

I need the total amount of times a piece of equipment was used in a assignment. Not sure if to use a count statement or group by.

220 views

I have two tables. On the first one I store all ads information. On the second table I store pictures path.
What I want to do is to select all data from the first table and select only one picture wh…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. PHP
    (117,296)
  2. Databases
    (53,501)
  3. Query Syntax
    (47,304)
  4. MS SQL Server
    (156,711)
  5. Linux
    (64,383)
  6. Apache Web Server
    (19,600)
  7. MS SQL Server 2005
    (71,488)
  8. Web Development
    (73,015)
  9. MS Access
    (215,594)
  10. MS SQL Server 2008
    (48,768)