Questions tagged [mysql]

25

votes

13

answers

Move node in nested set

asked 2009-05-20T18:37:08.253

10

votes

12

answers

How to detect if a user has logged out, in php?

php mysql session http-redirect logout

asked 2009-05-20T13:32:11.210

128

votes

20

answers

How to escape single quotes in MySQL?

mysql database string escaping quotes

asked 2009-05-20T09:28:53.710

9

votes

1

answers

Troubleshooting consistent "SQLException: Lock wait timeout exceeded"

mysql jdbc transactions locking quartz-scheduler

asked 2009-05-19T09:31:38.363

98

votes

5

answers

Is closing the mysql connection important?

php mysql

asked 2009-05-19T03:48:22.850

10

votes

4

answers

How to compare MySQL database schemas

mysql schema

asked 2009-05-18T08:30:27.487

59

votes

1

answers

Create an ActiveRecord database table with no :id column?

mysql ruby-on-rails ruby security activerecord

asked 2009-05-17T13:36:32.800

13

votes

5

answers

Why are UNION queries so slow in MySQL?

mysql query-optimization union

asked 2009-05-15T17:59:01.887

9

votes

2

answers

MySQL on duplicate key update

mysql duplicates

asked 2009-05-15T06:01:33.327

18

votes

4

answers

Is using mysql ENUM a bad architectural solution?

mysql architecture

asked 2009-05-14T15:49:07.370

86

votes

9

answers

How do you select every n-th row from mysql

mysql

asked 2009-05-13T15:49:09.583

752

votes

29

answers

Find duplicate records in MySQL

mysql duplicates

asked 2009-05-12T18:24:21.757

126

votes

18

answers

Problems with contenttypes when loading a fixture in Django

mysql django django-models fixtures mysql-error-1062

asked 2009-05-12T17:02:15.337

14

votes

8

answers

What's the most efficient way to insert thousands of records into a table (MySQL, Python, Django)

python sql mysql django insert

asked 2009-05-11T21:13:26.747

16

votes

2

answers

Conditional column for query based on other columns in MySQL

mysql database syntax conditional-statements

asked 2009-05-11T18:15:57.083

33

votes

6

answers

Mysql: How to query a column whose type is bit?

mysql select bit

asked 2009-05-08T12:34:31.183

29

votes

8

answers

How to search and replace all instances of a string within a database?

mysql database wordpress replace

asked 2009-05-07T17:47:32.680

20

votes

6

answers

php connection pooling mysql

php mysql connection connection-pooling

asked 2009-05-06T17:09:56.430

18

votes

8

answers

MySQL change type of foreign key

sql mysql foreign-keys

asked 2009-05-06T14:37:31.177

26

votes

11

answers

How to automate migration (schema and data) for PHP/MySQL application

php mysql deployment migration

asked 2009-05-05T16:35:16.253

41

votes

3

answers

MySQL timestamp only on create

mysql timestamp

asked 2009-05-03T16:09:04.243

22

votes

7

answers

How do I add more than one row with Zend_Db?

php mysql zend-framework zend-db zend-db-table

asked 2009-05-03T12:17:45.783

63

votes

14

answers

Faster way to delete matching rows?

mysql performance sql-delete sql-execution-plan

asked 2009-05-01T18:12:09.083

91

votes

5

answers

MySQL - ignore insert error: duplicate entry

php mysql insert

asked 2009-05-01T17:48:05.973

60

votes

13

answers

Singular or plural database table names?

sql mysql sql-server

asked 2009-04-30T20:50:08.430

303

votes

9

answers

How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?

mysql foreign-keys

asked 2009-04-30T13:45:47.953

191

votes

5

answers

UPDATE multiple tables in MySQL using LEFT JOIN

mysql sql-update

asked 2009-04-30T13:25:00.327

19

votes

5

answers

How to count and limit record in a single query in MYSQL?

php mysql count

asked 2009-04-29T13:31:33.533

43

votes

9

answers

Does the order of tables referenced in the ON clause of the JOIN matter?

sql mysql sql-server oracle-database

asked 2009-04-24T12:09:18.763

137

votes

14

answers

How to insert multiple rows from array using CodeIgniter framework?

php mysql codeigniter insert bulkinsert

asked 2009-04-23T01:39:06.257

95

votes

7

answers

MySQL parameterized queries

python mysql bind-variables

asked 2009-04-22T00:43:21.360

40

votes

6

answers

Switching from MySQL to PostgreSQL - tips, tricks and gotchas?

mysql postgresql migration load-data-infile

asked 2009-04-21T11:18:24.993

52

votes

2

answers

MySQL - Duplicate table

mysql

asked 2009-04-20T04:49:24.233

64

votes

4

answers

MySQL Enum performance advantage?

mysql enums

asked 2009-04-19T22:52:05.420

29

votes

2

answers

How do I get time from a datetime.timedelta object?

python mysql timedelta

asked 2009-04-18T20:55:48.703

10

votes

3

answers

Are MySQL Triggers Asynchronous

mysql triggers

asked 2009-04-17T17:47:28.820

10

votes

5

answers

MYSQL: Can you pull results that match like 3 out of 4 expressions?

mysql

asked 2009-04-17T15:59:37.003

11

votes

2

answers

Why does the cardinality of an index in MySQL remain unchanged when I add a new index?

mysql indexing full-text-search cardinality

asked 2009-04-16T10:43:45.237

104

votes

4

answers

MySQL Join Where Not Exists

mysql join not-exists

asked 2009-04-15T04:45:32.743

24

votes

5

answers

Using SQL to determine word count stats of a text field

mysql sql text-processing word-count

asked 2009-04-14T16:01:55.357

9

votes

5

answers

Naive bayes calculation in sql

sql mysql machine-learning nlp bayesian

asked 2009-04-13T15:21:14.603

9

votes

3

answers

Store GUID in MySQL from C#

c# mysql

asked 2009-04-12T17:47:25.837

163

votes

17

answers

Reorder / reset auto increment primary key

mysql database

asked 2009-04-11T16:11:39.117

330

votes

9

answers

Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?

mysql postgresql full-text-search lucene sphinx

asked 2009-04-10T10:38:14.153

10

votes

4

answers

delete rows from multiple tables

mysql delete-row sql-delete

asked 2009-04-09T14:50:43.880

12

votes

3

answers

mysql + update top n

mysql sql sql-update

asked 2009-04-07T15:40:12.840

22

votes

7

answers

Clear data in MySQL table with PHP?

php mysql

asked 2009-04-07T14:20:56.073

19

votes

7

answers

Empty database in MySQL and PHP?

php mysql

asked 2009-04-07T13:59:44.767

24

votes

4

answers

Extra Fields with SQL MIN() & GROUP BY

sql mysql aggregate-functions

asked 2009-04-06T20:22:17.523

17

votes

4

answers

How do you safely and efficiently get the row id after an insert with mysql using MySQLdb in python?

python mysql

asked 2009-04-01T18:14:27.770

Questions tagged mysql