Code Snippets

MySQL Insert many records with a string with incrementation values

A way to insert many records with incrementing names for testing purposes.

delimiter //
CREATE PROCEDURE dorepeat(p1 INT)
BEGIN
SET @x = 0;
REPEAT
SET @x = @x + 1;

INSERT INTO testtable (
testfield
)
VALUES (
CONCAT('teststring-', @x)
);

UNTIL @x >= p1 END REPEAT;
END
//

CALL dorepeat(15)//
DROP PROCEDURE IF EXISTS dorepeat//

Keywords: procedureincrementnamesinsert

CakePHP Solved problem with login (Auth)

If you use languages in your routes it is sometimes a little bit complicated to get your login action working.

$language = null;
if (isset($this->params['language'])) { 
	$language = $this->params['language']; 
}
$this->Auth->loginAction = array('controller' => 'users', 'action' => 'login', 'language' => $language);

Keywords: authloginloginActionlanguageparams

CakePHP Use (My)SQL functions in save action

Sometimes it is necessary to use SQL statements in your cakePHP save action, but CakePHP usually escapes everything when saving. This code helps to prevent your statements from beeing escaped.

'expires' => DboSource::expression('DATE_ADD(NOW(), INTERVAL 10 day)'),

Keywords: mysqlstatementdateintervalnow()saveescape

MySQL MySQL condition for empty fields

Select different fields for select using a condition

SELECT 
CASE 
WHEN name_de IS NULL THEN name_en 
ELSE name_de
END
AS name
FROM mytable
ORDER BY name ASC

Keywords: mysqlselectcondition

Apache Optimise performance using expire and deflate

Improve the page load performance of your website by adding long life expire dates to your static files.

<IfModule mod_deflate.c>
# compress content with type html, text, and css
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/xml
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE text/javascript
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE application/rss+xml
AddOutputFilterByType DEFLATE application/javascript
AddOutputFilterByType DEFLATE application/x-javascript

BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
</IfModule>

<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType application/javascript "access plus 10 years"
ExpiresByType text/css "access plus 10 years"
ExpiresByType text/js "access plus 10 years"
ExpiresByType text/javascript "access plus 10 years"
ExpiresByType application/x-javascript "access plus 10 years"
ExpiresByType image/png "access plus 10 years"
ExpiresByType image/gif "access plus 10 years"
ExpiresByType image/jpeg "access plus 10 years"
ExpiresByType application/x-shockwave-flash "access plus 10 years"

ExpiresByType image/vnd.microsoft.icon "access plus 10 years"
ExpiresByType image/x-icon "access plus 10 years"
</IfModule>

FileETag none

Keywords: htaccessmod_deflatemod_expireperformanceload

PHP Extract file extension from filename

Small function to extract the extension of a file from a given filename

function getFileExtension($filename)
{
	$fileextension = explode('.',$filename);
	$return = $fileextension[(count($fileextension)-1)];
}

Keywords: fileextensionextractgetfilename

Typo3 Show specified content element

Typoscript to show a content element with given id.

temp.CONTENT = RECORDS
temp.CONTENT {
	source = 123
	tables = tt_content
	dontCheckPid = 1
}

Keywords: typoscriptcontenttt_contentelementrecordssource

Typo3 Page tree condition for configuration of a page and everything below this page

Page tree condition for configuration of a page and everything below this page

[globalVar = TSFE:id = 123][globalVar = TSFE:page|pid = 123]
your typoscript
[global]

Keywords: typoscriptconditionpagepagetreepidtsfeglobalvar

Typo3 Hide select icons for database relation in backend

If you create an extension in kickstarter with related table dropdown, you'll get a set of hidden icons for each select option. If you do not want them to appear in backend, you need this code snippet.

"mydropdown" => Array (		
	"exclude" => 1,		
	"label" => "...",		
	"config" => Array (
		"type" => "select",	
		"items" => Array (
			Array("",0),
		),
		"foreign_table" => "mydropdowntable",	
		"foreign_table_where" => "",	
		"size" => 1,	
		"minitems" => 0,
		"maxitems" => 1,
		"suppress_icons" => 1,
	)
),

Keywords: pluginextensiontcasuppressiconshideiconkickstarter

MySQL Insert with content of another table

INSERT INTO table1 (field1, field2) (SELECT field3, field4 FROM table2 WHERE field3 IS NOT NULL);

Keywords: insertselect

Typo3 Do not hide plugins on copy / prevent copy from new "copy x" title

With this snippet you could control, if copied plugins should be hidden or not and which text should be prepended to title of the copied element.

$TCA['tt_content']['ctrl']['hideAtCopy'] = 0;
$TCA['tt_content']['ctrl']['prependAtCopy'] = '';

# if you want to use another title text
$TCA['tt_content']['ctrl']['prependAtCopy'] = 'MyNewTitle %s.)';
# or use a string from translation file
$TCA['<tablename>']['ctrl']['prependAtCopy'] = 'LLL:EXT:yourextkey/locallang_db.xml:yourtextkey';

Keywords: pluginextensioncopyext_tableshiddenhidecopytexttcaprependAtCopyhideAtCopylocallang

PHP Cut text after last space inside of limited length

$limit = 240;
if (strlen($text))
{
	// cut text
	$text = substr($text, 0, 240);
	// cut before last space
	$text = substr($text, 0, strrpos($text, ' '));
}

Keywords: textcutlimitsubstrspace

MySQL MySQL requests with regular expressions

SELECT yoursomething FROM yourtable WHERE yourcolumn REGEXP 'yourregexp';

Keywords: regexpregularexpressionselect

MySQL Change database to utf8

ALTER DATABASE mydatabase CHARACTER SET utf8;

Keywords: databasealterutf8

CakePHP SQL query with virtual fields

Sometimes it is neccessary to retrieve your data via the "query" function of CakePHP with plain SQL, e.g. for requests with subselects for correct data while grouping and sorting. To urge this data into the "normal" data array you need to use virtual fields definition.

$this->virtualFields = array(
	'errors' => 'SUM(Bug.errors)',
);			
$sql = "
SELECT Project.*, SUM(Bug.errors) AS Project__errors FROM 
(SELECT * FROM projects GROUP BY company_id ORDER BY created DESC) AS Project  
LEFT JOIN bugs AS Bug 
ON Project.id = Bug.project_id 
GROUP BY company_id";
$results = $this->query($sql);

Keywords: virtualFieldsgroupsumavgquerysubselect

MySQL Get an alphabet of all elements

Useful for glossary anchors or something else. It retrieves the first letter of each entry and groups by it.

SELECT SUBSTRING(title, 1, 1) as firstletter FROM glossary GROUP BY firstletter ORDER BY firstletter ASC;

Keywords: firstletteralphabetglossary

MySQL Get localised month names from MySql

Retrieves localised month names any given date in (My)SQL

SET lc_time_names = 'de_DE'
SELECT DISTINCT MONTHNAME(FROM_UNIXTIME(date)) as month;

Keywords: monthlocalisedlocalisationlc_time

Typo3 Images in Extension

Two ways to use Typo3 resize and crop functions for images in your extension/plugin.

// to render an image
$image = $this->conf["image."];		
$image['file.']['maxW'] = 160;
$image['file.']['maxH'] = 90;
$image['altText'] = '';
$image['titleText'] = '';
$image['file'] = 'uploads/tx_yourextension/'.$data['image'];
$image = $this->cObj->IMAGE($image);

// to resize/crop image and get the path only
$image = array();
$image['img'] = 'IMG_RESOURCE';
$image['img.'] = $this->conf["image."];
$image['img.']['file.']['width'] = 160;			
$image['img.']['file.']['height'] = 90;
$image['img.']['file'] = 'uploads/tx_yourextension/'.$data['image'];
$imgPath = $this->cObj->cObjGetSingle($image['img'], $image['img.']);

// crop/resize options
['maxW'], ['maxH'] - define maximum width and height
['width'], ['height'] - define width and height

['width'] = '160'
['height'] = '90c' - crop height to 90px when resized image  width to 160px

['height'] = '90c-50' - image center -50% (closer to top) from middle of image
['height'] = '90c+50' - image center +50% (closer to bottom) from middle of image

Keywords: extensionpluginimageresizecroprenderpath

Typo3 Get the Record Storage Page ids of plugin

$sysfolderPids = $this->cObj->data["pages"];

