Becky – Drive test


Becky – Dublin zoo


Becky demolition


Becky crane hire


Becky spare tyre


Becky orange order


Becky mariah


Becky wants to be a hairdresser


Becky wants to be a footballers wife

No tags

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use a Perl module.

To login (from unix shell) use -h only if needed.

[mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server.
create database [databasename];

List all databases on the sql server.
show databases;

Switch to a database.
use [db name];

To see all the tables in the db.
show tables;


To see database’s field formats.
describe [table name];

To delete a db.
drop database [database name];

To delete a table.
drop table [table name];

Show all data in a table.
SELECT * FROM [table name];

Returns the columns and column information pertaining to the designated table.
show columns from [table name];

Show certain selected rows with the value “whatever”.
SELECT * FROM [table name] WHERE [field name] = "whatever";

Show all records containing the name “Bob” AND the phone number ‘3444444′.
SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';

Show all records not containing the name “Bob” AND the phone number ‘3444444′ order by the phone_number field.
SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;

Show all records starting with the letters ‘bob’ AND the phone number ‘3444444′.
SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with a.
SELECT * FROM [table name] WHERE rec RLIKE "^a$";

Show unique records.
SELECT DISTINCT [column name] FROM [table name];

Show selected records sorted in an ascending (asc) or descending (desc).
SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

Return number of rows.
SELECT COUNT(*) FROM [table name];

Sum column.
SELECT SUM(*) FROM [table name];

Join tables on common columns.
select lookup.illustrationid, lookup.personid,person.birthday from lookup

left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;
Switch to the mysql db. Create a new user.
INSERT INTO [table name] (Host,User,Password) VALUES('%','user',PASSWORD('password'));

Change a users password.(from unix shell).
[mysql dir]/bin/mysqladmin -u root -h hostname.blah.org -p password 'new-password'

Change a users password.(from MySQL prompt).
SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');

Allow the user “bob” to connect to the server from localhost using the password “passwd”
grant usage on *.* to bob@localhost identified by 'passwd';

Switch to mysql db.Give user privilages for a db.
INSERT INTO [table name] (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');

or

grant all privileges on databasename.* to username@localhost;
To update info already in a table.
UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';

Delete a row(s) from a table.
DELETE from [table name] where [field name] = 'whatever';

Update database permissions/privilages.
FLUSH PRIVILEGES;

Delete a column.
alter table [table name] drop column [column name];

Add a new column to db.
alter table [table name] add column [new column name] varchar (20);

Change column name.
alter table [table name] change [old column name] [new column name] varchar (50);

Make a unique column so you get no dupes.
alter table [table name] add unique ([column name]);

Make a column bigger.
alter table [table name] modify [column name] VARCHAR(3);

Delete unique from table.
alter table [table name] drop index [colmn name];

Load a CSV file into a table.
LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);

Dump all databases for backup. Backup file is sql commands to recreate all db’s.
[mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql

Dump one database for backup.
[mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql

Dump a table from a database.
[mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

Restore database (or database table) from backup.
[mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql

Create Table Example 1.
CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups
VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));

Create Table Example 2.

create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 'bato');

MYSQL Statements and clauses

ALTER DATABASE

ALTER TABLE

ALTER VIEW

ANALYZE TABLE

BACKUP TABLE

CACHE INDEX

CHANGE MASTER TO

CHECK TABLE

CHECKSUM TABLE

COMMIT

CREATE DATABASE

CREATE INDEX

CREATE TABLE

CREATE VIEW

DELETE

DESCRIBE

DO

DROP DATABASE

DROP INDEX

DROP TABLE

DROP USER

DROP VIEW

EXPLAIN

FLUSH

GRANT

HANDLER

INSERT

JOIN

KILL

LOAD DATA FROM MASTER

LOAD DATA INFILE

LOAD INDEX INTO CACHE

LOAD TABLE...FROM MASTER

LOCK TABLES

OPTIMIZE TABLE

PURGE MASTER LOGS

RENAME TABLE

REPAIR TABLE

REPLACE

RESET

RESET MASTER

RESET SLAVE

RESTORE TABLE

REVOKE

ROLLBACK

ROLLBACK TO SAVEPOINT

SAVEPOINT

SELECT

SET

SET PASSWORD

SET SQL_LOG_BIN

SET TRANSACTION

SHOW BINLOG EVENTS

SHOW CHARACTER SET

SHOW COLLATION

SHOW COLUMNS

SHOW CREATE DATABASE

SHOW CREATE TABLE

SHOW CREATE VIEW

SHOW DATABASES

SHOW ENGINES

SHOW ERRORS

SHOW GRANTS

SHOW INDEX

SHOW INNODB STATUS

SHOW LOGS

SHOW MASTER LOGS

SHOW MASTER STATUS

SHOW PRIVILEGES

SHOW PROCESSLIST

SHOW SLAVE HOSTS

SHOW SLAVE STATUS

SHOW STATUS

SHOW TABLE STATUS

SHOW TABLES

SHOW VARIABLES

SHOW WARNINGS

START SLAVE

START TRANSACTION

STOP SLAVE

TRUNCATE TABLE

UNION

UNLOCK TABLES

USE

String Functions

AES_DECRYPT

AES_ENCRYPT

ASCII

BIN

BINARY

BIT_LENGTH

CHAR

CHAR_LENGTH

CHARACTER_LENGTH

COMPRESS

CONCAT

CONCAT_WS

CONV

DECODE

DES_DECRYPT

DES_ENCRYPT

ELT

ENCODE

ENCRYPT

EXPORT_SET

FIELD

FIND_IN_SET

HEX

INET_ATON

INET_NTOA

INSERT

INSTR

LCASE

LEFT

LENGTH

LOAD_FILE

LOCATE

LOWER

LPAD

LTRIM

MAKE_SET

MATCH AGAINST

MD5

MID

OCT

OCTET_LENGTH

OLD_PASSWORD

ORD

PASSWORD

POSITION

QUOTE

REPEAT

REPLACE

REVERSE

RIGHT

RPAD

RTRIM

SHA

SHA1

SOUNDEX

SPACE

STRCMP

SUBSTRING

SUBSTRING_INDEX

TRIM

UCASE

UNCOMPRESS

UNCOMPRESSED_LENGTH

UNHEX

UPPER

Date and Time Functions

ADDDATE

ADDTIME

CONVERT_TZ

CURDATE

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURTIME

DATE

DATE_ADD

DATE_FORMAT

DATE_SUB

DATEDIFF

DAY

DAYNAME

DAYOFMONTH

DAYOFWEEK

DAYOFYEAR

EXTRACT

FROM_DAYS

FROM_UNIXTIME

GET_FORMAT

HOUR

LAST_DAY

LOCALTIME

LOCALTIMESTAMP

MAKEDATE

MAKETIME

MICROSECOND

MINUTE

MONTH

MONTHNAME

NOW

PERIOD_ADD

PERIOD_DIFF

QUARTER

SEC_TO_TIME

SECOND

STR_TO_DATE

SUBDATE

SUBTIME

SYSDATE

TIME

TIMEDIFF

TIMESTAMP

TIMESTAMPDIFF

TIMESTAMPADD

TIME_FORMAT

TIME_TO_SEC

TO_DAYS

UNIX_TIMESTAMP

UTC_DATE

UTC_TIME

UTC_TIMESTAMP

WEEK

WEEKDAY

WEEKOFYEAR

YEAR

YEARWEEK

Mathematical and Aggregate Functions

ABS

ACOS

ASIN

ATAN

ATAN2

AVG

BIT_AND

BIT_OR

BIT_XOR

CEIL

CEILING

COS

COT

COUNT

CRC32

DEGREES

EXP

FLOOR

FORMAT

GREATEST

GROUP_CONCAT

LEAST

LN

LOG

LOG2

LOG10

MAX

MIN

MOD

PI

POW

POWER

RADIANS

RAND

ROUND

SIGN

SIN

SQRT

STD

STDDEV

SUM

TAN

TRUNCATE

VARIANCE

Flow Control Functions

CASE

IF

IFNULL

NULLIF

Command-Line Utilities

comp_err

isamchk

make_binary_distribution

msql2mysql

my_print_defaults

myisamchk

myisamlog

myisampack

mysqlaccess

mysqladmin

mysqlbinlog

mysqlbug

mysqlcheck

mysqldump

mysqldumpslow

mysqlhotcopy

mysqlimport

mysqlshow

perror

Perl API - using functions and methods built into the Perl DBI with MySQL

available_drivers

begin_work

bind_col

bind_columns

bind_param

bind_param_array

bind_param_inout

can

clone

column_info

commit

connect

connect_cached

data_sources

disconnect

do

dump_results

err

errstr

execute

execute_array

execute_for_fetch

fetch

fetchall_arrayref

fetchall_hashref

fetchrow_array

fetchrow_arrayref

fetchrow_hashref

finish

foreign_key_info

func

get_info

installed_versions

last_insert_id

looks_like_number

neat

neat_list

parse_dsn

parse_trace_flag

parse_trace_flags

ping

prepare

prepare_cached

primary_key

primary_key_info

quote

quote_identifier

rollback

rows

selectall_arrayref

selectall_hashref

selectcol_arrayref

selectrow_array

selectrow_arrayref

selectrow_hashref

set_err

state

table_info

table_info_all

tables

trace

trace_msg

type_info

type_info_all

Attributes for Handles

PHP API - using functions built into PHP with MySQL

mysql_affected_rows

mysql_change_user

mysql_client_encoding

mysql_close

mysql_connect

mysql_create_db

mysql_data_seek

mysql_db_name

mysql_db_query

mysql_drop_db

mysql_errno

mysql_error

mysql_escape_string

mysql_fetch_array

mysql_fetch_assoc

mysql_fetch_field

mysql_fetch_lengths

mysql_fetch_object

mysql_fetch_row

mysql_field_flags

mysql_field_len

mysql_field_name

mysql_field_seek

mysql_field_table

mysql_field_type

mysql_free_result

mysql_get_client_info

mysql_get_host_info

mysql_get_proto_info

mysql_get_server_info

mysql_info

mysql_insert_id

mysql_list_dbs

mysql_list_fields

mysql_list_processes

mysql_list_tables

mysql_num_fields

mysql_num_rows

mysql_pconnect

mysql_ping

mysql_query

mysql_real_escape_string

mysql_result

mysql_select_db

mysql_stat

mysql_tablename

mysql_thread_id

mysql_unbuffered_query

No tags

Me: bienbuon

Him: linshi

——————————-

29/11/2008

Conversation

(01:06:56) linshipl: yo
(01:07:06) bienbuon: hi ya
(01:07:15) bienbuon: i thot you dont wanna talk to me
(01:07:28) bienbuon: i got your message
(01:07:33) bienbuon: that was very nice
(01:07:43) linshipl: yep
(01:07:45) linshipl: very nice
(01:08:06) linshipl: but i didn`t think u`ll get it serious
(01:08:07) linshipl:
(01:08:13) linshipl: u know me too much
(01:08:21) bienbuon: well, i was so furious
(01:08:24) linshipl: i was angry cos u said u`ll came over
(01:08:36) linshipl: and u gave me 5 dates but u newer
(01:08:38) linshipl:
(01:08:43) linshipl: thats i was angry
(01:08:50) bienbuon: i thot you sent me that text cus i couldnt go over, and it was your birthday
(01:08:55) linshipl: and whatdo u think about my new mobile ?
(01:09:03) linshipl: sony ericsson xperia x1
(01:09:08) bienbuon: at the time i was moving hose
(01:09:10) bienbuon: house
(01:09:10) linshipl: i paid 550 quid for it
(01:09:16) linshipl: when u`ll came
(01:09:20) bienbuon: and was too busy
(01:09:35) bienbuon: and forgot to reply ur text
(01:09:36) linshipl: now i`ll invite u for christmas eve
(01:09:43) linshipl: feel inviited
(01:09:47) linshipl: christmas eve
(01:09:59) linshipl: it`s most important day of christmas for poles
(01:10:12) linshipl: i hope u`ll came
(01:10:30) bienbuon: i got to be honest
(01:10:40) bienbuon: it’ not possible this time
(01:10:42) linshipl: if not, then, i`ll never talk to u again ( and this time i`m serious)
(01:10:44) bienbuon: im sorry
(01:10:51) linshipl: than……………..
(01:10:54) linshipl: take care
(01:10:56) linshipl: ………………………..
(01:10:56) bienbuon: it’s up to you, this my last year
(01:10:57) linshipl: bye
(01:11:15) linshipl: i did invited u
(01:11:16) bienbuon: im so disapointed
(01:11:18) bienbuon: thanks
(01:11:18) linshipl: 123124124 times
(01:11:23) linshipl: and u never came
(01:11:33) linshipl: that means u dont want to came
(01:11:37) linshipl: take care dude
(01:11:44) bienbuon: i wish i could, but you can see, i cant even get out of inverness
(01:11:56) linshipl: excuses excuse
(01:12:06) bienbuon: do you think that im not sick of thic place
(01:12:07) linshipl: stop laiyng
(01:12:13) linshipl: bye
(01:12:22) bienbuon: well, whatever you think man
(01:12:31) linshipl: i tought if i`ll talk to you this time u`ll came
(01:12:33) bienbuon: dont call me a lier
(01:12:44) linshipl: but now i know u don`t fucking care
(01:12:52) linshipl: take care
(01:12:53) bienbuon: its not as easy as you thought
(01:13:13) linshipl: everything it`s easy if u only want it
(01:13:22) bienbuon: stop being like that
(01:13:31) linshipl: i`m earning fucking 12.79/h
(01:13:42) linshipl: and i can get off whenever i want to
(01:13:44) linshipl: then stop
(01:13:45) bienbuon: im not earning that much
(01:13:50) linshipl: have good life
(01:14:01) bienbuon: wel, yeh, sorry lukasz , we should stop talking
(01:14:27) linshipl: u just where banned by linshi
(01:14:37) linshipl: and he think, u r fucking lier
———————————————————————————————

Back to the message which i highlighted in the conversation, i got a message from him the other day like this:

“I’ve deleted everything from you, your contact information, your email, everything…, don’t ever talk to me or try to contact me again, have a good life”.
And that was it, i didn’t know why he text me like that, so i didn’t talk to him since. but let’s go back to the old day before i had that message from him.

We used to be good friends, we worked in the same place, we lived in the same flat, we shared things in common.

Our hobbies were Linux. at the time he did help me a lot about Linux stuff, in return i helped him with English and other stuff. but let’s not talk about helping story, as friends i really didn’t expect getting anything from friends.

We were good friends for a while. what remind me of him was that he didn’t have any friends except his girlfriend. what i like about him was that he was clever and a bit eccentric, he lived in his own world, he didn’t like to talk to other people. There’s restriction of his own world which tied him indoor. i don’t think he realizes that.

After a while he left his job and moved away, he found a new job, a new place, got a new life. I was glad that he’s happy because he wasn’t happy here the place where i live.

I thought i would have time to visit him one day, unfortunately I’m always busy, I thought I’ll go when things are settled for me. he kept invited me to his new place so we can have a chat, a drink like the old days, i thought about that and i really really wanted to go.

I thought i would go to see him last year but time to go never fit in, there’s always something stopped me. I planned to go, i thought i definitely could go but again, there’s always something came up, i got promoted at work as a manager, i need to work harder, new course arrive, i had to work harder to pay for the study fee, work harder to pay for living, work, work, and work, and number of reasons like that stop me going anywhere.

I cant afford a day or 2 days away to somewhere else, i wish i could have a holiday, i wish i could finish my study so that i could have a proper holiday, i could earn more money, i could go to visit my friends. In my mind i thought to my self that ” Please be patient, you have to stick to what you’re doing, there’s only one year left, you can go to the end of the world if you achieve this very last year, patient and patient…”

I wish my friends, my family could understand me like they could read my mind so that they don’t demand so much from me when i can’t do such things for them while im busy.

back to my old friend there, he said I’m a fucking lier and i don’t want to go to visit him, im so disappointed, so furious.

how can a friend call you a lier while you cant afford time to go to see him? if you don’t trust your friends why have friends?

what do i have to lose when a friend said bullsh*t to me? NOTHING, i have nothing to lose just sorry for your narrow minded.

what is the point of being sulk to a friend? DAFT POINT! Who the hell do you think you are to talk to me like that? my friend DO NOT talk to me like that!

Why would i have to tell lie to you? am i getting something out of it if I’m lying to a friend? NO, nothing, pointless.

I’m a straight guy, if i said i cannot go, that mean i cannot go, if i said my name Is Hung that mean it is my name, it’s the truth!

I’ve been away from home for 5 years now and i haven’t been back to my country to visit my family, my friends cus i haven’t had a chance, i would go to morrow if i have a chance. Am i lying to myself that i haven’t been back to my country for 5 years? the fact is i have not!

only people has a narrow minded that cant even think about the obvious facts like that.

I wrote this here not really because i lost my old friend or because i feel sorry about it. NO! I’ve just lost 20 stones, well my friend is that heavy!

I wrote this here for you, whoever read this to open your mind if you think that your friend is lying to you, if you think that your friend can’t give you what you demand.

Everyone has their own reasons to do something.

Finally can you define meaning of friends? if you can’t then i don’t think that you have so many friends and you should find the meaning of it.

To me, the person who understands more about the meaning of “friends” they would have more friends than other person who doesn’t understand much about it.

I lost a friend but i gain the better friends and of course i have many good friends.

No tags

check this out guys

Andy is awsum

No tags

This photoshop tutorial will show you how you can create a vector style poster design. Yep, it includes that spiffy “sun ray” element that’s hot right now. So, fire up Photoshop and let’s get started.

The first thing you’ll need to do is get some brushes, and find a good stock picture. Here’s a ZIP file with the brushes you’ll need, as well as the stock picture I used.
Resources

Install the brush files in C:\Program Files\Adobe\Photoshop CS2\Presets\Brushes\Photoshop Only, or wherever your photoshop is installed to.

Step 1

Open a new document in Photoshop, set the dimensions to 500 x 500. Set your foreground and background colors to #12d60d and #22a61b . Create a new laye, and then select the gradient tool (or hit G), then click the gradient preview on gradient toolbar, and set it to Foreground to Background.

On the new layer, click in the middle of the document, then drag (while holding the mouse, and shift) up to the top of the document, then release.

Now, make a new layer, and set the foreground color to #11860b, and click the brush tool. Load Vector 2 by Physical Magic, and select the first brush. Resize it to 700 or so, and click in on the center of the document. Now your design should look like this.

On the “sun ray” layer, set the layer style to this.

Now you are done with the background design.

Step 2

Next, open up the fist stock image included in the zip file. Extract it from the white background. Once you have a layer with just the first on it, go to Image > Adjustments > Threshold. Then enter 160, and hit ok.

Then, go to Filter > Artistic > Cutout, and enter these setting:

• Number of Levels: 8
• Edge Simplicity: 2
• Edge Fidelity: 2

Now, when you extracted the first, depending on what method you used, you might have some little white pixels randomly in the image. To get rid of these, use the lasso tool / polygon lasso tool to select the first. Give it some padding when you select it, so that you aren’t exactly on the first. Then just right click, select inverse, and hit delete. Now you have a clean extraction, that looks like this.

Step 3

Ok, drag the first layer onto the original document, and resize it to 60-70%, and center it. Now, add this layer style (the stroke is 10px, white; the colors for the gradient are #dcb48a to #dd8e4d.)

Step 4

Make a new layer under the fist layer. Grab the brush tool (or hit B), and then select BRUSHES_01_02, or load the brush set if you haven’t already. Grab a few of the brushes, resize them to around 500, and click in the center of the image. Here’s what I got:

Step 5

Now for the last step. Go to Google, and image search “family crest” or “coat of arms,” and limit the results to just high resolution. Then find an image with a banner that you like, and copy it into photoshop. Loosely cut out the banner, and clone or copy out the text on it, replacing it with your own in whatever font you like. Add a drop shadow to the banner layer, and whatever font styling you want. Here’s what mine looks like:

This tutorial is created by: http://tutorialaday.com/awesome-photoshop-vector-style-poster-design/

No tags