IMG-LOGO

Tutorial

IMG
INT Data Type in MySql
04 Jan-2021

 

In MySQL, INT stands for the numbers that's a entirety number. An numbers can be composed without a fragmentary component e.g., 1, 100, 4, -10, and it cannot be 1.2, 5/3, etc.

An numbers can be zero, positive, and negative. MySQL bolsters all standard SQL numbers sorts Numbers or INT and SMALLINT. In expansion, MySQL gives TINYINT MEDIUMINT, and BIGINT as expansions to the SQL standard. MySQL INT information sort can be marked and unsigned.

The taking after table outlines the characteristics of each numbers sort counting capacity in bytes, least esteem, and most extreme esteem.

 

Type 

Storage

Minimum Value

Maximum Value

 

(Bytes)

(Signed/Unsigned)

(Signed/Unsigned)

TINYINT

1

-128

127

   

0

255

SMALLINT

2

-32768

32767

   

0

65535

MEDIUMINT

3

-8388608

8388607

   

0

16777215

INT

4

-2147483648

2147483647

   

0

4294967295

BIGINT

8

-9223372036854775808

9223372036854775807

   

0

18446744073709551615

 

MySQL INT with the show width attribute MySQL gives an expansion that permits you to indicate the show width alongside the INT datatype. The show width is wrapped interior brackets taking after the INT catchphrase e.g., INT(5) indicates an INT with the show width of five digits.

 

It is vital to note that the show width property does not control the esteem ranges that the column can store. The show width trait is regularly utilized by the applications to arrange the numbers values. MySQL incorporates the show width trait as the metadata of the returned result set.

 

 

MySQL INT with the ZEROFILL attribute in expansion to the show width trait, MySQL gives a non-standard ZEROFILL quality. In this case, MySQL replaces spaces with zero. Consider the taking after illustration.

Example :

 

CREATE TABLE products ( product_id INT AUTO_INCREMENT PRIMARY KEY, product_text VARCHAR(255) );

 

First, create a table named zerofill_test :

 

 
CREATE TABLE zerofill_test( id INT AUTO_INCREMENT PRIMARY KEY, v1 INT(2) ZEROFILL, v2 INT(3) ZEROFILL, v3 INT(5) ZEROFILL );

Second, insert a new row into the zerofill_test table.

 
INSERT INTO zerofill_test(v1,v2,v3) VALUES(1,6,9);

 

News

IMG
iPhone 13 series is expected to launch in September
News 17 Jul-2021

iPhone 13 series is expected to launch in September year and expected to come with Wi-Fi 6E support for the 6GHz band and increased range, a new report says. The latest Apple smartphone is expected to come with upgraded cameras, particularly the wide-angle lens, and expanded mmWave support to more regions.

A DigiTimes report cites industry sources to say Apple will incorporate Wi-Fi 6E technology into its new iPhones this year, and the technology is expected to become a standard feature of both iOS and Android smartphones in 2022.

This will lead to significant gains for Taiwan's GaAs IC foundries Win Semiconductors, Advanced Wireless Semiconductor Company (AWSC), and GaAs epi-wafer supplier Visual Photonics Epitaxy Company (VPEC).

Apple introduced Wi-Fi 6 with the iPhone 11, which significantly improved speeds and security than the previous generation Wi-Fi 5 protocol. Wi-Fi 6E is considered as a slight upgrade in comparison as t only adds minimal 6GHz band support. This will result in increased bandwidth and less interference for devices that support Wi-Fi 6E.

The report adds that the three companies mentioned above will also see third quarter revenue increase further because of VCSEL chips demand as iPhones continue to adopt 3D Face ID sensors for general models and ToF LiDAR scanners for Pro series.

 

IMG
Windows 11 Introducing
News

A new Windows experience, bringing you closer to the people and things you love.

Get a fresh perspective

Windows 11 provides a calm and creative space where you can pursue your passions through a fresh experience. From a rejuvenated Start menu to new ways to connect to your favorite people, news, games, and content—Windows 11 is the place to think, express, and create in a natural way.

Maximize your productivity

Access all the apps you need and multi-task with ease with tools like Snap layouts, Desktops, and a new more-intuitive redocking experience.

 

New ways to connect

Connect instantly to the people you care about right from your desktop with Microsoft Teams. Call or chat for free—no matter what device they’re on.

Your content, curated by you

With Microsoft Edge and a multitude of Widgets you can choose from, you can quickly stay up to date with the news, information, and entertainment that matters most to you. Easily find the apps you need and the shows you love to watch in the new Microsoft Store.

 

Info : 

This updated Start menu is a simplified version of what currently exists in Windows 10, without Live Tiles. It includes pinned apps, recent files, and the ability to quickly shut down or restart Windows 11 devices. It’s really a lot more simplified than what exists in Windows 10 today.

If you don’t want the app icons and Start menu centered, there’s an option to move them all back to the left-hand side. Coupled with the dark mode that’s also available, and Windows 11 starts to look like a more refined version of Windows 10 than something dramatically new.

Microsoft is also using rounded corners throughout Windows 11. These are visible in context menus, and around apps and the File Explorer. The Start menu itself also includes rounded corners. This is still an early version of Windows 11 that has leaked, so not everything is included yet.

We’re expecting to see more changes to the built-in apps within Windows 11, but most of those don’t appear to be present yet. A large part of the operating system feels finished though, so we’d expect to see a beta of this to arrive shortly for Windows Insiders to test.

You may have noticed a new icon in the Windows 11 taskbar, and it’s labeled Widgets in the operating system. Rumors have suggested Microsoft is bringing back Windows Widgets, and this early version appears to include some.

As this is clearly a very early version of Windows 11, the widgets aren’t loading fully in the OS, but they’re designed to slide out and provide quick access to news, weather, and other web content.

 

Collected From Internet and many way....

Thank You

IMG
Get Windows 11 update
News

Microsoft’s latest and most new operating system has just been released "Windows 11"

Microsoft is offering Windows 11 free of charge.

How to check if your laptop can run Windows 11

Follow these steps to test whether your PC meets the system requirements for Windows.

1. Download Microsoft's PC Health Check here. Open the file, agree to the terms of service and click Install. Make sure the box is checked that says Open PC Health Check, and click Finish

2. The app home page that pops up says "PC health at a glance." At the top, a box reads "Introducing Windows 11." Click Check now

If your machine is not compatible, you'll get a message that says, "This PC will not run Windows 11." Though at first this was all you could see, on Friday, Microsoft updated the tool to give you more detailed information on what system requirements were not met. 

If your machine is compatible, you can download the Windows 11 update for free when it becomes available around the 2021 holiday season.

System requirements to run Windows 11

Here's the full list of system requirements for Windows 11, including at least 4 gigabytes of RAM, 64GB of storage and a 720p display larger than 9 inches diagonally.

Thank You

Course

IMG
CCNA2 Chapter 1
Course - 12 Jan-2021

 

Exploring the Network

§Explain how multiple networks are used in everyday life.

§Explain the topologies and devices used in a small to medium-sized
business network.

§Explain the basic characteristics of a network that supports
communication in a small to medium-sized business.

§Explain trends in networking that will affect the use of networks in
small to medium-sized businesses.
 
 
Thank you
Chapter 2 will be soon

 

Projects