# if you use recursive configuration use this script to get all page ids
$pageIds = $this->pi_getPidList($this->cObj->data["pages"], $this->conf["recursive"]);

Keywords: extensionpluginpagespidrecursivegetPidList

Typo3 Get all PIDs in tree of specified page

This function retrieves all page ids below the given tree root.

# if first argument is null, the pid of the current plugin is used
$pageIds = $this->pi_getPidList($myPageId, $this->conf["recursive"]);

Keywords: extensionplugingetPidListpidtreerecursivepages

Typo3 Render extension content with css_styled_content

Just a function to use for rendering extension/plugin content inserted with RTE.

$this->pi_RTEcssText($data['text']);

Keywords: extensionpluginrendercontentRTEcssTextformat

Typo3 Get content from specified column

A quick and small way to get the content of a specified column with css_styled_content. Good to read content of the new Typo3 4.5 Backend Layout feature.

myContent = COA
myContent.10 < styles.content.get
myContent.10.select.where = colPos = 5

Keywords: typoscriptstylescontentcss_styled_contentcolumncolPosselect

Typo3 Show extension data in page mode

Sometimes it is useful to show the content of a plugin in page mode of Typo3. The benefit is a better usability for editors.

# insert into localconf.php
$typo_db_extTableDef_script = 'extTables.php';

# insert into extTables.php
# usage: comma for new column, semicolon for line break
$table = 'extension_table';
$TYPO3_CONF_VARS['EXTCONF']['cms']['db_layout']['addTables'][$table][0] = Array(
	'fList' => 'title;subtitle,nextcolumn',
	'icon' => TRUE,
);

Keywords: extensionpluginpagepagemodebackend

Typo3 Different wrap methods for tt_content

tt_content.stdWrap.innerWrap.cObject = CASE
tt_content.stdWrap.innerWrap.cObject {
	key.field = CType
 
	default = CASE
	default {
		key.field = section_frame
		1 = TEXT
		1.value = <div class="box">|</div>
	}
	shortcut = TEXT
	shortcut.value = |
}

tt_content.stdWrap.outerWrap.cObject = CASE
tt_content.stdWrap.outerWrap.cObject {
	key.field = layout
	1 = TEXT
	1.value = <div class="box">|</div>
}

tt_content.stdWrap.dataWrap.cObject = CASE
tt_content.stdWrap.dataWrap.cObject {
	key.field = section_frame
	1 = TEXT
	1.value = <div class="box">|</div>
}

Keywords: typoscripttt_contentwrapstdWrapdataWrapouterWrapinnerWrapcasesection_framelayoutcType

Typo3 Configure Meta Tags in Typo3

With this snippet you can define default keywords and description for pages without these. Otherwise the keywords and description defined in page configuration will be used.

# meta configuration
page.meta.keywords.field = keywords
page.meta.keywords.ifEmpty (
your, keywords
)
page.meta.description.field = description
page.meta.description.ifEmpty (
your description
)
page.meta.robots = index, follow, noarchive
page.meta.author = Jon Doe
page.meta.copyright = Jon Doe
page.meta.email = mail@example.com
page.meta.language = en
page.meta.revisit-after = 2days

Keywords: typoscriptpluginmetatagsrobotsdescriptionkeywordsrevisit

Typo3 Render content elements in extension

This function renders content elements specified by an array of uids as css_styled_content would render. With this function you could insert content elements in your extension.

function appendContent($uids = null)
{
	if ($uids)
	{
		$this->conf['tables'] = 'tt_content';
		$this->conf['conf.']['tt_content'] = '< tt_content';
		$this->conf['source'] = $uids;
		$this->conf['dontCheckPid'] = '1';
		return $this->cObj->cObjGetSingle('RECORDS', $this->conf);
	}
	return false;
}

Keywords: extensiontt_contentrender

Typo3 404 Not found redirect

Redirects to configured page. This page could be a typo3 page too.

# insert into typo3conf/localconf.php
$TYPO3_CONF_VARS['FE']['pageNotFound_handling'] = '/notfound.html';
$TYPO3_CONF_VARS['FE']['pageNotFound_handling_statheader'] = 'HTTP/1.0 404 Not Found';

Keywords: localconf.phpredirect404errorpage

