Hej,
skulle behöva lite hjälp med att konvertera om en SQL query från MSSQL till MYSQL.
Kod:
IF NOT EXISTS (SELECT * FROM IF_sessions WHERE session_name = '" + sSession_name + "' AND session_id = '"+ sSession_id + "')
BEGIN
INSERT INTO IF_sessions(session_id, created, expires, session_name, session_data)
Values('" + sSession_id + "', GETDATE(), '" + System.DateTime.Now.AddHours(2) + "', '" + sSession_name + "', '" + sSession_data + "')
END
ELSE
BEGIN
UPDATE IF_sessions SET expires = GETDATE(), session_data = '" + sSession_data + "' WHERE session_id = '" + sSession_id + "' AND session_name = '"+ sSession_name + "'
END