Questions tagged [mysql]

20

votes

6

answers

How to use LOAD_FILE to load a file into a MySQL blob?

mysql mysql-loadfile

asked 2011-11-22T16:13:28.413

41

votes

4

answers

Mysql covering vs composite vs column index

mysql sql indexing covering-index composite-index

asked 2011-11-21T14:19:03.800

33

votes

2

answers

MySQL disable & enable keys

mysql sql database

asked 2011-11-21T10:53:29.233

8

votes

4

answers

How to generate random chars and insert with MySQL?

mysql sql

asked 2011-11-21T04:43:55.197

10

votes

2

answers

Storing a percentage in Rails + MySQL

mysql ruby-on-rails

asked 2011-11-20T17:27:00.047

19

votes

2

answers

MySQL: Update a full table, inserting a MD5 hash, for each row a specific one

mysql sql sql-update md5

asked 2011-11-19T19:09:31.617

72

votes

4

answers

Postgres 9.1 vs Mysql 5.6 InnoDB?

mysql postgresql

asked 2011-11-18T11:23:46.003

8

votes

7

answers

Format date in MySQL to return MonthName, Year

mysql sql datetime

asked 2011-11-17T02:04:15.650

18

votes

2

answers

REGEXP performance (compare with "LIKE" and "=")

mysql sql database

asked 2011-11-16T14:30:37.527

14

votes

1

answers

"Where" statement : contains a certain substring

mysql sql database

asked 2011-11-16T13:38:11.203

75

votes

9

answers

Pass array to MySQL stored routine

mysql arrays stored-procedures parameter-passing

asked 2011-11-16T09:45:02.240

19

votes

6

answers

Loading CSV files into MySQL Workbench

mysql excel csv mysql-workbench

asked 2011-11-15T21:04:01.040

28

votes

2

answers

Doctrine 2 with multiple indexes

mysql annotations indexing doctrine-orm

asked 2011-11-15T18:34:10.013

12

votes

3

answers

How to set the column order of a composite primary key using JPA/Hibernate

mysql hibernate jpa composite-primary-key

asked 2011-11-15T16:13:30.233

12

votes

1

answers

MySQL Update Subset Having

mysql having

asked 2011-11-14T19:55:42.003

23

votes

2

answers

mysql while loop Break equivalent

mysql stored-procedures

asked 2011-11-14T16:55:29.100

190

votes

7

answers

Implementing Comments and Likes in database

mysql database design-patterns database-design

asked 2011-11-13T16:11:08.243

19

votes

2

answers

UnpicklingError invalid load key, '{'

python mysql pickle

asked 2011-11-13T10:59:29.820

9

votes

4

answers

Connecting to a remote database through CodeIgniter

mysql codeigniter remote-access

asked 2011-11-12T20:46:08.620

8

votes

3

answers

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver during Runtime (eclipse / maven /tomcat)

mysql eclipse tomcat maven-2 jdbc

asked 2011-11-12T17:03:01.403

11

votes

2

answers

What authentication libraries for PHP are not attached to a framework and meet these requirements?

php mysql authentication

asked 2011-11-11T04:59:00.787

13

votes

6

answers

Is mysql auto increment safe to use as userID?

mysql auto-increment userid

asked 2011-11-10T11:37:47.760

13

votes

1

answers

Spawning a "Pokemon" type graph in php from MYSQL data

php mysql graph

asked 2011-11-09T17:57:45.523

8

votes

2

answers

Preventing a single query from appearing in slow query log

mysql performance logging

asked 2011-11-09T06:08:59.390

13

votes

3

answers

How to specify Ruby regex when using Active Record in Rails?

mysql ruby-on-rails regex ruby-on-rails-3 activerecord

asked 2011-11-09T02:46:03.903

38

votes

6

answers

How do I store an UTC ISO8601 date in a MySQL database?

php mysql date java-dateformat iso8601

asked 2011-11-08T08:01:23.737

10

votes

2

answers

Most efficient way of selecting thousands of rows from a list of ids

mysql

asked 2011-11-05T17:42:38.890

65

votes

11

answers

How to run command "mysqladmin flush-hosts" on Amazon RDS database server instance?

mysql amazon-rds

asked 2011-11-04T18:52:07.627

16

votes

2

answers

MySQL datatype conversion from varchar to float

mysql

asked 2011-11-04T06:02:27.723

16

votes

2

answers

What is a MySQL Server Instance?

mysql sql-server

asked 2011-11-03T23:56:33.483

27

votes

3

answers

Can you do a For Each Row loop using MySQL?

mysql

asked 2011-11-03T04:20:31.943

8

votes

1

answers

Lock table for reading and writing

php mysql

asked 2011-11-02T14:07:02.317

45

votes

8

answers

MySQL FULL JOIN?

mysql

asked 2011-11-02T07:48:43.737

14

votes

2

answers

natural key vs surrogate key an innodb foreign key

mysql database database-design foreign-keys relational-database

asked 2011-11-01T19:11:44.013

34

votes

1

answers

How can I map a Java date to DATETIME in mysql (by default its TIMESTAMP) with Hibernate annotations

java mysql hibernate annotations

asked 2011-11-01T12:18:03.793

8

votes

4

answers

How to move data between 2 tables / with different columns in different databases

mysql

asked 2011-11-01T09:52:17.230

8

votes

0

answers

Fuzzy Street Address Searches Using MySQL Fulltext (or sphinx?)

mysql search sphinx full-text-search

asked 2011-10-31T18:53:28.923

9

votes

1

answers

Caching Query Results per user

mysql performance security

asked 2011-10-30T19:50:43.230

11

votes

3

answers

Does Dapper work on Mono?

c# mysql postgresql mono dapper

asked 2011-10-28T20:48:02.093

8

votes

3

answers

MySQL select DATETIME similar up to the minute

mysql datetime multiple-tables

asked 2011-10-28T11:21:57.560

8

votes

4

answers

MySQL Determine longest VarChar length

mysql varchar

asked 2011-10-28T09:35:39.167

35

votes

2

answers

MySQL Views and index use

mysql view

asked 2011-10-27T21:31:38.710

8

votes

2

answers

MySQL datetime not returning time

java mysql sql

asked 2011-10-24T11:52:41.283

13

votes

5

answers

MySQL queries are fast when run directly but really slow when run as stored proc

mysql sql stored-procedures

asked 2011-10-24T10:02:45.410

57

votes

4

answers

mysql count group by having

mysql sql group-by aggregate-functions

asked 2011-10-22T05:08:26.633

8

votes

1

answers

Creating a "feed" from multiple rails models, efficiently?

mysql ruby-on-rails ruby-on-rails-3

asked 2011-10-20T20:01:54.093

15

votes

4

answers

What structure type do I use for HTML content (MySQL)

mysql html sql

asked 2011-10-20T09:01:17.610

90

votes

7

answers

How do I extract Month and Year in a MySQL date and compare them?

mysql sql date

asked 2011-10-20T03:57:59.450

11

votes

4

answers

MySQL alter table modify column failing at rows with null values

mysql

asked 2011-10-19T21:32:25.323

11

votes

4

answers

How do I convert mySql SQL script to MS SQL one?

mysql sql sql-server

asked 2011-10-19T11:27:31.253

Questions tagged mysql