Questions tagged [mysql]

14

votes

2

answers

Groovy - class not found

asked 2013-08-03T18:47:48.787

8

votes

1

answers

Mysql query to dynamically convert rows to columns on the basis of two columns

mysql sql pivot pivot-table

asked 2013-07-31T07:23:12.203

15

votes

2

answers

MySQL - Where Or?

mysql sql where-clause

asked 2013-07-30T17:29:12.463

11

votes

1

answers

What is the recommended max value for join_buffer_size in mysql?

mysql sql

asked 2013-07-29T15:43:35.813

99

votes

4

answers

How to make MySQL table primary key auto increment with some prefix

mysql auto-increment

asked 2013-07-27T03:38:04.223

10

votes

3

answers

Foreign Key constraints missing after phpmyadmin export

mysql sql phpmyadmin foreign-keys key

asked 2013-07-26T20:26:20.477

12

votes

2

answers

DateTime error while insert to MySQL

mysql insert

asked 2013-07-25T23:02:12.923

16

votes

1

answers

Transaction necessary for single update query?

mysql transactions innodb

asked 2013-07-25T11:11:07.003

9

votes

8

answers

Disable autocommit in SQL Developer when using MySQL

mysql oracle-sqldeveloper autocommit

asked 2013-07-24T06:32:25.597

40

votes

4

answers

How do I use MySQL through XAMPP?

mysql xampp localhost

asked 2013-07-24T00:20:07.077

36

votes

11

answers

Table 'mysql.user' doesn't exist:ERROR

mysql

asked 2013-07-22T05:40:06.350

53

votes

1

answers

SQL JOIN many-to-many

mysql sql join many-to-many

asked 2013-07-21T16:22:11.867

18

votes

2

answers

PyMysql UPDATE query

python mysql sql-update pymysql

asked 2013-07-20T02:29:36.230

15

votes

3

answers

Liquibase preconditions: How do I check for a column being non-nullable?

mysql liquibase preconditions

asked 2013-07-19T12:24:37.257

8

votes

4

answers

How to test a scheduling program in php

php mysql codeigniter

asked 2013-07-19T12:08:39.700

66

votes

5

answers

ORDER BY "ENUM field" in MYSQL

mysql sql enums sql-order-by

asked 2013-07-11T21:32:08.793

36

votes

6

answers

Run MySQL query on remote machine through ssh in command line

mysql ssh remote-access

asked 2013-07-09T09:40:02.327

13

votes

5

answers

Can REPLACE() be made accent insensitive (é = e)?

mysql utf-8 character-encoding collation

asked 2013-07-08T07:38:38.650

9

votes

2

answers

SELECT TOP error

mysql sql database select

asked 2013-07-06T13:58:10.267

36

votes

4

answers

How to write a stored procedure in phpMyAdmin?

php mysql stored-procedures phpmyadmin

asked 2013-07-05T05:49:44.210

9

votes

3

answers

What happens when auto increment primary key in MySQL comes to maximum

mysql int primary-key auto-increment

asked 2013-07-04T22:12:52.880

74

votes

1

answers

Optimistic locking in MySQL

mysql sql locking database optimistic

asked 2013-07-02T16:52:16.577

8

votes

5

answers

Complicated Query

mysql

asked 2013-07-01T17:13:13.047

8

votes

3

answers

Mysql DATETIME evaluation: Get all records whose value is before midnight of the current day (basically yesterday and before

mysql

asked 2013-06-25T21:09:49.910

24

votes

7

answers

PDO error: SQLSTATE[HY000]: General error: 2031

php mysql pdo prepared-statement

asked 2013-06-24T11:38:20.997

16

votes

3

answers

select first N columns of MySQL table

mysql

asked 2013-06-23T08:32:12.577

18

votes

3

answers

mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables

php mysql mysqli prepared-statement

asked 2013-06-21T13:58:41.327

8

votes

3

answers

How to fix Column Index out of range SQLException

java mysql exception

asked 2013-06-20T06:55:56.313

11

votes

4

answers

Number of days between current date and date field

mysql datediff

asked 2013-06-18T22:06:36.927

433

votes

15

answers

Get the new record primary key ID from MySQL insert query?

mysql insert key auto-increment

asked 2013-06-14T16:10:37.877

18

votes

3

answers

One-to-Many relationship in MySQL - how to build model?

mysql relational-database

asked 2013-06-11T13:01:30.023

23

votes

2

answers

Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench

mysql sql-server mysql-workbench migrate

asked 2013-06-11T07:30:44.177

14

votes

2

answers

How to query MySQL for fields containing null characters

mysql unicode character-encoding escaping

asked 2013-06-08T00:42:17.110

34

votes

3

answers

right join even if row on second table does not exist

mysql sql

asked 2013-06-07T15:07:09.703

14

votes

5

answers

How to connect to a MySQL server running on a Virtual Machine

mysql virtual-machine

asked 2013-06-06T05:36:59.727

27

votes

7

answers

Maximum length of a Column name in MySQL

mysql

asked 2013-06-04T14:06:34.813

12

votes

2

answers

Hibernate - Store a column as encrypted, and decrypt only on runtime

java mysql hibernate security encryption

asked 2013-06-04T13:13:17.120

20

votes

21

answers

mysql is not starting in XAMPP UBUNTU

php mysql xampp ubuntu-12.04

asked 2013-05-30T08:01:52.367

61

votes

11

answers

How to ignore certain MySQL tables when importing a database?

mysql mysqlimport

asked 2013-05-24T12:48:15.583

8

votes

3

answers

MYSQL: How to define or get LONG string variables

mysql variables

asked 2013-05-23T19:49:05.103

9

votes

2

answers

Get Popular words in PHP+MySQL

php mysql

asked 2013-05-23T07:13:02.377

11

votes

3

answers

MySql. How to use Self Join

mysql sql self-join

asked 2013-05-22T21:32:39.513

10

votes

5

answers

Automatically Update Values in Database from DataGridView

c# mysql winforms

asked 2013-05-22T07:31:39.767

14

votes

7

answers

MySql count() to return 0 if no records found

mysql sql

asked 2013-05-19T15:43:37.393

9

votes

2

answers

OSCommerce tep_db_input vs tep_db_prepare_input

php mysql oscommerce

asked 2013-05-16T22:13:38.323

12

votes

1

answers

Mysql CREATE DEFINER

mysql stored-procedures

asked 2013-05-16T18:31:28.770

77

votes

6

answers

Counting number of grouped rows in mysql

mysql sql count

asked 2013-05-16T10:06:28.447

8

votes

2

answers

MySQL - How to measure the amount of space used by certain rows?

mysql

asked 2013-05-13T17:04:13.280

14

votes

1

answers

OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on '192.168.129.139' (111)") None None

python mysql sql sqlalchemy

asked 2013-05-09T22:26:57.150

31

votes

4

answers

SQL Error: 0, SQLState: 08S01 Communications link failure

java mysql hibernate jdbc

asked 2013-05-09T10:49:41.583

Questions tagged mysql