[FONT=monospace]CREATE TABLE [COLOR=#B1B100]IF[/COLOR] NOT EXISTS `kelidestan_test_1` [COLOR=#009900]([/COLOR]
`id` int[COLOR=#009900]([/COLOR][COLOR=#CC66CC]11[/COLOR][COLOR=#009900])[/COLOR] NOT [COLOR=#009900][B]NULL[/B][/COLOR] AUTO_INCREMENT[COLOR=#339933],[/COLOR]
`name` varchar[COLOR=#009900]([/COLOR][COLOR=#CC66CC]100[/COLOR][COLOR=#009900])[/COLOR] NOT [COLOR=#009900][B]NULL[/B][/COLOR][COLOR=#339933],[/COLOR]
`city` varchar[COLOR=#009900]([/COLOR][COLOR=#CC66CC]100[/COLOR][COLOR=#009900])[/COLOR] NOT [COLOR=#009900][B]NULL[/B][/COLOR][COLOR=#339933],[/COLOR]
PRIMARY [COLOR=#990000]KEY[/COLOR] [COLOR=#009900]([/COLOR]`id`[COLOR=#009900])[/COLOR]
[COLOR=#009900])[/COLOR] ENGINE[COLOR=#339933]=[/COLOR]InnoDB [COLOR=#B1B100]DEFAULT[/COLOR] CHARSET[COLOR=#339933]=[/COLOR]utf8 AUTO_INCREMENT[COLOR=#339933]=[/COLOR][COLOR=#CC66CC]6[/COLOR] [COLOR=#339933];[/COLOR]
INSERT INTO `kelidestan_test_1` [COLOR=#009900]([/COLOR]`id`[COLOR=#339933],[/COLOR] `name`[COLOR=#339933],[/COLOR] `city`[COLOR=#009900])[/COLOR] VALUES
[COLOR=#009900]([/COLOR][COLOR=#CC66CC]1[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'alireza'[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'shiraz'[/COLOR][COLOR=#009900])[/COLOR][COLOR=#339933],[/COLOR]
[COLOR=#009900]([/COLOR][COLOR=#CC66CC]2[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'hamid'[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'tehran'[/COLOR][COLOR=#009900])[/COLOR][COLOR=#339933],[/COLOR]
[COLOR=#009900]([/COLOR][COLOR=#CC66CC]3[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'hasan'[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'yazd'[/COLOR][COLOR=#009900])[/COLOR][COLOR=#339933],[/COLOR]
[COLOR=#009900]([/COLOR][COLOR=#CC66CC]4[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'karim'[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'ghom'[/COLOR][COLOR=#009900])[/COLOR][COLOR=#339933],[/COLOR]
[COLOR=#009900]([/COLOR][COLOR=#CC66CC]5[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'hosein'[/COLOR][COLOR=#339933],[/COLOR] [COLOR=#0000FF]'tabriz'[/COLOR][COLOR=#009900])[/COLOR][COLOR=#339933];[/COLOR][/FONT]