Questions tagged [mysql]

15

votes

3

answers

varchar(255) v tinyblob v tinytext

sql mysql database-design

asked 2008-09-27T16:20:01.270

129

votes

10

answers

Comparing date ranges

sql mysql date

asked 2008-09-27T12:29:18.813

481

votes

18

answers

Convert from MySQL datetime to another format with PHP

php mysql datetime

asked 2008-09-25T23:10:30.203

9

votes

6

answers

SQL Command for copying table

sql mysql

asked 2008-09-25T07:00:17.540

47

votes

11

answers

Is there something wrong with joins that don't use the JOIN keyword in SQL or MySQL?

sql mysql join

asked 2008-09-24T18:36:12.320

37

votes

6

answers

View grants in MySQL

mysql

asked 2008-09-24T14:58:55.633

15

votes

5

answers

Change database files location in MySQL administrator?

mysql

asked 2008-09-24T10:32:45.947

71

votes

19

answers

Can't connect to MySQL server on 'localhost' (10061)

mysql localhost mysql5 windows-firewall

asked 2008-09-23T03:52:34.090

10

votes

3

answers

MySQL InnoDB database restore

mysql backup innodb restore

asked 2008-09-22T15:49:22.957

700

votes

19

answers

How do I restore a dump file from mysqldump?

mysql sql database

asked 2008-09-19T21:27:00.673

9

votes

3

answers

What happens if MySQL connections continually aren't closed on PHP pages?

php mysql

asked 2008-09-19T16:05:43.580

10

votes

4

answers

The ultimate MySQL legacy database nightmare

mysql database refactoring binary-log

asked 2008-09-19T12:06:30.943

42

votes

13

answers

What is the SQL command to return the field names of a table?

sql mysql sql-server database

asked 2008-09-19T08:33:25.020

79

votes

13

answers

How does one create an index on the date part of DATETIME field in MySql

mysql

asked 2008-09-18T18:15:25.160

29

votes

10

answers

Is there a simple tool to convert mysql to postgresql syntax?

mysql database postgresql

asked 2008-09-18T12:24:45.673

9

votes

5

answers

How do I restore from a drop database command using a mysql binary log?

mysql database recovery

asked 2008-09-17T23:59:56.667

9

votes

3

answers

MySQL tools which ease creation of SQL JOIN statements?

sql mysql

asked 2008-09-17T12:56:24.217

62

votes

13

answers

Select data from "show tables" MySQL query

mysql sql metadata

asked 2008-09-15T17:24:54.340

12

votes

4

answers

MySQL: "lock wait timeout exceeded"

mysql database

asked 2008-09-15T16:53:54.787

9

votes

3

answers

MySQL Interview Questions

mysql

asked 2008-09-15T09:58:36.127

15

votes

4

answers

Best tool for synchronizing MySQL databases

mysql synchronization

asked 2008-09-09T18:48:21.413

15

votes

1

answers

PHP + MySql + Stored Procedures, how do I get access an "out" value?

php mysql stored-procedures mysqli

asked 2008-09-07T04:06:34.137

10

votes

4

answers

Setting Up MySQL Triggers

mysql triggers

asked 2008-09-06T11:24:53.000

137

votes

8

answers

Show all triggers in a MySQL database

sql mysql database triggers sqlcommand

asked 2008-09-06T10:02:26.770

50

votes

8

answers

MySQL Partitioning / Sharding / Splitting - which way to go?

mysql partitioning database-performance sharding

asked 2008-09-05T13:59:07.663

860

votes

18

answers

MySQL Error 1093 - Can't specify target table for update in FROM clause

mysql subquery sql-delete mysql-error-1093

asked 2008-09-05T10:03:46.590

17

votes

10

answers

How do you manage SQL Queries

php sql mysql

asked 2008-09-01T11:38:36.773

15

votes

10

answers

Migrating database changes from development to live

php mysql schema migration

asked 2008-08-29T19:02:34.170

11

votes

6

answers

WordPress MediaWiki integration

php mysql wordpress lamp mediawiki

asked 2008-08-29T01:15:24.593

13

votes

4

answers

Does Visual Studio Server Explorer support custom database providers?

c# mysql visual-studio oracle-database sqlite

asked 2008-08-28T09:09:58.983

12

votes

3

answers

MySQL Results to a File

mysql database

asked 2008-08-27T18:48:04.970

10

votes

6

answers

How to select posts with specific tags/categories in WordPress

php mysql sql wordpress plugins

asked 2008-08-26T14:29:38.093

167

votes

5

answers

SQL Group By with an Order By

mysql sql mysql-error-1111

asked 2008-08-26T13:09:15.883

102

votes

10

answers

How can I specify a MySQL ENUM type field in a Django model?

python mysql django django-models enums

asked 2008-08-21T23:48:08.777

893

votes

25

answers

MyISAM versus InnoDB

mysql database performance innodb myisam

asked 2008-08-21T14:50:52.780

266

votes

17

answers

Quick easy way to migrate SQLite3 to MySQL?

mysql sqlite migration

asked 2008-08-20T19:49:13.337

15

votes

3

answers

How do I display database query statistics on Wordpress site?

mysql performance wordpress layout statistics

asked 2008-08-18T16:33:58.870

342

votes

13

answers

mysqli or PDO - what are the pros and cons?

php mysql pdo mysqli database-abstraction

asked 2008-08-17T09:47:22.610

10

votes

7

answers

How do I get PHP and MySQL working on IIS 7.0?

php mysql iis-7

asked 2008-08-15T03:05:13.273

150

votes

12

answers

Differences between MySQL and SQL Server

mysql sql-server t-sql

asked 2008-08-14T03:13:26.633

10

votes

2

answers

MySQL replication for fallback scenario

mysql replication fallback binary-log

asked 2008-08-11T19:12:33.920

189

votes

15

answers

How do you manage databases in development, test, and production?

mysql svn

asked 2008-08-08T20:50:02.930

21

votes

8

answers

How do I Concatenate entire result sets in MySQL?

mysql sql union

asked 2008-08-06T18:47:24.137

454

votes

21

answers

Multiple Updates in MySQL

mysql sql sql-update

asked 2008-08-06T14:12:09.903

29

votes

11

answers

MySQL/Apache Error in PHP MySQL query

php mysql apache

asked 2008-08-05T21:45:11.033

22

votes

11

answers

What do I need to escape when sending a query?

mysql oracle-database security

asked 2008-08-05T18:45:46.747

359

votes

14

answers

Auto Generate Database Diagram MySQL

mysql database database-design diagram

asked 2008-08-05T15:45:02.930

345

votes

15

answers

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

mysql database database-performance

asked 2008-08-04T14:31:11.410

88

votes

4

answers

SQL Server 2005 implementation of MySQL REPLACE INTO?

mysql sql-server sql-server-2005

asked 2008-08-01T22:13:34.100

Questions tagged mysql