Questions tagged [mysql]

12

votes

3

answers

Which one is faster and lighter - mysqli & PDO

asked 2012-05-22T06:18:43.413

8

votes

2

answers

MySQL update changing multiple columns is non-atomic?

mysql sql django sqlite

asked 2012-05-21T21:28:40.657

9

votes

3

answers

how to remove underscore from values of textarea?

php mysql codeigniter

asked 2012-05-21T06:54:36.933

34

votes

11

answers

MySQL pid ended (cannot start mysql)

mysql database macos mysql-error-1064

asked 2012-05-16T01:25:31.913

27

votes

4

answers

Alter SQL table - allow NULL column value

mysql sql alter

asked 2012-05-15T09:37:17.540

12

votes

5

answers

Storing IP address in MySQL database (IPv4 AND IPv6)

php mysql ip ipv6 ipv4

asked 2012-05-14T19:34:03.110

28

votes

12

answers

Is there a simpler way to achieve this style of user messaging?

mysql sql database database-design innodb

asked 2012-05-14T17:43:05.270

8

votes

4

answers

Selecting with UNION but limiting every subquery and receiving distinct values

mysql sql

asked 2012-05-14T14:06:29.490

8

votes

4

answers

SQL Select Radius Search based on Latitude Longitude

mysql sql

asked 2012-05-12T14:29:44.673

17

votes

3

answers

Best Way To Build A Multi-Notification System in PHP

php mysql codeigniter database-design database-schema

asked 2012-05-11T01:54:58.460

13

votes

1

answers

INSERT into DB DateTime string

mysql

asked 2012-05-10T17:20:46.900

128

votes

11

answers

Schrödingers MySQL table: exists, yet it does not

mysql

asked 2012-05-10T17:01:40.787

37

votes

5

answers

PDO were rows affected during execute statement

php mysql pdo prepared-statement

asked 2012-05-09T19:05:10.930

8

votes

3

answers

Java MySQL Timestamp time zone problems

java mysql timezone timestamp

asked 2012-05-09T18:48:39.453

36

votes

1

answers

How to set a MySQL row to READ-ONLY?

mysql sql database

asked 2012-05-08T16:09:17.283

13

votes

1

answers

PDO Transactions & function calls

php mysql transactions pdo

asked 2012-05-08T14:05:27.403

370

votes

23

answers

ERROR 2006 (HY000): MySQL server has gone away

mysql

asked 2012-05-06T22:46:13.100

52

votes

6

answers

In SQL, is it OK for two tables to refer to each other?

mysql database database-design

asked 2012-05-04T09:58:01.353

10

votes

6

answers

Can I just SELECT one column in MYSQL instead of all, to make it faster?

php mysql

asked 2012-05-01T20:53:28.547

48

votes

6

answers

MySql - Update table using select statment from same table

mysql

asked 2012-05-01T18:56:20.763

10

votes

2

answers

DISTINCT COUNT in SELECT CASE SQL

mysql select if-statement case

asked 2012-05-01T13:04:40.053

120

votes

4

answers

Using group by on two fields and count in SQL

mysql sql

asked 2012-04-30T09:03:03.277

8

votes

5

answers

MYSQL - How to workaround the row size limit of 66 KBytes

mysql

asked 2012-04-27T10:56:34.530

8

votes

6

answers

String compare exact in query MySQL

mysql comparison collation

asked 2012-04-27T07:44:37.227

11

votes

6

answers

PHP mysql_real_escape_string returns empty string

php mysql database mysql-real-escape-string

asked 2012-04-26T18:35:30.977

14

votes

3

answers

PHPUnit and MySQL truncation error

php mysql phpunit

asked 2012-04-26T10:16:48.957

9

votes

2

answers

Mysql: unknown variable, can't run any mysql applications, doesn't seem to be to do with my.cnf

mysql linux fedora

asked 2012-04-25T18:40:37.380

55

votes

4

answers

Exporting query results in MySQL Workbench beyond 1000 records

mysql mysql-workbench

asked 2012-04-23T21:39:42.910

9

votes

1

answers

How to remove the default DEFINER when executing a CREATE TRIGGER on a table?

mysql triggers

asked 2012-04-23T09:50:25.410

12

votes

1

answers

How can I see the auto-generated SQL query for DB schema update with Doctrine2 and Symfony2?

mysql sql symfony doctrine-orm

asked 2012-04-22T09:41:30.933

8

votes

2

answers

JPA persist many to many

java mysql jpa

asked 2012-04-22T08:27:04.023

9

votes

1

answers

Counting number of events per week in PHP

php mysql date count strtotime

asked 2012-04-21T13:50:06.827

12

votes

6

answers

How to get field names of mysql table in codeigniter?

php mysql sql codeigniter

asked 2012-04-21T10:30:36.930

13

votes

1

answers

FILESTREAM storage in SqlServer -> MySQL equivalent?

mysql

asked 2012-04-21T00:07:17.390

44

votes

3

answers

Import CSV to Update only one column in table

mysql csv import

asked 2012-04-20T21:11:12.210

13

votes

3

answers

"The total number of locks exceeds the lock table size" Deleting 267 Records

mysql locking innodb sql-delete

asked 2012-04-20T20:59:56.007

8

votes

3

answers

MySQL Workbench unable to startup/shutdown from remote

mysql amazon-ec2 mysql-workbench

asked 2012-04-19T03:59:39.100

14

votes

4

answers

PHP & MySQL: Converting Stored TIMESTAMP into User's Local Timezone

php mysql datetime timezone timezone-offset

asked 2012-04-17T02:12:37.463

19

votes

2

answers

Grep in MySQL CLI interpretter

mysql command-line-interface

asked 2012-04-16T15:52:37.387

20

votes

3

answers

Why does SELECT results differ between mysql and sqlite?

mysql sql sqlite

asked 2012-04-16T09:11:46.357

502

votes

38

answers

MySQL error 1449: The user specified as a definer does not exist

mysql permissions

asked 2012-04-16T07:08:05.337

8

votes

3

answers

My simple MySql query doesn't use index

mysql select indexing

asked 2012-04-15T08:51:23.523

10

votes

4

answers

What's a good approach to managing the db connection in a Google Cloud SQL (GAE) Python app?

python mysql google-app-engine webapp2 google-cloud-sql

asked 2012-04-15T01:13:01.917

71

votes

6

answers

Select all where [first letter starts with B]

mysql

asked 2012-04-14T20:07:36.110

8

votes

4

answers

MySQL column defaults - advantages/disadvantages and should I use for all columns?

mysql null default default-value

asked 2012-04-14T16:00:28.920

12

votes

2

answers

How to use PHP string in mySQL LIKE query?

php mysql sql string

asked 2012-04-12T23:52:13.180

57

votes

8

answers

WHERE clause before INNER JOIN

mysql join optimization where-clause

asked 2012-04-12T23:39:35.260

23

votes

3

answers

which database suits my application mysql or mongodb ? using Node.js , Backbone , Now.js

mysql node.js mongodb backbone.js

asked 2012-04-11T16:27:33.573

8

votes

6

answers

Error installing mysql2

mysql ruby-on-rails ruby

asked 2012-04-11T08:15:59.067

16

votes

4

answers

MySql: if value exists UPDATE else INSERT

php mysql

asked 2012-04-10T20:06:06.510

Questions tagged mysql