Try either .table
or SELECT tbl_name FROM sqlite_master WHERE type='table'; -tk On Mon, Jan 21, 2019 at 4:54 AM Cycle London <[email protected]> wrote: > Hi Andrew, > > Please forgive me, I'm not being deliberately thick, and I'm not trying to > annoy anyone. Tried the above - even tried to remove the space between > the command the semicolon, just in case sqllite handled white space > differently than MySQL ... > > [cyclellondon@weather ~]$ sqlite3 archive.sdb > SQLite version 3.7.17 2013-05-20 00:56:22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> show tables ; > Error: near "show": syntax error > sqlite> show tables; > Error: near "show": syntax error > > On Mon, 21 Jan 2019 at 12:50, Andrew Milner <[email protected]> > wrote: > >> you are being very obscure >> >> SQLite only has one database in use at one time - the one you open >> >> usage - eg - sqlite3 archive.sdb >> >> then you can >> show tables; >> >> >> >> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote: >>> >>> CHeers. Those links aren't really clear. Maybe i'm too old. Or too >>> dim. >>> >>> Anyway, time to gird my loins, snapshot the VM .. and just do it. >>> >>> On Mon, 21 Jan 2019 at 10:42, gjr80 <[email protected]> wrote: >>> >>>> Regards transferring from SQLite to MySQL have you ready through the >>>> Transfer from SQLite to MySQL page of the wiki ( >>>> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL) >>>> and the Configuring MySQL section of the User's Guide ( >>>> http://weewx.com/docs/usersguide.htm#configuring_mysql) ? >>>> >>>> Those two areas have about everything you need for the transfer. >>>> >>>> Gary >>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "weewx-user" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
