Eduguru - Tech Blog and Discussion - Page 13

MySQL – NOT NULL Constraint

August 31, 2021 eduguru 0 Comments a column can hold NULL values. The "NOT NULL constraint" enforces a column to NOT accept NULL values. This enforces a field to always contain a value, NOT NULL Constraint, NOT NULL Constraint By default, which means that you cannot insert a new record

NOT NULL Constraint By default, a column can hold NULL values. The “NOT NULL constraint” enforces a column to NOT accept

MySQL Constraints

August 31, 2021 eduguru 0 Comments MySQL Constraints

MySQL Constraints SQL constraints are used to specify rules for data in a table. The constraint in MySQL is used

MySQL CREATE TABLE Statement

August 31, 2021 eduguru 2 Comments .... ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, 'DATE', Address, Address varchar(255), and City columns are of type varchar and will hold characters, and City: Example CREATE TABLE Persons ( PersonID int, and the maximum length for these fields is 255 characters. The empty "Persons" table will now look like this: PersonID LastName FirstName Address City, City varchar(255) ); The PersonID column is of type int and will hold an integer. The LastName, column2 datatype, column3 datatype, etc.). MySQL CREATE TABLE Example The following example creates a table called "Persons" that contains five columns: PersonID, FirstName, FirstName varchar(255), integer, LastName, LastName varchar(255), MySQL CREATE TABLE Statement, MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype

MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a

MySQL AUTO INCREMENT Field

August 31, 2021 eduguru 0 Comments MySQL AUTO INCREMENT Field

MySQL AUTO INCREMENT Field What is an AUTO INCREMENT Field? Auto-increment allows a unique number to be generated automatically when

Install MariaDB 10.6 on CentOS 7

August 30, 2021 eduguru 0 Comments Install MariaDB 10.6 on CentOS 7

Install MariaDB 10.6 on CentOS 7 MariaDB is a commonly used OpenSource database mainly known for being robust and scalable

LibreOffice Calc – Open-Source Spreadsheet Software for Linux

August 30, 2021 eduguru 0 Comments Download LibreOffice, Download the Sourcecode, LibreOffice Calc - Open-Source Spreadsheet Software for Linux

LibreOffice Calc – Open-Source Spreadsheet Software for Linux The majority of Linux users will mention LibreOffice Calc as spreadsheet software. This open-source

Ethical Hacking IT Security

How to Hack WiFi Password

August 28, 2021 eduguru 0 Comments Cracking Wireless network WEP/WPA keys, How to access a wireless network?, How to Crack Wifi (Wireless) Networks, How to Hack WiFi Password, How to Secure wireless networks

How to Hack WiFi Password Wireless networks are accessible to anyone within the router’s transmission radius. This makes them vulnerable to

Ethical Hacking IT Security

What is ARP Poisoning

August 28, 2021August 28, 2021 eduguru 0 Comments Deleting an ARP cache entry, What is ARP Poisoning

What is ARP Poisoning ARP is the acronym for Address Resolution Protocol. It is used to convert an IP address

Ethical Hacking IT Security

What is IP Address and MAC Address

August 28, 2021 eduguru 0 Comments and it uses 128-bit numbers. IPv4 addresses are formatted in four groups of numbers separated by dots. The minimum number is 0, IPv6 has been developed, storage disks on a computer network. There are currently two versions of IP addresses. IPv4 uses 32-bit numbers. Due to the massive growth of the internet, What is IP Address and MAC Address, What is IP Address and MAC Address IP Address IP Address is the acronym for Internet Protocol address. An internet protocol address is used to uniquely identify a computer or device such as printers

What is IP Address and MAC Address IP Address IP Address is the acronym for Internet Protocol address. An internet

Apache MPM performance Test : event -prefork

August 28, 2021 eduguru 0 Comments apache load testing, apache mpm, Apache MPM performance Test : event -prefork, Apache-Performance-Load-Testing, mpm test apache

Apache MPM performance Test: event -prefork As a basic test, I will create a PHP file that checks the existence