loonix

inicio
	real numkm
	inteiro km_m
	inteiro mnauticas
	inteiro milhas
	inteiro pes
	numKm <- 0.0
	escrever "Introduza o número de KM:"
	ler numkm
	km_m <- numKm *1000 

loonix

inicio
	inteiro num1
	inteiro num2
	inteiro sum
	inteiro prod
	inteiro media
	num1 <- 0
	num2 <- 0
	escrever "Introduza o primeiro numero:"
	ler num1

loonix

inicio
    variavel inteiro ano
    variavel inteiro resto4
    variavel inteiro resto100
    variavel inteiro resto400
    escrever "Introduza um ano: "
    ler ano
    
    resto4 <- ano % 4
    resto100 <- ano % 100

loonix

///
/// Converting class objects to JSON string in Flutter
///
class Employee {
  final String name;
  final String email;

  Employee(this.name, this.email);

  Employee.fromJson(Map<String, dynamic> json)

loonix

--Insert files into dept from csv file
LOAD DATA LOCAL INFILE 'C:\\Users\\danie\\Desktop\\db2.csv' INTO TABLE dept
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\r\n'

LOAD DATA LOCAL INFILE 'C:\\Users\\danie\\Desktop\\db21.csv' INTO TABLE emp
FIELDS TERMINATED BY ','
ENCLOSED BY ''
LINES TERMINATED BY '\r\n';

loonix

--- run mysql XAAMP >> mysql -u root mysql
------------------------------------------------------------------------
--                               DB 3
------------------------------------------------------------------------

create database db3 charset latin1 collate latin1_swedish_ci;

CREATE TABLE IF NOT EXISTS products (
productID 		INT UNSIGNED 		NOT NULL AUTO_INCREMENT,
productCode 	CHAR(3) 			NOT NULL DEFAULT '',

loonix

-- MariaDB dump 10.17  Distrib 10.4.13-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: db2
-- ------------------------------------------------------
-- Server version	10.4.13-MariaDB-1:10.4.13+maria~bionic

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

loonix

create database db21 charset latin1 collate latin1_swedish_ci;

create database db23 charset latin1 collate latin1_swedish_ci;

mysql -u root db22 < C:/Users/danie/Documents/Universidade/university/Databases/MariaDbDatabases/db4.sql
mysql -u root db22 > C:/Users/danie/Documents/Universidade/university/Databases/MariaDbDatabases/db55.sql

C:/Users/danie/Documents/Universidade/university/Databases/MariaDbDatabases/db-hp-calc-input.csv

-- insert products CSV

loonix

    private void Notas_Load(object sender, EventArgs e)
        {
            ClassBD classBD = new ClassBD(); // link a classDB
            //SqlDataReader dataReader = classBD.ObterDadosCodigos(); // Obter os dados para popular a tabela

            //DataTable table = new DataTable();
            //table.Load(dataReader); // Carrega os dados para a datatable

            DataTable table = classBD.ObterDadosCodigos2();
            dataGridView1.DataSource = table; // Mostra valores na grid

loonix

create database db3 charset latin1 collate latin1_swedish_ci;