Questions tagged [mysql]

53

votes

4

answers

Using MySQL's TIMESTAMP vs storing timestamps directly

asked 2011-08-11T16:03:16.747

39

votes

6

answers

MySQL MONTHNAME() from numbers

mysql

asked 2011-08-11T13:54:37.403

24

votes

10

answers

Adding foreign key to existing table gives error 1050 table already exists

mysql foreign-keys mysql-workbench mysql-error-1050

asked 2011-08-10T23:08:27.910

11

votes

2

answers

How to escape special SQL characters in regular expression in Mysql

mysql regex

asked 2011-08-10T11:54:17.263

11

votes

3

answers

Good way to generate SQL strings in java?

java mysql sql generator sqlbuilder

asked 2011-08-08T13:55:13.900

9

votes

3

answers

MySQL Database Error: Packets larger than max_allowed_packet are not allowed - during insert

mysql

asked 2011-08-07T16:08:40.983

17

votes

5

answers

Best practices for migrating database content from one very poor structure to one very logical?

mysql database database-design migration relational-database

asked 2011-08-07T14:44:01.560

52

votes

3

answers

Storing IPv6 Addresses in MySQL

mysql sql

asked 2011-08-06T01:14:01.870

129

votes

3

answers

What is the difference between MySQL Server and MySQL Client

mysql linux ubuntu

asked 2011-08-05T21:36:33.843

30

votes

3

answers

Need help selecting non-empty column values from MySQL

mysql sql null

asked 2011-08-04T19:11:42.003

21

votes

3

answers

Storing files in database Vs file system

php mysql document document-management

asked 2011-08-04T09:30:11.507

9

votes

5

answers

Perl (or R, or SQL): Count how often string appears across columns

mysql string perl r

asked 2011-08-04T02:19:22.927

37

votes

3

answers

The dreaded 'keep me logged in' and session checking

php mysql session

asked 2011-08-03T15:07:49.213

33

votes

3

answers

Mysql int(11) number out of range

php mysql

asked 2011-08-03T04:25:18.310

15

votes

6

answers

how to change storage engine of database in phpmyadmin?

mysql sql phpmyadmin

asked 2011-08-03T04:08:12.897

10

votes

3

answers

Why is MySQL treating é the same as e?

mysql unicode utf-8 character-encoding collation

asked 2011-08-02T23:22:14.750

11

votes

3

answers

auto-refreshing MySQL query on Linux commandline

mysql linux command-line

asked 2011-08-02T14:37:27.867

11

votes

1

answers

Codeigniter sessions class w/ database storage option not optimized?

mysql codeigniter session-state php

asked 2011-08-02T14:31:52.600

10

votes

6

answers

Problems with RODBC sqlSave

mysql r rodbc

asked 2011-08-02T10:25:40.530

113

votes

12

answers

select count(*) from table of mysql in php

php mysql count

asked 2011-08-02T05:45:13.977

67

votes

9

answers

SQL Update query with group by clause

mysql sql

asked 2011-08-01T13:16:03.863

26

votes

5

answers

PDO/MySQL memory consumption with large result set

php mysql pdo

asked 2011-08-01T06:59:39.800

113

votes

4

answers

Maximum length of a table name in MySQL

mysql

asked 2011-07-29T03:23:19.817

9

votes

4

answers

Database design: lots of rows vs lots of tables?

mysql sql database-design

asked 2011-07-28T12:57:13.757

24

votes

1

answers

Does MySQL use index for sorting?

mysql sql sorting

asked 2011-07-28T12:18:14.143

13

votes

4

answers

How to allow Mysql to add more than 1000 rows?

mysql

asked 2011-07-28T07:55:18.267

16

votes

1

answers

How to store long text to MySql DB using Rails?

mysql ruby-on-rails text

asked 2011-07-26T13:12:49.837

41

votes

4

answers

Copy 1 column to another by mysql query

mysql

asked 2011-07-26T08:46:47.280

17

votes

4

answers

MySQL - specific columns on join?

mysql sql

asked 2011-07-26T06:52:42.337

10

votes

2

answers

How can I replace NULL category titles in MySQL ROLLUP function?

php mysql rollup

asked 2011-07-25T21:37:33.280

11

votes

4

answers

MySQL INT meaning

mysql int

asked 2011-07-25T14:14:19.853

11

votes

4

answers

MySQL database connection not closed: what will happen?

php mysql database performance

asked 2011-07-24T19:52:07.237

19

votes

8

answers

Efficient method to find collision free random numbers

php mysql random primary-key

asked 2011-07-24T17:45:05.627

9

votes

2

answers

Can I set user-defined variable in Python MySQLdb?

python mysql sql database

asked 2011-07-24T13:59:03.970

9

votes

4

answers

Create table in mysql with one column containing sum of another two columns value

mysql create-table

asked 2011-07-24T07:28:10.567

87

votes

2

answers

MySQL command line formatting with UTF8

mysql utf-8

asked 2011-07-22T09:06:00.983

59

votes

8

answers

In MySQL, should I quote numbers or not?

mysql sql ansi-sql

asked 2011-07-21T19:58:40.333

140

votes

13

answers

Using a .php file to generate a MySQL dump

php mysql

asked 2011-07-19T16:20:08.477

29

votes

6

answers

How does 'LIMIT' parameter work in sql?

mysql sql limit

asked 2011-07-18T16:58:46.190

15

votes

2

answers

How do you run a MySQL query from a rake task?

mysql ruby-on-rails ruby rake

asked 2011-07-18T16:07:57.850

48

votes

3

answers

How to combine GROUP BY, ORDER BY and HAVING

mysql sql

asked 2011-07-18T14:14:06.553

75

votes

7

answers

Incorrect usage of UNION and ORDER BY?

mysql sql-order-by union

asked 2011-07-18T12:10:00.823

12

votes

4

answers

How to re-assign AUTO_INCREMENT column for every row in a MySQL table using PHP

php mysql auto-increment

asked 2011-07-16T16:20:21.287

50

votes

6

answers

How to SUM and SUBTRACT using SQL?

mysql sql aggregate-functions

asked 2011-07-16T03:23:56.997

42

votes

5

answers

MySQL query - using SUM of COUNT

mysql

asked 2011-07-15T15:49:22.617

10

votes

4

answers

[Hibernate]Error: entity class not found:

java mysql eclipse hibernate

asked 2011-07-14T12:07:44.847

29

votes

10

answers

group by range in mysql

mysql group-by range

asked 2011-07-14T01:31:55.557

14

votes

5

answers

MySQL database backup: performance issues

performance backup mysql database-backups

asked 2011-07-13T16:44:47.630

11

votes

3

answers

Compare two MySQL databases, on command-line, with a free tool

mysql sql diff

asked 2011-07-13T13:08:23.910

11

votes

4

answers

why is scaling writes to a relational database virtually impossible?

mysql sql-server database nosql cassandra

asked 2011-07-12T17:23:50.270

Questions tagged mysql