Hi,
I want to create a sql database where there should be three coloumns date, check, info and topic how to make this, i don’t know how to use this component
Ok then u have to use sql query block
And run a query
CREATE TABLE data (
Id int not null primary key,
Date DATE,
Check Text,
Info Text
) ;
Id is a unique number for every record
Date check and info are coloumns
U can also set logic to aut increment in id for every new record
By following query
CREATE TABLE data (
Id int not null Auto_Increment primary key,
Date DATE,
Check Text,
Info Text
) ;
So this will be in the coloumns paramter?
1 Like
Read above i have updated my post
After running the above query your table willbbe created where
Id is an integer number
Info is a text
Date is a date data type
And check is also a text datatype
edit
After table creation u can put data into tables columns by insert queries
Seee manual of sql queries by searching on Google u can aslo use SoloLearn app for basics of sql
but where’s the id parameter, and what about the other parameter?
No… Actually all of the parameters are set by you… To set these parameters
Use single query block
And the block u share here is to get data from database
Wait i’ll send you a complete documentation of how to use thia component
ohh so you are telling to use this block
and first i need to create a table and then using this block i can add values 
Exactly m talking about this block
See here… here is the complete documentation with aia of this component
Originally it was an extension but later on it was added in kodular as a component
See here SQLite extension (SPONSORED!)
Can’t open this link
I updated the lnk
And how can i detect whether I’m entring duplicate row like the same values for all three coloumns?
1 Like
For this you can search that this is already present in any row
Like get id of row where info text = your text
note its not the exact query
U can search for the proper query by googling
Like queries for search an item in sql somthing like this
U can use
Select From table_name where ‘info’ = place your text here ;
If you get value then its mean that data is already present if not get value then u can add new data
Evaluate this logic according to your situation
1 Like
ok will try and tell you
1 Like
The data are stored in tables. Tables are made up of rows and columns. Each column must have a name and type. Name should represent the contents of that column (name, age, telephone number, date of birth) and the type of column is to standardize the information that the column will store (string, number, date …) The line represents a unit of the recorded information in the table. So when you write Name = Rogerio Rios, Data = 08/08/80 and Telephone = 897567899 you will add 1 line in the table. As in Excel … To search for information, we use the Select Command. You select the fields (columns) you want (vertical filtering - columns) and filter by name or date of birth (horizontal filtering - lines) …
2 Likes
You don’t get in line. You either create a line with Insert Into or search for the line, and edit the column values with Update.
1 Like
And for not equal to is it != ?
