Sign UpAds
Welcome New Members!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
View by :
|
|
Is it possible to "combine" two inserts somehow?
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?
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?
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?
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?
What is the reason people use UPPERCASE for SQL keywords? Why not use all lowercase?
|
|
|
Whats an explicit join?
Whats an explicit join?
|
|
|
How to insert 237.741343124473 number in a table?
How to insert 237.741343124473 number in a table?
|
|
|
Can I concatenate three fields whilst querying them?
Can I concatenate three fields whilst querying them? eg. areacode, exchange, phonenumber?
|
|
|
Are SQLers just code monkeys shooting from the hip?
Are SQLers just code monkeys shooting from the hip?
|
|
|
What's a query ?
What's a query ?
|
|
|
Is this correct syntax?
Is this correct syntax: UPDATE tablename SET copycolumn=originalcolumn
|
|
|
Whats the safest password encryption for mysql db now ?
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?
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?
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?
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?
How do you add 1 to month('2009-11-15') in MSSQL?
|
|
|
Is it possible to save queries in phpMyAdmin?
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?
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?
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?
what's the best way to do a "if exists, update; else, insert" with mysql?
|
