Search - Joel Lipman .Com

1. Databases: / Category /; Created on 05 March 2020
2. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE ...; Created on 20 March 2019
3. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
4. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
5. Restore MSSQL Error: Database is in use: / Databases /; What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged ...; Created on 08 March 2013
6. Export/Import Database using MySQL Workbench: / MySQL /; What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...; Created on 05 February 2013
7. Quickly update all content in mySQL database replacing a string: / MySQL /; ... that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me ...; Created on 03 February 2013
8. Access MySQL databases using Oracle SQL Developer: / MySQL /; What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, ...; Created on 01 February 2013
9. JDatabase: using the Joomla database with examples: / Joomla /; What? Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation ...; Created on 27 January 2013
10. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
11. Search a database with SOUNDEX: / Databases /; ... same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding ...; Created on 11 October 2012
12. Search a database for a string (MySQL, T-SQL): / Databases /; What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...; Created on 08 October 2012
13. Connect to Joomla database in standalone script: / Joomla /; ... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...; Created on 17 August 2012
14. The ReportServer Database: / Databases /; ... as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...; Created on 08 August 2011
15. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected ...; Created on 05 January 2011
16. Create Read-Only Database User in SQL Server: / Databases /; The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security ...; Created on 09 November 2010
17. Search and Replace in a MySQL Database: / MySQL /; ... but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html ...; Created on 17 March 2010
18. Database Error: Unable to connect to the database: Could not connect to MySQL: / MySQL /; I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause ...; Created on 25 September 2009
19. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
20. ZohoCRM: Import Attachments: / Zoho /; ... database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the ZCRM Record ID (eg. if Contacts module then the CRM Contact ID) and column ...; Created on 16 January 2023