ashabanu
Last Activity: Dec 30 '11, 12:57 PM
Joined: Dec 4 '11
Location:
-
thank you so very much. -
first and foremost , yes im using SQL. only SQL query language. I am using MYSQL workbench to extract some features needed for my project. I have managed to extract the features needed and store it in a new table call new event. I have also converted the time into integer. Below is the sql code used :-
select iphdr.cid ,iphdr.ip_dst, date(event.time stamp), convert(time(ev ent.timestamp), unsigned) as newtime, event.signature
...Leave a comment:
-
hi,
i tried something else, but it still gives the same error.
DELIMITER $$
select * from new_event where for each row
begin
set a = select newtime from new_event where cid
if a < 80101 then set newtime = 0
else set newtime = 1
end if
DELIMITER;
can you help me with the syntax.
thank u.Leave a comment:
-
MYSQL if statement syntax
Hi,
currently im using MYSQL workbench to extract some features needed for my project. However im having a problem with this query,
select newtime from new_event
IF newtime < 80101
than set newtime = 0
elseif newtime > 80000 and newtime < 160101 than set newtime = 1
elseif newtime >160000 than set newtime = 2
end if
I have converted... -
Time Frame
hi all,
i have two questions,
1) I have a huge data set, I need to separate them into three different time frame (equally). What is the fastest way to do so.
2) After performing a select statement ( a query from the original database) how can i save the output into a different database with a different name so that i could use the selected result other purpose.
thank u.
No activity results to display
Leave a comment: