Comments - Getting Help With MariaDB

1 year, 4 months ago Daryl Lee

I have a simple script that produces a simple table output;

MariaDB [nation]> source script.sql
+-----------+------------+-----------+
| name      | area       | region_id |
+-----------+------------+-----------+
| India     | 3287263.00 |         2 |
| Kazakstan | 2724900.00 |         2 |
+-----------+------------+-----------+
2 rows in set (0.000 sec)

But when I run it from the command line, I get this:

$mariadb -u root -pxxxxxxxx nation < script.sql
name	area	region_id
India	3287263.00	2
Kazakstan	2724900.00	2
[daryl@tigger sqltut]

Are there command line optons or script-level commands I can use to produce the tabular output?

 
1 year, 4 months ago Daryl Lee

Problem solved. The -t command line option is what I was looking for.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.