Questions tagged [mysql]

57

votes

2

answers

How to insert utf-8 mb4 character(emoji in ios5) in mysql?

asked 2011-10-18T22:03:36.477

32

votes

2

answers

MySQL: ERROR 1227 (42000): Access denied - Cannot CREATE USER

mysql

asked 2011-10-17T17:49:50.410

22

votes

2

answers

Error reading text file in php

php mysql

asked 2011-10-17T01:02:06.210

10

votes

5

answers

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

mysql innodb master-slave

asked 2011-10-16T07:02:43.897

20

votes

3

answers

Store list of values (such as interests)

mysql list database-design

asked 2011-10-14T10:24:34.960

28

votes

4

answers

MySQL select rows from exactly 7 days ago

php mysql intervals

asked 2011-10-13T15:39:02.197

103

votes

1

answers

varchar(255) vs tinytext/tinyblob and varchar(65535) vs blob/text

mysql

asked 2011-10-13T14:24:30.743

15

votes

4

answers

Mysql - connect to remote server using IP address

php mysql

asked 2011-10-13T13:21:24.610

27

votes

5

answers

Illegal mix of collations for operation 'concat'

mysql sql

asked 2011-10-13T11:46:20.850

10

votes

5

answers

Is it possible to insert a new row at top of MySQL table?

mysql

asked 2011-10-13T11:38:54.687

9

votes

9

answers

Inserting a multi-dimensional php array into a mysql database

php mysql multidimensional-array

asked 2011-10-12T21:18:07.480

9

votes

2

answers

How can I override the ENGINE=INNODB parameter while importing a MySQL dump file?

database import innodb mysql

asked 2011-10-12T12:07:53.610

9

votes

3

answers

MySQL event scheduler in XAMPP

mysql configuration xampp

asked 2011-10-11T14:03:53.970

15

votes

2

answers

Online/Offline Database Synchronization - MySQL/PHP

php mysql synchronization

asked 2011-10-11T07:26:52.720

8

votes

6

answers

How to instruct Rails to generate the correct SQL on uniqueness validation when case insensitive

mysql ruby-on-rails

asked 2011-10-10T13:48:21.223

11

votes

2

answers

Mysql Datediff query

mysql sql date time datediff

asked 2011-10-10T12:22:50.667

12

votes

8

answers

left join returning more than expected

mysql sql

asked 2011-10-10T10:20:51.087

24

votes

7

answers

Is there a way to ignore columns that don't exist on INSERT?

mysql sql

asked 2011-10-09T14:50:31.933

25

votes

4

answers

Storing image files in Mongo database, is it a good idea?

mysql mongodb file database

asked 2011-10-09T13:37:24.163

19

votes

8

answers

MySQL How to SELECT data from table which recorded today?

php mysql datetime select

asked 2011-10-07T05:13:17.883

32

votes

5

answers

How many tables can be created in a MySQL database?

mysql sql

asked 2011-10-05T05:11:51.777

10

votes

1

answers

MySQL datetime: insert a date with timezone offset

mysql datetime date

asked 2011-10-04T16:57:34.900

9

votes

2

answers

Removing duplicate results while using UNION SELECT

mysql select group-by

asked 2011-10-03T20:42:06.583

10

votes

3

answers

Getting and ordering rows with value greater than zero then rows with value zero

mysql sql

asked 2011-10-03T07:09:41.593

14

votes

8

answers

load data local infile ERROR 2 file not found

mysql load

asked 2011-10-02T01:08:56.030

15

votes

1

answers

Unable to drop database due to illegal character

mysql sql-drop

asked 2011-10-01T06:23:40.837

71

votes

2

answers

How to execute a .sql script from bash

mysql database linux bash

asked 2011-09-30T22:00:30.997

54

votes

6

answers

How to change MySQL timezone in a database connection using Java?

java mysql jdbc timezone

asked 2011-09-30T04:29:08.357

168

votes

7

answers

How do I select an entire row which has the largest ID in the table?

mysql sql

asked 2011-09-30T00:47:22.557

33

votes

4

answers

Am I Using JDBC Connection Pooling?

java mysql jdbc jakarta-ee connection-pooling

asked 2011-09-29T03:13:37.763

12

votes

2

answers

Amazon Web Services + ASP.NET MVC 3 + MySql

mysql asp.net-mvc-3 amazon-web-services appharbor

asked 2011-09-29T00:06:20.820

24

votes

4

answers

MySQL Left Join + Min

mysql group-by left-join greatest-n-per-group min

asked 2011-09-28T18:58:21.213

9

votes

2

answers

Logging only insert, update and delete mysql queries

mysql logging

asked 2011-09-28T17:17:38.517

27

votes

6

answers

Unable to create table in MySQL using Doctrine and Symfony2

mysql symfony doctrine-orm

asked 2011-09-27T07:18:46.473

11

votes

2

answers

Using chardet to detect bad encoding in a MySQL db with JDBC

java mysql scala jdbc

asked 2011-09-26T22:28:08.953

9

votes

4

answers

Two queries faster than than one?

mysql performance optimization

asked 2011-09-26T14:03:31.093

27

votes

2

answers

How to select last 3 minutes' records from MySQL with PHP

php mysql

asked 2011-09-26T09:49:50.103

40

votes

1

answers

What type would you map BigDecimal in Java/Hibernate in MySQL?

java mysql hibernate numbers bigdecimal

asked 2011-09-26T03:15:13.223

14

votes

1

answers

Mysql Server 5 vs 6 vs MariaDB

mysql mariadb

asked 2011-09-25T17:11:29.787

10

votes

3

answers

MySQL - Views - Super slow query

mysql sql view query-optimization

asked 2011-09-24T03:54:22.373

70

votes

2

answers

skip copying to tmp table on disk mysql

mysql sql

asked 2011-09-23T16:48:23.953

9

votes

1

answers

List and Linq To Sql Performance Issue

mysql sql linq-to-sql list linq-to-entities

asked 2011-09-23T07:58:57.257

20

votes

2

answers

MySql Foreign keys: ON DELETE NO ACTION behavour - how to leave info in referenced field?

mysql foreign-keys

asked 2011-09-22T08:00:19.143

15

votes

1

answers

MySQL in-operator must match all values?

mysql in-operator

asked 2011-09-21T18:50:23.003

15

votes

2

answers

How get the sum for every distinct value in another column?

mysql sql database

asked 2011-09-18T21:43:01.163

19

votes

4

answers

MySQL - How to store AES_Encrypted data?

php mysql security encryption aes

asked 2011-09-18T14:05:39.773

94

votes

10

answers

MySQL data directory location

mysql macos installation

asked 2011-09-18T02:23:51.263

16

votes

4

answers

Escaping user input from database necessary?

php mysql escaping sql-injection user-input

asked 2011-09-16T07:53:30.783

9

votes

2

answers

Full text search ranking

mysql full-text-search

asked 2011-09-16T00:04:40.060

14

votes

1

answers

Is there a way to add a column into an existing view in mysql?

mysql database view

asked 2011-09-15T21:50:42.063

Questions tagged mysql