Gossamer Forum
Home : Products : Gossamer Links : Discussions :

SQL - change of rows in MySQL

Quote Reply
SQL - change of rows in MySQL
Hi all,
shure you know the situation:
You have such new fields and need a new one to add.
But you want it on another position; e.g. you have
Text
Comment

Pic1
Pic2

Comment from Admin <--- The new one.

And i want to group the fields together;
Text
Comment
Comment from Admin

Now i can change the pos in the links.def; but after a resync
the positions change back.

So what i need is a way or a tool to change the position of cols in MySQL.
Shure i could get the defs and content with phpmyadmin, change them and pass it back.
But the problem is the data, i cant change some hundreds of links per hand.

Any idea, how to do that?
Robert
Quote Reply
Re: [Robert] SQL - change of rows in MySQL In reply to
OK, i got it. Instead of add a new field with Links, i do it with phpMyAdmin; then i could choose where the field should be entered;
then resync ...
Robert