Questions tagged [mysql]

25

votes

6

answers

MySqlCommand Command.Parameters.Add is obsolete

asked 2012-11-27T09:24:39.513

19

votes

6

answers

Adding only one value to the table in sql

mysql database

asked 2012-11-26T20:26:52.593

32

votes

3

answers

How to export MySQL schema with data?

mysql

asked 2012-11-26T14:20:24.720

8

votes

2

answers

Why is MySQL in Node.js so slow?

mysql node.js node-mysql

asked 2012-11-26T10:01:50.497

33

votes

4

answers

Concat a string to SELECT * MySql

mysql sql string concatenation

asked 2012-11-25T12:33:42.147

24

votes

5

answers

How to add ROW INDEX as a column to SQL SELECT query?

mysql sql

asked 2012-11-25T11:53:00.247

34

votes

4

answers

How to convert a column of type TEXT to VARCHAR?

mysql

asked 2012-11-23T14:39:29.700

32

votes

2

answers

Regex str_replace

php mysql regex url str-replace

asked 2012-11-23T11:38:07.797

10

votes

2

answers

Foreign keys for myISAM and InnoDB tables

mysql innodb

asked 2012-11-22T00:12:02.640

18

votes

2

answers

Database design for comments and replies

mysql database database-design one-to-many

asked 2012-11-21T09:57:21.500

18

votes

4

answers

Mysql : how to calculate business hrs between two timestamps and neglect weekends

mysql sql date

asked 2012-11-17T00:01:40.180

14

votes

1

answers

MySQL - Query combine rows with same id and keep all entry for that id but as one record

mysql sql phpmyadmin wampserver

asked 2012-11-16T18:38:58.203

32

votes

2

answers

why varbinary instead of varchar

mysql sql sql-server database database-design

asked 2012-11-15T08:20:14.613

11

votes

3

answers

Cannot connect to MySQL - host not allowed

mysql

asked 2012-11-14T12:09:25.520

47

votes

7

answers

how to set length of an column in hibernate with maximum length

java mysql hibernate

asked 2012-11-13T15:50:42.473

12

votes

3

answers

SqlAlchemy: filter to match all instead of any values in list?

python mysql sql sqlalchemy

asked 2012-11-12T19:03:14.207

10

votes

1

answers

MySQL temporary variable assignment

mysql stored-procedures

asked 2012-11-08T05:47:13.590

57

votes

1

answers

Mysql tmp_table_size max_heap_table_size

mysql

asked 2012-11-06T20:56:52.670

21

votes

3

answers

How to convert string into a decimal?

mysql ruby-on-rails ruby

asked 2012-11-06T06:07:31.517

36

votes

4

answers

utf8 garbled when importing into mysql

mysql utf-8

asked 2012-11-05T14:45:24.167

14

votes

4

answers

I need my PHP page to show my BLOB image from mysql database

php mysql image blob mime

asked 2012-11-05T03:58:47.207

128

votes

10

answers

Empty IN clause parameter list in MySQL

mysql sql in-clause

asked 2012-11-03T14:51:04.737

8

votes

2

answers

Invalid use of group function while updating a table with sum function

mysql sql sql-update

asked 2012-11-03T07:37:51.817

12

votes

5

answers

get number of rows with pdo

mysql pdo rows

asked 2012-11-02T13:13:19.207

11

votes

6

answers

PHP and MySQL smallest and largest possible date

php mysql date

asked 2012-11-01T14:10:51.560

15

votes

4

answers

utf8 encoding in Perl and MySql

mysql perl utf-8

asked 2012-10-31T10:03:01.620

29

votes

2

answers

Figure out if a table has a DELETE on CASCADE

mysql database cascading-deletes

asked 2012-10-30T08:07:35.713

8

votes

2

answers

How to handle database crashes (Glassfish/MySQL)?

java mysql exception glassfish

asked 2012-10-26T11:18:35.587

8

votes

4

answers

How to retry transaction after a deadlock using Doctrine?

php mysql database doctrine-orm deadlock

asked 2012-10-25T13:08:42.883

9

votes

2

answers

In MySQL, how to build index to speed up this query?

mysql indexing database-performance

asked 2012-10-24T14:24:54.033

70

votes

9

answers

restart mysql server on windows 7

mysql windows

asked 2012-10-19T10:33:24.367

22

votes

1

answers

How to estimate SQL query timing?

mysql query-optimization timing estimation time-estimation

asked 2012-10-16T23:49:06.613

20

votes

1

answers

Python mySQL - escaping quotes

python mysql mysql-python

asked 2012-10-15T19:43:51.693

35

votes

3

answers

MYSQL LOAD DATA INFILE ignore duplicate rows (autoincrement as primary key)

mysql csv load-data-infile

asked 2012-10-15T07:51:08.993

22

votes

3

answers

MySQL LOAD DATA LOCAL INFILE Python

python mysql

asked 2012-10-15T06:02:49.387

105

votes

1

answers

Get total number of rows when using LIMIT?

mysql

asked 2012-10-14T22:41:59.833

16

votes

4

answers

How can I get the autoincremented id when I insert a record in a table via jdbctemplate

java mysql spring-mvc jdbctemplate

asked 2012-10-14T13:54:55.057

23

votes

7

answers

MySQL is not allowing ON UPDATE CURRENT_TIMESTAMP for a DATETIME field

mysql datetime timestamp

asked 2012-10-14T13:25:31.080

11

votes

5

answers

How to integrate "Did you mean" functionality in rails?

mysql ruby-on-rails full-text-search search-engine

asked 2012-10-12T10:15:05.657

15

votes

10

answers

Why in SQL NULL can't match with NULL?

mysql sql sql-server oracle-database null

asked 2012-10-12T07:06:52.490

14

votes

1

answers

How to store 800 billion GPS markers in database

mysql database database-design gps nosql

asked 2012-10-10T18:19:16.113

11

votes

5

answers

Error 1148 MySQL The used command is not allowed with this MySQL version

php mysql load-data-infile

asked 2012-10-10T12:13:35.373

34

votes

3

answers

MySQL TINYINT as unsigned

mysql unsigned

asked 2012-10-10T05:14:24.050

8

votes

1

answers

MySQL Script with rollback on error

mysql transactions

asked 2012-10-09T14:02:38.110

21

votes

5

answers

How to make SQL query more readable in PHP?

php mysql readability code-readability

asked 2012-10-08T14:00:37.700

22

votes

2

answers

What are implications to using "date" as a MySQL column name?

mysql database-design database-schema

asked 2012-10-08T05:14:37.983

20

votes

2

answers

How to convert latin1_swedish_ci data into utf8_general_ci?

php mysql character-encoding

asked 2012-10-06T05:00:28.543

115

votes

3

answers

MySQL update CASE WHEN/THEN/ELSE

mysql

asked 2012-10-05T21:44:48.000

9

votes

4

answers

Constraint detail from information_schema (on update cascade, on delete restrict)

mysql foreign-keys constraints information-schema

asked 2012-10-04T19:18:46.217

17

votes

4

answers

How To Left Join 2 Tables On 2 Different Databases?

mysql sql

asked 2012-10-02T05:56:00.180

Questions tagged mysql