12-24-2009, 01:06 AM
I've been learning SQL through phpmyadmin, but I also want to see what it's like without phpmyadmin. However, I'm having some problems.
I have
saved into Test.sql
I want to see my chart or some sort of result in my browser, how do I do this. I've already tried putting it in /var/www/. However, that didn't work, it only displayed Test.sql in plain text.
I have
Code:
-- phpMyAdmin SQL Dump
-- version 3.1.2deb1ubuntu0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 24, 2009 at 01:58 AM
-- Server version: 5.0.75
-- PHP Version: 5.2.6-3ubuntu4.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `mydomain`
--
-- --------------------------------------------------------
--
-- Table structure for table `people`
--
CREATE TABLE IF NOT EXISTS `people` (
`id` int(6) NOT NULL,
`name` char(100) NOT NULL,
`telephone` char(50) NOT NULL,
`birthday` char(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `people`
--
INSERT INTO `people` (`id`, `name`, `telephone`, `birthday`) VALUES
(100100, 'ross', '222 222 222', '3 january'),
(200200, 'John', '999 999 999', '19 may'),
(300300, 'jane', '888 888 888', '19 july');
saved into Test.sql
I want to see my chart or some sort of result in my browser, how do I do this. I've already tried putting it in /var/www/. However, that didn't work, it only displayed Test.sql in plain text.