Database Archives - Page 4 of 44

MySQL, Programming

IT Nursery

Mysql command not found in OS X 10.7

I cant get my mysql to start on os x 10.7. It is located in /usr/local/mysql/bin/mysql I get command not found when I ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL: Sort GROUP_CONCAT values

In short: Is there any way to sort the values in a GROUP_CONCAT statement? Query: GROUP_CONCAT((SELECT GROUP_CONCAT(parent.name SEPARATOR " » ") FROM test_competence ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

UPDATE multiple rows with different values in one query in MySQL

I am trying to understand how to UPDATE multiple rows with different values and I just don’t get it. The solution is everywhere ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

Select records from NOW() -1 Day

Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

#1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

Connect to mysql in a docker container from the host

(It’s probably a dumb question due to my limited knowledge with Docker or mysql administration, but since I spent a whole evening on ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

Import SQL file into mysql

I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL – Get row number on select

Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> ...

June 1, 2022
0 Comments

Database, Programming

IT Nursery

Generate the ERD for an existing database [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to change the CHARACTER SET (and COLLATION) throughout a database?

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, ...

June 1, 2022
0 Comments