SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    If I want to see the table, should I use Excel?

    Hello

    This question is coming from someone who has been struggling to understand the first day of the Sitepoint PHP/MySQL course for weeks.

    It is my perception (am I wrong?) that when a person wants to make a table or insert or edit the data in a cell of the table, it is done in MySQL via commands that the writer needs to memorize, and typed in piece by piece. It would take an inept person like me an unworkable amount of time to do that. It's hard for me to work on things where I can't really see what I'm doing and I have to remember a bunch of commands the whole time.

    Apparently MySQL can accept csv files from Excel, where I can write cell data and actually see the cells all lined up and next to each other. This would be a much more feasible method for me.

    What I want to end up with is trivial. I want to make an HTML page of text articles in one container that are selected for view by a list of links in another container. It could be short rants or recipes or plot summaries or some such things.

    Is Excel the dummy tool that I need?

    Thank you kindly

    MP

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Mr pseudonym View Post
    ... it is done in MySQL via commands that the writer needs to memorize, and typed in piece by piece.
    not really

    go get yourself HeidiSQL and give it a try

    this is a comprehensive "front end app" that acts as a user-friendly interface between you (the person) and mysql

    of course, there are others (e.g. the mysql query browser, navicat, sqlyog, etc.), but i like this one the best
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile

    Yes, you need strong programming skills to use PHP and MySQL. However, phpMyAdmin is replacement of PHP and MySQL for non-programmer. It offers a simple way to manage / optimize the fields and tables of your database. See an example Optimize Database Table

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    when i mentioned front end apps for mysql, i left phpmyadmin out on purpose

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I got that Heidi thing and I can't make head nor tail of it. Maybe in five or ten years when I understand this better.

    But phpMyAdmin has an insert tab that seems to provide a usable framework for entering stuff.

    P

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    in heidisql, you insert new data like this --

    1. use the left pane to navigate to the table

    2. click on the Data tab -- this allows you to browse through the rows in the table

    3. look for the round buttons at the top -- a green one with a plus sign and a red one with a minus sign -- these are for inserting a row or deleting a row
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •