Tags » PHP/MySQL

Εισαγωγή μεγάλου αρχείου sql από cmd

C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root -p YourDatabaseName < YourFileName.sql
PHP/MYSQL

Msql tutorial

1. ΑΠΛΟ JOIN (ΓΡΑΦΕΤΑΙ ΚΑΙ ΧΩΡΙΣ ΤΟ KEYWORD JOIN) 

SELECT posts.title, categorys.title FROM posts,categorys WHERE posts.category_id = categorys.id
SELECT `posts`.`title`, `categorys`.`title` FROM `posts` JOIN `categorys` ON `posts`.`category_id`=`categorys`.`id` 
… 93 more words
PHP/MYSQL

Εξαγωγή excel με php/mysql

<?PHP

//EDIT YOUR MySQL Connection Info:
$DB_Server = “localhost”; //your MySQL Server
$DB_Username = “root”; //your MySQL User Name
$DB_Password = “”; //your MySQL Password… 635 more words

PHP/MYSQL