DROP TABLE IF EXISTS `table`;

CREATE TABLE `table` (

    `my name` varchar(255),

    `another field` varchar(255),

    `field,with,comma` varchar(255)

);

​

INSERT INTO `table` VALUES ('Smith','James','Male');

INSERT INTO `table` VALUES ('Johnson','Maria','Female');

​

/*************here you can find backtick********************/

SELECT * FROM `table`;