lyrics.trackid

вот постои sql
-------------------------

-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 24, 2007 at 11:52 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
-- 
-- Database: `lyrics`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `artists`
-- 

DROP TABLE IF EXISTS `artists`;
CREATE TABLE `artists` (
  `id` int(11) NOT NULL auto_increment,
  `artist` varchar(255) NOT NULL,
  `totaltracks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  ;

-- --------------------------------------------------------

-- 
-- Table structure for table `lyrics`
-- 

DROP TABLE IF EXISTS `lyrics`;
CREATE TABLE `lyrics` (
  `trackid` int(7) NOT NULL,
  `lyrics` text NOT NULL,
  PRIMARY KEY  (`trackid`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Table structure for table `pendinglyrics`
-- 

DROP TABLE IF EXISTS `pendinglyrics`;
CREATE TABLE `pendinglyrics` (
  `id` int(11) NOT NULL auto_increment,
  `artist` varchar(255) NOT NULL,
  `track` varchar(255) NOT NULL,
  `album` varchar(255) NOT NULL,
  `lyrics` text NOT NULL,
  `email` varchar(255) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  ;

-- --------------------------------------------------------

-- 
-- Table structure for table `sitetotals`
-- 

DROP TABLE IF EXISTS `sitetotals`;
CREATE TABLE `sitetotals` (
  `statkey` varchar(20) NOT NULL,
  `lastupdate` datetime NOT NULL,
  `statvalue` int(11) NOT NULL
) ENGINE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `tracks`
-- 

DROP TABLE IF EXISTS `tracks`;
CREATE TABLE `tracks` (
  `id` int(7) NOT NULL auto_increment,
  `artist` varchar(250) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `album` varchar(250) NOT NULL default '',
  `dateadded` datetime NOT NULL,
  `artwork` varchar(50) default NULL,
  `views` int(11) NOT NULL default '0',
  `votestar1` int(5) NOT NULL default '0',
  `votestar2` int(5) NOT NULL default '0',
  `votestar3` int(5) NOT NULL default '0',
  `votestar4` int(5) NOT NULL default '0',
  `votestar5` int(5) NOT NULL default '0',
  `votestartotal` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `artist` (`artist`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `album` (`album`)
) ENGINE=MyISAM ;


INSERT INTO `sitetotals` VALUES ('totaltracks', '2007-10-24 23:35:10', 0);
INSERT INTO `sitetotals` VALUES ('totalartists', '2007-10-24 23:35:10', 0);

и? снова ошибка?

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

#1054 - Unknown column 'tracks.trackid' in 'where clause'

уф..

что делаь

`tracks.id`

из вни тут ты имеешь в виду

 UPDATE `tracks` SET `lyrics`.`lyrics` = `tracks`.`lyrics` WHERE `lyrics`.`tracks` = `trackid`.`id`

да это, только

UPDATE `tracks` SET `lyrics`.`lyrics` = `tracks`.`lyrics` WHERE `lyrics`.`trackid` = `tracks`.`id`

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

error

говорю же не пробовал так делать)

попробуй

UPDATE `tracks`, `lyrics` SET `lyrics`.`lyrics` = `tracks`.`lyrics` WHERE `lyrics`.`trackid` = `tracks`.`id`

тока сделай предварительно дамп БД

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

эта команда стирала всю запись в таблице lyrics в поле lyrics

восстановись из дампа.

я вот какую странную запись нашёл в гугле

вместо

UPDATE `tracks`, `lyrics`, SET 

http://sqlinfo.ru/forum/viewtopic.php?id=3083

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET `lyrics`.`lyrics` = `tracks`.`lyrics` WHERE `lyrics`.`trackid` = `tracks`.`i' at line 1