#auto increment

Mysql Sıradaki Atlanmış Boş Otomatik Id Numaralarını Bulma

Bazen auto increment kullanırken aradan veriler silinebiliyor. Bunları doldurabilmek için bu şekilde bir kullanım ile tekrar boş idleri doldurabilirsiniz SELECT t1.id+1 AS siradaki FROM urun AS t1 WHERE 0=(SELECT COUNT(t2.id) FROM urun AS t2 WHERE t2.id=t1.id+1 order by t2.id asc) order by t1.id asc LIMIT 1 Yukarıdaki örnekte urun adlı tablodaki id sütununa göre arama yapar ve limit sayısınca…

SQL Auto Increment allows a uniqe number to be generated automatically when a new record created into the database table. This is usually the primary key field that we would like to be created automatically every time a new record is added in table. The keyword AUTOINCREMENT can only be used with the INTEGER datatype field. Syntax CREATE TABLE tablename( column1 INTEGER AUTO_INCREMENT, column2…

CREATE TABLE auto_increment ( id CHAR(36) NOT NULL COLLATE 'latin1_swedish_ci', store_id CHAR(36) NOT NULL COLLATE 'latin1_swedish_ci', shift_date DATE NOT NULL, store_sequence INT(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) USING BTREE, INDEX store_id_shift_date_store_sequence (store_id, shift_date, store_sequence) USING BTREE ) COLLATE='latin1_swedish_ci' ENGINE=MyISAM;

Main things:

Engine: MyISAM

set Auto Increment for sequential column

Make composed key for sequential column along with categories column

こんにちは。SHUNです。

MySQLのAUTO INCREMENTは便利な機能ですが、開発環境下でリセットしたり、手動でセットしたくなることもあるのでメモ。

手動でAUTO INCREMENTの値を設定

ALTER TABLE table_name AUTO_INCREMENT=1000;

AUTO INCREMENTのリセット

... Now I know that I have a problem creating tables -.-'

:I The Auto_Increment doesn't work... Is it really "CREATE TABLE User (id INTEGER AUTO_INCREMENT, ..."?

New Post has been published on http://mocco.sk/installing-powerdns-with-mysql-backend/

Installing PowerDNS with MySql backend

The PowerDNS Nameserver is a modern, advanced and high performance authoritative-only nameserver. It is written from scratch and conforms to all relevant DNS standards documents. Furthermore, PowerDNS interfaces with almost any database.

This tutorial has been tested and is working on Debian etch and lenny

1. Install the PowerDNS server and MySql backend using apt

apt-get install pdns-server pdns-backend-mysql

2. Create a new database (or use existing) and execute the following SQL queries to create the PowerDNS table structure:

create table domains ( id INT auto_increment, name VARCHAR(255) NOT NULL, master VARCHAR(128) DEFAULT NULL, last_check INT DEFAULT NULL, type VARCHAR(6) NOT NULL, notified_serial INT DEFAULT NULL, account VARCHAR(40) DEFAULT NULL, primary key (id) )type=InnoDB;   CREATE UNIQUE INDEX name_index ON domains(name);   CREATE TABLE records ( id INT auto_increment, domain_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(6) DEFAULT NULL, content VARCHAR(255) DEFAULT NULL, ttl INT DEFAULT NULL, prio INT DEFAULT NULL, change_date INT DEFAULT NULL, primary key(id) )type=InnoDB;   CREATE INDEX rec_name_index ON records(name); CREATE INDEX nametype_index ON records(name,type); CREATE INDEX domain_id ON records(domain_id);   create table supermasters ( ip VARCHAR(25) NOT NULL, nameserver VARCHAR(255) NOT NULL, account VARCHAR(40) DEFAULT NULL );

3. Configure PowerDNS to use the MySql backend by adding this line into the configuration file (pico /etc/powerdns/pdns.conf)

launch=gmysql

4. Configure MySql login information for the PowerDNS server that can read from the tables you created earlier by adding lines similar to these (pico /etc/powerdns/pdns.d/pdns.local)

gmysql-host=127.0.0.1 gmysql-user=pdns gmysql-password=password gmysql-dbname=pdns

Replace the username, password and dbname with a valid login information and database name.

5. Restart PowerDNS

/etc/init.d/pdns restart

Now you should have a fully functional PowerDNS server installed. To manage the database (adding zones and records), consider using the Poweradmin web-based administration tool.