SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE ANIMALS (NAME VARCHAR(20), OWNER VARCHAR(20), SPECIES VARCHAR(20), SEX CHAR(1), BIRTH DATE); INSERT INTO ANIMALS (NAME, OWNER, SPECIES, SEX, BIRTH) VALUES ('FLUFFY', 'HAROLD', 'CAT', 'F', '1993-02-04'), ('CLAWS', 'GWEN', 'CAT', 'M', '1994-03-17'), ('BUFFY', 'HAROLD', 'DOG', 'F', '1989-05-13'), ('FANG', 'BENNY', 'DOG', 'M', '1990-08-27'), ('BOWSER', 'DIANE', 'DOG', 'M', '1998-08-31'), ('CHIRPY', 'GWEN', 'BIRD', 'F', '1998-09-11'), ('WHISTLER', 'GWEN', 'BIRD', 'F', '1997-12-09'), ('SLIM', 'BENNY', 'SNAKE', 'M', '1996-04-29'); SELECT NAME, REVERSE (NAME) FROM ANIMALS; SELECT OWNER, REVERSE (OWNER) FROM ANIMALS; SELECT SPECIES, REVERSE (SPECIES) FROM ANIMALS;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear