How can I suppress column header output for a single SQL statement?

by

Invoke mysql with the -N (the alias for -N is --skip-column-names) option:

mysql -N ...
use testdb;
select * from names;

+------+-------+
|    1 | pete  |
|    2 | john  |
|    3 | mike  |
+------+-------+
3 rows in set (0.00 sec)

Credit to ErichBSchulz for pointing out the -N alias.

To remove the grid (the vertical and horizontal lines) around the results use -s (--silent). Columns are separated with a TAB character.

mysql -s ...
use testdb;
select * from names;

id  name
1   pete
2   john
3   mike

To output the data with no headers and no grid just use both -s and -N.

mysql -sN ...

More Related Contents:

  1. Which ORM should I use for Node.js and MySQL? [closed]
  2. What does it mean by select 1 from table?
  3. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  4. Can’t connect to RDS instance from EC2 instance
  5. How can a query multiply 2 cell for each row MySQL?
  6. Incorrect integer value: ” for column ‘id’ at row 1
  7. apache mysql – “packets out of order” on 3306
  8. find number of rows in returned mysql result (nodejs)
  9. What is difference between storing data in a blob, vs. storing a pointer to a file?
  10. How to estimate SQL query timing?
  11. Rails select random record
  12. mysql select distinct rows into a comma delimited list column
  13. Access mysql running on localhost from minikube
  14. MySQL fulltext search – Only results that contain all words
  15. How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?
  16. mysql UPDATE statement – overhead for same values?
  17. Select from same table as an Insert or Update
  18. How do I limit the number of rows per field value in SQL?
  19. MySQL: Left join and column with the same name in different tables
  20. Disadvantages of quoting integers in a Mysql query?
  21. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  22. How do I add more members to my ENUM-type column in MySQL?
  23. How to get mysql random integer range?
  24. How to find nearest location using latitude and longitude from SQL database?
  25. Are Users ‘User’@’%’ and ‘User’@’localhost’ not the same?
  26. MySql – Update table using select statment from same table
  27. Optimizing MySQL for ALTER TABLE of InnoDB
  28. MySQL: SELECT from another server
  29. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?
  30. How to allow fulltext searching with hyphens in the search query

Leave a Comment