Questions tagged [mysql]

44

votes

1

answers

What happens if I drop a MySQL column without dropping its index first?

mysql indexing

asked 2010-12-03T02:18:23.020

62

votes

4

answers

Generate ER Diagram from existing MySQL database, created for CakePHP

mysql cakephp mysql-workbench reverse-engineering erd

asked 2010-12-01T16:13:23.347

33

votes

7

answers

Does VARCHAR size limit matter?

php mysql database-design varchar

asked 2010-12-01T13:35:53.170

35

votes

14

answers

How do I get next month date from today's date and insert it in my database?

php mysql date

asked 2010-11-30T21:43:42.037

26

votes

3

answers

Get the number of affected rows in a MySQL update statement?

sql mysql stored-procedures

asked 2010-11-29T17:04:56.833

16

votes

3

answers

How to fix "ERROR 130 (HY000): Incorrect file format"

mysql

asked 2010-11-28T15:50:54.123

16

votes

1

answers

Maximum length for longtext field

php mysql

asked 2010-11-27T23:33:14.920

14

votes

3

answers

How to find Free world city database in mysql

php mysql database

asked 2010-11-27T08:27:03.467

39

votes

6

answers

How to adjust display settings of mysql command line?

mysql command-line

asked 2010-11-26T13:27:03.627

132

votes

3

answers

MySQL IN condition limit

mysql conditional-statements

asked 2010-11-25T09:46:39.800

40

votes

7

answers

SQL UPDATE with sub-query that references the same table in MySQL

mysql sql mysql-error-1093

asked 2010-11-24T15:23:09.743

9

votes

4

answers

MYSQL UNION ORDERING

sql mysql

asked 2010-11-24T14:10:05.780

25

votes

2

answers

MySQL - InnoDB vs MyISAM

mysql

asked 2010-11-22T23:13:33.317

11

votes

4

answers

SELECT INTO OUTFILE can't write to file

mysql sql linux into-outfile

asked 2010-11-22T21:07:21.227

102

votes

2

answers

MySQL & Java - Get id of the last inserted value (JDBC)

java mysql jdbc

asked 2010-11-22T14:49:43.017

161

votes

4

answers

Create an index on a huge MySQL production table without table locking

mysql indexing production alter-table table-locking

asked 2010-11-22T10:57:46.197

11

votes

5

answers

Creating Taxonomy Table in MySQL

sql mysql database taxonomy hierarchy

asked 2010-11-21T21:21:34.727

41

votes

13

answers

How to connect to a MySQL Data Source in Visual Studio

mysql visual-studio-2010 datasource mysql-connector

asked 2010-11-20T22:16:45.107

74

votes

3

answers

What are MySQL database engines?

mysql database storage innodb database-engine

asked 2010-11-20T16:48:44.180

10

votes

3

answers

How to optimize date time search in Mysql?

mysql datetime search

asked 2010-11-20T14:06:16.757

29

votes

3

answers

How to implement a MySQL fulltext search across multiple tables?

mysql full-text-search

asked 2010-11-19T16:09:53.837

247

votes

17

answers

Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in

php mysql database

asked 2010-11-18T21:53:43.287

20

votes

4

answers

phpMyAdmin showing negative total records for a database table

mysql phpmyadmin

asked 2010-11-17T13:56:35.640

97

votes

6

answers

How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE

mysql csv

asked 2010-11-17T08:14:18.007

10

votes

1

answers

How to make innodb as default engine

mysql innodb

asked 2010-11-16T21:58:00.233

11

votes

1

answers

Rails 3 - Eager loading with conditions

mysql ruby-on-rails rails-activerecord

asked 2010-11-16T18:07:45.243

13

votes

1

answers

How to display all the tables with more information (create date, size,...) in a MySQL database?

sql mysql

asked 2010-11-16T17:23:46.663

84

votes

3

answers

Best way to code Achievements system

php mysql database design-patterns

asked 2010-11-16T09:26:10.087

11

votes

7

answers

SQL: select all unique values in table A which are not in table B

sql mysql

asked 2010-11-15T16:05:23.657

10

votes

2

answers

Product Naming Algorithm

php mysql html algorithm

asked 2010-11-15T07:12:02.050

9

votes

4

answers

MySQL: How does groupby work on columns without aggregate functions?

mysql group-by

asked 2010-11-14T17:57:04.167

51

votes

8

answers

Remove duplicates in list of object with Python

python mysql sqlobject

asked 2010-11-12T21:36:39.563

12

votes

1

answers

Increment field value on REPLACE

mysql

asked 2010-11-11T10:07:50.250

11

votes

4

answers

query sql convert text field dd/mm/yyyy to date field yyyy-mm-dd

mysql date

asked 2010-11-10T10:31:16.867

208

votes

9

answers

SQL UPDATE all values in a field with appended string CONCAT not working

sql mysql concatenation

asked 2010-11-08T21:41:29.197

15

votes

3

answers

In a database, when should you store derived data?

mysql normalization

asked 2010-11-08T19:06:40.360

50

votes

7

answers

MySql, combining date and time column into a time stamp

mysql datetime time timestamp

asked 2010-11-08T16:42:22.727

16

votes

7

answers

How to migrate stored procedures to testing db?

mysql ruby-on-rails-3 testing stored-procedures

asked 2010-11-05T17:42:27.857

30

votes

5

answers

How to create a ssh tunnel in ruby and then connect to mysql server on the remote host

mysql ruby ssh

asked 2010-11-05T05:36:45.707

143

votes

11

answers

How to annotate MYSQL autoincrement field with JPA annotations

java mysql orm jpa annotations

asked 2010-11-04T23:51:10.143

22

votes

6

answers

How update a database table record in Zend?

php mysql sql zend-framework zend-db

asked 2010-11-04T13:43:22.570

21

votes

6

answers

MYSQLi error: User already has more than 'max_user_connections' active connections

php mysql error-handling mysqli

asked 2010-11-02T15:58:33.690

11

votes

5

answers

Auto increment feature in Database

asp.net mysql sql-server database sql-server-2005

asked 2010-11-02T07:16:26.637

65

votes

5

answers

MySQL unknown column in ON clause

sql mysql mysql-error-1054

asked 2010-11-01T00:48:10.530

95

votes

4

answers

How to deal with an apostrophe while writing into a MySQL database

php mysql mysql-error-1064

asked 2010-10-30T02:00:09.870

46

votes

2

answers

What does the number in parenthesis really mean?

mysql sql ddl

asked 2010-10-29T20:16:18.017

11

votes

5

answers

MySQL implementation with CUDA

mysql database cuda

asked 2010-10-28T21:31:50.027

9

votes

3

answers

MySQL Foreign Key Constraint - Integer Column

sql mysql foreign-keys

asked 2010-10-28T20:01:03.113

16

votes

8

answers

SQLAlchemy JSON as blob/text

python mysql database sqlalchemy

asked 2010-10-27T22:41:17.280

10

votes

2

answers

Interval datatype in MySql

mysql types

asked 2010-10-27T21:11:28.003

Questions tagged mysql