Create temporary database php

Question

This might sounds stupid but is it possible to create temporary table/database using Zend Framework and Mysql? If it is possible, may I have a sample code? Thanks

ntchosting.com/mysql/create-database.html read the manual and use the queries in php as you need. — Peon
– Peon, Commented Aug 6, 2012 at 9:00

madflow · Accepted Answer · 2012-08-06 08:57:09Z

2

/* @var $db Zend_Db */
$db->execute('CREATE TABLE tmp LIKE table_something');

answered Aug 6, 2012 at 8:57

madflow

8,6933 gold badges45 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Fluffeh Over a year ago

This will make a table, not a database. The question is asking about how to make an actual database.

madflow Over a year ago

...create temporary *table*/database

Laurynas Tretjakovas · Accepted Answer · 2012-08-06 09:00:42Z

2

It is the same as you would create a normal talble, just add 'TEMPORARY' after 'CREATE'. Such tables will be dropped after the connection closes.

$db->execute('CREATE TEMPORARY TABLE tmp');

answered Aug 6, 2012 at 9:00

Laurynas Tretjakovas

6594 silver badges12 bronze badges

Comments

Kalpesh · Accepted Answer · 2012-08-06 09:02:15Z

2

In Mysql, you can create temporary table with engine BLACKHOLE

It creates tables on the fly, means it will only be available upto one HTTP request, and on completing it will be deleted.

CREATE TABLE table_name engine = BLACKHOLE;

I don't know how to do in Zend, but may be something like this would help:

$db->execute("CREATE TABLE table_name engine = 'BLACKHOLE'");

answered Aug 6, 2012 at 9:02

Kalpesh

5,6952 gold badges25 silver badges39 bronze badges

2 Comments

txyoji Over a year ago

Blackhole engine does not save data, even for a single request. dev.mysql.com/doc/refman/5.0/en/storage-engines.html

Kalpesh Over a year ago

It will hold the data temporarily during the query. It don't store it there permanently.

Collectives™ on Stack Overflow

Create temporary database php

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related