Method 1

In MySQL, run these statements:

/*This will create table2 with the schema of table1*/
CREATE TABLE `table2` LIKE `table1`
 
/*This will copy the data from table1 to table2*/
INSERT INTO `table2` SELECT * FROM `table1`

Method 2

On the command line, run these commands:

# Create a dump from MySQL.
# The -d flag will only copy the structure/schema of the tables. If you want
# to copy the data along with the schema then dont use -d flag
#
# In here, two MySQL commands are piped so the output from mysqldump is sent 
# to mysql command
mysqldump -d -u username -pPassword  db_name | mysql -u username -pPassword db_new_name

Share on Facebook

DESCRIBE `table_name`

Mysql will give you table information which will contain field names, their types, etc. What if you want just the field names and nothing else? You can run this query and do just that:

SELECT column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tablename'
AND   table_schema = 'dbname';

Share on Facebook

By default, Zend Studio has a 200 millisecond delay in showing code assist. You can shorten it if you feel the delay is too long. I set it to 100 milliseconds.

Go to Preferences -> Java -> Editor -> Content Assist -> Auto-Activation and decrease Auto activation delay from 200 to 100 (or whatever suits you better).

Share on Facebook

 
/*
If the CSV file was created in Windows, then replace '\n' with '\r\n' 
*/
LOAD DATA LOCAL INFILE '/path/to/csv_file.csv' INTO TABLE `table_name`
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY "\"" 
LINES TERMINATED BY '\n' 
(field1, field2, field3);

Share on Facebook

# Use the -e flag
shell>mysql -e "select * from table"

Tell MySQL to output the results of a query in HTML or XML

# On command line you would write the following to 
# tell MySQL to output the results in HTML format
shell>mysql -e "select * from table" --html
 
# This is for XML
shell> mysql -e "select * from table" --xml
 
# This is for batched results
shell> mysql -e "select * from table" --batch

Share on Facebook

http://kb.zend.com/index.php?View=entry&EntryID=480

Share on Facebook

So I decided to make Zend Server connect to my default MySQL instance instead of uninstalling Zend Server (because I want to play with it). For those with the same problem, you can do this:

# Rename Zend Studio's socket file to something else
# If you didn't choose the default, installation path then 
# use the path to that location instead
mv /usr/local/zend/mysql/tmp/mysql.sock /usr/local/zend/mysql/tmp/mysql_old.sock
 
# My MySQL installation's socket file is located in /tmp
# If your's is different, then you will have to modify the source path
 
ln -s /tmp/mysql.sock /usr/local/zend/mysql/tmp

Share on Facebook

The way to resolve this is to have a ::1 entry in your hosts file for every 127.0.0.1 entry. Here’s an example:

127.0.0.1         example.com
::1               example.com

You will notice I have 2 entries for example.com. One is IPv4 and the other is IPv6. My requests to the local web server take almost no time at after I did that. I think Lion tries to use IPv6 before it uses IPv4 and since it doesn’t find any entries for that in your hosts file, it goes to the internet searching for that domain.

Share on Facebook

1. You sign up with Sabre for a web services account and you they will give you an IPCC, username and passwrord that you use for communicating with their web services.You will send over the username and password for only authentication request. However, you will use your IPCC in all the requests you make.
2. Your initial request should be a SessionCreate request. You will provide your username and password in it. Upon success, you will receive a binary token. You will use this token in all the subsequent requests you make.
3. Your subsequent requests will depend on what you want to do and the services you have access to. Sabre has multiple flight services that you can communicate with. You will need to contact them, explain your needs and ask what service will be best for you. LowFareSearch and BargainFinder are probably the ones that are most used.
4. After you are done selecting the flight, etc. You will send a request to AirBook (if I remember the name correctly) to book a flight. And, there’s other services you might want to use to pass passenger information, etc.
5. After you are done, you end the session with a call to SessionCloseRQ.

When you get an account with Sabre, you will be able to look at request and response formats for  the for the web services over here: https://drc.sabre.com/oer/

Share on Facebook

Share on Facebook