Description:
MySQL RDBMS technical discussions.
|
|
|
Column naming standard – general opinions
|
| |
Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use lower-case letters with words separated for emphasis using the underscore character, for example: customer_num, employee_id, invoice_line, transaction_code... more »
|
|
SELECT * INTO OUTFILE fails if file exists
|
| |
Dear Newsgroup MYSQL won't overwrite an existing OUTFILE. How can I programmatically delete the OUTFILE? Is there a way to make the SELECT...OUTFILE overwrite the OUTFILE? Regards scooper
|
|
Multilingual Development (with PHP)
|
| |
Hi all, I'm currently attempting to prepare my site for the possibilities of multilingual support in the future. For translations between different languages, I tend to use some sort of implementation such as Zend_Translate, which allows the user to set their language, and then using a text-based file for the appropriate language, a PHP wrapper... more »
|
|
select `Field` from show columns?
|
| |
How come this query doesn't work? SELECT `Field` FROM ( SHOW COLUMNS FROM Cards ) AS alias I don't want all the columns that SHOW COLUMNS returns, just `Field`.
|
|
Link table to external CSV
|
| |
Morning all, Is it possible to create a table in Mysql that "links" to an external CSV file? I have found a couple of mentions to a CSV Engine - but cannot find any basic "newbie" information. thank you richard
|
|
Evaluate EXPLAINs automatically
|
| |
Dear community, for my application I would like to write a piece of code that automatically runs EXPLAIN queries for all regular queries I send to the database. Technically I know how to do this but my question is how I can let my code determine whether an EXPLANE result is good or bad. What are the main indicators I can use for that?... more »
|
|
Move datadir to different server
|
| |
Hi, I want to move the datadir of mysql to a different server because I'm planning to run it as a cluster later and separate it from the data for more security. But at the moment there are only two servers, the one I installed mysql on and another one which I want to hold the data. How can I move the datadir to the 2nd server? (They're both runnung... more »
|
|
|