MySQL Archives - Page 8 of 38

MySQL, Programming

IT Nursery

MySQL CONCAT returns NULL if any field contain NULL

I have following data in my table “devices” affiliate_name affiliate_location model ip os_type os_version cs1 inter Dell 10.125.103.25 Linux Fedora cs2 inter Dell ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

How to use MySQL DECIMAL?

I can’t quite get a grasp of MySQL’s DECIMAL. I need the row to be able to contain a number anywhere from 00.0001 ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

How to properly create composite primary keys – MYSQL

Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

ALTER TABLE to add a composite primary key

I have a table called provider. I have three columns called person, place, thing. There can be duplicate persons, duplicate places, and duplicate ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

How do I put an ‘if clause’ in an SQL string?

So here’s what I want to do on my MySQL database. I would like to do: SELECT * FROM itemsOrdered WHERE purchaseOrder_ID = ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

how to customize `show processlist` in mysql?

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL: How to reset or change the MySQL root password?

How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql service before setting ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

Deleting rows with MySQL LEFT JOIN

I have two tables, one for job deadlines, one for describe a job. Each job can take a status and some statuses means ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

Search for all occurrences of a string in a mysql database [duplicate]

This question already has answers here: Search text in fields in every table of a MySQL database (26 answers) Closed 5 years ago. ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL Removing Some Foreign keys

I have a table whose primary key is used in several other tables and has several foreign keys to other tables. CREATE TABLE ...

May 28, 2022
0 Comments