mysql export Thread

Hello Chaps.

I'm having a issue exporting a column from a mysql table, i need a specific column as i need to use the field then run a replace query on them, the current export is only doing the whole sheet, with one line per row, with all the column details in the first row of the exel document.

I need the first row and column to just consist of the url column from the table, any ideas?

Aaron

So if I get you right you are looking to export a single colon from an excel sheet into CSV or SQL? Or do you need to query a single colon from an SQL DB table?

The latter my good sir.

Well, to get a single colon from an SQL DB table you simply use the SELECT command similar to this:
SELECT colonName FROM tableName;

What you did is most probably selecting all colons which would:
SELECT * FROM tableName;

You can also filter while export:
SELECT colonName FROM tableName WHERE colonName = value;

Or sorting:
SELECT colonName FROM tableName WHERE colonName = value ORDER BY colonName {ASC|DESC};

Replace by itself you can do directly in the DB without any export. Would look something like this:
UPDATE tableName SET colonName = value WHERE condition;

That is if you plan to set the same value to all colons matching your condition.

How the export looks like though depends on your DB client. I hope I understood correctly what you are looking for. Otherwise just ask again.

ok next issue, got the exports sorted but i need to sort the table data so each line matches with the correct url
if the line goes to another url it wont work, a to z sorting doesnt work, any thoughts?

Sorting works from inside Excel as well as from inside the DB. In Excel just select all lines (and all columns containing data) and use the sort feature. The program keeps lines together while sorting. In the DB just use the ORDER BY clause as mentioned above. This keeps also the lines together.

i have the two table sets but the urls differ so its not sorting it 1-1
My original idea was to export the url data, then find and replace all the old url data with the new stuff and export it, however i need 2 corresponding columns of information, i have them, but they need to match each other.

So if I get this right you've got two tables let's say A and B with each having an url somewhere (let's say A.url and B.url). You want to merge-sort them. Assuming there is a property A.link and B.link that match each other you can do this using a JOIN clause. This would look like this:

SELECT * FROM A INNER JOIN B ON ( A.link = B.link ) ORDER BY A.url ;

The INNER JOIN simply creates a new temporary table out of table A and B linking rows where A.link matches B.link . The ORDER BY applies then to the joined table and delivers the result you want.