mysql

I have a PHP search script which queries a MySQL database. Currently, when no results are displayed the script shows and error. How can I make it…

I want to only display 5 results from my database with my PHP search script. How can I do this? My PHP code is: <?php…

I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes. I'm also starting to…

I wrote an application on VB6/Access for a retail shop almost 8 yrs ago. They are still using it, and now they are asking for changes/upgrade and…

I want all my tables and infact the whole database to use Myisam engine. My Project uses myisam database exclusively.. So.. I want that by default…

My problem is pretty much decribed with the title! I have this code that inserts data to the db: <?php require_once 'connection.php'; $pName =…

hello i'v built a search, using MySQL, PHP and jQuery, this is the search query using Prepared Statement.. $sql = "SELECT singer_name FROM singers…

Could $user_input in the following code be chosen to make the MySQL query not behave as expected? <? $regexp = mysql_real_escape_string(…

C:\Users\Me>easy_install MySQL-python Searching for MySQL-python Reading [http://pypi.python.org/simple/MySQL-python/ Reading…

Is it preferred to create tables in mysql using a third party application (phpmyadmin, TOAD, etc...) instead of php? The end result is the same, I…

My father has a small business and asked me to make him a quick program to help automate several of his daily tasks. Due to the nature of these…

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…

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…

I installed XAMPP in my pc and start run the XAMPP Control Panel Application. The FileZilla is automatically running but Apache and MySql is not…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I'm currently experiencing a weird problem with one of my MySQL database servers: It stopped asking for passwords when I try to access the database…

I'm going to create a php web application using mysql for a business in the future and I want to know what sort of server specs do I need? I will be…

If an account kept inactive for 45 days that account should be deleted automatically. How to perform this? Do the following function old_date+45…

enter code here def pacman(self): while True: while True: try: x1=self.sockfd.recv(2048) print x1 print "\n hi" conn.begin() x.execute("UPDATE…