Questions tagged [mysql]

30

votes

4

answers

MySQL - SELECT AS in WHERE

mysql sql select

asked 2013-01-19T11:30:14.270

10

votes

2

answers

On RDS can I create Tables in a Read Replica that are not present on the Master?

mysql master-slave rds

asked 2013-01-18T18:20:55.817

22

votes

1

answers

Checking if a date is within 7 days of the current time

php mysql date

asked 2013-01-16T23:53:03.530

13

votes

3

answers

Extend MySQL implementation of PiP Algorithm?

php mysql raycasting point-in-polygon

asked 2013-01-16T17:40:37.053

8

votes

1

answers

Doctrine2 generates two extra tables for a ManyToMany relationship

php mysql symfony doctrine-orm

asked 2013-01-15T11:09:20.060

129

votes

6

answers

MySQL Error 1264: out of range value for column

mysql sql insert integer

asked 2013-01-11T18:33:09.523

15

votes

4

answers

SELECT id HAVING maximum count of id

mysql sql select group-by having-clause

asked 2013-01-10T01:57:48.647

10

votes

5

answers

MySQL NOT IN from another column in the same table

mysql sql

asked 2013-01-09T20:15:13.123

8

votes

5

answers

MySQL: insert values from another table into one column

mysql

asked 2013-01-09T00:44:55.970

9

votes

5

answers

update query sometimes does not update field in mySQL database

mysql innodb

asked 2013-01-08T22:57:47.007

9

votes

3

answers

How to calculate aggregate function SUM on an alias column?

mysql sql

asked 2013-01-08T15:07:23.687

14

votes

2

answers

Warning#1264:out of range error in mysql

mysql decimal

asked 2013-01-08T14:05:05.917

8

votes

2

answers

MySQL - JOIN only if a row exists from the left table

mysql select join group-by

asked 2013-01-06T13:31:28.190

48

votes

5

answers

Sequelize.js foreign key

mysql node.js orm sequelize.js

asked 2013-01-05T07:26:02.153

17

votes

3

answers

MySQL WHERE NOT IN extremely slow

mysql sql query-optimization

asked 2013-01-05T02:02:53.737

8

votes

3

answers

return value 'no row' if max query return a NULL

mysql null max

asked 2013-01-04T09:09:19.417

14

votes

7

answers

MySQL REGEXP query - accent insensitive search

mysql regex diacritics accent-insensitive

asked 2013-01-03T10:43:58.103

180

votes

5

answers

MySQL SELECT WHERE datetime matches day (and not necessarily time)

mysql date select

asked 2012-12-31T17:19:14.417

9

votes

3

answers

JSON parsing issue not resolved

java php android mysql json

asked 2012-12-31T10:02:13.070

21

votes

6

answers

mysql new user access denied

mysql

asked 2012-12-31T06:23:19.553

9

votes

7

answers

Xampp Won't Startup MySQL server on Mac OSX?

mysql macos osx-lion xampp

asked 2012-12-31T04:22:47.083

25

votes

3

answers

How to delete a MySQL record after a certain time

mysql

asked 2012-12-31T01:12:06.640

41

votes

3

answers

MySQL InnoDB: autoincrement non-primary key

mysql primary-key innodb

asked 2012-12-29T22:02:46.277

21

votes

1

answers

Sorting a subtree in a closure table hierarchical-data structure

mysql hierarchical-data transitive-closure-table

asked 2012-12-28T12:36:19.393

16

votes

6

answers

Must database primary keys be integers?

mysql primary-key

asked 2012-12-27T18:52:19.793

20

votes

3

answers

Is there any way I can execute a PHP script from MySQL?

php mysql

asked 2012-12-26T11:54:37.103

8

votes

4

answers

How do I move a MySQL database from one hard drive to another?

mysql mysql-workbench

asked 2012-12-24T21:58:55.253

22

votes

3

answers

How to Alter a stored procedure in mysql

mysql

asked 2012-12-20T10:39:05.247

31

votes

7

answers

How to Avoid Lock wait timeout exceeded exception.?

java mysql hibernate

asked 2012-12-20T06:25:15.483

9

votes

4

answers

Mysql Error: #1075

mysql sql mysql-error-1075

asked 2012-12-19T23:33:43.983

10

votes

3

answers

Complicated mySQL Query Order By

mysql

asked 2012-12-19T22:36:21.630

10

votes

1

answers

Mysql vs Oracle XE vs Postgresql . Scalability and performance, which to chose?

mysql oracle-database postgresql database-performance

asked 2012-12-19T12:08:21.847

983

votes

4

answers

TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes

mysql innodb

asked 2012-12-18T12:13:35.297

17

votes

2

answers

Use specific mysql index with rails

mysql ruby-on-rails ruby activerecord

asked 2012-12-16T18:03:46.387

14

votes

4

answers

Order by datetime mysql

mysql datetime sql-order-by

asked 2012-12-16T08:32:04.773

12

votes

4

answers

How can I make two condition in having clause

mysql

asked 2012-12-15T22:40:03.740

14

votes

1

answers

SQLAlchemy blocked on dropping tables

python mysql sqlalchemy

asked 2012-12-14T16:15:20.390

10

votes

4

answers

Autorunning Query in mysql

mysql automation mysql-event

asked 2012-12-14T04:21:25.867

22

votes

4

answers

Why INNER JOIN not equal (!=) hang forever

mysql database

asked 2012-12-13T16:05:13.770

14

votes

2

answers

Store query in array in bash

mysql linux bash

asked 2012-12-12T16:12:30.683

16

votes

4

answers

How do I use a LIKE clause in a PDO prepared statement?

php mysql pdo

asked 2012-12-12T04:44:09.417

8

votes

3

answers

Any way to check if someone has closed their browser using Javascript/PHP?

php javascript mysql

asked 2012-12-08T08:48:52.387

11

votes

2

answers

Assign query results to MySQL variable

mysql sql variables mysql-error-1193

asked 2012-12-06T05:00:31.513

16

votes

7

answers

Surpassing MySQL's TIME value limit of 838:59:59

mysql time sum

asked 2012-12-05T21:54:21.457

154

votes

26

answers

phpmyadmin logs out after 1440 secs

mysql django phpmyadmin timeout logout

asked 2012-12-04T07:12:32.387

9

votes

2

answers

PDO and MySQL Fulltext searches

php mysql pdo full-text-search

asked 2012-12-03T11:32:15.033

9

votes

2

answers

Select query using IN() and without any sorting

mysql sql sorting sql-order-by

asked 2012-12-01T08:45:33.200

8

votes

4

answers

What does this preg_replace do? (/[\xF0-\xF7].../)

php mysql regex utf-8 sql-injection

asked 2012-11-30T23:02:48.860

123

votes

11

answers

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\xBD\xF0\x9F...'

java mysql encoding character-encoding sqlexception

asked 2012-11-30T21:51:41.213

40

votes

2

answers

How to disable triggers in MySQL?

mysql database-trigger

asked 2012-11-28T05:02:19.670

Questions tagged mysql