Typo3 Transform special chars in links for validation issues

To improve the w3c validation of your page you need to activate the transformation of special chars (like & to &) in links and menus.

# menus
1 = TMENU
1 {
	NO {
		stdWrap.htmlSpecialChars = 1
	}
	ACT < .NO
}

# typolinks
1 = TEXT
1.value = Terms of Use & Legal statement
1.stdWrap.htmlSpecialChars = 1
1.typolink.parameter = 42

Keywords: typoscriptmenulinkspecialcharsvalidationvalidate

MySQL Sort result with a specified sort list

Very useful if there is a WHERE field IN (values) condition. The values could be used in the same way for the sorting definition.

SELECT * WHERE id IN (2, 7, 45, 3) ORDER BY FIELD(id, 2, 7, 45, 3);

Keywords: sortingspecialfields

Typo3 Simple link with typoscript

temp.MYLINK = TEXT
temp.MYLINK.value = My Link
temp.MYLINK.typolink.ATagParams = class="mylink" title="mylinktitle"
temp.MYLINK.typolink.parameter = 42

Keywords: typoscriptlinktypolinkatagparams

PHP Localisation for date functions

Localise the output of date functions for months and days

setlocale(LC_TIME, "de_DE");
// get localised date
strftime('%d. %B %Y', date('U'))

Keywords: localisationlocaliselocalizationlocalizedatestrftimesetlocalelc_time

Typo3 Condition for all elements with page id in rootline / tree

[PIDInRootline = 1,3,9]
#your typoscript
[global]

Keywords: typoscriptconditionpidPIDInRootline

Typo3 Get PIDs from "Record Storage Page" selector

Get PIDs of selected pages from "Record Storage Page" selector in plugin inclusion.

$this->cObj->data['pages'];

Keywords: pluginextensioncobjpidpages

Typo3 List of all possible menu status

Just a listing of all possible menu status you can use for menu generation in typoscript.

NO, IFSUB, ACT, ACTIFSUB, CUR, USR, SPC, CURRO, CURIFSUB, CURIFSUBRO, ACTRO, ACTIFSUBRO

Keywords: typoscriptmenustatusstatiNOIFSUBACTACTIFSUBCURUSRSPCCURROCURIFSUBCURIFSUBROACTROACTIFSUBRO

Typo3 Create a "switch language" menu (variant 2)

Another way to create a switch language menu with active status of the current language. In this variant you could set different settings for all links for each selected language.

temp.langlink1 = TEXT
temp.langlink1.value =Deutsch
temp.langlink1.innerWrap = <span>|</span>
temp.langlink1.typolink.parameter.data = page:uid
temp.langlink1.typolink.additionalParams = &L=0
temp.langlink1.typolink.ATagParams = class="lang-de-active" lang="de" xml:lang="de" title="zu deutscher Sprache wechseln"

temp.langlink2 = TEXT
temp.langlink2.value=English
temp.langlink2.innerWrap = <span>|</span>
temp.langlink2.typolink.parameter.data = page:uid
temp.langlink2.typolink.additionalParams = &L=1
temp.langlink2.typolink.ATagParams = class="lang-en" lang="en" xml:lang="en" title="switch to english language"

[globalVar = GP:L = 1]
temp.langlink1 = TEXT
temp.langlink1.value =Deutsch
temp.langlink1.innerWrap = <span>|</span>
temp.langlink1.typolink.parameter.data = page:uid
temp.langlink1.typolink.additionalParams = &L=0
temp.langlink1.typolink.ATagParams = class="lang-de" lang="de" xml:lang="de" title="zu deutscher Sprache wechseln"

temp.langlink2 = TEXT
temp.langlink2.value=English
temp.langlink2.innerWrap = <span>|</span>
temp.langlink2.typolink.parameter.data = page:uid
temp.langlink2.typolink.additionalParams = &L=1
temp.langlink2.typolink.ATagParams = class="lang-en-active" lang="en" xml:lang="en" title="switch to english language"
[global]

temp.LANGNAV = COA
temp.LANGNAV {
	wrap= <ul>|</ul>
	10 < temp.langlink1
	10.wrap = <li>|</li>
	
	20 < temp.langlink2
	20.wrap = <li>|</li>
}

Keywords: typoscriptswitchlanguagemenuactive

