Tags
PHP , MySQL
Asked 7 years ago
21 Nov 2016
Views 1097
sqltreat

sqltreat posted

how to reset AUTO INCREMENT in MySql ?

How to reset Auto Increment in MySql

i set my id as Primary Key with not null and auto increment .
but problem arise that i was testing environment untill now for my PHP web application. now i am transferring it to production.and i want to reset all Auto increment to 0 so it start with 1
so tell me how to reset Auto increment to 1 so it start Counting from 1 again.

jassy

jassy
answered Apr 24 '23 00:00

To create a drop-down menu in HTML, you can use the <select> and <option> tags. Here's a step-by-step guide on how to do it:

1.Create a <select> tag: The <select> tag is used to create the drop-down menu. Within the <select> tag, you can add the different options that will appear in the menu.

2.Create <option> tags: Within the < select > tag, create one or more <option> tags to specify the options that will appear in the drop-down menu. Each < option > tag should have a value attribute that will be sent to the server when the form is submitted.

3.Add text to the < option > tags: Between the opening and closing < option > tags, add the text that you want to appear in the drop-down menu.

4.Close the <select> tag: Once you have added all the < option > tags, close the <select> tag.

Here's an example of what the HTML code for a simple drop-down menu might look like:



<form>
  <label for="menu">Select a menu item:</label>
  <select id="menu" name="menu">
    <option value="item1">Item 1</option>
    <option value="item2">Item 2</option>
    <option value="item3">Item 3</option>
    <option value="item4">Item 4</option>
  </select>
  <input type="submit" value="Submit">
</form>

In this example, the < select > tag creates the drop-down menu, and each < option > tag specifies one of the menu items. The value attribute for each < option > tag specifies the value that will be sent to the server when the form is submitted.
Post Answer