Member Avatar for Mylsamy

Hi all,

I am using mySql query to insert a row into table.

I have two tables as Table1 and ZTable1.

Table1 has 3 fields TId,TName,TAge .

ZTable1 has 4 fields ZTId,TId,TName,TAge.

Table1 has 1 row.

1, Myl,24.

Now i want to insert values to ZTAble1 as 1,(1,Myl,24) these values from Table1.

I insert that row in ZTable1 along with 1 as ZTId.

How can I do this?

Plz very urgent.

Help me.

  • 2 Contributors
  • 2 Replies
  • 82 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Mylsamy
Member Avatar for smantscheff 
insert into ZTable1 select 1, ZTable.* from ZTable

Or maybe you want

insert into ZTable1 select TId,TId,TName,TAge from ZTable

It's hard to tell from your post.

Member Avatar for Mylsamy

Thank you smantscheff. I solved the problem using your tip

insert into ZTable1 select 1, ZTable.* from ZTable

Or maybe you want

insert into ZTable1 select TId,TId,TName,TAge from ZTable

It's hard to tell from your post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.