Top "Mysql" questions

Create mysql table directly from CSV file using the CSV Storage engine?

I just learned that MySQL has a native CSV storage engine which stores data in a Comma-Separated-Value file per table. …

mysql database csv storage-engines

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause? CREATE TABLE `foo` ( `…

mysql timestamp mysql-error-1293

MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777

Any ideas? SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*…

mysql mysql-error-1045 into-outfile

How can I append a string to an existing field in MySQL?

I want to update the code on all my record to what they currently are plus _standard any ideas? So …

sql mysql string

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

Possible Duplicate: How to get the insert ID in JDBC? Hi, I'm using JDBC to connect on database through out …

java mysql jdbc

MySQL: How to copy rows, but change a few fields?

I have a large number of rows that I would like to copy, but I need to change one field. …

sql mysql

SQL split values to multiple rows

I have table : id | name 1 | a,b,c 2 | b i want output like this : id | name 1 | a 1 | b 1 | c 2 | b

mysql sql delimiter delimiter-separated-values

How to delete mysql database through shell command

I use the pylons and sqlalchemy. I constantly update the schema files and delete and recreate the database so that …

mysql database linux shell ubuntu

Get top n records for each group of grouped results

The following is the simplest possible example, though any solution should be able to scale to however many n top …

mysql sql greatest-n-per-group mysql-variables

Count the number of occurrences of a string in a VARCHAR field?

I have a table like this: TITLE | DESCRIPTION ------------------------------------------------ test1 | value blah blah value test2 | value test test3 | test test …

mysql sql