Sunday 29 January 2017
IMPORT SQL CSV FILE ON PHPMYADMIN
---------------------------------------------------------------------------------------------------
READ MORE:
----------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
https://www.youtube.com/watch?v=iidJTbbhp94&t=60s
https://www.tutorialspoint.com/execute_sql_online.php
http://www.sqlcourse.com/create.html
http://spreadsheetpage.com/index.php/file/C35/
---------------------------------------------------------------------------------------------------
1) MAKE DATA BASE NAME
2) MAKE Main.sql FILE
3) IMPORT SQL FILE WITH
IMPORT BUTTON AND PRESS GO BUTTON
4) PRESS BROWS BUTTON FOR VIEW
---------------------------------------------------------------------------------------------------
CODE: Main.sql
---------------------------------------------------------------------------------------------------
CREATE TABLE NAMES(Id integer PRIMARY KEY, Name text);
INSERT INTO NAMES VALUES(1,'Tom');
INSERT INTO NAMES VALUES(2,'Lucy');
INSERT INTO NAMES VALUES(3,'Frank');
INSERT INTO NAMES VALUES(4,'Jane');
INSERT INTO NAMES VALUES(5,'Robert');
---------------------------------------------------------------------------------------------------
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment