SQL - examples

 3 tables join

SELECT

  tbl_data_09_12_fon_islem.fon_id,

  tbl_data_09_11_fon_id.fon_ad,

  tbl_data_09_12_fon_islem.islem_id_date,

  tbl_ref_09_11_islem_tip.islem_tip, 

  tbl_data_09_12_fon_islem.islem_amount 

FROM

  tbl_data_09_12_fon_islem

  INNER JOIN tbl_data_09_11_fon_id ON tbl_data_09_12_fon_islem.fon_id = tbl_data_09_11_fon_id.fon_id

  INNER JOIN tbl_ref_09_11_islem_tip ON tbl_data_09_12_fon_islem.islem_tip_id = tbl_ref_09_11_islem_tip.islem_tip_id 

Order By tbl_data_09_11_fon_id.fon_ad, tbl_data_09_12_fon_islem.islem_id_date;

Relationship; 

suppose we have two tables country and city

• country: 
• countryid - integer - Primarykey
• countryname - char - index unique
• city
• cityid - int - primary key
• cityname - char - index unique
• countryid - int - index 
• relationship connection is done here on the child table and not on the parent
• so the relationship to the table country will appear on here
• you must first create the index here so as the connection 1 to many becomes possible 

XAMPP - how to transfer db from one computer to another

• dbconfig.php
• localhost:3310 or whatever - change it
• phpmyadmin
• user account password 
• olustur
• pass ayni olmayabilir ona gore update?
• user account config pass 
• degistir
• XAMPP 
• kapat
• yeniden ac
• XAMPP versiyonlari
• bendeki versiyon neyse karsida oyle olmali
• apache 4.47
• işlemeyen versiyon: 4,50
• php 7.23.18
• işlemeyen versiyon: 8,0,11
• karsi tarafta versiyon farkliysa islemeyebilir
• php update ve ust versiyonlarda sistem islemeyebilir
•