Click here to Skip to main content
15,312,009 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to updat a column from start point Pin
NitinDhapte16-Jun-14 3:01
MemberNitinDhapte16-Jun-14 3:01 
AnswerRe: how to updat a column from start point Pin
PIEBALDconsult20-May-14 3:36
professionalPIEBALDconsult20-May-14 3:36 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 17:47
Membermhd.sbt20-May-14 17:47 
GeneralRe: how to updat a column from start point Pin
Mycroft Holmes20-May-14 19:54
professionalMycroft Holmes20-May-14 19:54 
AnswerRe: how to updat a column from start point Pin
NitinDhapte16-Jun-14 3:08
MemberNitinDhapte16-Jun-14 3:08 
QuestionUpdate DB Table based on another temp Table data Pin
Sachin k Rajput 19-May-14 4:11
MemberSachin k Rajput 19-May-14 4:11 
AnswerRe: Update DB Table based on another temp Table data Pin
PIEBALDconsult19-May-14 12:22
professionalPIEBALDconsult19-May-14 12:22 
Questionweird scenario after executing prepared statement mysql Pin
Gilbert Consellado15-May-14 23:15
professionalGilbert Consellado15-May-14 23:15 
I got these very weird scenario i encounter.

it happens when i try execute the sample provided in mysql doc about prepared statement, i created the table with columns correspond with the sample. mysql prepared statement

then when i execute it(BTW i used the c# sample), it populate the rows with 1000 entries.

after that i try to insert one entry with out the prepared statement (at this moment the ignore prepare property is set to true), then the executeNonQuery return 1, so it means it inserted the so i checked the database but the value i inserted is not in there, so i try it many time but still no luck.

so i decide to write the insert query directly to workbench, but i got thesame result the data was not there.

so i tried to delete the last row, then the weird things happen. it delete the the last row that has an the id of 1000(btw the id was autoincrement) it also insert 1 new data with the id of 1001, so try to delete to rows but after the two rows was deleted it also insert two more rows with the id of 1002 and 1003.

then after that i tried to insert new data but is still keep telling me that 1 row is inserted but i cant see that on the table so, i tried to delete rows still bu t it still doing the same.

BTW as u can see on the documentation the second column is a number, then when i delete the data it also insert now row with the incremented value of it.

so i decide to truncate the table and insert few row and then delete some of it, at this point it was working as expected, then i decide to execute the prepared statement(ignore prepare set to false) then after that it do the same weird things.

i dont know what on this, could somebody explain to me.

i will appreciate for any enlightenment will come.

thank you very much
AnswerRe: weird scenario after executing prepared statement mysql Pin
Kornfeld Eliyahu Peter17-May-14 8:21
professionalKornfeld Eliyahu Peter17-May-14 8:21 
GeneralRe: weird scenario after executing prepared statement mysql Pin
Gilbert Consellado21-May-14 23:53
professionalGilbert Consellado21-May-14 23:53 
QuestionJoin Query returning duplicated rows Pin
devenv.exe15-May-14 23:13
professionaldevenv.exe15-May-14 23:13 
AnswerRe: Join Query returning duplicated rows Pin
Mycroft Holmes16-May-14 13:20
professionalMycroft Holmes16-May-14 13:20 
AnswerRe: Join Query returning duplicated rows Pin
NitinDhapte6-Jun-14 23:07
MemberNitinDhapte6-Jun-14 23:07 
QuestionTranspose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 4:52
MemberDavidemazzuuu13-May-14 4:52 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Corporal Agarn13-May-14 5:46
professionalCorporal Agarn13-May-14 5:46 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:11
MemberDavidemazzuuu13-May-14 21:11 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 12:53
professionalMycroft Holmes13-May-14 12:53 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:04
MemberDavidemazzuuu13-May-14 21:04 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 21:30
professionalMycroft Holmes13-May-14 21:30 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 22:27
MemberDavidemazzuuu13-May-14 22:27 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Member 1026233013-May-14 21:34
MemberMember 1026233013-May-14 21:34 
QuestionSQL Server 2012 Cube Build failing. Pin
rnbergren12-May-14 9:52
Memberrnbergren12-May-14 9:52 
QuestionAccess DB Pin
Zeyad Jalil11-May-14 19:45
professionalZeyad Jalil11-May-14 19:45 
AnswerRe: Access DB Pin
Bernhard Hiller11-May-14 22:30
MemberBernhard Hiller11-May-14 22:30 
AnswerRe: Access DB Pin
sankarsan parida12-May-14 19:33
professionalsankarsan parida12-May-14 19:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.