![]() ![]() insert inot table_name values(value1,value2,value_n) 6.After without any error creating table you need for feel the some data in that table then go for insert statement.Įx.*note :- this Friends table belong to M圜ircle database. create table Friends(ID integer primary key autoincrement, Name varchar(60), Age int) create table Table_Name(field_name1, type, field_name2 type,fild_n type_n) (After writing query must and should semicolon required otherwise execution time you get output like…>)Įx. after if u create successful database then required to go for create the table for storing and manage the data.Įx. databases command you can show the list of databases. *note: you can give extension of your database file as. ![]() ![]() for your understanding purpose i create database name as M圜ircle. type the command “SQlite3 database_name.sqlite” and press enter. then type the command CD Desktop (semicoln not require). 2.First select the location where you want save your database file.or in the Menu go on Application -> Terminal. Using spolight(press the cmd+space) search the terminal, Terminal its a default editor avilable in mac. Q.41 How to create SQLite3 database using mac Terminal.? Ans:.
0 Comments
Leave a Reply. |