CEO & Founder of Falcon-Tech – Keyboard is my piano
  • Home
  • PHP
    • CakePHP
  • JavaScript && jQuery
  • Java && Android
  • Linux
  • Databases
    • MySQL
  • Other
    • Drupal
  • About me

Category: Databases

Kavecan.com MySQLPHP
13 Oct 2017

How to prevent SQL injection?

Posted by nikola, With 0 Comments, Category: MySQL, PHP,
Important is that any parameter in a query needs to be parameterized. It doesn't matter is your query is select, insert, update or delete ki ...

Read more
14 Oct 2016

Copy structure and all entries from one table to another (or how to create copy of existing table)

Posted by nikola, With 0 Comments, Category: Databases, MySQL, Tags: backup, mysql
Creating copy of existing MySQL table is useful when you want to prevent loose of existing data from it, or when you want to archive existin ...

Read more
15 Mar 2014

How to export MySQL table data into file CSV file, or even better, into file readable by Excel?

Posted by nikola, With 0 Comments, Category: MySQL, Tags: administration
How to export MySQL table data into file CSV file, or even better - into Excel readable file All you have to do is that in your SQL comma ...

Read more
01 Feb 2013

How to reset Primary Key value of MS SQL Server table?

Posted by nikola, With 0 Comments, Category: Databases, Tags: sqlserver
Just run following query: DBCC CHECKIDENT('YourTableName', RESEED, 0) This one is often used after truncating table - under usual curcumst ...

Read more

Search

Today's poll

What are your main interests when it comes to computers?

View Results

Loading ... Loading ...

Recent Posts

  • How to burn ISO image to DVD or CD
  • How to prevent SQL injection?
  • Read file, line by line
  • Copy structure and all entries from one table to another (or how to create copy of existing table)
  • Redirection in JavaScript

Friends

falcon-tech

Random Linux Trivia

  • In December 2009, IBM announced a new mainframe system designed for Linux

Tags

administration backup cakephp curl debugging development drupal7 google javascript jquery linux mysql personal php server sqlserver

Tweeter @kavecan

@MercedesAMGF1 but where is this livery? :) twitter.com/MercedesAMGF1/…

About 2 days ago via Twitter Web Client

Lookin GOOD! @redbullracing #redbullracing #rb15 #Honda #HondaF1 twitter.com/redbullracing/…

About 2 days ago via Twitter Web Client

On first peak it loks the same, but there are lots of differences. Tomorrow is a big day - @ForceIndiaF1, @MercedesAMGF1 and @redbullracing we are waiting for you! 🧐🤠🏁#skf1 #formula1 #f1 twitter.com/F1/status/1095…

About 3 days ago via Twitter Web Client

Sorry, but hopefully it doesn't run as bad as it looks twitter.com/WilliamsRacing…

About 4 days ago via Twitter for Android

Yes, #HaasF1Team is ready to go and it's lookin g-r-e-a-t! Next will be @ToroRosso and @WilliamsRacing, on February 11 #skf1 #F1 twitter.com/Haas_Automatio…

Last week via Twitter for Android

Instagram @kavecan

© 2016 - Kavecan.com - All rights reserved - About me & Contact
This website uses cookies to improve your experience. We'll assume you're OK with this, but you can opt-out if you wish.Accept Read More