-
Replied To a Post in Get row before SELECT query
> I suggested an 'id' PK column at the start and for me, that would be the easiest option. WHat I fail to understand is why you're giving the set … -
Replied To a Post in Get row before SELECT query
> Joins create temp tables, so I'm assuming that you need to supply more memory to their creation. > > My queries run OK on phpMyAdmin and SQLyog, so perhaps … -
Replied To a Post in Get row before SELECT query
> Possibly, but I can't think how. Is this a problem for you? Have you been told that you're not allowed to use them? The program Im using to make … -
Replied To a Post in Get row before SELECT query
Um: Error Code: 126. Incorrect key file for table '/tmp/#sql_141c_1.MYI'; try to repair it What does this even mean? -
Replied To a Post in Get row before SELECT query
> 'onerows' is just a name for the intermediate rownumbers equal to the row before the row where cycle=1, which ultimately show up in the 'i' column. Out of interest … -
Replied To a Post in Get row before SELECT query
Offtopic but changing a table to INNODB that had 2842501 records took 18 HOURS 38 minutes and 31.44 seconds. Biggest query Ive EVER done. -
Replied To a Post in Get row before SELECT query
The "Times" table has a column named Time_Stamp and Time_Stamp_ms Thats why Im not sure about "onerows" :S -
Replied To a Post in Get row before SELECT query
BTW, Im kinda of confused as you change field and table names. Im going to try to apply it. Yeah, tried and it has confused me. Could you please change … -
Replied To a Post in Get row before SELECT query
I would have to do two queries there and Im not sure I can (I can do two but Im not sure if that variable would be persistant) -
Created Error Code: 3. Error writing file (Errcode: 28)
Im doing a query and Im getting this: Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28) Its not a space issue or a permission issue either:  Whats … -
Replied To a Post in Get row before SELECT query
Thank you. Seems like a very complicated query indeed.... -
Replied To a Post in Get row before SELECT query
> You seem to be returning the last row of each cycle set is that right? Each cycle ends with the row BEFORE the 1. 1 starts a cycle set. -
Created Get row before SELECT query
I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name … -
Marked Solved Status for Why doesnt this timediff function return anything?
Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... -
Replied To a Post in Why doesnt this timediff function return anything?
> I pasted your code into MySQL and it returned 48:00:00 as you desired I didnt test the code, I just saw that %H limits it from 0-23 You are … -
Replied To a Post in How to check and see if a string contains invalid characters?
Here is a quickie: //declare another integer called x while i <= Length(sEmail) do begin while x <= Length(ALLOWED) do begin if sEmail[i] = ALLOWED[x] then begin bResult := true; … -
Replied To a Post in How to check and see if a string contains invalid characters?
if sEmail[i] in [ALLOWED[1] .. ALLOWED[Length(ALLOWED)]] then I cant find any documentation on a "if.......in......then" statement. -
Replied To a Post in How to check and see if a string contains invalid characters?
OK, from debugging I see your problem is in the while.... Debugging some more as I havent done Pascal in a LONG time. -
Replied To a Post in How to check and see if a string contains invalid characters?
Id take a hack at it (putting it on my PC and testing it) but is this Pascal or Delphi? Looks like Delphi... -
Created Best universal way to validate date?
Im thinking of proper ways to validate dates. Which months have 30 or 31, feb when it has 28, etc. Since Im doing this in VBScript and there is no … -
Replied To a Post in Getting duplicate key error: See log where the INSERT query error is
I went ahead with REPLACE but thank you And this isnt a PHP question. -
Replied To a Post in Why doesnt this timediff function return anything?
Figured it out. I have another question: Would: SELECT time_format(timediff('2014-04-25 09:11:00','2014-04-23 09:11:00'),'%H:%m:%S') as dif Return 48:00:00 If not, how can I get it so it can return 48:00:00 ? Thank … -
Replied To a Post in Why doesnt this timediff function return anything?
This does work BTW: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:11:47'),'%H:%m:%S') as dif It returns -00:00:10 like it should -
Created Why doesnt this timediff function return anything?
Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... -
Marked Solved Status for C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Revoked Solved Status for C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Marked Solved Status for C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Marked Solved Status for C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Replied To a Post in C# DataGridView does not show seconds from a MySQL DateTime column
Solved it with this code: try { dataGridView1.Columns["Time_Stamp"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss"; } catch (Exception x) { MessageBox.Show(x.Message); } -
Edited C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Created C# DataGridView does not show seconds from a MySQL DateTime column
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me … -
Replied To a Post in INSERT in MySQL 5.1 and 5.6 and then SELECT...
> It looks as though the data is just being placed at the beginning of the table in MySQL5.1 instead of the end. Unless specified, MySQL will add the inputted … -
Created INSERT in MySQL 5.1 and 5.6 and then SELECT...
I insert something simple like insert into table(pri1,pri2,value) values (1,1,1); insert into table(pri1,pri2,value) values (1,2,1); And in MySQL 5.6 they show up as: pri1 pri2 value 1 1 1 1 … -
Replied To a Post in Swallow duplicate entries
I figured it out: insert into table(Time_Stamp,Time_Stamp_ms,p1,p2) values (time,timems,'1','2') on duplicate key update p1 = '1',p2='2' That works for me. Did not know you could update more than one. -
Created Swallow duplicate entries
Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want … -
Created Getting duplicate key error: See log where the INSERT query error is
I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and … -
Created Getting duplicate key error: See log where the INSERT query error is
I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and … -
Marked Solved Status for Difficult date,time, and miliseconds query
I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', … -
Replied To a Post in How to get 5 rows in sql?
Even better: select * from table limit 1,5; -
Replied To a Post in Difficult date,time, and miliseconds query
Tried that but didn't work. Got it to work :) -
Replied To a Post in Split database data (tables, columns, data, etc) into various files
I did but accidiently made two threads: http://www.daniweb.com/web-development/databases/threads/476852/split-databasetables-across-various-files -
Replied To a Post in Difficult date,time, and miliseconds query
Noone has any ideas? At all? -
Created Difficult date,time, and miliseconds query
I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', … -
Replied To a Post in Split database/tables across various files
I perfer something built into MySQL natively, not a third party solution which Im sure there are plenty out there. -
Created Split database data (tables, columns, data, etc) into various files
I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? … -
Replied To a Post in Convert pairs of hex digits to char?
For example DE07 is "2014" but it is also "32303134" I have DE07. I need to convert it into "2014" (or 32303134 which I can convert to "2014). How can … -
Created Convert pairs of hex digits to char?
I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you -
Created Hex to char?
I want to get a string in hex (example: "07DE" is 2014) and convert that to a char. How can I do this in MySQL Server? Sorry for the sloppy … -
Replied To a Post in Delete last row inserted
Well how is the best way I can do that? -
Replied To a Post in BLOB to human readable?
> Unserealizing the BLOB byte data would be done in a program, probably just like you turned it into bytes in the first place. I don't think there is a …
The End.