Tag Archives: SQL

Microsoft Tech-Ed Europe 2009 | 9-13 November 2009, Berlin, Germany

Microsoft Tech-Ed Europe 2009 | 9-13 November 2009, Berlin, Germany

Here are the top 3 reasons you should join Tech·Ed Europe 2009.

More networking, more knowledge – Tech·Ed Europe 2009 an intensive learning experience and a great opportunity to expand our network of IT contacts.

Practical skills – Together, we can cover more ground by going to more sessions and more labs. Then we can start applying our new skills right away to build, deploy, secure, mobilise and manage solutions.

Competitive Advantage – Tech·Ed Europe 2009 can give us all the chance to experience emerging technologies and share ideas. That’s the perfect way for all of us to get a competitive edge in the future.

Sound good? Let’s do it! To learn all about Tech·Ed  Europe 2009, just click here.

SQL error – Out of range value adjusted for column OR Duplicate entry xxx for key 1

Senario:
CREATE TABLE test_table (test_id TINYINT, test_text VARCHAR(20));
INSERT INTO test_table (test_id, test_text) VALUES ('', 'This is a test');

Errors:
SQL error “Out of range value adjusted for column…”

if you have removed STRICT_TRANS_TABLES from my.ini (Windows) or my.cnf (Linux)
Server SQL Modes

You will get this error…
Duplicate entry xxx for key 1

ATTENTION:
If you want to remove STRICT_TRANS_TABLES
1. You need to have access and restart MySQL Server! A production server !?!?
2. Not everybody has root access or admin rights to change the sql mode.
3. Maybe, you need the server to run in strict mode for some reason.
4. NOT RECOMMENDED!

Solution:
Check the field type (e.g test_id TINYINT -128 to 127 )
So if you are trying to insert into a table value 128 it won’t insert !

MySQL 5.1 Reference Manual :: 10 Data Types :: 10.2 Numeric Types

😉

1 Star2 Stars (+3 rating, 2 votes)
Loading...

SQL Injection Cheat Sheet by ferruh mavituna

Currently only for MySQL and Microsoft SQL Server, some ORACLE and some PostgreSQL. Most of samples are not correct for every single situation. Most of the real world environments may change because of parenthesis, different code bases and unexpected, strange SQL sentences.

Samples are provided to allow reader to get basic idea of a potential attack and almost every section includes a brief information about itself.

M :     MySQL
S
:     SQL Server
P
:     PostgreSQL
O
:     Oracle
+
:     Possibly all other databases

Examples :

-(MS) means : MySQL and SQL Server etc.
-(M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server

Read the whole Cheat Sheet here.

1 Star2 Stars (+22 rating, 5 votes)
Loading...