MySQL Archives - Page 5 of 77

We’re using Doctrine, a PHP ORM. I am creating a query like this: $q = Doctrine_Query::create()->select('id')->from('MyTable'); and then in the function I’m adding ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

What does it mean by select 1 from table?

I have seen many queries with something as follows. Select 1 From table What does this 1 mean, how will it be executed ...

June 2, 2022
0 Comments

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

WordPress

IT Nursery

Update a WordPress post or page takes 60+ seconds

Since updating to WordPress 3.5 I’ve had my updates of pages and posts become excessively slow. I’ve been timing them and they take ...

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

Programming, Python

IT Nursery

Setting Django up to use MySQL

I want to move away from PHP a little and learn Python. In order to do web development with Python I’ll need a ...

June 2, 2022
0 Comments

WordPress

IT Nursery

Slow meta_query with about 4 milion record on wp_postmeta

Although optimized wordpress all the way but still very slow as follows : I have converted from LONGTEXT meta_value field to TEXT Then ...

June 2, 2022
0 Comments

WordPress

IT Nursery

How to migrate the posts from an old custom legacy blog to a new WordPress website?

I have to migrate the posts of a very old custom legacy blog made in ASP (the posts are stored in a MySql ...

June 2, 2022
0 Comments