SQL Tutorial - 7: Data-Types in SQL (Part-2)

Показать описание

In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.

Рекомендации по теме

Комментарии

bro u teaching me better than the university prof i'm paying to teach me. hands down for your patience, technology may change over time but we need more people like you sharing information free and effectively.

minagan

Tanks Madhur, Your tutorials very useful for me.
thank you very much.
(Zack - Indonesia)

rozaq-sa

Nice English with nice knowledge .thanks thank you very much

skdonsingh

Good Job...

Thanks a lot for the tutorials.

TuhinShaikh

thanks madhur, well explained about difference between char and varchar.

varanasiteja

Hi Madhur. For the numeric datatypes, I typically use integer for everything, no matter the size. Does it matter to overall database performance to try to pick the most accurate?

MoniqueBoea

Do you know telugu sir. I speak little bit english can you teach me sir.

darlingdhana

hey ! I just stored an image in my database using the blob datatype.. now when i try to retrieve it in matlab i am not able to.. while i can retrieve all other information present in my table but not the image.. can u provide some guidance relating to this?

sanjumadesha

can you put a link for the slides u r using in the videos?

yasmeenkhaled

HI Madhur,
I am using SQL server.
Can you pls let me know how to add alphanumeric character into a column.
which datatype has to be used while creating the table?
I tried using VARCHAR datatype, but got an error while inserting DATA(O123) into the table.

bharathkumarreddy

HI,
I have installed Microsoft SQLExpress. there after i dont what to click where to click to get SQL command prompt
pls guide me

sarannaren

Why use char at all if it wastes space compared to varchar?

dschiff

How to change the date format to dd mm yyyy

tamalikaroy

insert into emp
values(100, 'steven', 'king', 'sking', '1987-06-17', 'ad_pres', 24000, 3);
sir i inserted like this but it is not executing pls help in oracle i did

rashuankala

SQL Tutorial - 7: Data-Types in SQL (Part-2)

SQL Tutorial - 7: Data-Types in SQL (Part-2)

MySQL 24 - Important Data Types

SQL Server Tutorial - Understanding data types

8- Datatypes in SQL | SQL Datatype | String | Numeric | Character | DateTime | | Interview Questions

Inserting Data - SQL - Tutorial 7

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

create table as select in MySQL database #shorts #mysql #database

3 AI SQL Tools #sql #ai #dataanalytics

SQL Handson 16: System Information Functions -SQL Project #sqltutorial #dataanalytics #SQL

Basic SQL commands #viral #youtubeshorts #study #shorts

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

How to find the Nth record from the sql table #sql #sqlqueries #sqlserver #coding #shorts

Fastest Way To Learn SQL

T-SQL - Data Types

Types of operators in Python #python #operator #type

SQL database tutorial: relational database, schema, table, SQL data types, SQL constraints, RDBMS

Simple SQL code || Structured Query Language || SQL || RDBMS #programming

SQL Data Types: Data Science Code

SQL Quiz-1 | SQL Tutorial for Beginners

SQL Tutorial - 6: Data-Types in SQL (Part-1)

SQL data types you should know! #sql #mysql #datatypes #ivyproschool

SQL Telugu Tutorial: SQL Functions (Sum Function) SQL Tutorial For Beginners Telugu, My SQL, MSSQL

SQL Tutorial for Beginners, SQL Operators, (Is NULL, Is Not NULL), SQL Telugu Tutorial, MySql, DBMS

Data Analyst SQL Interview Question | Window Functions | Moving Average #sqlinterview #dataanalysis