Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

MySQL query caching: limited to a maximum cache size of 128 MB?

My application is very database intensive so I've tried really hard to make sure the application and the MySQL database …

caching mysql performance innodb
Advanced MySql Query: Update table with info from another table

I would like to update a table in mySql with data from another table. I have two tables "people" and "…

mysql sql-update
Can't get access to PHPmyAdmin after setting a root password and using Instant Rails

Wanted to get started with Ruby on Rails so I installed instant rails and set up a mysql password. Problem …

mysql ruby-on-rails phpmyadmin mysql-error-1045
MYSQL Stored Procedures: Variable Declaration and Conditional Statements

I have looked over numerous tutorials, manuals and documentations, but I still can not get this to work. I am …

mysql sql stored-procedures variable-declaration
WampServer - mysqld.exe can't start because MSVCR120.dll is missing

I've tried to run wampserver on my local side, but mysql server doesn't run. when I try to install service, …

mysql wordpress windows-7 vmware wampserver
When to close cursors using MySQLdb

I'm building a WSGI web app and I have a MySQL database. I'm using MySQLdb, which provides cursors for executing …

python mysql mysql-python
a simple way to sum a result from UNION in MySql

I have a union of three tables (t1,t2,t3). Each rerun exactly the same number of records, first column …

sql mysql union
Difference in MySQL JOIN vs LEFT JOIN

I have this cross-database query... SELECT `DM_Server`.`Jobs`.*, `DM_Server`.servers.Description AS server, digital_inventory.params, products.products_…

mysql query-optimization left-join inner-join
How do I lock read/write to MySQL tables so that I can select and then insert without other programs reading/writing to the database?

I am running many instances of a webcrawler in parallel. Each crawler selects a domain from a table, inserts that …

mysql locking web-crawler mysql-error-1093
How do I view my stored procedures in phpMyAdmin?

I created a stored procedure in phpMyAdmin CREATE PROCEDURE Sample() SELECT * FROM feedback Where could I view this this procedure? …

mysql sql stored-procedures phpmyadmin