sql
strange sql error
i have the following code: <!--ajouter une carte--> <?php if($_POST[\"submit_dd\"]){ mysql_query(\"INSERT INTO data SET desc=\'\".$_POST[\"carte_nom\"].\"\' \") or die(mysql_error());[详细]
2023-04-13 02:47 分类:问答Deleting Related Rows in a Many-to-Many Relationship
I\'m deleting a row in a table that is on one site of a many-to-many relationship. I would also like to delete any related rows on the other side of that relationship.[详细]
2023-04-13 02:35 分类:问答Accessing 400 tables in a single query
I want to delete rows with a condition from mu开发者_如何学编程ltiple tables. DELETE FROM table_1[详细]
2023-04-13 02:29 分类:问答How do I get a 'combined' ranking of OR phrases using CONTAINSTABLE in SQL Server?
I\'d like to get a \'combined\' ranking of OR phrases with CONTAINSTABLE, but have not had any luck. Basically I\'m seeking functionality for an AND/OR ability.[详细]
2023-04-13 02:26 分类:问答Group by with diff percentage MySQL
I have been trying to query the increase percentage of a product grouped in certain range depending on the actual increase for ea开发者_Go百科ch run.So for example I have the following table schema[详细]
2023-04-13 02:19 分类:问答Securely storing (encrypting) data in an ASP.Net application
I have an asp.net application, accessed by people over the internet using web browsers.It runs on a web server and it talks to a backend database.[详细]
2023-04-13 02:17 分类:问答How to collect and clean database entries with bad emails
So I\'ve been given the task of going through our mailing list and \"cleaning\" the emails which are slightly incorrect (trailing symbols, 开发者_如何学运维random symbols accidentally in the middle of[详细]
2023-04-13 02:16 分类:问答DB2 SQL query to compare 2 schemas
I have been unable to find a solution in my searching for this throughout the web, most responses recommend a tool, which leads me to believe this may be very difficult with an SQL query or something,[详细]
2023-04-13 02:15 分类:问答JOINING comma separated values
I have 2 tables as below: TABLE:CITY CITY_ID CITY ---------------- 1London 2Chicago 3Newyork 4Delhi TABLE:TRAIN[详细]
2023-04-13 02:11 分类:问答Speed up linq query without where clauses
Quick LINQ performance question. I have a database with many many records and it\'s used for a webshop.[详细]
2023-04-13 02:02 分类:问答