Questions tagged [mysql]

24

votes

2

answers

MySQL Delete with Group By

mysql group-by

asked 2011-06-09T16:23:31.193

158

votes

3

answers

MySQL: Quick breakdown of the types of joins

mysql join

asked 2011-06-09T14:49:45.980

9

votes

6

answers

What is the most accepted method for hiding password for 'connect.php' file?

php mysql encryption passwords password-protection

asked 2011-06-08T16:14:10.330

16

votes

1

answers

Attempted to read past end of the stream error in MySQL

.net mysql ioexception connector

asked 2011-06-08T15:26:07.997

17

votes

4

answers

BatchSqlUpdate - how to get auto generated keys

java mysql sql spring

asked 2011-06-07T22:19:21.060

292

votes

10

answers

Convert Unix timestamp into human readable date using MySQL

mysql unix-timestamp

asked 2011-06-07T15:23:30.297

12

votes

3

answers

Getting the most recent message in a thread

php mysql messaging

asked 2011-06-07T05:48:43.807

10

votes

1

answers

How to convert bool to int in MySql

mysql

asked 2011-06-07T04:54:01.713

87

votes

5

answers

MySQL match() against() - order by relevance and column?

mysql full-text-search

asked 2011-06-07T00:56:01.823

63

votes

13

answers

converting database from mysql to mongoDb

mysql mongodb database

asked 2011-06-06T11:46:32.610

16

votes

6

answers

MySQL.. Return '1' if a COUNT returns anything greater than 0

mysql sql

asked 2011-06-04T03:50:09.080

11

votes

3

answers

Foreign keys must be Index in mySQL?

mysql sql foreign-keys indexing

asked 2011-06-03T17:34:26.607

9

votes

2

answers

What can we do in MySQL 5.0 replication to address bandwidth concerns?

mysql database-replication

asked 2011-06-01T18:39:22.240

124

votes

16

answers

How to log in to MySQL and query the database from Linux terminal?

mysql linux authentication

asked 2011-06-01T11:11:28.310

60

votes

5

answers

Reference: What is a perfect code sample using the MySQL extension?

php mysql security sql-injection

asked 2011-06-01T08:09:03.803

17

votes

7

answers

Problem Storing Latitude and Longitude values in MySQL database

php mysql types floating-point

asked 2011-05-31T13:17:39.703

43

votes

5

answers

SQL Query to show nearest date?

mysql sql datetime

asked 2011-05-31T11:37:06.563

10

votes

6

answers

MySQL InnoDB hangs on waiting for table-level locks

java mysql locking innodb

asked 2011-05-31T10:02:36.503

74

votes

6

answers

Django "Cannot add or update a child row: a foreign key constraint fails"

mysql django orm foreign-keys

asked 2011-05-30T16:47:41.353

12

votes

3

answers

Convert dd/mm/yyyy string to Unix timestamp in MySQL

mysql

asked 2011-05-30T16:07:46.557

10

votes

4

answers

How to take MySQL Database backup and put it in Amazon s3 every Night by using Cron tab?

mysql backup cron

asked 2011-05-30T10:52:29.477

48

votes

3

answers

MySQL VARCHAR(255) UTF8 is too long for key, but max length is 1000 bytes

mysql utf8mb4

asked 2011-05-30T06:05:37.737

76

votes

11

answers

How do you use MySQL's source command to import large files in windows

mysql import xampp

asked 2011-05-28T18:41:30.017

10

votes

2

answers

MySQL: Trying to populate data into one column from another table

mysql sql merge

asked 2011-05-27T20:51:42.397

28

votes

8

answers

MySQL error - #1062 - Duplicate entry ' ' for key 2

mysql database

asked 2011-05-27T14:18:09.190

13

votes

4

answers

How to configure MySQL/PHP to use less memory?

php mysql memory-management ubuntu virtual-machine

asked 2011-05-26T21:17:23.487

16

votes

4

answers

rails mysql adapter error

mysql ruby-on-rails-3.1

asked 2011-05-26T15:42:37.450

10

votes

2

answers

Should VARCHAR columns be put at the end of table definitions in MySQL?

mysql rdbms varchar

asked 2011-05-26T13:50:05.830

171

votes

10

answers

MySQL - SELECT WHERE field IN (subquery) - Extremely slow why?

mysql subquery where-in

asked 2011-05-26T07:53:23.047

24

votes

6

answers

Automatic Rollback if COMMIT TRANSACTION is not reached

mysql transactions rollback

asked 2011-05-25T09:00:01.843

9

votes

1

answers

Creating a MySQL index on a Varchar always makes 2 indexes?

mysql database database-design optimization indexing

asked 2011-05-24T18:59:02.793

75

votes

6

answers

MySQL LIMIT on DELETE statement

mysql limit sql-delete

asked 2011-05-24T14:25:28.203

101

votes

6

answers

How to Perform an UPSERT so that I can use both new and old values in update part

mysql performance upsert

asked 2011-05-24T08:36:20.733

12

votes

1

answers

How to make a Rails Migration be utf-8 instead of my default latin1

mysql ruby-on-rails-3 utf-8 migration latin1

asked 2011-05-23T23:16:39.177

18

votes

6

answers

Multiple cursors in nested loops in MySQL

mysql database-cursor

asked 2011-05-23T15:39:59.487

9

votes

2

answers

Tracking User activity log - SQL vs NoSQL?

mysql mongodb database-design relational-database nosql

asked 2011-05-22T22:40:16.313

25

votes

2

answers

pdo free result

php mysql pdo

asked 2011-05-21T20:54:19.140

10

votes

4

answers

When Selecting everything from MySQL can I rename specific fields and still select everything else as is with the *

php mysql csv into-outfile

asked 2011-05-19T23:50:29.630

14

votes

2

answers

MySQL Subquery with main query data variable

mysql select subquery

asked 2011-05-19T18:08:45.950

11

votes

3

answers

Column in where clause is ambiguous - What does that mean?

php mysql join mysql-error-1052

asked 2011-05-19T17:01:10.717

11

votes

5

answers

Which is the least expensive aggregate function in the absence of ANY()

mysql sql t-sql

asked 2011-05-19T14:28:03.637

10

votes

2

answers

JDBC: foreign key on PK created in same transaction

java mysql transactions

asked 2011-05-19T10:01:00.420

27

votes

5

answers

How to show sequential number in MySQL query result

mysql select

asked 2011-05-19T08:24:09.003

11

votes

4

answers

PHP Caching - Is it faster to save in database or create a file?

php mysql caching

asked 2011-05-19T03:23:23.597

64

votes

5

answers

Python MySql Insert not working

python mysql

asked 2011-05-17T06:52:34.287

13

votes

2

answers

How do I use the empty variable in MySQL more than once?

php mysql sql mysql-error-1064

asked 2011-05-15T05:13:32.783

311

votes

12

answers

How to debug Lock wait timeout exceeded on MySQL?

mysql debugging transactions innodb acid

asked 2011-05-14T07:07:45.043

86

votes

5

answers

When to use datetime or timestamp

mysql datetime timestamp

asked 2011-05-13T08:59:13.693

10

votes

4

answers

Connecting MySQL to Dropbox

php mysql dropbox

asked 2011-05-13T07:08:29.647

14

votes

3

answers

Create a new MySQL user in XAMPP

mysql xampp

asked 2011-05-13T02:21:35.130

Questions tagged mysql