hmm, do the 'show tables;' and 'select * from [TABLENAME];' queries not
work? Because that's how I usually get field info if I don't have a GUI
client.
I'm not sure how it spits out the data but it should be linebroken at least
and there are SQL commands for sort, so theoretically you could copy the
output into a Word doc or something?
(sorry, I worked 'data entry' for nine months which was really 'learn basic
SQL' because the only way you could update more than one item at a time -
say, if we got a new pricelist - was direct SQL queries, so my instinct is
to problem-solve)
no subject
hmm, do the 'show tables;' and 'select * from [TABLENAME];' queries not work? Because that's how I usually get field info if I don't have a GUI client.
I'm not sure how it spits out the data but it should be linebroken at least and there are SQL commands for sort, so theoretically you could copy the output into a Word doc or something?
(sorry, I worked 'data entry' for nine months which was really 'learn basic SQL' because the only way you could update more than one item at a time - say, if we got a new pricelist - was direct SQL queries, so my instinct is to problem-solve)