Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged mysql

« Prev 1 2 3 Next »

SQL MySQL Table - ISO Country List with Abbreviations

This will create and then populate a MySQL table with a list of the names and ISO 3166 codes for countries in existence.

mysql

5 2171 posted 17 years ago by cbrant

SQL MySQL random password string

mysql

1 1107 posted 17 years ago by stancell

SQL Storing an IP address in a database table

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...

mysql

0 1372 posted 17 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.

mysql

3 1111 posted 17 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.

mysql

1 1032 posted 17 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

1 846 posted 17 years ago by drk

SQL MySQL Commands I wish I could remember

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

mysql

9 1151 posted 17 years ago by chrisaiv

SQL See all mysql grants

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

mysql

0 1035 posted 17 years ago by therobot

SQL Differences between two Tables

mysql

1 1268 posted 17 years ago by zingo

SQL MySQL LOAD DATA INFILE with WHERE

mysql

1 1006 posted 17 years ago by bassnode

SQL Ordering multiple SELECT statements in a UNION

mysql

0 1202 posted 17 years ago by andyhartleeds

SQL MySQL Mass Text/String Replace

mysql

4 1265 posted 17 years ago by andyhartleeds

SQL Generate Simple Bar Charts From a MySQL Prompt

You can generate a simple bar chart of the values by executing this command...

mysql

0 1154 posted 17 years ago by zingo

SQL Change password for mysql root user on debian

mysql

0 1137 posted 17 years ago by therobot

SQL Add an user to an mysql account

mysql

0 1027 posted 17 years ago by therobot

SQL Export and import from MySQL

mysql

2 1007 posted 17 years ago by micmath

SQL SELECT older than x days

2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days

mysql

2 1084 posted 18 years ago by assbach

SQL now plus 20 years

useful if a "valid until" should have an exact ( in this case far future ) value.

mysql

0 949 posted 18 years ago by assbach

SQL HABTM relationship MySQL tables for use in Rails

mysql

0 1097 posted 18 years ago by alexwilliams

SQL MySQL error reporting

mysql

1 1062 posted 18 years ago by Shpigford

SQL How to determine a timeout using unix time in mysql

This will return the number of seconds between now and when the time field was inserted.

mysql

0 1263 posted 18 years ago by wolfie

SQL MySQL 3.23 Space after query gotya

mysql

0 1015 posted 18 years ago by benpjohnson

SQL Load CSV into MySQL

mysql

7 1203 posted 18 years ago by brentroady

« Prev 1 2 3 Next »