You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP s...

0 871 posted 16 years ago by zingo

SQL Grant MySQL Privileges

To grant all privileges to a user from any location login to the mysql shell and run the following queries.

3 653 posted 16 years ago by cbrant

SQL Set MySQL root password

To reset the MySQL root password, login to the mysql shell and run the following commands.

1 648 posted 16 years ago by cbrant

SQL UPDATE, falls Eintrag schon vorhanden, sonst INSERT

Wenn ein INSERT einen doppelten Wert erzeugen wÃ¼rde, wird das UPDATE ausgefÃ¼hrt.

mysql
update

1 491 posted 16 years ago by drk

SQL TSQL for Recursive Select Using Common Table Expressions

0 726 posted 16 years ago by rengber

SQL MySQL Commands I wish I could remember

https://www.chrisjmendez.com/2008/03/23/mysql-commands-i-wish-i-could-remember/

mysql
sql

9 723 posted 16 years ago by chrisaiv

SQL SQL To Show WaitTime and other Process Stats

0 591 posted 16 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 797 posted 16 years ago by rengber

SQL Update from select

sql
update

4 777 posted 16 years ago by wolfie

SQL TSQL to Reset a Tables Primary Key Autonumber

database
sql

0 587 posted 16 years ago by rengber

SQL See all mysql grants

It does not show the grants themselves, but shows all users with grants.

mysql

0 631 posted 16 years ago by therobot

SQL Differences between two Tables

mysql
sql

1 796 posted 16 years ago by zingo

SQL Copy table into a new table

Oracle
sql

0 532 posted 16 years ago by Caliban

SQL Generate the SQL necessary to create triggers (Oracle)

Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with â€˜tblâ€™. It may need to be modified to work with different naming conventions.

Oracle
sql

0 533 posted 16 years ago by thecrumb

SQL Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create sequences for every table. NOTE: This doesnâ€™t create sequences. The results need to be copied and run as a script.