This is a great set of two commands that allow the creation and population of a new table with the structure and data of an existing table. This provides a quick means of making a point-in-time copy of a table and is a safe, easy way to make a quick copy of a table for testing an application in development on live data without risking a production environment.

CREATE TABLE members LIKE iproton.users;

creates the new table “members” by duplicating the structure of the existing table “users”.

INSERT members SELECT * FROM iproton.users;

The second command copies the data from old to new.

Change the logo in the player of Adobe presenter

1. Create a new file named logo.swf(The ideal size for the finished logo.swf file is 47 x 27 pixels) that contains your custom branding.
2. In Windows Explorer, navigate to the templates folder where Presenter 7 was installed.
3. Add your custom logo.swf file to the Templates folder.
4. In PowerPoint, publish the presentation to your computer.
5. View the output to see the new logo.

Remove the “Adobe Presenter” during loading….

1. Open a presentation in PowerPoint, and save and publish the presentation to your computer to copy the files locally.
2. In Windows Explorer, locate this folder:
c:\Documents and Settings\username\My Documents\My Adobe Presentations\PresentationName\data
3. Open the vconfig.xml file in an XML editor or Notepad. Scroll down about one-half page to the section, and type this code on a blank line, inserting your custom text as the value:

4. Save and close the vconfig.xml file.
5. Open the index.htm web page holding the presentation, located here:
c:\Documents and Settings\username\My Documents\My Adobe Presentations\PresentationName
6. When the page opens, view your custom text as the presentation loads.

Rather than leaving the default Adobe Presenter preload text, or customizing the text for each presentation, you can modify an Adobe Presenter program file to change the text for all your presentations. Here’s how:
1. Locate the Themes folder on your hard drive.On Windows XP, in Windows Explorer, find the folder here:
c:\Documents and Settings\username\Local Settings\Application Data\Adobe\Adobe Presenter\Themes
On Windows Vista, from the desktop click Start > Run and type the following command:
%LOCALAPPDATA%\Adobe\Adobe Presenter
Click OK to close the Run dialog box and open the folders; double-click the Themes folder.
2. Open the language.xml file in an XML editor or Notepad.
3. Look for the section near the start of the file, and type this code, inserting your custom text as the value:

4. Save and close the language.xml file.
5. Back in PowerPoint, save and publish the presentation to your computer, selecting the View Output option.
6. Test the new content.