Re: 'vector<mysqlpp::row> v;' is crashing my program.

[Mengmeng Zhang]

On Thu, Dec 23, 2010 at 11:48 PM, Adrian Cornish <mysql@stripped> wrote:
>
>
> On Thu, Dec 23, 2010 at 10:19 PM, Mengmeng Zhang
> <mengmengzhang1982@stripped> wrote:
>>
>> >          Query queryc = conn.query("CREATE TABLE
> sports_schedule_timeadj
>> This does not preserve the complete structure of the original table.
>
> Good point Mengmeng (hope that is correct first name)

Yep, Mengmeng is my first name. :)

> This will not copy index's etc. Neither will solution I provided

The original way Eric had it actually does preserve indexes. "create
table foo like bar; insert into foo select * from bar" is the way I've
always made exact table copies. (Looking in the docs there are a
couple of esoteric options "create table ... like ... " doesn't
preserve, but they're pretty rarely encountered.)

> [Its a shame usenet became less popular!!]

Indeed!

(Ironically, I think you accidentally sent this reply only to me.)