phpmyadmin

How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I…

I'm using mySQL and PHPMyAdmin. I have the floowing three tables and fields in my DB; T_users; F_uID - varchar - (PK) F_Forename - text F_Surname -…

I need days in my tables and I need the query to compare with today like this ex : $query = "select course_ID from course where day = (today)"; This…

I have setup a domain name to run on amazon ec2 running ubuntu 11.04, nginx and php5-fpm. The domain name works great, I have setup it's own…

i am using magento 1.4.2 I am trying to bulid custom sales report but does't find model to find sales report query. plz help

I have a SQL query as follows SELECT * FROM epf_application WHERE application_id IN (SELECT application_id FROM epf_application_device_type WHERE…

I have nginx and php5-fpm running on ubuntu 11.04. I have installed phpmyadmin but im having trouble accessing it. I would like to access it via…

I'm running nginx along with fastcgi-php to get php working for phpmyadmin. (I'm developing with Rails primarily.) I'm running everything from a…

I can do this process, but I want to change the values in excel that seperate the data and columns and lines. At the moment each field is not…

I have a table called phase with following fields. ID,Name. I want to change its comment using query. ALTER TABLE phase CHANGE Name Name…

I've got a fairly complex xml file stored on a MySQL table, and I'm trying to find a way to update and replace the entire xml structure with a new…

Which is better 100 tables with 10,000 rows or 1,000 tables with 1,000 rows? The above question is just a base.Its not completed without the…

SELECT count(sfoa.city) as count_of_city, sfoa.city FROM sales_flat_order as sfo LEFT JOIN sales_flat_order_address as sfoa ON…

My Query: select distinct a.city, ( select count(*) from sales_flat_order where a.email=b.customer_email group by a.city ) as 'lora' from…

I have a joomla mysql database with a table name prefix of "jos_" on all of my table names. But I would like to remove it from all of my tables. I…

Am Newbie.I have this coding...How to store into Mysql and How to Retrieve from the Database? <input type="checkbox" name="like"…

for a basic SQL command via PHPMyAdmin in MySQL I want to select items more than 1 day old. I'm getting a basic error saying that there's a SQL…

I'm working in phpMyAdmin 3.3.9 with mySQL 5.5.8. I have a database with myISAM tables so I had to write a trigger to check referential integrity…

Is it possible to access phpmyadmin from outside the network? Where do I set it? I tried editing httpd.conf, and restarted all services from…

Here is my function: $result_display = mysql_query("SELECT * FROM Events ORDER BY TimeStamp DESC LIMIT $y, 20"); $result_comment =…