Is it possible to "combine" two inserts somehow? Ill explain my problem. I first insert to one table and then the primary key of that table is incremented and a new row is inserted. I need that pkey f
Is it possible to select data from two tables at once? almost like making two select statements but in one/query
How do I execute a MySQL query without cache? I want to test the speed of my queries but it keeps getting cached and returning trivial execute times like 0.00011. I know the first execution was 0.456.
How do I view all triggers? I have two triggers setup but I have no idea how to view them. I'm using phpMyAdmin and would like to view them in there but I can execute SQL as well.
What is the reason people use UPPERCASE for SQL keywords? Why not use all lowercase?
Whats an explicit join?
How to insert 237.741343124473 number in a table?
Can I concatenate three fields whilst querying them? eg. areacode, exchange, phonenumber?
Are SQLers just code monkeys shooting from the hip?
What's a query ?
Is this correct syntax: UPDATE tablename SET copycolumn=originalcolumn
Whats the safest password encryption for mysql db now ? (where mssql has this function by default)
is it possible to insert data into two separate tables in one statement?
How can I delete all records from a table that are 20 days old in MySQL? I have a datetime column.
Using a datetime field as a column in MySQL, how can I select all of the rows in the last 24 hours?
How do you add 1 to month('2009-11-15') in MSSQL?
Is it possible to save queries in phpMyAdmin? Like bookmark them for later use?
what is a good use for storing files as a blob?
does SQL have a syntax where it will select all info from a table except for something you specify?
what's the best way to do a "if exists, update; else, insert" with mysql?
Exposix does not evaluate or guarantee the accuracy of any Exposix content. Click here for the Full Disclaimer.