If you fancy a couple of free Jiu Jitsu lessons and you live anywhere near Gravesend Dartford Swanscombe or Greenhithe in the North Kent area of UK, then check out the details here: http://www.empirewalkreedcourt.com/services/learn-ju-jitsu-in-gravesend
It’s a friendly club, for teenagers and adults. Get fit, learn to defend yourself and before you know it you’ll be a black belt Jiu Jitsu master! First two lessons are free and then it’s a small charge each time you go after that.
I’d like to tell you about a new website I’ve put together, to take you from a typical flabby guy to having a six pack like on the front of all those men’s magazines.
The website is www.six-pack-workout.com and includes pages on how to lose the fat in the first place, including nutrition and exercise. Also included are the most effective abs exercises and a complete and effective abs workout that you can do once or twice a week.
Total self-indulgent promotion, but I’ve done a lot of research on this and I’m putting the findings into practice for myself. I’d welcome any feedback or suggestions on how to make the site more interesting or the program more effective.
I have a table with ~500,000 rows and I receive a new copy of the file every day with a small number of changes. I want to update the table with the changes and track the changes so that I can retrieve all the rows that have been updated since any date.
e.g. select * from testdata where last_updated > ’2011-02-01′
It needs to include new rows and updated rows. I’ll never delete rows, but it should be pretty obvious how to add this in if required.
CREATE TABLE IF NOT EXISTS `testdata` ( `testdata_id` int(11) NOT NULL, `data1` varchar(100) NOT NULL, `data2` varchar(100) NOT NULL, `last_updated` datetime NOT NULL, PRIMARY KEY (`testdata_id`)); CREATE TABLE IF NOT EXISTS `testdata_staging` ( `testdata_id` int(11) NOT NULL, `data1` varchar(100) NOT NULL, `data2` varchar(100) NOT NULL, PRIMARY KEY (`testdata_id`))
Bulk load the data into testdata_staging using whatever method is required.
Then to update the table:
/* updates */
update testdata, (select ts.*,now()
from testdata_staging ts
inner join testdata t
on ts.testdata_id = t.testdata_id
where ((ts.data1 != t.data1)
or (ts.data2 != t.data2))
) chg
set testdata.data1 = chg.data1,
testdata.data2 = chg.data2,
testdata.last_updated = now()
where testdata.testdata_id = chg.testdata_id;
/* inserts */
insert into testdata
select ts.*,now()
from testdata_staging ts
left outer join testdata t
on ts.testdata_id = t.testdata_id
where t.testdata_id is null;
There you go.
If you want to travel to Budapest, Hungary, and don’t want to spend a lot of money on hotels, then you should have a look at the recommended cheap budapest hotels on www.hotelsearchengines.net.
The website contains a lot of information about hotels, including reviews and ratings. Importantly you will only see popular ones listed on the cheap budapest hotels page, so long as they are also cheap!
The hotel list updates continually as new pricing information is always changing. At the time of writing, the number one hotel is Dominic Panzio Hotel Budapest. The average rating for the hotel is 3.5 out of 5, and the price is 3502 HUF. You can choose your own currency on the site so that you can see the price in terms you understand.
Go to the page, click on the link and you will see all the details, photos and the map of the hotel.
There are 10 hotels listed in total so check it out!
There are numerous books available telling you how you should bring up your kids. Ironically many of the books seem to be written by authors who have no kids themselves. As a parent I find that most frustrating.
OK here’s a list of some of the more popular e-books. I won’t review each one here as each will appeal to different people. My suggestion is to click on each in turn but don’t decide until you’ve had a look at each one. You will see the sales page for the product. If you want to get one of these then the benefit of an e-book is that you could be reading it within a few minutes, also that they all come with money back guarantees in case you don’t like it (double-check this! in case they have changed).
Here are the most popular child discipline books, according to Amazon:
You can read the reviews for each of these on Amazon (click on the link to be taken to the appropriate page). The reviews are from people who have bought the book themselves, which I find gives the most useful information.
The following websites are good authorities on kids, parenting and discipline:
There is also a wealth of information on squidoo. Here’s one to look at, and you can see other recommended pages with squidoo from this page.
If you find a good resource that I haven’t listed, please let me know in the comments below!
Knowing how to deal with your little treasure when he kicks off with a baby temper tantrum can be hard. When it happens for the first time it’s a shock and when it’s an ongoing occurrence you find yourself wanting answers.
Babies don’t have a whole lot of ways to communicate, so a tantrum is often the only way they can get the message across that something is wrong. Try to avoid them happening at first, by studying what happens leading up to them. Chances are it will be from lots of different things but hopefully you’ll be able to tune into the various demands.
The most important thing to do at this time is to make sure your baby realises you are there and realises you care. If you catch it early you can get the baby to focus their attention on something else. A rattle, car keys (yep – can’t beat the rattling car keys), or if they’re in their pram just a change of scenery could do it. My son was captivated by trees. If he was distressed while we were out you could park him under a tree and as soon as he saw the leaves moving above him it was like he want into a trance.
For more advice about dealing with baby tantrums, take a look at the following article on http://www.squidoo.com/baby-temper-tantrums. There are a few more articles from the same author, covering general parenting advice for babies, toddlers and old kids as well. A lot of the advice for older kids actually applies to babies as well surprisingly.
Finally, it might be helpful to realise that crying can be very therapeutic for a baby. I didn’t realise this until I read about the research into tears and how they include a hormone which is an indicator of stress. It’s made me think a little differently about crying for my older kids too.
The study compared the tears from emotional stress to tears from physical pain and found that there was a clear difference between the two. It seems that tears are a great way to get rid of the stress hormone, so it would seem that crying is how babies and kids let off steam, much like the way adults do sometimes.
Source:
Posted in Parenting
|
Leave a reply
If you know of Potpiegirl, then you’ve probably seen her advice to publish internet marketing articles to 3StepAds.com, Unique-Article-Database.com, and Writers-Block-Unblocked.com. Unfortunately while one of these is currently working, the other produces 404 errors and the last doesn’t allow new registrations. No doubt due to excessive spam. Good news though – this website is now open for article publishing. To avoid the problem of spam this is on an invitation only basis. However if you would like to post your articles here and thus get a free backlink from a blog (which every good search engine loves), then send an email to matt @ mattsnotes . com with the subject “Sign me up”. Let me know which sites you want to promote and I’ll register you. Obviously no spam, porn or anything like that. All parents want happy well-adjusted and sociable kids. Also every parent wants a nice child as well. There are lots of resources available to help with parenting, including parents, social groups, friends, as well as blogs, websites and books. There are lots of great articles on squidoo on the subject of how to raise children including that one When it comes to child behavior there are many books on child discipline that address this issue with the latest research. The best book on this subject that I have found is the Happy Child Guide. Hope you take a moment to look at the links on this page and that they help you to raise happy kids. Thoughts of the day: I recently made a change on my hotel comparison website, www.hotelsearchengines.net to re-engineer the internal processes and make it more manageable. This is the website that I hadn’t touched in 18 months that was still generating lots of visitors, but wanting to increase it further I thought I should make some changes. Everything looked fine after the upgrade, the site was loading much faster thanks to the use of a CDN (content delivery network) and using CSS sprites. That was until yesterday when I noticed my daily revenue dropped by about 50% of the average for the past month. To my horror I realised that my upgrade had inadvertently dropped off the meta description (and keywords) on all the pages on the site! Yikes … I’ve put it back now and I’m hoping Google will visit the home page again soon and pick up the change. In the meantime I am running at 50% revenue. Makes you think … meta description is very important. When you find your site in google (any page but specifically the home page) does the description look right? If your meta description is too long then it will be truncated. If you have none then Google will do its best to grab some text from the site somewhere. Suggestion: Take a look at your google results. If the text isn’t perfect, change your meta description today I am a fan of the Seagull framework and the last time I checked, Hostmonster was the cheapest webhost provider that allows unlimited websites, domains and traffic. The only limitation for Hostmonster is the number of files which is capped at 50,000. This is a problem if you install multiple copies of a framework with their own copies of the pear libraries. To get around this I install the websites under ~/www and the seagull libraries under ~/seagull/lib-0.6.8. I include the library version so that I can use the latest library on the current project I am working on without affecting the existing websites. When I go back to update the other websites I bring them forward to the latest version too. So here is how to install a new Seagull website using the above structure. 1. Download the latest Seagull bug fixes and rename for the new website: 2. Set up a vhost entry for the new website pointing to the new directory. If you’re not using Arch Linux the paths may be different: 3. Set up an /etc/hosts entry for mywebsite pointing to 127.0.0.1 4. Install seagull by browsing to http://website. Note that the database name needs to be myuser_mywebsite, as all hostmonster databases are prefixed with myuser_. 5. Now move the www directory and reconfigure seagull and apache: 6. Move libs up a directory so it can be sharedInternet Marketing Articles
Raising Happy Kids
The importance of meta description
Thinking hotels are seasonal I left it at that, but fortunately I was checking the site in Google’s Webmaster Tools and noticed that I was getting hits for a new keyphrase. Typing this into google I saw that was #1 for the new phrase (yay), but the text that google was showing for the site didn’t look right.Installing Seagull projects on Hostmonster
$ cd /home/myuser/seagull
$ svn co http://svn.seagullproject.org/svn/seagull/branches/0.6-bugfix
$ mv 0.6-bugfix mywebsite
$ vi /etc/httpd/conf/extra/httpd-vhosts.conf
<VirtualHost *:80>
ServerName mywebsite
DocumentRoot /home/myuser/seagull/mywebsite
mywebsite
ServerAdmin me@me.com
ErrorLog /home/myuser/logs/mywebsite-access_error
CustomLog /home/myuser/logs/mywebsite-access_log common
</VirtualHost>
$ mv /home/myuser/seagull/mywebsite/www /home/myuser/www/mywebsite
$ vi /etc/httpd/conf/extra/httpd-vhosts.conf
<VirtualHost *:80>
ServerName mywebsite
DocumentRoot /home/myuser/www/mywebsite/www
mywebsite
ServerAdmin me@me.com
ErrorLog /home/myuser/logs/mywebsite-access_error
CustomLog /home/myuser/logs/mywebsite-access_log common
</VirtualHost>
$ vi /home/myuser/seagull/mywebsite/var/mywebsite.conf.php
# $conf['path']['webRoot'] = '/home/myuser/seagull/mywebsite/www';
$conf['path']['webRoot'] = '/home/myuser/www/mywebsite';
$ vi /home/myuser/www/mywebsite/index.php
//$rootDir = realpath(dirname(__FILE__) . '/..');
//$varDir = realpath(dirname(__FILE__) . '/../var');
$rootDir = '/home/myuser/seagull/mywebsite';
$varDir = $rootDir . '/var';
$ cd /home/myuser/seagull/mywebsite/
$ mv lib ../lib-0.6.8
$ ln -s /home/myuser/seagull/lib-0.6.8 lib