Typo3 Create a "switch language" menu (variant 1)

How to create a switch language menu with active status of the current language.

temp.LANGUAGENAVIGATION = COA
temp.LANGUAGENAVIGATION.20 = TEXT
temp.LANGUAGENAVIGATION.20.value = DE
temp.LANGUAGENAVIGATION.20.typolink {
	parameter.data = TSFE : id
	additionalParams = &L=0
	title = Zur deutschen Sprache wechseln	
	ATagParams = class="active lang-de"
	wrap = <span>|</span>
	ATagBeforeWrap = 1
}
temp.LANGUAGENAVIGATION.30 = TEXT
temp.LANGUAGENAVIGATION.30.value = EN
temp.LANGUAGENAVIGATION.30.typolink {
	parameter.data = TSFE : id
	additionalParams = &L=1
	title = Switch to english language	
	ATagParams = class="lang-en"
	wrap = <span>|</span>
	ATagBeforeWrap = 1		
}

[globalVar = GP:L = 1]
temp.LANGUAGENAVIGATION.30.typolink.ATagParams = class="active lang-en"
temp.LANGUAGENAVIGATION.20.typolink.ATagParams = class="lang-de"
[global]

Keywords: typoscriptswitchlanguagemenuactive

Typo3 How to use user functions

Small snippet to retrieve content from user functions in extensions.

# decide wether to use COA (cached) or COA_INT (uncached)
temp.CONTENT = COA_INT
temp.CONTENT.10 < plugin.tx_myplugin_pi1
temp.CONTENT.10.userFunc = tx_myplugin_pi1->myfunctionname

Keywords: typoscriptuserfuncfunctionextensionplugin

Typo3 Language fall

Language fallback for multi language pages

config.sys_language_mode = content_fallback

Keywords: typoscriptlanguagefallback

Typo3 Plain and empty template

Useful to generate RSS or AJAX content pages.

config {
	disableAllHeaderCode = 1
	additionalHeaders = Content-type:text/xml
	no_cache = 1
	xhtml_cleaning = 0
	xmlprologue = none
	disablePrefixComment = 1
} 
tt_content.stdWrap.dataWrap = |
lib.stdheader >
tt_content.stdWrap.innerWrap > 

page = PAGE
page.typeNum = 0
page.10 = COA
page.10 < styles.content.get

Keywords: typoscripttemplateemptyplainrssajax

Typo3 Include typoscript from file

Script to include typoscript from file. Useful for versioning.

<INCLUDE_TYPOSCRIPT: source="FILE: fileadmin/templates/ts/config.ts">

Keywords: typoscriptincludeexternalfile

Typo3 Show navigation title only in pagetree

The page tree is sometimes very confusing if you define navigation title and page title for your pages. With this code you could show the navigation title only.

# insert into TSconfig of user
options.pageTree.showNavTitle = 1

// or add to typo3conf/localconf.php
t3lib_extMgm::addUserTSConfig('options.pageTree.showNavTitle = 1');

Keywords: typoscriptlocalconf.phpnavtitleTSconfig

Typo3 Get translation for current language from locallang.xml

Reads translated string from locallang.xml for current language selection. If there is no translation, the default string would be returned.

$this->pi_getLL('locallang-key');

Keywords: pluginextensionlanguagelocallangtranslate

Typo3 Get current language key in extension

Sometimes you need to get the current language key in your extension.

$this->LLkey; // returns en, de, etc.

Keywords: pluginextensionlanguagekey

Typo3 Get current sys_language_uid in extension

Sometimes you need to get the current sys_language_uid in your extension.

$GLOBALS['TSFE']->sys_language_uid;

Keywords: pluginextensionsys_language_uidtsfelanguage

Typo3 Basic page config for multi domains / multi languages

Initial configuration for baseUrl and language meta tags for multi domain and multi language pages.

