Manual de Programación en 64 Bits: Data from MySQL Tables to Harbour Programs + Qt

Visit the New Harbour MiniGUI tutorial

http://www.facebook.com/groups/harbourminigui/

TUTORIALS ABOUT HARBOUR PROGRAMMING by Giovanni Di Maria




Database____ : company



Table_______ : products



Procedures (1) : create_table_products()

"Copy" and "Paste" the following code into MySQL, create a database (company) and a table (products) and 1 procedures: create_table_products ()

"Copiar" y "Pegar" el siguiente código dentro de MySQL, para crear una base de datos (company) y una tabla (products) y 1 procedimiento: create_table_products()



drop database  company;



create database company;



show databases;



use company;



delimiter //



create procedure create_table_products()

begin

    create table products(

    name varchar(20),

    price double(6,2),

    sales_apr  double (6,2),

    sales_may double (6,2),

    sales_jun  double (6,2),

    tot_sales double (8,2),

    ave_sales double (6,2));

end //



delimiter ;



call create_table_products();



describe products;