I have a slight problem. I am wanting to optimise a set of tables which seem to have been modelled on text based config files (not the wisest idea) for a server application I have to manage.
The table format I want to use is distributed over a couple of different tables which I can link together without much trouble.
The trouble is that the server application wants the data back like this for a specific username:
id, username, attribute, value, op
10, chickens@tempuri.org, Framed-IP-Address, 192.168.1.138, :=
11, chickens@tempuri.org, cisco-avpair, ip:route=192.168.1.1, :=
The lookup is based on the username for the existing database format.
So how can I somehow maybe join up two queries to return two distinct rows of data?
edit: this has to work with MySQL 4.1 btw
The table format I want to use is distributed over a couple of different tables which I can link together without much trouble.
The trouble is that the server application wants the data back like this for a specific username:
id, username, attribute, value, op
10, chickens@tempuri.org, Framed-IP-Address, 192.168.1.138, :=
11, chickens@tempuri.org, cisco-avpair, ip:route=192.168.1.1, :=
The lookup is based on the username for the existing database format.
So how can I somehow maybe join up two queries to return two distinct rows of data?
edit: this has to work with MySQL 4.1 btw
Last edited: