Alles over netwerken en security.
 Menu:


 
 Forum  Documentatie
 Forum  Diensten
 Forum  ADSL providers
 CCIE Blog  CCIE BLOG


Database aanmaken

Create new database, table and insert some stuff



CREATE DATABASE pruts;

CREATE TABLE nodes
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(60),
ipadres VARCHAR(20),
description VARCHAR(40),
state INT,
lastchange TIMESTAMP(8)
);

INSERT INTO nodes (name, ipadres, description, state) VALUES ("systeem 1", "172.16.1.1", "monitoring", 1);






2004 - Frizone webdesign