Questions tagged [mysql]

16

votes

5

answers

SQL Data Type to store build versions

asked 2010-07-31T18:15:12.377

22

votes

2

answers

How to convert JSON to string

php mysql json

asked 2010-07-31T10:41:02.967

26

votes

4

answers

Adding MySQL alias fields together

sql mysql

asked 2010-07-30T16:50:17.870

57

votes

4

answers

What are the known ways to store a tree structure in a relational DB?

mysql design-patterns tree relational-database

asked 2010-07-29T12:59:06.773

33

votes

6

answers

Is there a reason MySQL doesn't support FULL OUTER JOINS?

mysql sql

asked 2010-07-29T11:41:21.057

9

votes

1

answers

Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB?

php mysql session innodb myisam

asked 2010-07-29T04:01:30.117

24

votes

3

answers

How to return different strings from a Boolean type in MySQL?

sql mysql

asked 2010-07-29T03:53:19.530

39

votes

8

answers

a better approach than storing mysql password in plain text in config file?

php mysql security passwords

asked 2010-07-28T15:07:06.163

18

votes

5

answers

How would you store a business's hours in the db/model of a Rails app?

mysql ruby-on-rails datetime

asked 2010-07-28T00:22:03.593

10

votes

5

answers

Set up large database in MySQL for analysis in R

mysql macos r

asked 2010-07-27T03:33:12.453

11

votes

6

answers

PHP MySQL select random rows

php mysql

asked 2010-07-27T01:01:32.143

83

votes

3

answers

How to find similar results and sort by similarity?

mysql sql string sorting similarity

asked 2010-07-26T20:49:48.857

11

votes

1

answers

Mysql unique index doesn't work on a certain umlaut

mysql indexing mysql-error-1062

asked 2010-07-26T05:25:58.903

9

votes

5

answers

Converting MySQL datetime to RSS pubDate using PHP?

php mysql rss

asked 2010-07-25T16:22:47.950

11

votes

2

answers

hibernate map java Long to MySQL BIGINT error

java mysql hibernate

asked 2010-07-23T06:57:22.593

120

votes

5

answers

Print debugging info from stored procedure in MySQL

mysql debugging

asked 2010-07-23T01:35:57.820

14

votes

3

answers

MySQL query with dependent subquery takes too long

mysql mysql-dependent-subquery

asked 2010-07-22T10:09:12.733

10

votes

2

answers

java.net.SocketException: Broken pipe

java mysql hibernate tomcat jdbc

asked 2010-07-22T06:19:28.340

16

votes

3

answers

PHP strtotime() function wrong by 1 hour?

php mysql strtotime unix-timestamp

asked 2010-07-21T21:21:51.713

11

votes

5

answers

Encrypted columns with Entity Framework

c# mysql entity-framework encryption entity

asked 2010-07-21T12:16:35.530

58

votes

17

answers

How to get first day of every corresponding month in mysql?

mysql date

asked 2010-07-21T10:34:39.757

46

votes

4

answers

Where should I store a foreign key?

mysql database database-design data-modeling

asked 2010-07-20T19:50:48.750

48

votes

3

answers

How to truncate the text returned for a column in a MySQL query

sql mysql

asked 2010-07-20T13:52:53.847

29

votes

3

answers

Using MySql with Entity Framework 4 and the Code-First Development CTP

mysql asp.net-mvc entity-framework-4 code-first ctp

asked 2010-07-19T18:19:22.387

24

votes

5

answers

Mysql Select Second Row

php mysql sql

asked 2010-07-19T10:15:44.173

9

votes

1

answers

recursive self query

mysql parent-child self-join

asked 2010-07-18T15:36:04.150

39

votes

2

answers

Java + Mysql UTF8 Problem

java mysql xml utf-8 insert

asked 2010-07-18T12:40:43.960

17

votes

6

answers

Whats the most efficient way to store an array of integers in a MySQL column?

mysql

asked 2010-07-16T03:20:52.410

25

votes

2

answers

MySQL dump file and commented out lines

phpmyadmin mysql

asked 2010-07-15T15:28:27.717

11

votes

6

answers

How to sort in SQL, ignoring articles ('the", "a', "an" etc)

sql mysql sorting switch-statement trim

asked 2010-07-15T05:00:00.760

28

votes

4

answers

How do I get first name and last name as whole name in a MYSQL query?

sql mysql

asked 2010-07-15T00:24:45.463

28

votes

4

answers

MySQL Update Query using a left join

mysql left-join

asked 2010-07-14T16:54:43.410

152

votes

14

answers

Is there a way to view past mysql queries with phpmyadmin?

mysql phpmyadmin

asked 2010-07-14T14:38:37.397

19

votes

10

answers

Django unable to find MySQLdb python module

python django mysql

asked 2010-07-14T02:49:55.563

13

votes

3

answers

How to return a boolean value from a function in MySQL?

mysql

asked 2010-07-12T11:34:28.517

17

votes

5

answers

PHP-MySQLi connection randomly fails with "Cannot assign requested address"

php mysql debian

asked 2010-07-09T06:20:08.080

99

votes

8

answers

MySQL - how to front pad zip code with "0"?

sql mysql database database-design

asked 2010-07-08T04:56:31.577

16

votes

3

answers

How to concatenate more than 2 fields with SQL?

sql mysql

asked 2010-07-05T22:53:44.527

19

votes

6

answers

Get the year out of timestamp sql

mysql timestamp

asked 2010-07-05T14:03:34.263

20

votes

7

answers

update all NULL fields MySQL

mysql sql-update

asked 2010-07-04T15:16:41.093

36

votes

2

answers

Can a table field contain a hyphen?

mysql sql database

asked 2010-07-02T19:38:41.727

10

votes

2

answers

Trigger on INSERT ON DUPLICATE KEY

mysql triggers

asked 2010-07-02T01:36:43.330

15

votes

7

answers

Multiple Ranks in one table

sql mysql

asked 2010-07-01T23:29:56.617

19

votes

5

answers

How to select one text column, which string length >0?

mysql

asked 2010-07-01T12:18:35.150

15

votes

3

answers

Using a single common WHERE condition for UNION in SQL

sql mysql

asked 2010-07-01T10:24:52.500

9

votes

6

answers

How to tune a 7-table-join MySQL count query where tables contain 30,000+ rows?

sql mysql count performance

asked 2010-06-30T16:38:51.217

31

votes

7

answers

How to handle error for duplicate entries?

php mysql error-handling sql-insert mysql-error-1062

asked 2010-06-30T06:09:03.363

10

votes

2

answers

Optimal query to fetch a cumulative sum in MySQL

sql mysql query-optimization

asked 2010-06-29T21:10:17.873

13

votes

2

answers

Does MySQL support user defined data types

mysql

asked 2010-06-29T06:40:23.267

28

votes

6

answers

php code to test pdo is available?

php mysql pdo

asked 2010-06-28T09:50:29.430

Questions tagged mysql