From: Gurkan Aslan (gurkan@iaslan.com)
Date: Wed 07 Apr 2004 - 10:58:29 EEST
On Tue, 2004-04-06 at 15:09, Aykut ARDIÇ wrote:
> insert ederken asagidaki ifadeyi kullanmissin ama var olan table üzerinde "vergidairesi ve notlar" diye bi field olmadigindan kayit gerçeklesmiyo sana önere bilecegim ya table a "vergidairesi ve notlar" field lerini aç yada asagida önerdigim sorguyu kullan
> Çalismayan sorgu :
>
> INSERT INTO $table (firstname, lastname, address, home, mobile, work, email, email2, vergidairesi, notlar) VALUES ('$firstname','$lastname','$address','$home','$mobile','$work','$email','$email2','$vergidairesi','$notlar')
>
> Önerilen sorgu
>
> INSERT INTO $table (firstname, lastname, address, home, mobile, work, email, email2) VALUES ('$firstname','$lastname','$address','$home','$mobile','$work','$email','$email2')
>
-> tam da burasi icin (Asagida) : Bu nasil bir table structure 'idir...
Her seyi olasi en buyuk degerlerle kullanmissiniz,
255 karakterlik ilk ada ne gerek var? Diger alanlar neden blob field
(text)? v.s. v.s.?
Veya benim sazanlik yapmama neden olan bu mevzunun ozu nedir? :)
Saygilar sevgiler...
> table içerigi
> _____________________________________
> CREATE TABLE addressbook (
> id int(9) unsigned NOT NULL auto_increment,
> firstname varchar(255) NOT NULL,
> lastname varchar(255) NOT NULL,
> address text NOT NULL,
> home text NOT NULL,
> mobile text NOT NULL,
> work text NOT NULL,
> email text NOT NULL,
> email2 text NOT NULL,
> bday tinyint(2) NOT NULL,
> bmonth varchar(50) NOT NULL,
> byear varchar(4) NOT NULL,
> PRIMARY KEY (id)
> );
>
> INSERT INTO addressbook (firstname, lastname, address, home, mobile, work, email, email2, vergidairesi, notlar) VALUES ('sdf','sdfs','fsdf','sdf','sdfs','sdf','sdfs','dfsd','fsdf','sdfsfd')Could not query:Unknown column 'vergidairesi' in 'field list'
>
>
>
> Iyi Çalismalar
> Aykut ARDIÇ
>
--
Hazar Agency & Computer Systems
(GNU/Linux Solutions)
Phone: +90 212 356 65 56
+90 212 356 62 75
Projects and Software Development Department Manager
Gurkan ASLAN (a.k.a. Integer)
-- Attached file included as plaintext by Ecartis --
-- File: signature.asc
-- Desc: This is a digitally signed message part
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQBAc7Slt+ZedpV+bSoRAn0gAJ9n5s/FyPI6UQvPaBs3DZZx31LEpACglGt1
emAUUQuC0GYCLv24WEedFjM=
=LnDf
-----END PGP SIGNATURE-----