Re: executing an SQL statement

[Randy Clamons]

Lois,

What I found is that SELECT ... INTO OUTFILE filename.txt by default adds a tab between columns. It should still line up, but the columns will be wider than expected. Here's a statement that produced columns from my table:

SELECT
  RPAD(`id` ,20,' '),
  RPAD(`userid` ,20,' '),
  RPAD(`itemid` ,20,' '),
  RPAD(`datetime` ,20,' '),
  RPAD(`time`,20,' ') ,
  RPAD(`maxbid`,20,' '),
  RPAD(`amount` ,20,' '),
  RPAD(`bidnotes`,100,' ')
INTO OUTFILE 'C:\\tmp\\bids.txt'
fields terminated by ''
FROM bids

The delimiter is an empty string. The first five columns are integers, then next 2 are decimal (10,2), the last column is varchar(100). Notice the varchar column is last.

I hope this helps.