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

SQL MySQL random password string

mysql

1 700 posted 15 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 859 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 643 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 643 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 485 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 714 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 623 posted 16 years ago by therobot

SQL Differences between two Tables

mysql

1 783 posted 16 years ago by zingo

SQL MySQL LOAD DATA INFILE with WHERE

mysql

1 591 posted 16 years ago by bassnode

SQL Ordering multiple SELECT statements in a UNION

mysql

0 747 posted 16 years ago by andyhartleeds

SQL MySQL Mass Text/String Replace

mysql

4 763 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 739 posted 16 years ago by zingo

SQL Change password for mysql root user on debian

mysql

0 705 posted 16 years ago by therobot

SQL Add an user to an mysql account

mysql

0 613 posted 16 years ago by therobot

SQL Export and import from MySQL

mysql

2 602 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 635 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 541 posted 17 years ago by assbach

SQL HABTM relationship MySQL tables for use in Rails

mysql

0 644 posted 17 years ago by alexwilliams

SQL MySQL error reporting

mysql

1 637 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 782 posted 17 years ago by wolfie

SQL MySQL 3.23 Space after query gotya

mysql

0 624 posted 17 years ago by benpjohnson

SQL Load CSV into MySQL

mysql

7 764 posted 17 years ago by brentroady

« Prev 1 2 3 Next »