Questions tagged [mysql]

172

votes

4

answers

MySQL convert date string to Unix timestamp

asked 2012-06-21T07:50:26.507

28

votes

7

answers

MySQLdb in Python: "Can't connect to MySQL server on 'localhost'"

mysql python-2.7

asked 2012-06-20T14:29:18.627

8

votes

2

answers

Data truncated for column 'url' at row 1 - Error with programming with Python Django

python mysql django

asked 2012-06-19T18:54:25.253

20

votes

3

answers

Using OR in LIKE Query in MySQL to compare multiple fields

mysql sql-like

asked 2012-06-19T18:15:04.893

17

votes

6

answers

Error #2002 Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)

mysql mamp mysql-error-2002

asked 2012-06-19T17:01:39.140

104

votes

7

answers

Can't drop table: A foreign key constraint fails

mysql sql drop-table

asked 2012-06-19T12:26:42.657

14

votes

2

answers

htmlspecialchars utf-8 returns empty string

php mysql utf-8 htmlspecialchars

asked 2012-06-18T18:37:47.260

9

votes

3

answers

Method of finding gaps in time series data in MySQL?

mysql database time gaps-and-islands

asked 2012-06-18T15:03:17.220

9

votes

1

answers

How do I create a join using a 'greater than' and a 'group by'?

mysql join group-by

asked 2012-06-18T13:46:50.810

28

votes

3

answers

TOP and ORDER BY sql error

mysql sql

asked 2012-06-18T03:19:15.373

9

votes

3

answers

Filtering Magento Collections by COND1 AND (COND2 OR COND3)

php mysql magento

asked 2012-06-15T18:04:48.040

8

votes

6

answers

How to securely encrypt credit card information in a database

mysql database encryption credit-card

asked 2012-06-15T07:12:35.470

14

votes

4

answers

Alter table add new field "ON UPDATE CURRENT_TIMESTAMP"

mysql

asked 2012-06-13T10:57:35.923

25

votes

17

answers

Format MySQL code inside PHP string

php mysql format

asked 2012-06-12T21:32:39.710

8

votes

3

answers

Altering the data type of a column in a HUGE table. Performance issues

mysql alter

asked 2012-06-12T11:30:44.577

17

votes

1

answers

SQL selecting people you may know

mysql sql

asked 2012-06-11T12:27:20.143

33

votes

8

answers

SQL Infinite Calendar Pattern

php mysql codeigniter calendar

asked 2012-06-10T21:58:47.863

68

votes

8

answers

Import and insert sql.gz file into database with putty

mysql import gzip putty

asked 2012-06-10T19:16:29.427

47

votes

5

answers

Error when preparing a multiple insert query

php mysql pdo

asked 2012-06-10T03:54:40.653

12

votes

2

answers

Storing currency values in MySQL database

mysql currency

asked 2012-06-08T16:44:45.973

82

votes

2

answers

How to store uuid as number?

mysql uuid

asked 2012-06-08T13:54:06.360

47

votes

10

answers

Restore the mysql database from .frm files

mysql

asked 2012-06-07T15:18:31.893

49

votes

3

answers

utf8_bin vs. utf_unicode_ci

mysql database collation relation

asked 2012-06-07T10:15:57.623

11

votes

1

answers

Re-indexing huge database (the English Wikipedia) efficiently

mysql sql database xampp mediawiki

asked 2012-06-06T21:11:14.080

25

votes

6

answers

SQL select distinct rows and ignore row if blank

mysql phpmyadmin

asked 2012-06-06T10:15:48.107

11

votes

1

answers

Test Remote Database Access Host

mysql database command-prompt remote-server

asked 2012-06-05T16:42:16.723

47

votes

2

answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

java mysql jdbc

asked 2012-06-05T11:04:20.090

32

votes

1

answers

How to declare a variable in MySQL for a normal query?

mysql variables variable-declaration

asked 2012-06-05T07:48:10.207

78

votes

35

answers

Can't connect to MySQL server on 'localhost' (10061) after Installation

mysql windows windows-7

asked 2012-06-05T06:31:11.740

56

votes

17

answers

Stop MySQL service windows

mysql shutdown restart

asked 2012-06-04T16:53:47.503

9

votes

1

answers

Rank function in MySQL with Order By clause

mysql oracle-database window-functions rank

asked 2012-06-04T13:14:36.657

56

votes

3

answers

What is the maximum size of int(10) in Mysql

asp.net mysql

asked 2012-06-04T09:49:04.867

13

votes

5

answers

Error while restoring MYSQL db

mysql

asked 2012-06-04T06:56:17.553

71

votes

20

answers

org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)

mysql windows hibernate jsf-2 jboss

asked 2012-06-01T18:29:14.740

70

votes

4

answers

True/False vs 0/1 in MySQL

mysql boolean

asked 2012-06-01T14:40:00.043

8

votes

2

answers

Mysql return more than one row

mysql sql group-concat

asked 2012-06-01T12:56:21.230

20

votes

6

answers

GUI MySQL database frontend

php mysql database user-interface web-applications

asked 2012-05-31T23:29:35.197

19

votes

4

answers

How can I iterate through a MySQL result set?

mysql ruby activerecord ruby-on-rails-3.2

asked 2012-05-31T15:39:01.937

12

votes

2

answers

Connecting mysql remotely via free host

php mysql hosting web-hosting

asked 2012-05-31T10:35:27.267

17

votes

6

answers

Why MYSQL IN keyword not considering NULL values

mysql mysql-python

asked 2012-05-30T05:22:02.877

24

votes

3

answers

How to store bidirectional relationships in a RDBMS like MySQL?

mysql database-design relational-database relationship

asked 2012-05-29T22:58:02.813

8

votes

3

answers

Warning raised by inserting 4-byte unicode to mysql

python mysql regex astral-plane

asked 2012-05-29T11:53:30.080

15

votes

2

answers

How to test speed a query without result in MySQL

mysql performance load-time

asked 2012-05-29T11:09:06.673

9

votes

4

answers

How to convert given number of days to years, months and days in MySQL?

php mysql datetime datediff

asked 2012-05-26T11:57:18.367

11

votes

1

answers

Is MySQL logic evaluation lazy/short-circuiting in JOIN clause?

mysql logic lazy-evaluation boolean-logic

asked 2012-05-25T00:29:57.940

39

votes

7

answers

how to find out number of days in month in mysql

mysql sql date

asked 2012-05-24T11:53:53.290

33

votes

7

answers

How to insert BLOB and CLOB files in MySQL?

mysql ubuntu qt4

asked 2012-05-24T00:52:35.127

11

votes

4

answers

Concurrency violation: the DeleteCommand affected 0 of the expected 1 records

c# mysql

asked 2012-05-22T23:06:53.050

9

votes

3

answers

Why is a mysqldump with single-transaction more consistent than a one without?

mysql

asked 2012-05-22T15:28:03.727

14

votes

4

answers

How to reset the auto increment number/column in a MySql table

mysql sql

asked 2012-05-22T06:55:52.663

Questions tagged mysql