Question

difference between (1) char and varchar (2). DDL AND DML

Answer 1

★★★(1)★★★

The char is a fixed-length character data type, the varchar is a variable-length character data type. Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. ... You can use char when the data entries in a column are expected to be the same size.

$\bold{\red{CHAR}}$
♥️♥️♥️♥️♥️♥️♥️♥️♥️

•Used to store character string value of fixed length.

•The maximum no. of characters the data type can hold is 255 characters.

•It's 50% faster than VARCHAR.

•Uses static memory allocation.

$\bold{\red{VARCHAR}}$
♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

•Used to store variable length alphanumeric data.

•The maximum this data type can hold is up to

•Pre-MySQL 5.0.3: 255 characters.

•Post-MySQL 5.0.3: 65,535 characters shared for the row.

•It's slower than CHAR.

•Uses dynamic memory allocation*.

=°=°=°=°=°=°=°=°=°=°=°=°=°=°==••••••••••••••••••=°=°=°=°=°=°=°=°=°=°=

★★★(2)★★★

The basic difference between DDL and DML is that DDL (Data Definition Language) is used to Specify the database schema database structure. On the other hand, DML (Data Manipulation Language) is used to access, modify or retrieve the data from the database.

$\bold{\blue{DDL}}$ and $\bold{\pink{DML}}$

♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

•The basic difference between DDL and DML is that DDL (Data Definition Language) is used to define the schema or the structure of Database which means it is used to create the Table (Relation) and the DML (Data Manipulation Language) is used to access, or modify the schema or Table created by DDL

•DML is classified in two types Procedural and Declarative DMLs whereas the DDL is not classified further.

•CREATE, ALTER, DROP, TRUNCATE, COMMENT and RENAME, etc. are the commands of DDL. On the other hand, SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, etc. are the commands of DML.

MAY THIS HELP U MY FRND!!!!!❤️❤️❤️❤️❤️

Answer 2

Answer:

Explanation:

★★★(1)★★★

The char is a fixed-length character data type, the varchar is a variable-length character data type. Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. ... You can use char when the data entries in a column are expected to be the same size.

♥️♥️♥️♥️♥️♥️♥️♥️♥️

•Used to store character string value of fixed length.

•The maximum no. of characters the data type can hold is 255 characters.

•It's 50% faster than VARCHAR.

•Uses static memory allocation.

♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

•Used to store variable length alphanumeric data.

•The maximum this data type can hold is up to

•Pre-MySQL 5.0.3: 255 characters.

•Post-MySQL 5.0.3: 65,535 characters shared for the row.

•It's slower than CHAR.

•Uses dynamic memory allocation*.

=°=°=°=°=°=°=°=°=°=°=°=°=°=°==••••••••••••••••••=°=°=°=°=°=°=°=°=°=°=

★★★(2)★★★

The basic difference between DDL and DML is that DDL (Data Definition Language) is used to Specify the database schema database structure. On the other hand, DML (Data Manipulation Language) is used to access, modify or retrieve the data from the database.

and

♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

•The basic difference between DDL and DML is that DDL (Data Definition Language) is used to define the schema or the structure of Database which means it is used to create the Table (Relation) and the DML (Data Manipulation Language) is used to access, or modify the schema or Table created by DDL

•DML is classified in two types Procedural and Declarative DMLs whereas the DDL is not classified further.

•CREATE, ALTER, DROP, TRUNCATE, COMMENT and RENAME, etc. are the commands of DDL. On the other hand, SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, etc. are the commands of DML.