How can create session in SQL/MySql.

Question

How Can be create session in Sql/MySql.

Ramesh Palaniappan · Answer

SET @start=1,@finish=10; or SELECT @start:=1,@finish:=10; SELECT * FROM USERTABLE WHERE place BETWEEN @start AND @finish; Declare it as variable and use it

Delpin Susai Raj · Answer

MySQL session https://m.youtube.com/watch?v=pqimG7wnXnc

Bikesh Srivastava · Answer

http://www.codeproject.com/Articles/104082/Configuring-ASP-session-state-on-SQL-server

Nitin Sontakke · Answer

Assuming you want to do the session state management in SQL Server, here is a link: https://support.microsoft.com/en-in/kb/317604

Tejas Trivedi · Answer

Hello Vijay, Only Event Session is available in MS SQL Server. There is no session available for queries and other objects in SQL Server. In MySQL, you can have session variable as Ramesh has explained in his example and can be declared and start with @. Hope, this will answer your query. Feel free to write if you need more information on this. Please don't forget to mark as answer if this helps.

Delpin Susai Raj · Answer

Sql session https://m.youtube.com/watch?v=o-8vjQu6SmI

Midhun T P · Answer

Hi, Please check below links- https://msdn.microsoft.com/en-us/library/bb677289.aspx http://www.sqlines.com/mysql/session_variables

Dhananjay Kumar · Answer

How to use MySQL-based sessions https://web.stanford.edu/dept/its/communications/webservices/wiki/index.php/How_to_use_MySQL-based_sessions

How can create session in SQL/MySql.

Answers (8)