Member Avatar for SenTnel

Hello!

I need your help again... thanks!

I have a table where I need to insert the same value in all rows and dont know how to.

Table: equipment, Column: available

How can I enter a number 1 in column "available" in all rows?

Thanks again!

  • 3 Contributors
  • 4 Replies
  • 77 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by finito
Member Avatar for finito

SQL?

Update statement

something like

Update table Set x=value where row = 1
Member Avatar for genevish

Omit the WHERE clause

Member Avatar for SenTnel

Thanks a lot!

Member Avatar for finito

please mark as solved if solved.

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.