SQL Syntax help

[trann123]

Can anyone help me how to add a table and call a value in that table and add a value in the table. Any random example would be appreciated, but of course with given info. Thanks guys.

[plankt]

Tutorials: http://www.mysqltuto...l-tutorial.aspx

Add a table: http://www.mysqltuto...ibe-tables.aspx

CREATE TABLE troll (
 id int(11) NOT NULL,
 name varchar(50) NOT NULL,
);

Add a value: http://www.mysqltuto...-statement.aspx

INSERT troll (id, name) VALUES (1, 'Troll facé');

Get the value: http://www.mysqltuto...query-data.aspx

SELECT name FROM troll WHERE id = 1

You will use query_sql with the emulator: http://rathena.org/wiki/Query_sql

Edited August 1, 2012 by plankt

[trann123]

Last question, where do you put the add table in the script?

Edited August 2, 2012 by trann123

[Emistry]

run that in ur MySQL / PhpMyAdmin / etc... ?

[trann123]

No I mean this

CREATE TABLE troll (

id int(11) NOT NULL,

name varchar(50) NOT NULL,

);

Do I put it in the script aswell?