Putty and winscp

From SQLZoo
Jump to navigation Jump to search

Start WinScp to connect inf08104.napier.ac.uk

Start WinScp

Off Campus? If so you will need to to follow this instead Putty and winscp off campus

Click New

Enter details of the server

Create a new file (called mksrs.sql or similar)

Write your SQL

Try it in mysql

  • Start putty, connect to inf08104.napier.ac.uk
  • Go into the mysql prompt
    mysql -u 40000036 -ptiger 40000036
  • Load in the file
    \. mksrc.sql

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects