Questions tagged [mysql]

21

votes

8

answers

Best practices for optimizing LAMP sites for speed?

asked 2009-03-30T15:56:22.920

49

votes

6

answers

Stored Procedure with optional "WHERE" parameters

sql mysql sql-server oracle-database

asked 2009-03-30T15:21:42.347

70

votes

9

answers

MySQL: Many tables or many databases?

mysql performance

asked 2009-03-30T10:22:44.097

40

votes

4

answers

Create if an entry if it doesn't exist, otherwise update?

mysql

asked 2009-03-30T06:33:40.293

10

votes

3

answers

Php on zend, how to escape a variable for a query?

php mysql zend-framework sql-injection

asked 2009-03-28T18:30:51.647

44

votes

5

answers

MySQL query to extract first word from a field

php sql mysql

asked 2009-03-27T13:58:13.493

15

votes

4

answers

Find overlapping (date/time) rows within one table

mysql

asked 2009-03-27T11:49:51.867

12

votes

5

answers

How can we rename the database name in MySQL 5.0

mysql

asked 2009-03-27T11:46:54.947

9

votes

2

answers

mysqldb on python 2.6+ (win32)

python mysql

asked 2009-03-26T13:45:56.183

16

votes

8

answers

Python and MySQL: is there an alternative to MySQLdb?

python mysql database

asked 2009-03-24T15:04:09.817

18

votes

5

answers

Are you allowed to use numbers as table names in MySQL?

mysql

asked 2009-03-24T07:38:56.830

269

votes

16

answers

MySQL: Cloning a MySQL database on the same MySql instance

mysql database copy clone

asked 2009-03-23T21:24:51.860

13

votes

5

answers

Application to reverse engineer MySQL & PostgreSQL DB?

mysql postgresql reverse-engineering

asked 2009-03-22T02:35:55.453

11

votes

3

answers

How to create an identical gzip of the same file?

version-control binary compression diff mysql

asked 2009-03-20T18:32:51.723

159

votes

4

answers

MySQL Results as comma separated list

sql mysql concatenation

asked 2009-03-19T13:31:10.887

170

votes

23

answers

Find the number of columns in a table

sql mysql

asked 2009-03-18T14:10:05.747

88

votes

6

answers

Search for "whole word match" in MySQL

mysql sql full-text-search

asked 2009-03-18T04:20:15.557

30

votes

6

answers

Optimizing MySQL for ALTER TABLE of InnoDB

mysql alter-table performance

asked 2009-03-17T14:56:59.223

16

votes

3

answers

MySQL error: "Column 'columnname' cannot be part of FULLTEXT index"

mysql character-encoding full-text-search

asked 2009-03-17T05:14:05.707

28

votes

7

answers

How to pivot a MySQL entity-attribute-value schema

mysql database-design pivot entity-attribute-value

asked 2009-03-16T09:58:21.257

102

votes

16

answers

Integrating MySQL with Python in Windows

python mysql windows

asked 2009-03-14T13:53:28.807

9

votes

4

answers

SQL - find next and previous rows given a particular WHERE clause

sql mysql

asked 2009-03-14T00:50:46.197

133

votes

7

answers

How to find duplicates in 2 columns not 1

mysql duplicates

asked 2009-03-13T13:18:10.857

17

votes

2

answers

What's the best way to deprecate a column in a database schema?

sql mysql database

asked 2009-03-13T09:55:28.567

14

votes

4

answers

SQL syntax error when creating a stored procedure in MySQL

mysql stored-procedures

asked 2009-03-12T15:14:06.823

52

votes

9

answers

Implementation of Levenshtein distance for mysql/fuzzy search?

mysql database algorithm search levenshtein-distance

asked 2009-03-11T15:15:08.170

26

votes

3

answers

Does the space occupied by deleted rows get re-used?

mysql database size innodb rows

asked 2009-03-11T12:11:40.967

10

votes

5

answers

How to use a temp column in the where clause

mysql sql mysql-error-1054

asked 2009-03-10T15:37:45.300

920

votes

22

answers

How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?

mysql sql max distinct greatest-n-per-group

asked 2009-03-04T20:14:26.573

34

votes

8

answers

Backup MySQL users

mysql database database-design migration backup

asked 2009-02-28T08:09:07.897

61

votes

9

answers

Best practices for storing bank information in a database

php mysql mcrypt

asked 2009-02-27T21:11:44.403

23

votes

6

answers

Is there way to match IP with IP+CIDR straight from SELECT query?

mysql ip mask bitmask cidr

asked 2009-02-27T17:28:44.080

40

votes

7

answers

Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?

mysql database keyword ansi-sql

asked 2009-02-27T15:04:26.940

72

votes

5

answers

MySQL not using indexes with WHERE IN clause?

sql mysql ruby-on-rails database optimization

asked 2009-02-25T15:14:02.457

79

votes

10

answers

MySQL vs PostgreSQL? Which should I choose for my Django project?

mysql django database postgresql django-migrations

asked 2009-02-25T10:52:11.650

11

votes

15

answers

Fast Loading web pages

php javascript mysql ajax

asked 2009-02-25T06:06:01.540

637

votes

13

answers

How can I view live MySQL queries?

mysql monitoring

asked 2009-02-20T06:54:18.763

14

votes

10

answers

How many MySQL queries should I limit myself to on a page? PHP / MySQL

php mysql performance

asked 2009-02-18T16:45:16.177

50

votes

2

answers

MYSQL: Index keyword in create table and when to use it

mysql

asked 2009-02-18T15:16:09.777

34

votes

2

answers

Using LIKE vs. = for exact string match

mysql string performance

asked 2009-02-18T01:32:32.330

10

votes

19

answers

Optimize SQL that uses between clause

sql mysql query-optimization

asked 2009-02-17T15:41:25.090

978

votes

12

answers

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

mysql insert

asked 2009-02-14T05:24:06.610

48

votes

9

answers

How can I manipulate MySQL fulltext search relevance to make one field more 'valuable' than another?

mysql search indexing full-text-search relevance

asked 2009-02-13T20:26:32.860

67

votes

9

answers

MySQL - Control which row is returned by a group by

mysql sql-order-by group-by

asked 2009-02-11T15:06:39.887

10

votes

4

answers

Using MySQL views in a Ruby on Rails app to improve performance

mysql ruby-on-rails ruby performance

asked 2009-02-09T21:40:08.373

32

votes

16

answers

PHP to store images in MySQL or not?

php mysql image

asked 2009-02-09T11:33:16.350

318

votes

4

answers

Order a MySQL table by two columns

mysql sql-order-by

asked 2009-02-05T07:49:49.053

58

votes

8

answers

"SELECT COUNT(*)" is slow, even with where clause

mysql performance optimization

asked 2009-02-04T15:25:50.053

19

votes

7

answers

Selecting a database in mysql with spaces in its name

mysql database console spaces

asked 2009-02-03T11:57:05.250

9

votes

2

answers

How can I get every n rows in MySQL?

php mysql mysqli

asked 2009-02-02T10:49:45.043

Questions tagged mysql