config {
	linkVars = L
	sys_language_uid = 0
	addParams = L=0
	language = en
	locale_all = en_EN
	baseURL = http://www.mydomain.com/
}
[globalString = HTTP_HOST=http://www.mydomain.de][globalVar = GP:L = 1]
	config {
		linkVars = L
		sys_language_uid = 1
		addParams = L=1
		language = de
		locale_all = de_DE
		baseURL = http://www.mydomain.de/
	}
[global]
[globalString = HTTP_HOST=http://www.mydomain.ch][globalVar = GP:L = 2]
	config {
	linkVars = L
	sys_language_uid = 2
	addParams = L=2
	language = ch
	locale_all = ch_CH
	baseURL = http://www.mydomain.ch/
	}
[global]

Keywords: typoscriptmultilanguagedomainconfigmeta

Typo3 Change plugin texts with typoscript

Change plugin texts with typoscript. You can do this for multi language texts too.

plugin.tx_EXTENSIONKEY_pi1 {
	_LOCAL_LANG {
		en {
			labelkey1 = My new text 1
			labelkey2  = My new text 2
		}
		de {
			labelkey1 = Mein neuer Text 1
			labelkey2  = Mein neuer Text 2
		}
	}
}

Keywords: typoscriptmultilanguagetextpluginextension

Typo3 Multi language texts with typoscript

A way to define multi language texts in typoscript

text.10.value = <h1>Deutsch</h1>
text.10.lang.en = <h1>Englisch</h1>

Keywords: typoscriptmultilanguagetext

Typo3 HTML template into Typo3 content element

Loads a HTML template part into a Typo3 content element.

temp.RIGHTCONTENT = COA
temp.RIGHTCONTENT.10 = TEMPLATE
temp.RIGHTCONTENT.10 {
	template = FILE
	template.file = fileadmin/templates/rightside.html
	workOnSubparts = DOCUMENT_BODY
}

Keywords: typoscripttemplatecontentcoa

Apache Redirect domain to www.domain

Redirects domain requests without www to www.domain with 301 status code (for search engines). This prevents from the problem of providing duplicate content.

<IfModule mod_rewrite.c>
	RewriteEngine On
	RewriteCond %{HTTP_HOST} ^mydomain\.com$ [NC]
	RewriteRule ^(.*)$ http://www.mydomain.com/$1 [R=301,L]
</IfModule>

Keywords: redirecthtaccessmod_rewrite301

Typo3 Show layout field in plugin content item

Sometimes you need the layout dropdown for the plugin content item too.

Remove entry "layout" in ext_tables.php "subtypes_excludelist". This list could be used to hide some other elements too.

$TCA['tt_content']['types']['list']['subtypes_excludelist'][$_EXTKEY.'_pi1']='layout,select_key';

Keywords: layoutpluginextensionext_tablesexcludelisttt_content

Typo3 Rendering Typo3 Link URLs within Extension

Retrieves URL for specified page id (pid). $GLOBALS['TSFE']->id contains current page id.

$this->pi_getPageLink($GLOBALS['TSFE']->id.'#my-anchor');

Keywords: typolinkgetpagelinkextensionpluginurltsfe

Typo3 Rendering Typo3 Links within Extension

How to render a Typo3 link. $myPageId could be replaced with $GLOBALS["TSFE"]->id if you want to render a link to current page. $this->pi_getLL('your-translation-key') translates your link name and link title based on your locallang.xml file.

$GLOBALS['TSFE']->ATagParams = 'title="'.$this->pi_getLL('link-title').'" class="link"';
$mylink = $this->pi_linkToPage(
	$this->pi_getLL('linkname-title'), 
	$myPageId.'#my-anchor', 
	'_top', 
	array('urlparam1' => 'value1')
);

Keywords: typolinklinktopageatagparamstranslationextensionplugintsfe

Typo3 Typoscript condition for special page

Condition to define typoscript for selected/exclusive pages of a specified pagetree/rootpage only.

[globalVar = TSFE:id=10, TSFE:page|pid=1]
# do things here
[global]

Keywords: typoscriptconditiontsfeidglobalvarpagetreerootpage

Typo3 Typoscript condition for special page

Condition to define typoscript for selected/exclusive pages only.

[globalVar = TSFE:id=10]
# do things here
[global]

Keywords: typoscriptconditiontsfeidglobalvar

MySQL Update table with content of another table

If you need to import content from another table width different field names.

UPDATE table2 AS t2 
LEFT JOIN (SELECT id, name FROM table1) AS t1 
ON t2.id = t1.id 
SET t2.title = t1.name;

Keywords: insertjoinmigrateimport