MySQL Import Data From EXCEL (csv file)

mysql logo

1. Save as excel document in CSV format. (found as CSV Comma Delimited file)

2. Connect to Mysql through command line
Start Cmd
cd c:\mysql\bin\ (or wherever the mysql directory is installed…)

3. Connect to MySQL command console
use
[sourcecode lang=”sql”]mysql -u root[/sourcecode]
to connect as root user to be able to do changes to your db

4. Remember to Save the CSV File in the mysql\bin directory

5. Enter the following commands
SELECT THE DATABASE TO USE
[sourcecode lang=”sql”]use yourdbname;[/sourcecode]
ENTER THE INSERT COMMAND
[sourcecode lang=”sql”]
LOAD DATA LOCAL INFILE ‘/yourCSVfilename.csv’
INTO TABLE test_table
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
(field1, filed2, field3); [/sourcecode]

For Greek or non-unicode Remember 3 Things
1.  mysql> set character_set_database =utf8;
2. CSV File saved as UTF8 encoding
3. database Table character set to greek_unicode_ci;

SQL Script for Constrains

sql server

This is a SQL Script that returns a list of all constrains in a database..

[sourcecode lang=”sql”]
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
[/sourcecode]

55 + 1 Sources for Web Design Inspiration

Here is the list ….

  1. The Best Designs
  2. Six Shooter Media’s Free Templates
  3. 2Advanced Studios
  4. Andreas Viklund Free Website Templates
  5. Studio7Designs
  6. Style Grind
  7. Open Source Web Design
  8. The Web Design Inspiration Photoset
  9. Most Inspired
  10. Open Source Templates
  11. Templates Box
  12. Smashing Magazine
  13. CSS Beauty
  14. CSS Galleries
  15. Drupal Sites
  16. Open Source Web Templates
  17. CSS Remix
  18. Glenn Wolsey 10 Most Beautiful Blog Designs
  19. CSS Drive
  20. Perfection
  21. CSS Elite
  22. SyleGala
  23. Creative Pakistan
  24. The FWA
  25. CSS Hazard
  26. Beautifully Webdesign
  27. Unmatched Style
  28. CSS Import
  29. Light on Dark
  30. StyleBoost
  31. CSS Bloom
  32. Screen Fluent
  33. CSS Websites
  34. Website Design Awards
  35. 3point7designs
  36. CSS Galaxy
  37. Screenalicio.us
  38. The Dreamer
  39. Style Crunch
  40. CSS Flavor
  41. Inspiration King
  42. CSS Thesis
  43. Web Creme
  44. CSS Zen Garden
  45. CSS Reboot
  46. WebDigity
  47. The Pixel Creativity
  48. Top Wordpess Themes
  49. CSSClip
  50. Deviant Art
  51. 83 Beautiful WordPress Themes (smashing magazine)
  52. Go Drupal
  53. One Pixel Army
  54. CSS Mania
  55. Design Shack
  56. Css Gallery

Simple Xml AS3 Navigation Menu-V2

This is a the new version of Flash ActionScript3 Navigation menu. It’s an xml driven

Features:

  • you can use it anywhere you want, all classes are open-source (caurina tweener included)
  • easy implementation of links and sub-links, fully xml driven
  • handles ok on non or relative links

Bugs Fixed:

  • MouseHand is now updated when hovering on a link ()
  • CallArg Class is now included ok, sorry for that i had this in my default class location

Download the sample files from this link.
The .fla file is included. Any comments on the code is appreciated. Feel free to use!!

Top 12 Windows 7 Hacks

logo

If you are looking for Windows 7 hacks, I am sure you can finds loads of them on web. What matters is, how many of them are really important. Do you think unlocking the Taskbar in Windows 7 is something very exciting? Obviously, not for the majority of users its nothing cool. Instead if you are interested in Windows 7 Hack that can help you to get rid of expiry date, remove watermark, or disable send feedback link then my article can surely help you out. I organized a set Top 12 Windows 7 Hack You Must Know. This list includes some of the handy posts on Windows 7 hacks in our blog. I have also provided the sources where you can find the hacks.

Fix Chrome on Windows 7 RC / Beta

chrome settings

right click on your chrome icon then select properties. Under the shortcut tab you will see Target. The line ends with chrome.exe so just add –in-process-plugins after that. So the line should look something like this:


C:\Users\user\AppData\Local\Google\Chrome\Application\chrome.exe --in-process-plugins

Apache on Windows 7 (WampServer Solution)

0

How to make Logmein work with Windows 7


How to use LogMeIn Free with Windows 7 Beta/RC:

1. Download the LogMeIn software to your desktop from this site: https://secure.logmein.com/logmein.zip

2. Unzip the folder to a new folder on your desktop named “logmein”.

3. Go to the start menu and search for “cmd. When you find the Command Prompt entry, right click it and select “Run as Administrator”, and Click through the warning prompt.

4.In command prompt type “cd\users\\desktop\logmein\x86” without quotes and press enter. (If you are running 64-bit Windows change the ‘x86′ to ‘x64′)

5. In command prompt type “logmein install” without quotes and press enter.

6. The installer will run and you should then see the tray icon when it’s finished. Right click on the icon and select “Open LogMeIn…

7. Firefox will open and you’ll get an error box. Just click “OK“.

8. Copy and paste this address into the address bar: https://127.0.0.1:2002/

9. Click through if you get a popup warning you about a certificate. On the page itself you will see something to allow an exception. Click on that and then click ‘Get Certificate‘ in the next box. Again you will probably get another warning but just click add anyway.

10. You should see the familiar LogMeIn screen. Just put in your computer user credentials and then you will be asked for your LogMeIn credentials.

It is a pretty straightforward process, but does take a bit of workaround to get it setup. Hopefully over the next few months LogMeIn will add support to Windows 7 for its installer package.

You ll be suprised when entering as you used to your username and password worked ok.
In Windows 7 if you use it this way u ll get this error message:
Error: Logon failure: unknown user name or bad password. (1326)

REMEMBER to type the username like this

computername\username
password

Grub Loader – Error 17

When you try to install a linux distro, in some cases …. (mine’s too) i had problems with grub loader. Grub is actually a program that prompts you which operating system will be launch on boot.

Upload with progressbar

New uploading Script Available on jQuery Community.

There are many solution to work in the net. There implementation for a default usage is quite simple.  And all have good documentations.


swfUpload

The classic and maybe the predecessor of all scripts that use a flash component to show the progress of the uploading status is swfupload. This main reason I stopped using this is because i found many versions. Each version not working with some browsers.  I also needed to change the script to implement a database insetion to store the uploaded media. This upload solutions is very versatile and customizable. Here you can see some demos.
Multiple file selection is supported.

Features

  • Multiple file selection is supported.
  • Customizable Folder, Action when All completed, One completed.
  • Size Limit
  • Custom File Extensions
  • Post/Get  Form Data
  • .NET 2.0 Support

upload_01


jQuploader

Another solution works with jQuery 1.2.xx JS Framework. The drawback is that latest jQuery framework doesn’t work ok with this. I used this for some time now. The fla file is included and i was able to implement actions to call js functions when the files uploading procedure was finished.  This solutions is the most compatible one i ve ever used. Works ok with FF, IE, Opera, Chrome, Sleipnir, Safari and also with Flash9 and 10. A very strong aspect of this solutions is that you can also send Form variables.

Check out the demos.

Features

  • Multiple file selection is not supported.
  • Asynchronous or synchronous file submitting is also supported.
  • Customizable Folder, Action when All completed, One completed.
  • Editable Flash Upload script. (Default = ‘upload.php’)
  • Size Limit
  • Custom Allowed Extensions

upload_02


apgetwikiimage

uploadify

This is actual the reason i made this post. This looks to be the most compatible version of all the above. It has all features mentioned and works with 1.3.x jQuery.
Features

  • Multiple file selection is supported.
  • Asynchronous or synchronous file submitting is also supported.
  • Restriction of the number of simultaneous uploads is also supported.
  • Customizable Folder, Actions for (onInit, inSelect, onSelectOnce, onCancel, onClearQueue, onError, onProgress, onComplete, onCompleteAll, onCheck)
  • Editable Flash Upload script. (Default = ‘upload.php’)
  • Domain restriction
  • Size Limit
  • Custom Allowed Extensions
  • Post Form Data
  • wmode for flash (i found that very important)
  • fileupload autostart option

Check out the uploadify, demos and this brief documentation.
The impementation is very simple.
upload_03