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 2976 posted 17 years ago by cbrant

SQL MySQL random password string

mysql

1 1307 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 1661 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 1517 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 1266 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 1095 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 1591 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 1263 posted 17 years ago by therobot

SQL Differences between two Tables

mysql

1 1462 posted 17 years ago by zingo

SQL MySQL LOAD DATA INFILE with WHERE

mysql

1 1199 posted 17 years ago by bassnode

SQL Ordering multiple SELECT statements in a UNION

mysql

0 1396 posted 17 years ago by andyhartleeds

SQL MySQL Mass Text/String Replace

mysql

4 1757 posted 18 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 1339 posted 18 years ago by zingo

SQL Change password for mysql root user on debian

mysql

0 1359 posted 18 years ago by therobot

SQL Add an user to an mysql account

mysql

0 1232 posted 18 years ago by therobot

SQL Export and import from MySQL

mysql

2 1236 posted 18 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 1549 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 1123 posted 18 years ago by assbach

SQL HABTM relationship MySQL tables for use in Rails

mysql

0 1330 posted 18 years ago by alexwilliams

SQL MySQL error reporting

mysql

1 1220 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 1661 posted 18 years ago by wolfie

SQL MySQL 3.23 Space after query gotya

mysql

0 1175 posted 19 years ago by benpjohnson

SQL Load CSV into MySQL

mysql

7 1686 posted 19 years ago by brentroady

« Prev 1 2 3 Next »