MySQL Server

46K

Solutions

51

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 2 unrelated tables "customers" and "categories"
customers has 2 fields custID and custName
categories has 2 fields catID and CatName

I have a 3rd table custcats that I want to insert Data…

910 views
 Java Android Coding Bundle

Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

I was given the following code to create some tables in MySQL:

create table vt_staff (
    stf_id          decimal(6,0)   primary key
  , stf_name_last   varchar(25)    not null
  , stf_name_fir…

312 views

I originally used mysqli object oriented way to log users in but am moving over to prepared statements. My problem is that with this code, as long as the email address is in the database, any password…

105 views

Hi Experts:

Could you please help me with displaying the images stored in the database table on a webpage.  I have a database table with 8 columns as shown in the picture below.  Sometimes each row…

114 views

Dear Experts,
I use 2 and in one sql statement,
but it is not working,
could you please check what's wrong with my code

$sql = "SELECT * FROM siparis where uid = '$uid' and _key = '$siparisno' a…

311 views

This is my query:(CODE)Here is the table structure:(CODE)What indexes could be added to increase the performance/speed of the query?

616 views

Hi,
I have the following table :
(CODE)

And I performed the following query :
(CODE)
In the output the key column had value NULL
which is expected as there is not index on user column.
So i…

213 views

HI,
I have the following table :
(CODE)

And i will be performing only the following queries on this table :
(CODE)
The first query can be alternatively thought of as where conversation, user i…

315 views

Hi,
I'm trying to put together a query that as part of the select, it takes the datetime stamp that the row was added  and todays date and returns the number of days that have passed.


Guessing s…

213 views

Hello,
 I want to create single store procedure in php mysql for all operations. Where I want pass all parameters including table name and column name. I don't want to create 100 procedure for my 100…

620 views
IT, Stop Being Called Into Every Meeting

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!

Using MySQL, how can I get a list of ALL items that have a duplicate `NumericID`?

In this example, it only shows the first matching duplicate.

http://sqlfiddle.com/#!9/ccb53/13/0(CODE)For exampl…

314 views

http://sqlfiddle.com/#!9/437c3/1/0

I need these results to be returned:(CODE)However, "10 Smiles" is included in the results 3 times.  Each item should only be included once, and if there is a matc…

813 views

I have a MySQL dump file named: "xyz.sql" that is about 10 gigabytes.  Is there a way to get the names of the tables from the .sql file from the Linux command line without having to download the file …

115 views

Hello!

I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this:

Database client version: libmysql - 5.5.50

But when I do this in the terminal:

mysql -V

I get ver. 5.5.52

Also in S…

414 views

sql server 2008 r2

I have an id_column that is varchar(50)

I have this query where I'm trying to pullout data in sequence piece by piece. into a text file.

[code][/
SELECT [Id_Column]
     …

417 views

what is the sql sentence to copy a column to the a new coloumn?
I want to create a copy of a column

319 views

when use PhpMyAdmin, I can easily see what content my tables have.
When I use PhpMyAdmin, I double click the table's row, I can edit the table data easliy.
But when I import a table to mysql databas…

414 views

I have an old and new database with different config as follows.

Old -`id` varchar(36) CHARACTER SET latin1 NOT NULL,

New - `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,

Can I alter the …

79 views

We have vtiger crm and MySQL database.  We have access to the DB but some table we have not been able to identify.  Any EE knows of vtiger tables or some sort of link that would describe them?

412 views
Course: MongoDB Object-Document Mapper for NodeJS

NodeJS (JavaScript on the server) is awesome, but some developers get confused about NoSQL when it comes to working in Node with MongoDB (NoSQL database). Do you need a better explanation of how to use Node.js with MongoDB? The most popular choice is the Mongoose library.

Hi Everyone,

Any assistance would be greatly appreciated. BIG THANKS!!!

Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…

1638 views

Dear Experts,
I'm using Ray Paseur PHP Client Registration, Login, Logout and Easy Access Control pages.

I have created a database for my users and I already set their user name and password for t…

525 views

Hi All ,

I want to install my sql Db on an ubuntu server. No idea how to do this. Never installed sql. Also how to define below:

    /** The name of the database for WordPress */
    define;

534 views

Hi there.

I have some Pictures stored in a MySQL database. Yeah yeah... I know it's not the best solution, but I didn't have a safe option to put them on a fileserver. Anyway... What is the best way …

1654 views

Hi,

I need to adapt this Mysql query, this will be a manual query that I will run from PHPMyAdmin

(CODE)
I want to replace consecutive space by only one  -

example
report summer      2016.p…

513 views

Hi Experts,

I have two tables that rows are linked by the 'PersonRef' field.

Table 'person' example:
PersonRef     FirstName      LastName
12                   Jim                   Smith
23…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. PHP
    (116,792)
  2. Databases
    (53,333)
  3. Query Syntax
    (47,093)
  4. MS SQL Server
    (156,055)
  5. Linux
    (64,141)
  6. Apache Web Server
    (19,560)
  7. MS SQL Server 2005
    (71,390)
  8. Web Development
    (72,781)
  9. MS Access
    (214,924)
  10. MS SQL Server 2008
    (48,415)