helppppppp database - Aici e raspunsul!

Intrebare

helppppppp database de radu2008

ba fratilor am reusit sa fac database dar acum nu pot sa intru in ia sa o vad ca eu nu am optiunea aia OPEN TABLE ca sa vada ce a realizat eu nu o am in meniu cum fac helpppppp

Tags:

cp1250 `irsz irsz

5

puncte

1668

vizualizari

27-02-2011 11:07:57

Data intrebarii:

(0.00 - 0 voturi)

Ratings:

Notificari raspunsuri

Pentru a putea bifa optiunea de notificare in email in cazul adaugarii de comentarii la aceasta intrebare trebuie sa fiti logat.
Daca nu aveti cont, click Aici

Raspunsuri

Comentariul lui:

robica

27-02-2011 11:19:11

Data:

baza de date contine tabelele

trebuie sa iti creezi tabele care vor contine campuri
De exemplu

CREATE TABLE 'orase' (
  'irsz_id' int(11) NOT NULL auto_increment,
  'irsz_nume' varchar(45) collate cp1250_bin NOT NULL default '',
  'irsz_irsz' varchar(10) collate cp1250_bin NOT NULL default '',
  UNIQUE KEY `irsz_id` (`irsz_id`),
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=cp1250 COLLATE=cp1250_bin;

si aici se introduc datele

INSERT INTO `irsz` (`irsz_id`,`irsz_nev`,`irsz_irsz`) VALUES
(1,'Aita Seca','4032'),
(2,'Atid','4189'),
(3,'Avramesti','4186'),
(4,'Bacau','5500'),
(5,'Balan','4110'),
(6,'Borsec','4222'),
(7,'Braila','6100'),
(8,'Brasov','2200'),
(9,'Bucuresti','   1'),
(10,'Tirgoviste','2000'),
(11,'Capilnita','4152'),
(12,'Casinul Nou','4134'),
(13,'Cirta','4141'),
(14,'Ciumani','4207'),
(15,'Cluj Napoca','3400'),
(16,'Constanta','8700'),
(17,'Corund','4169'),
(18,'Covasna','4055'),
(19,'Cristuru Secuiesc','4180'),
(20,'Danesti','4127'),
(21,'Ditrau','4214'),
(22,'Feliceni','4160'),
(23,'Galautas','4219'),
(24,'Gheorgheni','4200'),
(25,'Ghindari','3288'),
(26,'Joseni','4206'),
(27,'Lazarea','4215'),
(28,'Lemnia','4095'),
(29,'Lupeni','4168'),
(30,'Madaras','4120'),
(31,'Martinis','4162'),
(32,'Meresti','4158'),
(33,'Miercurea Ciuc','4100'),
(34,'Mugeni','4163'),
(35,'Odorheiu Secuiesc','4150'),
(36,'Pauleni-Ciuc','4130'),
(37,'Plaiesii de Sus','4134'),
(38,'Ploiesti','2000'),
(39,'Porumbenii Mari','4197');
INSERT INTO `irsz` (`irsz_id`,`irsz_nev`,`irsz_irsz`) VALUES
(40,'Praid','4174'),
(41,'Reghin','4225'),
(42,'Remetea','4212'),
(43,'Sarmas','4217'),
(44,'Secuieni','4182'),
(45,'Sf.Gheorghe','4000'),
(46,'Simonesti','4178'),
(47,'Sincraieni','4115'),
(48,'Sindominic','4142'),
(49,'Sinsimion','4114'),
(50,'Targu Mures','4300'),
(51,'Timisoara','1900'),
(52,'Toplita','4220'),
(53,'Tulghes','4209'),
(54,'Tusnad Bai','4113'),
(55,'Ulies','4193'),
(56,'Ulies','4193'),
(57,'Varsag','4167'),
(58,'Vlahita','4154'),
(59,'Oradea','3700'),
(60,'Aiud','3927'),
(61,'Marghita','3775'),
(62,'BISTRITA','4400');

*

Raspuns acceptat

Voturi:

4 Voteaza

Link sponsorizat

Comentariul lui:

robica

27-02-2011 11:20:16

Data:

irsz_nev il schimbi cu irsz_nume la insert

*

Comentariu

Voturi:

4 Voteaza

Comentariul lui:

radu2008

27-02-2011 11:37:23

Data:

gata am reusit merci

*

Comentariul autorului

Link sponsorizat

Raspunde / Comenteaza

Adauga un comentariu / raspuns:

Va rugam sa selectati unul din campuri:

Utilizator nou

Utilizator inregistrat

Ataseaza fisiere» (Max 200KB)

1	djbrain	44355
2	subofferul	5220
3	robica	4610
4	krystyana84	3980
5	elena2008	2690

Membri inscrisi	96837
Intrebari	35962
Raspunsuri	164760

Introduceti textul din imagine (pentru evitarea spam-ului):


introduceti mesajul


email admin: adip.at.myexpert.ro

nume
email