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
Quantum computing big take...
News 24 Jul-2021

The system marks a major step toward building large-scale quantum machines that could be used to shed light on a host of complex quantum processes and eventually help bring about real-world breakthroughs in material science, communication technologies, finance, and many other fields, overcoming research hurdles that are beyond the capabilities of even the fastest supercomputers today. Qubits are the fundamental building blocks on which quantum computers run and the source of their massive processing power.

"This moves the field into a new domain where no one has ever been to thus far," said Mikhail Lukin, the George Vasmer Leverett Professor of Physics, co-director of the Harvard Quantum Initiative, and one of the senior authors of the study published today in the journal Nature. "We are entering a completely new part of the quantum world."

According to Sepehr Ebadi, a physics student in the Graduate School of Arts and Sciences and the study's lead author, it is the combination of system's unprecedented size and programmability that puts it at the cutting edge of the race for a quantum computer, which harnesses the mysterious properties of matter at extremely small scales to greatly advance processing power. Under the right circumstances, the increase in qubits means the system can store and process exponentially more information than the classical bits on which standard computers run.

"The number of quantum states that are possible with only 256 qubits exceeds the number of atoms in the solar system," Ebadi said, explaining the system's vast size.

Already, the simulator has allowed researchers to observe several exotic quantum states of matter that had never before been realized experimentally, and to perform a quantum phase transition study so precise that it serves as the textbook example of how magnetism works at the quantum level.

These experiments provide powerful insights on the quantum physics underlying material properties and can help show scientists how to design new materials with exotic properties.

The project uses a significantly upgraded version of a platform the researchers developed in 2017, which was capable of reaching a size of 51 qubits. That older system allowed the researchers to capture ultra-cold rubidium atoms and arrange them in a specific order using a one-dimensional array of individually focused laser beams called optical tweezers.

This new system allows the atoms to be assembled in two-dimensional arrays of optical tweezers. This increases the achievable system size from 51 to 256 qubits. Using the tweezers, researchers can arrange the atoms in defect-free patterns and create programmable shapes like square, honeycomb, or triangular lattices to engineer different interactions between the qubits.

"The workhorse of this new platform is a device called the spatial light modulator, which is used to shape an optical wavefront to produce hundreds of individually focused optical tweezer beams," said Ebadi. "These devices are essentially the same as what is used inside a computer projector to display images on a screen, but we have adapted them to be a critical component of our quantum simulator."

The initial loading of the atoms into the optical tweezers is random, and the researchers must move the atoms around to arrange them into their target geometries. The researchers use a second set of moving optical tweezers to drag the atoms to their desired locations, eliminating the initial randomness. Lasers give the researchers complete control over the positioning of the atomic qubits and their coherent quantum manipulation.

Other senior authors of the study include Harvard Professors Subir Sachdev and Markus Greiner, who worked on the project along with Massachusetts Institute of Technology Professor Vladan Vuleti?, and scientists from Stanford, the University of California Berkeley, the University of Innsbruck in Austria, the Austrian Academy of Sciences, and QuEra Computing Inc. in Boston.

"Our work is part of a really intense, high-visibility global race to build bigger and better quantum computers," said Tout Wang, a research associate in physics at Harvard and one of the paper's authors. "The overall effort [beyond our own] has top academic research institutions involved and major private-sector investment from Google, IBM, Amazon, and many others."

The researchers are currently working to improve the system by improving laser control over qubits and making the system more programmable. They are also actively exploring how the system can be used for new applications, ranging from probing exotic forms of quantum matter to solving challenging real-world problems that can be naturally encoded on the qubits.

"This work enables a vast number of new scientific directions," Ebadi said. "We are nowhere near the limits of what can be done with these systems."

This work was supported by the Center for Ultracold Atoms, the National Science Foundation, the Vannevar Bush Faculty Fellowship, the U.S. Department of Energy, the Office of Naval Research, the Army Research Office MURI, and the DARPA ONISQ program.

IMG
Facebook removes malicious accounts, groups and pages
News

Facebook has suspended 5,381 malicious accounts, Groups and Pages from its main network and Instagram, according to a report by IANS. The social media platform had removed eight networks from seven countries. The majority of these campaigns targeted people in their own countries.

The cited source reported that around 2,784 Facebook accounts, 206 Instagram accounts, 2,249 Pages and 142 Groups were removed in the month of June. In Iraq and Iran, Facebook suspended 675 Facebook accounts, 16 Pages, and 10 Instagram accounts that reportedly targeted audiences in Iraq and were linked to Al-Maaref Radio in Iraq and Alborz Analysis and Development, an IT firm in Tehran.

 

 

“We found this activity as part of our internal investigation into suspected coordinated inauthentic behaviour in the region,” Facebook said while commenting on the same.

In Mexico, Facebook removed 1,621 Facebook accounts, 1,795 Pages, 75 Groups, and 93 Instagram accounts that focused on the state of Campeche and were linked to people in that state. It included individuals that were working for Worgcorp, a political strategy and public relations firm in Mexico.

“We found this activity as part of our internal investigation into suspected coordinated inauthentic behaviour in the region and removed it ahead of the Mexican elections,” Facebook said.

“When we find domestic, non-government campaigns that include groups of accounts and Pages seeking to mislead people about who they are and what they are doing while relying on fake accounts, we remove both inauthentic and authentic accounts, Pages and Groups directly involved in this activity,” Facebook added.

 

Written with inputs from IANS

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

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