h1

mySQL datu basean eragiketa basikoen zerrenda

2009 abendua 30

Beti gertatzen zait SQL komando bat behar dudanean ez dudala eskura, ta bilatzen hasi behar…., hemen 4 garrantzitsuenak ipiniko ditut eskura izateko:

UPDATE:
UPDATE tabla SET field = field +1 WHERE field2 = ‘zerbait’

DELETE:
DELETE FROM tabla WHERE field=’zerbait’

INSERT:
INSERT INTO tabla (field, field2) VALUES (‘zerbait’, ‘edozer’)

SELECT:
SELECT field, field2 FROM tabla WHERE field=’zerbait’
SELECT tabla.field, tabla.field2, tabla2.field FROM tabla INNER JOIN tabla2 (ON tabla.id = tabla2.fk_id) WHERE field=’zerbait’

Beno hauekin espero dut apañatzea, ta zueiz zerbaitetarako balio bazaizue ba hobeto.

Advertisements

One comment

  1. Mila esker postarengatik. Hasteko soberan daukat ;D



Utzi erantzun bat

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Aldatu )

Twitter picture

You are commenting using your Twitter account. Log Out / Aldatu )

Facebook photo

You are commenting using your Facebook account. Log Out / Aldatu )

Google+ photo

You are commenting using your Google+ account. Log Out / Aldatu )

Connecting to %s

%d bloggers like this: