How does data work

[someone learning code]

all i know about data is that there is columns and rows like below, and when you search for something for example height of 20cm it will show row 1 and 2 but i don't understand how to save the data, where to save it, what code you use to save it or how to filter through the data from code.
if anyone could explain it to me it would help a lot.

row	Height	Length	Width
1	20cm	20cm	15cm
2	20cm	12cm	14cm
3	60cm	16cm	28cm

 

[Johna]

Are you talking about databases?

If using a relational database (which I assume you are referring to because you included a table), you'll probably have to use SQL.

So to select all rows from the table where the height is 20cm, do something like this (assuming the table name is Dimensions):

SELECT * FROM Dimensions
WHERE Height = "20cm";

 

[JosiahMaybe]

From like my limited knowledge of databases, you will also need a backend language like C, PHP, or Node.js Javascript. Things may depend on what type of database you are using. According to what I know there are normally primary keys and secondary keys. Primary keys are like main identifiers for that thing in database. Other things may be found by either searching by primary keys or for data directly. I am kind of a layman myself but maybe this helps.
X E.

 

[someone learning code]

Are you talking about databases?

If using a relational database (which I assume you are referring to because you included a table), you'll probably have to use SQL.

So to select all rows from the table where the height is 20cm, do something like this (assuming the table name is Dimensions):

SELECT * FROM Dimensions
WHERE Height = "20cm";

do i just use notepad or excel to save data or are there better places to use

 

[Antero360]

do i just use notepad or excel to save data or are there better places to use

Depends on what your application needs are. Sure, you can store data in a text file, in JSON format. Sure, you can excel sheet. Sure, you can use languages like SQL/MySQL to store the data in a relational database. The question here is: What is the right database for my application? What database will make things easier for my application? What are the limitations, if any, to keep in mind? What are the security risks of using this database over another?