Top "Mysql" questions

PHP mySQL - Insert new record into table with auto-increment on primary key

Wondering if there is a shorthand version to insert a new record into a table that has the primary key …

php mysql insert auto-increment

Capitalize first letter. MySQL

Does any one know the equivalent to this TSQL in MySQL parlance? I am trying to capitalize the first letter …

mysql string capitalize

On duplicate key ignore?

I'm trying to finish this query; my tag field is set to UNIQUE and I simply want the database to …

mysql

MySQL SELECT DISTINCT multiple columns

Let's say I have columns a, b c, d in a table in a MySQL database. What I'm trying to …

mysql sql distinct

How to connect to a MySQL Data Source in Visual Studio

I use the MySQL Connector/Net to connect to my database by referencing the assembly (MySql.Data.dll) and passing …

mysql visual-studio-2010 datasource mysql-connector

mysqldump exports only one table

I was using mysqldump to export the database, like this: mysqldump -u root -ppassword my_database > c:\temp\my_…

mysql innodb mysqldump

Windows: XAMPP vs WampServer vs EasyPHP vs alternative

There was a similar question asked here three years ago, but I want to open it up further to include …

php mysql windows apache wamp

Project Links do not work on Wamp Server

I am installing the Wamp Server on another computer to run a mid-sized database and UI. I have been successful …

php mysql apache wamp wampserver

Case statement in MySQL

I have a database table called 'tbl_transaction' with the following definition: id INT(11) Primary Key action_type ENUM('Expense', …

mysql sql database case

How big can a MySQL database get before performance starts to degrade

At what point does a MySQL database start to lose performance? Does physical database size matter? Do number of records …

mysql database database-performance