BasicMysql

From Wiki
Jump to: navigation, search

CREATE TABLE

CREATE TABLE tamany ( codi VARCHAR(20), databaixa varchar(20), usuari VARCHAR(20), tamany integer, lloc varchar(60));


Crear INSERTS per base de dades

cat tamany.csv | awk -F "," {'print "insert into tamany values (\"" $1 "\",\"" $2 "\",\"" $3 "\"," $4 ",\"" $5 "\"); "'} > aa.sql

Personal tools
Namespaces
Variants
Actions
Navigation
Content
Toolbox