Change Column Data Type of PaymentMethod to VARCHAR(100)
Change Column Data Type of PaymentMethod to VARCHAR(100)
PaymentMethod is VARCHAR(50):
Query Explanation:
● CREATE TABLE Payments5 (...) creates a table named Payments5 with a column PaymentMethod initially set to VARCHAR(50).
● ALTER TABLE Payments5 MODIFY COLUMN PaymentMethod VARCHAR(100) increases the size limit of the PaymentMethod column from 50 to 100 characters.
● INSERT INTO Payments5 (...) VALUES (...) inserts 4 records into the table, including longer text like "UPI Payment via Google Pay" to confirm that the updated size supports larger values.
SQL Query:
-- Creating Payments5 table with PaymentMethod as VARCHAR(50)
CREATE TABLE Payments5 (
PaymentID INT PRIMARY KEY,
OrderID INT,
PaymentMethod VARCHAR(50)
);
-- Altering the table to change PaymentMethod to VARCHAR(100)
ALTER TABLE Payments5
MODIFY COLUMN PaymentMethod VARCHAR(100);
-- Inserting data to test new column size
INSERT INTO Payments5 (PaymentID, OrderID, PaymentMethod)
VALUES
(1, 101, 'Credit Card'),
(2, 102, 'Net Banking'),
(3, 103, 'Cash on Delivery'),
(4, 104, 'UPI Payment via Google Pay');
-- SHOW COLUMNS FROM Payments5;
-- This query will display the structure of the Payments5 table, including all columns and their data types.
SHOW COLUMNS FROM Payments5;
Output:
PaymentMethod was previously VARCHAR(50) and has now been updated to VARCHAR(100).
