MySQL Archives - Page 9 of 38

MySQL, Programming

IT Nursery

How can I initialize a MySQL database with schema in a Docker container?

I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: FROM ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

String concatenation in MySQL

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn’t work : ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Warning the user/local/mysql/data directory is not owned by the mysql user

I can’t start the mysql service in Snow Leopard, and in the panel prefs appears the message, warning the user/local/mysql/data directory is not ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Invalid default value for ‘create_date’ timestamp field

I have the following sql create statement mysql> CREATE TABLE IF NOT EXISTS `erp`.`je_menus` ( -> `id` INT(11) NOT NULL AUTO_INCREMENT , -> ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Location of my.cnf file on macOS

I’m trying to follow along this tutorial to enable remote access to MySQL. The problem is, where should my.cnf file be located? I’m ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Reset MySQL root password using ALTER USER statement after install on Mac

I’m new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after install. It ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

JOIN queries vs multiple queries

Are JOIN queries faster than several queries? (You run your main query, and then you run many other SELECTs based on the results ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Count the number of occurrences of a string in a VARCHAR field?

I have a table like this: TITLE | DESCRIPTION ------------------------------------------------ test1 | value blah blah value test2 | value test test3 | test ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

How do you uninstall MySQL from Mac OS X?

I accidentally installed the PowerPC version of MySQL on my Intel Mac in Snow Leopard, and it installed without a problem but of ...

May 27, 2022
0 Comments

MySQL, Programming

IT Nursery

Best data type for storing currency values in a MySQL database

What is the best SQL data type for currency values? I’m using MySQL but would prefer a database independent type. 9 Answers 9

May 27, 2022
0 Comments