Instructional Tennis

SQL statements

Create Table SQL

CREATE TABLE tblEquipment (
pmkEquipmentId INT AUTO_INCREMENT PRIMARY KEY,
fldEquipmentName varchar(100),
fldStrings varchar(100),
fldSpecsDesc varchar(400)
);

Populate the table with data

INSERT INTO tblEquipment (fldEquipmentName,
fldStrings, fldSpecsDesc) VALUES

('Head Prestige MP', 'Solinco Revolution', 'This an 11.3 oz racquet with an 18x20 string pattern.
 This racquet offers the utmost prescision and control without losing its power. 
 The solinco strings provide better feel and control on the ball.' ),

('Wilson Pro Staff SIX.ONE', 'Wilson Natural Gut', 'This is a heavier and more dense racquet accustomed for the more advanced
and professional players. It weighs at 11.6 oz with an 18x20 string pattern which again offers a more precise and controlled feel.
Many professionals use natural gut due to its ultimate feel, however natural gut wears down very quickly and costs a fortune.'),

('Tecnifibre TFight 305RS', 'Head Lynx Tour', 'This is an 11.4 oz racquet with an 18x19 string pattern. This pattern, though a slight difference
compared to the 18x20 pattern, creates more power without losing its precision. This is a combination of the popular 16x19 and 18x20 pattern.
The head lynx tour string is used by a few players on the pro tour because of its popular use as a hybrid string.'),

('Wilon Ultra Tour', 'Solinco Revolution 17G', 'This is a lighter racquet weighing 10.8 oz and is much more-user friendly compared to 
the racquets listed above. With lead tape added to certain sections of the racquet, it can become a very consistent and powerful racquet. The 17 gauge 
string is just a thinner version of the regular solinco revolution and is more accustomed to 18x20 racquets.');

Select data for display

SELECT fldEquipmentName, fldStrings, fldSpecsDesc FROM tblEquipment
        

Create table to save forms data

CREATE TABLE tblFavoritePlayer (
        pmktblFavoritePlayerId INT AUTO_INCREMENT PRIMARY KEY,
        fldPlayerLeague varchar(40),
        fldWhyPlayer text,
        fldFirstName varchar(50),
        fldLastName varchar(50),
        fldPlayerName varchar(60),
        fldEmail varchar(60),
        fldExperience varchar(20),
        fldServeVolley boolean,
        fldAggressiveBaseliner boolean,
        fldCounterPuncher boolean

);

Populate table with data

        INSERT INTO tblFavoritePlayer (fldPlayerLeague, fldWhyPlayer, fldFirstName, 
        fldLastName, fldPlayerName, fldEmail, fldExperience, 
        fldServeVolley, fldAggressiveBaseliner, fldCounterPuncher) VALUES
        ('ATP', 'I like this player because of how powerful he is', 'Arjun', 'Nair', 'Stan Wawrinka',
        'arjunps.nair@gmail.com', '1', '1', '1', '0');
        

Select data for display

SELECT fldPlayerLeague, fldWhyPlayer, fldFirstName, fldLastName, fldPlayerName, fldEmail, fldExperience,
fldServeVolley, fldAggressiveBaseliner, fldCounterPuncher FROM tblFavoritePlayer