Some one help create this small database on PHP My admin?

Question

Hello,
Well I tried so many times writing a database but i kept getting errors.

does anybody knows how to make this in a database table?

protected String ip, name, description;
protected int portId, id;
protected boolean online;



and thats how they work :

servers.add(new ListedServer(results.getString("server_i…
, results.getString("server_name")
, results.getString("discription")
, results.getInt("server_port")
, results.getInt("id")
,results.getString("status").equals(…


and MORE EXAMPLE


private ListedServer(String ip, String name, String description, int portId, int id, boolean online) {
this.ip = ip;
this.name = name;
this.description = description;
this.portId = portId;
this.id = id;
this.online = online;
can some be kind enough to write me a table of 6 columns?
and it needs to have texts inside them just give me hints were to put the text and ip thx

Answer 1

You need to understand SQL syntax to create the table



To create the table use the Create Table clause

Answer 2

run following query in phpMyAdmin using SQL tab:



CREATE DATABASE test;

USE test;





CREATE TABLE `server` (

`id` smallint(6) NOT NULL,

`ip` varchar(30) NOT NULL,

`name` varchar(250) NOT NULL,

`description` int(11) NOT NULL,

`port` smallint(6) NOT NULL,

`status` varchar(10) NOT NULL

);

Answer 3

you would be able to desire to easily use something like the web pages the guy above me gave you, yet once you what to understand your internet pages and make extra useful pages, restoration trojan horse and such, then your going to could earn HTML.