MySQL TIPS

for pew:

  • sudo mysql (to give permissions)
  • create database ; (only needs setting up once)
  • use ; (before you start working on a db, make sure you are using the right one)
  • create table
    …etc see below.
  • show tables;
  • describe
    ;

DB: nmr
TABLE: datatest

  • CREATE TABLE datatest (time TIMESTAMP, recID TINYINT(10), avidID VARCHAR(16));

Check status (on pew, RHEL)
> mysqladmin -u root -p status

Start Mariadb (on pew, RHEL)
> sudo systemctl start mariadb

Deleting rows
> delete from nmr_records where id = >”799″;

> delete from nmr_index where colony = “800”;

Add columns:
> alter table nmr_records add column worker_pc smallint(4);