Skip to main content

:: how to reset auto increment in mysql

:: how to reset auto increment in mysql
mysql> ALTER TABLE table_name AUTO_INCREMENT = 0;
0 = starting value for auto increment

:: links
+ googlelinux
+ bayublitar
Labels:

Comments

Post a Comment

Popular posts from this blog

:: solution for libtoolT error

:: what is please take a look at this. :: case /bin/rm: cannot remove `libtoolT': No such file or directory if you get some error message like that when you compiling some application from source you can do like this for resolve on it. :: solution this example for resolve on compiling mysql package. install libtool packages from repository and run liboolize command line on the package: linux:~/download/mysql-5.1.37 # yum install libtool linux:~/download/mysql-5.1.37 # libtoolize --force linux:~/download/mysql-5.1.37 # autoconf and/or linux:~/download/mysql-5.1.37 # autoreconf after that you can recompile and install your package from source. :: links + GoogleLinux
4 comments
:: Read more..

:: install postfix, cyrus, courier, mysql, postfixadmin, squirrelmail on opensuse

:: what is please take a look this. :: install dependency + installing berkeleyDB + installing MySQL + installing Apache + installing PHP :: remove sendmail [ root:~ ]# rpm -e sendmail --nodeps :: build cyrus-sasl [ root: ~ ]# wget ftp://ftp.andrew.cmu.edu/pub/cyrus-mail/cyrus-sasl-2.1.23.tar.gz [ root: ~ ]# tar -xzf cyrus-sasl-2.1.23.tar.gz [ root: ~ ]# groupadd mail [ root: ~ ]# useradd -u 96 -d /usr/cyrus -g mail cyrus [ root: ~ ]# passwd cyrus [ root: ~ ]# cd cyrus-sasl-2.1.23/ [ root: cyrus-sasl-2.1.23 ]# export CPPFLAGS="-I/usr/local/mysql/include/mysql" [ root: cyrus-sasl-2.1.23 ]# ./configure --enable-anon --enable-plain --enable-login --enable-sql --disable-krb4 --disable-otp --disable-cram --disable-digest --with-mysql=/usr/local/mysql --with-plugindir=/usr/lib/sasl2 --without-pam --without-saslauthd --without-pwcheck [ root: cyrus-sasl-2.1.23 ]# make && make install :: installing Postfix + download postfix [ root:~ ]# wget http://mirror.postfix.jp/...
Post a Comment
:: Read more..

:: installing berkeley db on linux

:: what is please take a look at this. :: download berkeley db [ linux:download ] # wget http://download.oracle.com/berkeley-db/db-4.8.24.tar.gz [ linux:download ] # tar -xzf db-4.8.24.tar.gz :: build/compiling berkeley db [ linux:download ] # cd db-4.8.24/build_unix/ [ linux:~/db-4.8.24/build_unix ] # ../dist/configure [ linux:~/db-4.8.24/build_unix ] # make && make install [ linux:~/db-4.8.24/build_unix ] # echo '/usr/local/BerkeleyDB.4.8/lib/' >> /etc/ld.so.conf [ linux:~/db-4.8.24/build_unix ] # ldconfig :: links + googlelinux
Post a Comment
:: Read more..