Mysql

Some examples: (to be completed)

show Tables;

% is anything

select UserName, Password from Users where UserName like "Pi%"

select * from Users;

delete from ---- where ----=1;

if autocommit=false it is needed to do after any modification/delete:

commit;

Crear base de dades MySQL (Actualitzat: Ja no cal, es pot fer posant root account a la web de configuracio):

mysql -u root -p mysql

I aleshores executar les següents commandes mysql:

create database wikidb identified by 'yourpassword';

o bé:

create database wikidb;
set password for 'wikiuser'@'localhost'=password('yourpassword');

grant all on wikidb.* to 'wikiuser'@'localhost';

o més especific:

grant create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';

flush privileges;
\q