Questions tagged [mysql]

32

votes

10

answers

Search a whole table in mySQL for a string

mysql sql search

asked 2012-08-13T18:01:40.620

8

votes

4

answers

Hibernate native query with multiple joins on same table returning wrong results

mysql hibernate join nativequery

asked 2012-08-13T07:11:30.323

22

votes

3

answers

MySQL find invalid foreign keys

mysql foreign-keys

asked 2012-08-10T18:12:02.593

17

votes

2

answers

How do I get the first date of a quarter in MySQL?

mysql date

asked 2012-08-09T13:32:54.110

14

votes

4

answers

Should password hash be stored in binary or hexadecimal number?

php mysql security hash passwords

asked 2012-08-08T18:44:07.173

9

votes

4

answers

Is it better do to a union in SQL or separate queries and then use php array_merge?

php mysql

asked 2012-08-08T16:00:15.200

9

votes

3

answers

MySQL replication not running updates in binlog

mysql sql-update replication

asked 2012-08-07T13:25:29.273

13

votes

6

answers

PHP - Insert date into mysql

php mysql date insert format

asked 2012-08-06T11:14:05.673

68

votes

15

answers

PHP Fatal error: Class 'PDO' not found

php mysql cakephp web-applications

asked 2012-08-05T01:52:49.277

29

votes

2

answers

database-design: table of likes?

mysql database postgresql database-design

asked 2012-08-04T12:28:16.930

206

votes

10

answers

SQL order string as number

sql mysql sql-order-by

asked 2012-08-04T12:12:58.657

12

votes

6

answers

PHP MySQL Greek letters showing like ???? marks

php mysql character-encoding

asked 2012-08-04T05:54:42.880

17

votes

4

answers

Dump sql file to ClearDB in Heroku

mysql ruby-on-rails ruby heroku

asked 2012-08-03T21:24:02.503

11

votes

4

answers

Does MySQL optimize subqueries automatically?

mysql sql

asked 2012-08-02T17:46:39.647

10

votes

1

answers

How to partition MySQL table by column that is not in the unique index

mysql partitioning unique-index

asked 2012-08-01T15:52:43.990

13

votes

3

answers

Hibernate encodes wrong while persisting objects [UTF-8]

mysql spring hibernate spring-mvc c3p0

asked 2012-08-01T11:18:54.590

35

votes

2

answers

How to figure out if mysql index fits entirely in memory

mysql sql indexing

asked 2012-07-31T20:38:35.223

334

votes

9

answers

mysql update column with value from another table

mysql sql sql-update

asked 2012-07-29T11:54:04.607

16

votes

4

answers

How to check if a table or a column exists in a database?

java mysql database

asked 2012-07-28T07:35:17.133

25

votes

15

answers

PHP MySQL Copy a row within the same table... with a Primary and Unique key

php mysql duplicates row

asked 2012-07-26T01:03:24.740

25

votes

6

answers

Eclipse - add .jar to Dynamic Web Project

java mysql servlets jar

asked 2012-07-25T14:48:16.263

9

votes

3

answers

Rails creating schema_migrations - Mysql2::Error: Specified key was too long

mysql ruby-on-rails activerecord rails-migrations

asked 2012-07-25T07:34:40.583

72

votes

13

answers

MySQL - SELECT all columns WHERE one column is DISTINCT

mysql sql

asked 2012-07-25T00:52:59.333

78

votes

9

answers

Pentaho Data Integration SQL connection

mysql pentaho

asked 2012-07-24T15:26:31.303

8

votes

3

answers

SQL error - Incorrect table definition; there can be only one auto column

mysql sql

asked 2012-07-24T12:54:10.950

8

votes

8

answers

How to export a specific column data in MySQL

mysql

asked 2012-07-24T12:42:00.563

8

votes

9

answers

MySQL workbench does not display the tables

mysql

asked 2012-07-21T13:42:21.510

8

votes

4

answers

PHP md5() gives different output then MySQL md5

php mysql md5

asked 2012-07-18T11:53:32.693

8

votes

2

answers

Securely escaping dynamic table names in MySQL using Codeigniter

php mysql security codeigniter activerecord

asked 2012-07-17T19:44:12.630

17

votes

4

answers

MYSQL - Order timestamp values ascending in order, from newest to oldest?

mysql timestamp sql-order-by

asked 2012-07-15T16:09:54.927

10

votes

1

answers

how to tell if column is primary key using mysqli?

php mysql mysqli primary-key

asked 2012-07-11T14:44:59.097

8

votes

1

answers

how to optimize mysql query : counting category and subcategory with single Query from two tables

mysql query-optimization

asked 2012-07-11T07:16:18.420

30

votes

8

answers

MySQL WHERE <multiple-column> IN <subquery>

mysql where-clause multiple-tables in-subquery

asked 2012-07-09T10:41:13.587

9

votes

1

answers

#1016 - Can't open file: './database_name/#sql-38f_36aa.frm' (errno: 24)

mysql partitioning

asked 2012-07-09T06:47:36.973

8

votes

6

answers

SQL - selecting all rows with maximum value

mysql sql greatest-n-per-group

asked 2012-07-08T08:13:28.137

9

votes

1

answers

Alias to Show Tables MySQL Result

mysql sql list

asked 2012-07-07T20:26:43.220

22

votes

4

answers

Find similar images in (pure) PHP / MySQL

php mysql image similarity

asked 2012-07-04T17:53:04.070

41

votes

7

answers

How to refresh datagrid in WPF

c# mysql wpf ado.net wpfdatagrid

asked 2012-07-04T07:51:49.203

805

votes

13

answers

When to use single quotes, double quotes, and backticks in MySQL

php sql mysql quotes

asked 2012-07-04T01:53:36.917

20

votes

5

answers

com.mysql.jdbc.PacketTooBigException

mysql blob packet

asked 2012-07-03T22:42:45.123

18

votes

3

answers

Mysql byte array storage

java mysql jdbc arrays binaryfiles

asked 2012-07-03T10:30:57.727

43

votes

3

answers

Simulate lag function in MySQL

mysql sql sliding-window

asked 2012-07-03T01:56:11.747

9

votes

4

answers

PHP - Displaying Urdu text retrieved from MySQL DB

php mysql database functional-programming

asked 2012-07-01T08:00:40.993

25

votes

6

answers

Get all mysql selected rows into an array

php mysql arrays

asked 2012-06-29T15:14:39.853

11

votes

2

answers

What's the appropriate way to test code that uses MySQL-specific queries internally

mysql maven testng embedded-database spring-jdbc

asked 2012-06-28T12:57:15.193

8

votes

1

answers

mysql - any way to help fulltext search with another index?

mysql full-text-indexing full-text-search

asked 2012-06-27T00:16:17.453

30

votes

5

answers

how to run mysql in ubuntu through terminal

mysql ubuntu

asked 2012-06-25T11:19:15.997

14

votes

2

answers

Why does MySQL's performance decrease when queries are executed in parallel?

mysql performance perl

asked 2012-06-22T16:40:07.177

8

votes

2

answers

How to efficiently query a directed acyclic graph

mysql directed-acyclic-graphs

asked 2012-06-22T08:43:33.723

8

votes

2

answers

Is it possible to make mysqldump skip the inserts for specific table?

mysql

asked 2012-06-21T15:15:45.467

Questions tagged mysql