Aşağıda eklediğim sorguda hata nerede arkadaşlar çalıştır dediğimde hata alıyorum..
-- Tablo için tablo yapısı `emlak`
--

CREATE TABLE IF NOT EXISTS 'emlak' (
`id` int(11) NOT NULL AUTO_INCREMENT,
`durum` int(100) NOT NULL,
`emlak` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`emlaktipi` int(100) NOT NULL,
`link` varchar(250) COLLATE utf8_turkish_ci NOT NULL,
`oda` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`isinma` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`kat` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`ilce` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`il` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`fiyat` varchar(200) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
`izlenme` int(40) NOT NULL DEFAULT '0',
`kredi` int(10) NOT NULL DEFAULT '0',
`dubleks` int(10) NOT NULL DEFAULT '0',
`tersdubleks` int(10) NOT NULL DEFAULT '0',
`catidubleks` int(10) NOT NULL DEFAULT '0',
`tripleks` int(10) NOT NULL DEFAULT '0',
`terstripleks` int(10) NOT NULL DEFAULT '0',
`terasli` int(10) NOT NULL DEFAULT '0',
`bahceli` int(10) NOT NULL DEFAULT '0',
`celikkapi` int(10) NOT NULL DEFAULT '0',
`dusakabin` int(10) NOT NULL DEFAULT '0',
`ciftbanyo` int(10) NOT NULL DEFAULT '0',
`jakuzi` int(10) NOT NULL DEFAULT '0',
`somine` int(10) NOT NULL DEFAULT '0',
`mobilya` int(10) NOT NULL DEFAULT '0',
`beyazesya` int(10) NOT NULL DEFAULT '0',
`ankastre` int(10) NOT NULL DEFAULT '0',
`deniz` int(10) NOT NULL DEFAULT '0',
`bogaz` int(10) NOT NULL DEFAULT '0',
`doga` int(10) NOT NULL DEFAULT '0',
`siteici` int(10) NOT NULL DEFAULT '0',
`deprem` int(10) NOT NULL DEFAULT '0',
`asansor` int(10) NOT NULL DEFAULT '0',
`jenerator` int(10) NOT NULL DEFAULT '0',
`su` int(10) NOT NULL DEFAULT '0',
`hidrofor` int(10) NOT NULL DEFAULT '0',
`uydu` int(10) NOT NULL DEFAULT '0',
`kablotv` int(10) NOT NULL DEFAULT '0',
`guvenlik` int(10) NOT NULL DEFAULT '0',
`kapici` int(10) NOT NULL DEFAULT '0',
`otopark` int(10) NOT NULL DEFAULT '0',
`kapaliotopark` int(10) NOT NULL DEFAULT '0',
`cocukparki` int(10) NOT NULL DEFAULT '0',
`yanginmerdiveni` int(10) NOT NULL DEFAULT '0',
`havuz` int(10) NOT NULL DEFAULT '0',
`panjur` int(10) NOT NULL DEFAULT '0',
`pvc` int(10) NOT NULL DEFAULT '0',
`aluminyum` int(10) NOT NULL DEFAULT '0',
`ciftkatcam` int(10) NOT NULL DEFAULT '0',
`balkon` int(10) NOT NULL DEFAULT '0',
`alarm` int(10) NOT NULL DEFAULT '0',
`kartonpiyer` int(10) NOT NULL DEFAULT '0',
`spotisik` int(10) NOT NULL DEFAULT '0',
`klima` int(10) NOT NULL DEFAULT '0',
`ytavan` int(10) NOT NULL DEFAULT '0',
`detay` text COLLATE utf8_turkish_ci NOT NULL,
`m2` int(40) NOT NULL DEFAULT '0',
`onay` int(10) NOT NULL DEFAULT '0',
`mahalle` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
`sokak` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=123 ;