Browsing Tag

mysql

Can’t Connect to MySQL instance Remotely that is running on EC2 Instance (Not RDS)

I have seen a lot of posts that claim they are running an RDS instance of MySql in which they cannot connect to, but I

Update data programmatically in code(Java) or in database using trigger (MySQL)?

I will create program that will update data in database. The update process will be triggered if I do insert data in table. The update

MySQL JOIN or UNION with AND based on previous resultset, WordPress pre_get_posts and post_meta

Trying to recursively select database fields based on parent IDs of current selection in a WordPress environment. On the WordPress side: I’m doing a pre_get_posts

mySQL queries are executed twice on wordpress website

I’m sorry for my english. I’m trying to add some functionalities at my WordPress website and to do this i have added a function in

how to make a copy of a mysql table, adding some columns and taking some out, changing the order and retaining any data relevant to the new table?

I want a wordpress user to be able to alter the structure of a database table, while retaining data in columns that are unchanged. My

MySQL query and array output from same database column

I’m still quite new to PHP & MySql and I’m not sure whether this would be acheived as SQL or PHP. I have the following

mySQL Query seems to crash server

I have a mySQL Query to handle a fairly complicated search in WordPress because I’ve been struggling to get wp_query to do everything I need

Mysql error 1093: How to delete wordpress users with no posts & no comments, is not an admin and registered in year 2013 and older

I have this code that works properly and displays the output that I want. SELECT * FROM wp_users WHERE ID NOT IN ( SELECT post_author

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result q

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result I get the error when trying to run this: <?php function kishvoteCount() { global $wpdb;

Trying to locate and bulk edit WooCommerce prices in MySQL

I have roughly 10,000+ products in WooCommerce version 2.1.12, WordPress version 3.9.1 and through an import error, the sale price field was populated with a

Storing checkbox values in mysql

So one of my columns in my table has values like this a:2:{i:0;s:6:"Subbed";i:1;s:6:"Dubbed";} Right now it’s stored as longtext and I’ve heard that varchar is

Best db design to optermise MySQL joins on large datasets

I currently have a review website running on WordPress. The website has grown and performance is now and issue. I currently store all the meta

Best db design to optimize MySQL joins on large datasets

I currently have a review website running on WordPress. The website has grown and performance is now and issue. I currently store all the meta

Select list with age groups to mysql query

I use a form with a select list with age groups. My question is how to convert this select list to a flexible mysql query.

Which rules to follow while writing mysql queries in WordPress

I am new to WordPress and have some doubts regarding structure. I want to know that while writing database queries using $wpdb global variable, is

mysql query doesnt work

I have a problem with a query in mysql. It’s from a wordpress blog and a try to set the title of each post als

Back to Top 134726 wordpress questions, 32 Wordpress answers.
Wordpress related, All rights reserved
Powered by Creative Advertising