I have MySQL tables in notepad, how can i put them in MySQL database server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sajad Bhat
    New Member
    • Apr 2011
    • 8

    I have MySQL tables in notepad, how can i put them in MySQL database server

    I have MySQL tables in Ms. Notepad, how can i put them in MySQL Server and want to extract all the required information from these tables to make an excelsheet.plea se give the answer in a detailed way so that i can implement the same. Please reply anybody to my ID saajgow@yahoo.c om.

    Thanks & regards
    Sajad H Bhat
  • dgreenhouse
    Recognized Expert Contributor
    • May 2008
    • 250

    #2
    Are you saying that you have the table creation and data insertion statements in a text file?

    If you have phpMyAdmin installed, you could use that.

    If not, you could possibly create a program to execute the creation/data insertion stuff.

    If not that, then you'd need access ssh on linux or the cli on windows.

    Give an example of the contents of the file.
    NOT THE WHOLE FILE - PLEASE! :)

    Also let us know if you have phpMyAdmin installed and your level of computer expertise in general.

    Comment

    Working...