Member Avatar for Shodow

Is this possible?

Insert Into Customer(CustomerID, CustomerName) Values('6','test') on DUPLICATE key Update CustomerID='Select Max(customerID)+1 from Customer'

  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for adam_k

why not just go with :

insert into customer(customerid, customername) select max(customerid) + 1 , 'test' 
from customer
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.