Questions tagged [mysql]

10

votes

4

answers

The dreaded MySQL import encoding issue - revisited

asked 2011-05-12T21:29:13.510

27

votes

1

answers

Reclaim disk space after drop database in mysql

mysql drop-database

asked 2011-05-12T20:05:56.647

16

votes

11

answers

Fetching a Single Row from Join Table

mysql

asked 2011-05-12T19:10:09.263

13

votes

3

answers

Explain inexplicable deadlock

mysql

asked 2011-05-11T20:28:22.277

14

votes

4

answers

Preventing simultaneous overwrites when editing a MySQL-row through PHP

php mysql

asked 2011-05-11T19:39:59.140

27

votes

3

answers

Select day of week from date

mysql

asked 2011-05-11T16:16:30.147

159

votes

12

answers

Convert partially non-numeric text into number in MySQL query

mysql sql

asked 2011-05-11T07:18:53.880

14

votes

6

answers

How to correct double-encoded UTF-8 strings sitting in MySQL utf8_general_ci fields?

php mysql utf-8

asked 2011-05-10T14:44:52.730

12

votes

7

answers

How to make a SELECT in PHP/MySQL case insensitive?

php mysql

asked 2011-05-09T14:08:19.017

10

votes

2

answers

Knowing the last mysql error

mysql error-handling

asked 2011-05-09T02:34:48.090

12

votes

2

answers

MySQL and PDO: Could PDO::lastInsertId theoretically fail?

mysql database pdo

asked 2011-05-08T23:45:15.220

21

votes

3

answers

php / Mysql best tree structure

php mysql tree hierarchical-data hierarchical

asked 2011-05-06T20:07:55.647

68

votes

3

answers

move table from one schema to another schema ?

mysql database

asked 2011-05-06T10:47:28.547

76

votes

22

answers

Does phpMyAdmin AllowNoPassword work with MySQL databases?

mysql phpmyadmin passwords

asked 2011-05-06T08:27:54.983

226

votes

5

answers

How to change the CHARACTER SET (and COLLATION) throughout a database?

mysql sql collation

asked 2011-05-06T03:53:00.830

32

votes

1

answers

Strange LINQ To Entities Exception

c# .net mysql linq linq-to-entities

asked 2011-05-05T20:10:33.013

10

votes

1

answers

PHP's MySQL Cursor implementations and how they manage memory

php mysql php-internals

asked 2011-05-05T14:48:13.057

10

votes

1

answers

MYSQL DateTime Now()+5 days/hours/minutes/seconds?

mysql datetime

asked 2011-05-04T22:48:37.120

12

votes

4

answers

What's the best way to use LEFT OUTER JOIN to check for non-existence of related rows

mysql sql join outer-join

asked 2011-05-04T15:41:02.097

103

votes

10

answers

Fatal error: [] operator not supported for strings

php mysql

asked 2011-05-04T07:00:25.417

9

votes

5

answers

Is it okay to save lots of information in $_SESSION?

php mysql session memcached

asked 2011-05-03T16:36:05.557

10

votes

1

answers

How much memory will be occupied by a null value in a DB?

mysql sql

asked 2011-05-03T04:39:43.883

10

votes

3

answers

MySQL UNIX_TIMESTAMP for PostgreSQL

mysql sql postgresql timestamp

asked 2011-05-02T13:52:35.953

13

votes

6

answers

Message Queue Exception : Queue does not exist or you do not have sufficient permissions to perform the operation

c# asp.net mysql message-queue

asked 2011-05-02T08:04:36.750

32

votes

5

answers

version of mysql2 (0.3.2) doesn't ship with the ActiveRecord adapter bundled anymore as it's now part of Rails 3.1

mysql ruby-on-rails-3

asked 2011-04-30T09:05:32.893

476

votes

30

answers

Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction

mysql sql

asked 2011-04-29T19:40:25.153

19

votes

3

answers

MySQL explain for DELETE queries

mysql

asked 2011-04-29T18:29:45.930

14

votes

2

answers

Real-time statistics: MySQL(/Drizzle) or MongoDB?

mysql mongodb statistics drizzle

asked 2011-04-29T10:30:47.870

16

votes

7

answers

What would be a sql query to remove \n\r from the text?

mysql sql

asked 2011-04-29T05:48:05.320

15

votes

3

answers

Is MySQL Query containing sub-query atomic?

mysql

asked 2011-04-28T08:53:31.500

22

votes

3

answers

How to define the default values for a column when creating tables in MySQL?

mysql database default-value

asked 2011-04-27T21:01:58.543

9

votes

2

answers

How to select part of a Timestamp in a SQL Query

mysql sql timestamp distinct extract

asked 2011-04-27T18:25:17.857

49

votes

9

answers

Get sum of MySQL column in PHP

php mysql

asked 2011-04-27T18:05:06.310

26

votes

5

answers

How to create a MySQL user without password - needed for remote login - to be used in bash insert script?

mysql bash

asked 2011-04-27T14:43:01.397

9

votes

2

answers

Calling a database view in Yii using Active Record

php mysql activerecord yii

asked 2011-04-25T20:27:21.590

10

votes

5

answers

MySQL: Fields length. Does it really matter?

mysql sql database database-abstraction

asked 2011-04-25T19:12:06.170

12

votes

3

answers

MySQL subquery to refer to field in parent query

mysql subquery

asked 2011-04-25T17:55:01.873

22

votes

8

answers

How costly are JOINs in SQL? And/or, what's the trade off between performance and normalization?

mysql sql performance join

asked 2011-04-24T22:19:23.820

18

votes

3

answers

Table name or column name length affect performance?

mysql hibernate

asked 2011-04-23T07:02:08.670

13

votes

10

answers

can't add foreign key in mysql?

mysql foreign-keys mysql-error-1005

asked 2011-04-22T17:22:25.323

27

votes

4

answers

Moving lat/lon text columns into a 'point' type column

mysql latitude-longitude point

asked 2011-04-22T14:03:28.703

39

votes

12

answers

MySQL - How to search for exact word match using LIKE?

mysql sql select sql-like

asked 2011-04-21T10:59:59.077

14

votes

4

answers

How to use result of an subquery multiple times into an query

mysql sql subquery

asked 2011-04-20T13:22:32.373

28

votes

5

answers

Trying to connect to remote MySQL host (error 2003)

mysql debian iptables mysql-error-2003

asked 2011-04-19T08:47:44.423

18

votes

4

answers

Removing NOT NULL restriction from column in MySQL

mysql null alter

asked 2011-04-18T18:55:04.420

30

votes

7

answers

insert command denied in mysql

php mysql

asked 2011-04-18T05:44:29.590

59

votes

4

answers

SELECT one column if the other is null

mysql sql

asked 2011-04-18T02:25:16.387

47

votes

4

answers

How can a query multiply 2 cell for each row MySQL?

mysql multiplication

asked 2011-04-17T11:35:08.163

53

votes

6

answers

Auto-login phpMyAdmin

php mysql cookies authentication phpmyadmin

asked 2011-04-16T16:39:54.490

14

votes

1

answers

Finding k-nearest neighbors for a given vector?

python mysql algorithm language-agnostic search

asked 2011-04-16T04:00:58.237

Questions tagged mysql