örnek sql dump edin deneyelim
Usta buyur da arkadaşlar yazmıştı zaten öyle olmayacağını önceki mesajlarda;
-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 17, 2009 at 10:39 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `beles`
--
-- --------------------------------------------------------
--
-- Table structure for table `students`
--
CREATE TABLE `students` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`housephone` text NOT NULL,
`teachmaterial` text NOT NULL,
`studyimproving` text NOT NULL,
`english` text NOT NULL,
`abacus` text NOT NULL,
`science` text NOT NULL,
`piano` text NOT NULL,
`gogame` text NOT NULL,
`math` text NOT NULL,
`meal` text NOT NULL,
`commission` text NOT NULL,
`total` text NOT NULL,
`date` text NOT NULL,
`notes` text NOT NULL,
`transportation` text NOT NULL,
`durum` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;
--
-- Dumping data for table `students`
--
INSERT INTO `students` VALUES(67, 'aiueaiuea', '5424', '542', '52', '52', '52', '220', '2', '0220', '20', '0', '014', '1194', 'January', 'aeiauieauieauei', '20', 'Payment Not Completed');
INSERT INTO `students` VALUES(68, 'iuauea', 'ieauiea', '41452', '542', '2452', '4524', '2452', '24452', '452', '4', '2452', '4524', '85758', 'July', 'eiaueiaiuea', '2452', 'Payment Completed');
INSERT INTO `students` VALUES(69, 'eiuaeia', 'uiea', '14', '421', '25', '254', '45', '542542', '24', '254242', '52', '245', '798316', 'April', 'eauieaiuea', '452', 'Payment Not Completed');
INSERT INTO `students` VALUES(70, 'eiuaeia', 'ae', '41', '141', '41', '41', '41', '41', '41', '41', '52', '54245', '54779', 'May', 'üieuaeuiauie', '054', 'Payment Not Completed');
INSERT INTO `students` VALUES(71, 'iuauea', 'üa', '25', '25', '54', '45245', '452452', '2', '2', '245', '524524', '452', '1023478', 'April', 'aeuauieauieaiueaueiauei', '452', 'Payment Not Completed');
INSERT INTO `students` VALUES(72, 'aa', 'uie', '47', '25', '52', '452', '452', '524', '2452', '542', '452', '452', '5902', 'January', 'auieaieuaieu', '452', 'Payment Completed');
INSERT INTO `students` VALUES(73, 'aa', '63,6', '', '', '', '', '', '', '', '', '', '', '0', 'January', '', '', 'Payment Completed');
INSERT INTO `students` VALUES(74, 'aa', '25', '25', '25', '25', '52', '2', '542', '52', '452', '245', '452', '1924', 'April', '', '52', 'Payment Not Completed');