-1

I'm using below query to fetch data from tables.

SELECT * FROM TABLE_NAME LIMIT 10 OFFSET 0;

but the result seems to have headers with it, how to get rid of those headers.

Thank you

Slawomir Cieslinski
  • 625
  • 5
  • 14
Pyd
  • 6,017
  • 18
  • 52
  • 109
  • what exactly are you trying to achieve? – Jester Jul 20 '17 at 08:36
  • @jester, want to pull records without headers using OFFSET – Pyd Jul 20 '17 at 08:39
  • its for partitioning of data first 1000 records in one array (i.e 1 -> 1000) and next 1000 records in another array like (1001 -> 2000). – Pyd Jul 20 '17 at 08:42
  • @vignesh. Refer https://stackoverflow.com/questions/16101495/how-can-i-suppress-column-header-output-for-a-single-sql-statement – Kaushik Nayak Jul 20 '17 at 08:51
  • Please show us sample data which includes the "header" which you want to remove. – Tim Biegeleisen Jul 20 '17 at 08:52
  • @TimBiegeleisen, `SELECT * FROM TABLE LIMIT 1 OFFSET 0` output is like `| EMPLOYEE_ID | first_name | last_name | Primary_email | secondary_email | gender | ip_address | Primary_NO | Secondary_No | Pincode | | P00100001 | Donald | Harrison | Destinee_Schiller@brandyn.us | gharrison0@booking.com | Male | 32.69.240.244 | 1-(216)488-8819 | 1-(573)770-6641 | 15 | 34 |` I have copied only few columns the table has 150 columns. – Pyd Jul 20 '17 at 08:55
  • 1
    OK your header labels should NOT be in the table. Reimport your data and don't use the first line. I am scared to even ask what the types of each column ended up being. – Tim Biegeleisen Jul 20 '17 at 08:59

1 Answers1

1

Delete the first row containing the header data and you are good to go

delete from TABLE_NAME where id=1;

am assuming the first row has the header information

indago
  • 2,041
  • 3
  • 29
  • 48