Login / Register

Share Snipplr

Follow @Snipplr

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 1375 posted 15 years ago by cbrant

SQL MySQL random password string

mysql

1 717 posted 16 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 883 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.

mysql

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

mysql

1 657 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

1 501 posted 16 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 737 posted 16 years ago by chrisaiv

SQL See all mysql grants

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

mysql

0 642 posted 16 years ago by therobot

SQL Differences between two Tables

mysql

1 808 posted 16 years ago by zingo

SQL MySQL LOAD DATA INFILE with WHERE

mysql

1 613 posted 16 years ago by bassnode

SQL Ordering multiple SELECT statements in a UNION

mysql

0 775 posted 16 years ago by andyhartleeds

SQL MySQL Mass Text/String Replace

mysql

4 792 posted 16 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 762 posted 16 years ago by zingo

SQL Change password for mysql root user on debian

mysql

0 724 posted 16 years ago by therobot

SQL Add an user to an mysql account

mysql

0 633 posted 16 years ago by therobot

SQL Export and import from MySQL

mysql

2 624 posted 16 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 663 posted 17 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 564 posted 17 years ago by assbach

SQL HABTM relationship MySQL tables for use in Rails

mysql

0 662 posted 17 years ago by alexwilliams

SQL MySQL error reporting

mysql

1 660 posted 17 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 808 posted 17 years ago by wolfie

SQL MySQL 3.23 Space after query gotya

mysql

0 645 posted 17 years ago by benpjohnson

SQL Load CSV into MySQL

mysql

7 786 posted 17 years ago by brentroady

« Prev 1 2 3 Next »