how to work on temporary table in mysql

Question

hi all i need to work on temporary table in mysql. this is the first time i need work on that please help me

Francis · Answer

i need to work on temporary table in mysql. Sure. Temporary tables were added in MySQL version 3.23. If you use an older version of MySQL than 3.23 you can't use temporary tables but you can use heap tables. Below links are helpful to your to get better insight on Temporary tables. http://www.tutorialspoint.com/mysql/mysql-temporary-tables.htm http://stackoverflow.com/questions/5859391/create-a-temporary-table-in-a-select-statement-without-a-separate-create-table If you want more on this you could follow the below google search: https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=temporary+tables+mysql Hope this helps!

Nishant Mittal · Answer

Hi The scope of Local Temporary table is only bounded with the current connection of current user. Check this out for more help http://www.tutorialspoint.com/sql/sql-temporary-tables.htm https://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/