Questions tagged [mysql]

17

votes

4

answers

Combine multiple rows into one space separated string

sql mysql hive

asked 2010-09-13T19:34:23.680

15

votes

3

answers

mysql: What is the right syntax for NOT LIKE?

syntax mysql

asked 2010-09-13T08:43:13.283

12

votes

2

answers

FIRST ORDER BY ... THEN GROUP BY

sql mysql

asked 2010-09-12T15:59:28.353

23

votes

3

answers

How do I set a full date & time sql using java, and not just the date?

java mysql datetime jdbc prepared-statement

asked 2010-09-09T14:36:50.833

21

votes

5

answers

pcntl_fork and the MySQL connection is gone

php mysql zend-framework fork

asked 2010-09-08T14:14:09.210

225

votes

13

answers

Bulk insert with SQLAlchemy ORM

python mysql database orm sqlalchemy

asked 2010-09-07T13:42:43.370

14

votes

2

answers

MYSQL query using variable as table name in LEFT JOIN

mysql left-join

asked 2010-09-05T14:34:02.923

394

votes

9

answers

How to see full query from SHOW PROCESSLIST?

mysql processlist

asked 2010-09-03T18:47:35.133

30

votes

5

answers

Where can I find the MySQL log file in XAMPP

mysql xampp

asked 2010-09-03T17:32:44.520

384

votes

24

answers

How do I import CSV file into a MySQL table?

mysql csv load-data-infile

asked 2010-09-03T11:10:55.290

9

votes

7

answers

Determining if MySQL table index exists before creating

mysql stored-procedures indexing

asked 2010-09-02T11:28:08.347

69

votes

9

answers

How to get the difference between two dates rounded to hours

sql mysql

asked 2010-09-01T19:26:22.510

83

votes

7

answers

Escape string Python for MySQL

python mysql escaping

asked 2010-09-01T10:23:59.700

27

votes

2

answers

Auto TimeStamp new entry to DB (phpMyAdmin)

mysql timestamp phpmyadmin

asked 2010-09-01T06:17:08.127

46

votes

4

answers

MySQLi count(*) always returns 1

php mysql mysqli

asked 2010-08-31T20:43:20.700

99

votes

6

answers

SQL Query: order by length of characters?

php sql mysql

asked 2010-08-31T07:31:36.143

38

votes

5

answers

Does "SELECT FOR UPDATE" prevent other connections inserting when the row is not present?

sql mysql sql-server oracle-database concurrency

asked 2010-08-30T15:38:02.773

11

votes

4

answers

return count 0 with mysql group by

sql mysql count group-by

asked 2010-08-30T02:53:52.060

11

votes

4

answers

Pros / Cons of MySql JOINS

mysql select join

asked 2010-08-29T16:16:18.457

19

votes

3

answers

SSH Tunnel for Python MySQLdb connection

python mysql ssh

asked 2010-08-26T17:06:13.877

31

votes

3

answers

What size INT should I use for my autoincrement ids MySQL

mysql primary-key auto-increment

asked 2010-08-25T03:52:14.287

11

votes

3

answers

MySQL: Most efficient data type to store long notes?

mysql performance types

asked 2010-08-24T10:07:41.400

31

votes

5

answers

TINYINT vs ENUM(0, 1) for boolean values in MySQL

php mysql enums tinyint

asked 2010-08-23T09:19:31.667

11

votes

6

answers

Can I enter formula in the column for MySQL database?

mysql database formula

asked 2010-08-22T11:18:15.300

27

votes

4

answers

How to join two tables mysql?

mysql inner-join sql

asked 2010-08-21T04:08:17.013

24

votes

2

answers

Differences between "IS NULL" and "ISNULL()" in Mysql

mysql performance null

asked 2010-08-20T10:44:26.227

27

votes

2

answers

Remove trailing newline

php mysql regex preg-replace

asked 2010-08-20T10:40:42.240

10

votes

2

answers

Slow UNION Query - MySQL

mysql optimization

asked 2010-08-19T17:50:05.777

13

votes

4

answers

Database architecture for millions of new rows per day

mysql database scalability analytics data-warehouse

asked 2010-08-18T07:07:21.050

12

votes

2

answers

SQL Error 1630: Function SUBSTRING does not exist.. huh?

mysql stored-procedures

asked 2010-08-17T22:04:47.273

13

votes

5

answers

Ways to escape single quotes in SQL 'LIKE' command

sql sql-server-2005 mysql oracle10g

asked 2010-08-17T15:48:35.187

39

votes

11

answers

@Column(unique=true) does not seem to work

mysql jpa jakarta-ee orm

asked 2010-08-16T18:18:01.197

22

votes

3

answers

MySQL boolean - flipping the value?

mysql boolean

asked 2010-08-16T05:19:17.357

10

votes

2

answers

mysql jdbc driver does not support delimiters in triggers with multiple statements

mysql jdbc triggers

asked 2010-08-14T02:26:20.703

44

votes

9

answers

Is there a performance decrease if there are too many columns in a table?

mysql database database-design schema

asked 2010-08-13T07:44:21.853

110

votes

4

answers

Get all characters before space in MySQL

sql mysql

asked 2010-08-12T19:18:36.617

41

votes

3

answers

How do I start auto increment from a specific point?

sql mysql

asked 2010-08-12T17:12:12.300

18

votes

6

answers

com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source

java mysql hibernate c3p0

asked 2010-08-12T08:22:49.850

40

votes

7

answers

How to get rid of "Error 1329: No data - zero rows fetched, selected, or processed"

sql mysql stored-procedures

asked 2010-08-11T22:15:00.153

11

votes

7

answers

Storing price in PHP. What is better double or string?

php mysql string oop double

asked 2010-08-10T22:52:59.847

10

votes

4

answers

Sorting string characters in MySQL

sql mysql

asked 2010-08-06T19:45:32.483

14

votes

3

answers

Caching strategy, when does caching become pointless?

php mysql caching

asked 2010-08-06T13:35:09.630

13

votes

1

answers

How to NOT select empty string

java mysql jpa orm

asked 2010-08-05T15:07:15.467

12

votes

3

answers

This SELECT query takes 180 seconds to finish

sql mysql select

asked 2010-08-05T15:02:25.500

12

votes

8

answers

CodeIgniter without a Database?

php mysql codeigniter

asked 2010-08-04T18:52:00.377

55

votes

5

answers

Only show tables with certain patterns in mysql "show tables"

mysql pagination show

asked 2010-08-04T16:27:10.460

14

votes

3

answers

MySQL INTERVAL Mins

mysql intervals

asked 2010-08-03T23:39:29.470

14

votes

3

answers

How to optimize an ORDER BY for a computed column on a MASSIVE MySQL table

mysql query-optimization sql-order-by

asked 2010-08-03T18:36:19.393

79

votes

9

answers

Meaning of "n:m" and "1:n" in database design

mysql database foreign-keys relationship

asked 2010-08-03T14:14:21.260

63

votes

6

answers

Hibernate JPA, MySQL and TinyInt(1) for Boolean instead of bit or char

java mysql hibernate jpa jpa-2.0

asked 2010-08-01T18:12:12.453

Questions tagged mysql