Assuming mysql is required, the following 75 results were found.
-
empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a string in a mySQL database.
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
my own personal website: www.joellipman.com. This article assumes you are familiar with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and MySQL all of which have various ways of escaping the ampersand (except for MySQL which doesn't need to and in my opinion is the best...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
compatible with phpBB. phpBB3 installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the phpBB3 system. For installation purposes, this mysql user has been granted...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
1 or more if not alpha numeric. SELECT PATINDEX('%[^a-zA-Z0-9]%' , @ParameterToCheck) AS NotAlphaNumeric FROM... -- MySQL -- 1 if is alphanumeric, 0 if not alpha numeric. SELECT @ParameterToCheck REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM... Usage...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
= preg_replace ( '/\'([^\']+)\'/', '$0', $string_formatted ); Surround string (backticks) with darkred styling Convert: `mysql_reserved_word`=my_alias » `mysql_reserved_word`=my_alias $string_formatted = preg_replace ( '/`([^`]+)`/', '$0',...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert,...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News category (to tell everyone...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a folder. Path: [ROOT]/components/com_akeebabackup Component Uninstall: Can't uninstall. Please remove manually. Go to run Mysql directly: delete from `#_extensions` where name='com_akeebabackup'; System > Extensions > Install from Web > Akeeba >...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This extension includes the default settings for "ExpressShow" in Camtasia Studio. My Setup MediaWiki v1.14.0 PHP v5.1.6 MySQL v5.0.45 Camtasia Studio v5.0 For Demonstration Purposes We want to add a video called "EXAMPLE.SWF" to an article Let's begin...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
not added the equipment info on the system), it just showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
used in report parameter expressions" either. I'm using an Oracle/PLSQL database for this so whether you're using T-SQL or MySQL you'll need to use the appropriate variable references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull off. After much umming and aah-ing, I have...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the name of "seamless...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB