MySQL Archives - Page 6 of 77

Programming, sql

IT Nursery

Delete sql rows where IDs do not have a match from another table

I’m trying to delete orphan entries in a mysql table. I have 2 tables like this: Table files: | id | .... ------------ ...

June 1, 2022
0 Comments

PHP, Programming

IT Nursery

selecting unique values from a column

I have a MySQL table which contains the following type of information: Date product 2011-12-12 azd 2011-12-12 yxm 2011-12-10 sdx 2011-12-10 ssdd Here ...

June 1, 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

PHP, Programming

IT Nursery

Best practice multi language website

I’ve been struggling with this question for quite some months now, but I haven’t been in a situation that I needed to explore ...

June 1, 2022
0 Comments

WordPress

IT Nursery

Manually query posts by taxonomy with MySQL

I’m trying to query posts from the WP database with the category uncategorised, while also joining the post meta table, but I can’t ...

June 1, 2022
0 Comments

WordPress

IT Nursery

Best settings for MySQL to speed up site? [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

WordPress

IT Nursery

Converting mysql to $wpdb

I’m trying to convert this to using a $wpdb class. It will return all the enums possible and i have to use this ...

June 1, 2022
0 Comments

WordPress

IT Nursery

Create a quick start wordpress installation [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