Member Avatar for gikonyo

am designing a database of which i want to increment no starting 70000 ever time a new record is updated in the table. i have the following columns order_no,urgency,cost_per_item,total_cost. therefore i want the order_no to be generated automatically starting from 70000. how do i set the database to auto increment.

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

1) Define order_no as an auto_increment field.
2) Enter ALTER TABLE mytable AUTO_INCREMENT = 70000; at the mysql command prompt.

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.