Login or Register :: Home :: Search :: Your Account :: Forums :: Waraxe Advisories :: Tools :: November 21, 2024 Menu Home Logout Discussions Forums Members List IRC chat Tools Base64 coder MD5 hash CRC32 checksum ROT13 coder SHA-1 hash URL-decoder Sql Char Encoder Affiliates y3dips ITsec Md5 Cracker User Manuals AlbumNow Content Content Sections FAQ Top Info Feedback Recommend Us Search Journal Your Account User Info Welcome, Anonymous Nickname Password (Register) Membership: Latest: MichaelSnaRe New Today: 0 New Yesterday: 0 Overall: 9144 People Online: Visitors: 79 Members: 0 Total: 79 Full disclosure SEC Consult SA-20241112-0 :: Multiple vulnerabilities in Siemens Energy Omnivise T3000 (CVE-2024-38876, CVE-2024-38877, CVE-2024-38878, CVE-2024-38879) Security issue in the TX Text Control .NET Server for ASP.NET. SEC Consult SA-20241107-0 :: Multiple Vulnerabilities in HASOMED Elefant and Elefant Software Updater Unsafe eval() in TestRail CLI 4 vulnerabilities in ibmsecurity 32 vulnerabilities in IBM Security Verify Access xlibre Xnest security advisory & bugfix releases APPLE-SA-10-29-2024-1 Safari 18.1 SEC Consult SA-20241030-0 :: Query Filter Injection in Ping Identity PingIDM (formerly known as ForgeRock Identity Management) (CVE-2024-23600) SEC Consult SA-20241023-0 :: Authenticated Remote Code Execution in Multiple Xerox printers (CVE-2024-6333) APPLE-SA-10-28-2024-8 visionOS 2.1 APPLE-SA-10-28-2024-7 tvOS 18.1 APPLE-SA-10-28-2024-6 watchOS 11.1 APPLE-SA-10-28-2024-5 macOS Ventura 13.7.1 APPLE-SA-10-28-2024-4 macOS Sonoma 14.7.1 IT Security and Insecurity Portal www.waraxe.us Forum Index -> MySql -> Search on several tables in SQL View previous topic :: View next topic Search on several tables in SQL Posted: Mon Sep 15, 2008 10:47 am str0xo Beginner Joined: Sep 15, 2008 Posts: 3 Good morning, I have a problem and I am currently blocked the above, I hope any help , my problem is as follows: I must write PL / SQL, requette SQL which makes a search (a search engine) on several tables (at least 8 => several joints) on fields that can be NULL, empty, full ... I do not recover as the list of id of the table (ROOT), this is how I have done, but it did not work Quote: SELECT tableRoot.Id FROM table_root tableRoot, table_fille1 fille1, table_fille2 fille2, table_fille3 fille3, table_fille4 fille4, ... WHERE tableRoot.champRoot1 LIKE '%i__var1%' AND tableRoot.champRoot2 = i__var2 AND tableRoot.champRoot3 = i__var3 AND fille1.champfille1_1 = i__var4 AND fille1.champfille1_2 = i__var5 AND fille2.champfille2 LIKE '%i__var6 %' AND fille3.champfille3 LIKE '%i__var7 %' AND fille4.champfille4_1 LIKE '%i__var8 %' AND fille4.champfille4_2 LIKE '%i__var9 %' AND ... -- Inner joins fille1.id = tableRoot.fk_id_1 AND fille2.id = tableRoot.fk_id_2 AND fille3.id = tableRoot.fk_id_3 AND fille4.id = tableRoot.fk_id_4 ...; thank's Posted: Mon Sep 15, 2008 10:56 am nuckel Active user Joined: Mar 25, 2008 Posts: 28 Good morning can you give a little more detail? what does not? a small example can be reduced to a child table to show us what you really want and what you problem? Thanks Posted: Mon Sep 15, 2008 11:02 am str0xo Beginner Joined: Sep 15, 2008 Posts: 3 hi Thank's for your response Already the first question that arises: Is what I'm on the right path, is this the way forward? y'aurais no problems fall performance, if information does not exist at a table which has been doing a join, it will not affect the requette short, you see problems in this method? Posted: Mon Sep 15, 2008 11:08 am nuckel Active user Joined: Mar 25, 2008 Posts: 28 hi, Already performance level will require that you use indexes According without more information, it is difficult to say any more worry. Posted: Mon Sep 15, 2008 11:16 am dzH Regular user Joined: Mar 15, 2008 Posts: 17 nuckel wrote: hi, Already performance level will require that you use indexes According without more information, it is difficult to say any more worry. Indexes with like '%...', no interest!!!! Posted: Fri Sep 19, 2008 12:34 pm 0xbadfaceX Regular user Joined: Aug 01, 2008 Posts: 12 Location: .bashrc$> str0xo wrote: hi Thank's for your response Already the first question that arises: Is what I'm on the right path, is this the way forward? y'aurais no problems fall performance, if information does not exist at a table which has been doing a join, it will not affect the requette short, you see problems in this method? look at : y'aurais . . . french??? if you want to send a translated text to someone or use it for your correspondence, explain that you always use a translator ... because there, you writing as the noobs i can not understand what you talked about because your language is very bad and i think that "str0xo", "Nuckel", "dzH" are the same person by different nickname, the IP used. . see u . . _________________ , Search on several tables in SQL www.waraxe.us Forum Index -> MySql You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum All times are GMT Page 1 of 1 All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Select a forumSecurity Research by waraxe----------------General discussionHow to fixMetasploit relatedHash cracking requests----------------MD5 hashesAll other hashesHash related informationhttp://www.waraxe.us portal----------------SuggestionsCooperation proposalsSecurity bugs and issues in general----------------Newbies cornerSql injectionCross-site scripting aka XSSRemote file inclusionFull path disclosureShell commands injectionPhishing and Social EngineeringAll other security holesVarious software----------------PhpNukePostNukePhpBBXMB forumvBulletin BoardInvision Power Boarde107MamboJoomlaXOOPSM$ WindowsLinux worldAll other softwareCoppermine Photo GalleryProgramming languages----------------PhpMySqlPerlJavaJavascriptC and C++Visual BasicBorland Delphi and PascalPythonHTML and XMLAssemblerReverse engineering----------------Newbies cornerDisassemblingPHP script decode requestsMiscellaneous stuff----------------Future of the ITNanotechnologyFun cornerLinksTry2hack sitesProxy databaseDirect Downloads----------------ToolsTutorialsWordlistsRecycle Bin----------------Removed messagesOutdated posts Powered by phpBB © 2001-2008 phpBB Group

Space Raider game for Android, free download - Space Raider gameplay video - Zone Raider mobile games
All logos and trademarks in this site are property of their respective owner. The comments and posts are property of their posters, all the rest (c) 2004-2024 Janek Vind "waraxe"
Page Generation: 0.035 Seconds