Hilfe zu Yii2 und php, Sql

SQL

Auto Increment ID in mysqli zurücksetzen

Währen der Entwicklung kommt es immer mal vor das man eine Datenbank Tabelle löschen und von vorne anfangen möchte. Störend ist dabei das eine Auto Increment ID einfach da weiterzahlt wo man, bei der vorherigen Version, aufgehört hat.
Eine Lösung wäre die Tabelle neu zu erzeugen einfacher isst aber diesen Befehl in die SQL Abfrage einzugeben.

ALTER TABLE tablename AUTO_INCREMENT = 1

Für „tablename“ setzt du den Namen der Tabelle ein die du bearbeiten möchtest.

  1. Avatar

    Najlepsze środki na impotencję. Chcesz powiększyć penisa to sprawdź ranking najlepszych suplementów i środków!

  2. Avatar

    Thanks for your entire labor on this web site. My mother take interest in participating in research and it is simple to grasp why. My spouse and i notice all regarding the powerful tactic you produce useful thoughts via your website and in addition recommend response from the others on this subject then our own princess is truly studying a whole lot. Take pleasure in the rest of the year. You have been performing a superb job.

  3. Avatar

    Thank you for your entire labor on this web site. My mom really loves managing investigations and it is obvious why. My partner and i learn all regarding the lively tactic you present rewarding techniques through your web site and in addition invigorate response from some others on the situation then our favorite princess is really starting to learn a whole lot. Take advantage of the rest of the year. You have been doing a stunning job.

  4. Avatar

    I’m commenting to let you be aware of of the beneficial discovery my child developed browsing the blog. She came to find a lot of details, including how it is like to have a great coaching character to get certain people completely comprehend a number of complex issues. You actually did more than her desires. I appreciate you for coming up with such effective, dependable, edifying and cool guidance on that topic to Ethel.

  5. Avatar

    I am glad for writing to make you know what a magnificent encounter my friend’s girl gained studying your web site. She learned several pieces, which include what it’s like to possess an awesome helping nature to let other folks very easily know just exactly several multifaceted subject matter. You truly exceeded people’s expectations. Thank you for presenting these powerful, safe, explanatory and in addition fun tips about this topic to Kate.

  6. Avatar

    I’m also commenting to let you be aware of of the cool discovery my child encountered checking your blog. She came to understand a wide variety of details, most notably how it is like to have a marvelous coaching heart to get folks easily fully grasp a variety of complicated matters. You actually did more than my desires. I appreciate you for delivering such good, dependable, edifying and also cool guidance on that topic to Evelyn.

  7. Avatar

    I enjoy you because of all your efforts on this site. Ellie enjoys doing internet research and it’s easy to see why. All of us hear all concerning the compelling means you deliver good information by means of the blog and as well cause contribution from other people about this concept plus my daughter is actually being taught a lot. Enjoy the remaining portion of the new year. You’re the one carrying out a glorious job.

  8. Avatar

    I enjoy you because of all of the effort on this blog. Betty delights in carrying out internet research and it’s easy to see why. A lot of people hear all about the compelling form you convey both useful and interesting guidelines by means of the blog and attract contribution from other individuals about this area of interest and my child has been becoming educated a great deal. Enjoy the remaining portion of the new year. You’re carrying out a dazzling job.

  9. Avatar

    Thanks for the suggestions about credit repair on this particular web-site. The things i would offer as advice to people is usually to give up this mentality that they buy at this point and fork out later. As being a society most of us tend to make this happen for many factors. This includes trips, furniture, in addition to items we’d like. However, it is advisable to separate one’s wants from the needs. As long as you’re working to raise your credit ranking score you really have to make some trade-offs. For example you may shop online to economize or you can check out second hand outlets instead of high priced department stores intended for clothing.

  10. Avatar

    Thanks for the recommendations on credit repair on this amazing site. A few things i would tell people is always to give up the actual mentality they can buy today and pay out later. Like a society we all tend to do that for many issues. This includes getaways, furniture, and also items we would like. However, you should separate the wants out of the needs. While you’re working to raise your credit score make some sacrifices. For example it is possible to shop online to save cash or you can visit second hand retailers instead of pricey department stores regarding clothing.

  11. Avatar

    Hello there, just became aware of your blog through Google, and found that it is really informative. I’m gonna watch out for brussels. I will appreciate if you continue this in future. A lot of people will be benefited from your writing. Cheers! https://hypothyroidismmed.com/ hypothyroidism drug treatment

Schreibe eine Antwort