WEEKLY REFLECTION 3

1. Start class on 11am
2. Download xampp
3. Rest
4. Miss explain how to do the database

• how to create database
• how to insert the data
• insert the field name,data type
• change column and field name

     5. Create table
      
         create table_table_table_name (field_name1 data_type (field_size),
                                                        (field_name2 data_type (field_size),

    6. How to show all the table in the database you're created :
      
       show tables ;

       How to show your table that you're ceated

       describe table_name ;

   7. How to insert the record/data in table

• insert into table_name values ("data1","data2","data3",....);
• must be match with your field name when you insert the data

                                                   or

• insert into table_name (field name 1,field name 2,......)

                                            values ("data1","data2",....);

  8. To display data that contains in table

   

       -----> select * from table_name;

  9. Change column / field name

     alter table table_name change old_field_name new_field_name data_type (field_size);