Database Archives - Page 39 of 44

How to do a regular expression replace in MySQL?

I have a table with ~500k rows; varchar(255) UTF8 column filename contains a file name; I’m trying to strip out various strange characters ...

May 1, 2022
0 Comments

Elasticsearch query to return all records

I have a small database in Elasticsearch and for testing purposes would like to pull all records back. I am attempting to use ...

May 1, 2022
0 Comments

What is the size of column of int(11) in mysql in bytes?

What is the size of column of int(11) in mysql in bytes? And Maximum value that can be stored in this columns? 1Best ...

April 30, 2022
0 Comments

How can I view live MySQL queries?

How can I trace MySQL queries on my Linux server as they happen? For example I’d love to set up some sort of ...

April 30, 2022
0 Comments

MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client

I can’t make a simple connection to the server for some reason. I install the newest MySQL Community 8.0 database along with Node.JS ...

April 30, 2022
0 Comments

Import SQL dump into PostgreSQL database

We are switching hosts and the old one provided a SQL dump of the PostgreSQL database of our site. Now, I’m trying to ...

April 30, 2022
0 Comments

MySql export schema without data

I’m using a MySql database with a Java program, now I want to give the program to somebody else. How to export the ...

April 30, 2022
0 Comments

Do you use source control for your database items? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

April 29, 2022
0 Comments

How do I change the data type for a column in MySQL?

I want to change the data type of multiple columns from float to int. What is the simplest way to do this? There ...

April 29, 2022
0 Comments

MySQL string replace

I have a column containing urls (id, url): http://www.example.com/articles/updates/43 http://www.example.com/articles/updates/866 http://www.example.com/articles/updates/323 http://www.example.com/articles/updates/seo-url http://www.example.com/articles/updates/4?something=test I’d like to change the word “updates” to “news”. Is ...

April 29, 2022
0 Comments