Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming tables is required, the following 39 results were found.

  1. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  2. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  3. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  4. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in the database @SearchStr -- Provide the search string. Use the '%' to coin the search. EX : X%--- will give data staring with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  5. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings :...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  6. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

    can back up the database. db_datareader Members of the db_datareader fixed database role can read all data from all user tables. db_datawriter Members of the db_datawriter fixed database role can add, delete, or change data in all user tables....

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  7. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a copy of (note the "jos_" prefix to all J15 tables, if you have changed this then reflect this in the SQL file). Rename any instance of "my_new_database" to the name of your new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  8. SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID], [student_reference],...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  9. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  10. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets stored in... Resources...the one with the codes and resource...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  11. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  12. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB

  13. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *

  14. MySQL Oracle equivalentshttps://www.joellipman.com/articles/else/database/mysql-oracle-equivalents.html

    a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  15. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions ie. InnoDB. Don't be silly like me and spend hours wondering why your...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB

  16. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    of creator is the one creating the connection link. The JSON response is that the update was successful but the Creator tables do not update... ZohoCreator/creatorapi option not available to enable: resolved by deleting any existing ones, refreshing the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  17. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  18. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *

  19. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    "can it be in a bigger font?"... without pushing back too much, it can end up looking like those old websites with HTML tables. We're going to use a HTML table again but that's because I want to send it to the PDF renderer in ZohoCreator and want all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  20. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    and completely optional): So now I can go back to my query and expand on it a little to include the other datasources (CRM Tables): SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" AS "Record ID", t1."RecordName"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
Results 1 - 20 of 39