I am running the following script to INSERT rows into one table and DELETE rows from another table. However, it is only inserting 1 row, while deleting ALL the rows…

How can I change this so that it inserts ALL the rows and deletes ALL the rows… I am basically moving rows from one table…

Hello, I want to export a mysql table to excel files and if not to csv, the problem with excel is it gives me data on one line, so I transformed it to csv and it works, the problem is it does not read arabic data

header( ‘Content-Type: text/csv; charset=utf-8; encoding=UTF-8′ );…

Hello everyone,

I have a pdf file in which there are about 1700 pages each page contains about 7 records and each record contains the following data:

company_name,
address_line_1,
address_line_2,
telephone,
fax,
email,

Dear friends,
I need an opensource application for “discussion forum” in php with mysql database. Is anybody can give any link/source will be appreciated please.

I tried sqlSave() in RODBC, but it runs super slowly. Is there an alternative way of doing this?

Thanks in advance

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I want to know the instruction to start from command-line.
I do as follow:

After

su root

I start the mySQL server by command-line, it produce error as below:

sh-3.2# /usr/local/mysql/bin/mysqld

111028 16:57:43 [Warning] Setting lower_case_table_names=2 because
file system for /usr/local/mysql-5.5.17-osx10.6-x86_64/data/ is case
insensitive

111028 16:57:43 [ERROR] Fatal error: Please read “Security” section of
the manual to find out how to run mysqld as root!

111028 16:57:43 [ERROR] Aborting

111028 16:57:43 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

Please help me!

I have a telephones database table with 4 columns:

countrycode
areacode
phonenumber
extension

I’m following the “Canonical” formatting, since I have some international numbers to consider.

And as fate would have it, some numbers entered have extensions.

I have a query that I use to auto-format everything, except the extension:

SELECT CONCAT('+',`countrycode`,'(',`areacode`,')', `phonenumber`) AS `fullnumber` ...

result: +1(123)4567890 or: +61(08)1234 1234
This works great, and it works perfectly with some dialer software I export to.

However, I now need to include the extension in this query. However, I need to auto-format it like so:

+1(123)4567890 x123

That’s rather easy, but since most numbers do not have an extension, I need to make a condition that will include the char (x). And this is my dilemma, since I’m still learning conditional statements in a query.

Anybody work with weird if/else statements inside a CONCAT?