Ir al contenido principal

Algunos puntos al momento de trabajar con MYSQL

Estoy haciendo un pequeno programa, de manejo de horarios.
Decide usar MYSQL para dicha apliacion. Aqui voy a escribir algunos puntos importantes que tengo que tener en cuenta al momento de manejar mysql.

Estoy usando como sistema operativo Ubuntu 11.10. Si desean saber como instalar mysql pueden ver este link (https://help.ubuntu.com/11.04/serverguide/C/mysql.html)

Comando para ingresar a nuestra base de datos

  • mysql -u usuario -p
    donde usuario es el usuario que ustedes crearon o el usuario rooot, que es el que se crea por default. -p indica que espera el parametro de la contrasena.(Password en ingles)

Comando para crear la base de datos

  • CREATE DATABASE NOMBRE

Comando para acceder a la base de datos

  • use nombre
    Donde nombre es el nombre de la base de datos

Comando para crear una table con llave primaria

Comando para crear table con llave foranea

  • CREATE TABLE consumidor (fecha DATE NOT NULL, hora TIME NOT NULL, codigo_id INT NOT NULL, PRIMARY KEY (fecha, hora), FOREIGN KEY (codigo_id) REFERENCES nombre_table (id) ON UPDATE CASCADE ON DELETE RESTRICT) ENGINE=INNODB;

Supongamos que tenemos nuestra base de datos en un archivo te texto y deseamos importar la informacion. Este es el comando

  • LOAD DATA LOCAL INFILE '/home/diego/NetBeansProjects/a.txt' INTO TABLE nombre_table;

Espero que les sirva un poco

Comentarios

Entradas populares de este blog

Find which devices are connected to our network

Sometimes, we want to know how many devices are connected to our network. With any Unix OS you get easily know this. For this small tutorial we´re going to use Lubuntu 16.04. We will use nmap. Nmap (Network Mapper) is a security scanner. It is used to discover hosts and services on a computer network. For installing it, we first do sudo apt-get install nmap If we just need to identify the host names  sudo nmap -sL 192.168.0.1/24  The result of this command will be Starting Nmap 7.01 ( https://nmap.org ) at 2016-10-02 12:39 CST Nmap scan report for 192.168.0.0 Nmap scan report for 192.168.0.1 Nmap scan report for 192.168.0.2 Nmap scan report for 192.168.0.3 Nmap scan report for 192.168.0.4 Nmap scan report for 192.168.0.5 If we need to know the OS of the devices we have connected we do a: sudo nmap -O 192.168.0.1/24 The address 192.188.0.1 depends of your network, you should do a ifconfig for knowing yours. The result of this command will be something like this:

Access to AWS Postgres instance in private subnet

I have been working with AWS in the last days and encounter some issues when using RDS.  Generally when you're working in development environment you have setup your database as Publicly accessible and this isn't an issue. But when you're working in Production. So we place the Amazon RDS database into a private subnet. What we need to do for connecting to the database using PgAdmin or other tool? We're going to use one of the most common methods for doing this. You will need to launch an Amazon EC2 instance in the public subnet and then use it as jumping box. So after you have your EC2, you will need to run the following command. See explantion below After this, you will need to configure your PgAdmin. The host name will be your localhost, the port is the same you define in the above command. Maintenance database will be your DB name and the username you have for connecting. Hope this helps you connect to your databases.

Pre order your Super Smash Bros. Ultimate for Nintendo Switch

Are you fan of Super Smash Bros! Don't wait until the last minute, you can pre order you Super Smash Bros Ultimate here This new game has stages and fighters are joined by the combined rosters of every past Super Smash Bros game. If you buy it, you will be enjoying this Limited Time Offer: Piranha Plant Playable Fighter. Buy Super Smash Bros. Ultimate and register your game with My Nintendo by 11:59 PM on Jan. 31, 2019 and get Piranha Plant in your game for free.