How to use the sql db component

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

component_method (3)
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
image

and first i need to create a table and then using this block i can add values image

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 != ?

Yes…it is
But m not sure it it works or not @Rogerio_Rios may confirm it

I can’t add this block to any of the conditions it is not attcaching