Mysql table name with space in mysql

Published: 25 June 2017
on channel: Open Source Devops

1,000

#mysql #table #name #rename #space
Demo of Table :-
CREATE TABLE IF NOT EXISTS `TABLE 8` (
`title` varchar(56) DEFAULT NULL,
`platform` varchar(16) DEFAULT NULL,
`score` decimal(2,1) DEFAULT NULL,
`genre` varchar(17) DEFAULT NULL,
`editors_choice` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TABLE 8`
--

INSERT INTO `TABLE 8` (`title`, `platform`, `score`, `genre`, `editors_choice`) VALUES
('LittleBigPlanet PS Vita', 'PlayStation Vita', 9.0, 'Platformer', 'Y'),
('LittleBigPlanet PS Vita -- Marvel Super Hero Edition', 'PlayStation Vita', 9.0, 'Platformer', 'Y'),
('Splice: Tree of Life', 'iPad', 8.5, 'Puzzle', 'N'),
('NHL 13', 'Xbox 360', 8.5, 'Sports', 'N'),
('NHL 13', 'PlayStation 3', 8.5, 'Sports', 'N'),
('Total War Battles: Shogun', 'Macintosh', 7.0, 'Strategy', 'N'),
('Double Dragon: Neon', 'Xbox 360', 3.0, 'Fighting', 'N'),
('Guild Wars 2', 'PC', 9.0, 'RPG', 'Y');

select Query :-
select * from `TABLE 8`;

~-~~-~~~-~~-~
Please watch: "create data dictionary using code"
• create data dictionary using code
~-~~-~~~-~~-~ buy a coffee for me on this URL https://opensourcedevops.web.app or PayPal donation https://www.paypal.com/paypalme/OpenS...

Watch video Mysql table name with space in mysql online without registration, duration hours minute second in high quality. This video was added by user Open Source Devops 25 June 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,000 once and liked it 5 people.

436