Member Avatar for lskoyles

I am new to SQL and am having a few simple problems that i cannot find solutions to on the web. Firstly I was wondering if there is any simple SQL command that will find the column names of a table. All sql tutorials seem to already know this. It is quite simple to do this using another database for the column names but this seems to be a clumsy solution.

Also I am using perl cgi scripts with the DBI module and the CSV type of database. Most SQL commands work with my code perfectly however a few random keywords and commands do not (such as auto_increment and ALTER TABLE) Is this a result of using CSV databases because of their extreme simplicity or is there something more sinister at work?

thanks so much

Liam Skoyles

  • 2 Contributors
  • 1 Reply
  • 168 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by campkev
Member Avatar for campkev

for the first sp_tables. For the second, I have no idea

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.