使用update 报错Truncated incorrect DOUBLE value: ''

ryza93 2018-03-26 05:27:22

求助各位大神帮忙，我的sql语句如下
update main a left join basic b on a.holder_job_code = b.if_id set a.holder_job_code = b.id where a.holder_job_code != '0'
执行后报错Truncated incorrect DOUBLE value:

a.holder_job_code 为 varchar(100)
b.id 为char(10)

到底是什么问题啊？？

...全文

832 4 打赏收藏转发到动态举报

写回复

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

zjcxc 2018-03-28

打赏
举报

回复

b.if_id 是什么类型，看错误信息，应该是这个的长度超过 a.holder_job_code 了吧

ryza93 2018-03-26

打赏
举报

回复

求助求助，各位大神

ryza93 2018-03-26

打赏
举报

回复

引用 1 楼 rucypli 的回复:

没毛病啊命令行试下呢

试过了，还是报这个错

rucypli 2018-03-26

打赏
举报

回复

没毛病啊命令行试下呢

发现问题图片地址如下 http://huoche.7234.cn/images/jb51/be3bsozsbye.jpeg 需要实现的效果是要加上尺寸，如以下效果 http://huoche.7234.cn/images/jb51/be3bsozsbye.jpeg|1200*675 一开始想当然使用 UPDATE tag_group SET cover = cover + '|1200*675' WHERE id = 1; 结果报错 Data truncation: Truncated incorrect DOUBLE value: ‘http://huoche.7234.cn/im

本文实例讲述了mysql基于正则实现模糊替换字符串的方法。分享给大家供大家参考，具体如下：例如: abcd(efg)hijk 替换之后是abcdhijk 代码如下:update tabaleA set name = replace(name, substring(name, locate(‘’, name),locate(‘’, name)-locate(‘’+10, name)),”); 执行之后，报错：Truncated incorrect DOUBLE value 解决办法，经过查询发现是concat(Str,'')函数错误问题

Delphi 7.1 Update Release Notes=======================================================This file contains important supplemental and late-breakinginformation that may not appear in the main productdocumentation, and supersedes information contained in otherdocuments, including previously installed release notes.Borland recommends that you read this file in its entirety.NOTE: If you are updating a localized version of Delphi 7, visit the Borland Registered User web site to obtain a localized readme file that may contain important late- breaking information not included in this readme file.IMPORTANT: Delphi must be closed before installing this update. =====================================================CONTENTS * INSTALLING THIS UPDATE * UPDATING LOCALIZED VERSIONS OF DELPHI 7 * KNOWN ISSUES * ISSUES ADDRESSED BY THIS UPDATE - IDE - CORE DATABASE - DATASNAP - DBGO (ADO COMPONENTS) - dbExpress - dbExpress COMPONENTS AND DB VCL - dbExpress CORE DRIVER AND METADATA - dbExpress VENDOR ISSUES - dbExpress CERTIFICATION - WEB SNAP - ACTIVEX - COMPILER - RTL - VCL - THIRD PARTY - BOLD FOR DELPHI * VERIFYING THAT THE UPDATE WAS SUCCESSFUL * FILES INSTALLED BY THIS UPDATE =======================================================INSTALLING THIS UPDATE* This update can not be applied to Delphi 7 Architect Trial version. * This update can not be removed after it is installed.* You will need the original Delphi 7 installation CD available to install this update.* To install this update from the CD, insert the CD, and launch the d7_ent_upd1.exe file appropriate for your locale.* To install this update from the Web, double-click the self-executing installation file and follow the prompts. * The Delphi 7 documentation PDF files are available on the update CD.========================================================UPDATING LOCALIZED VERSIONS OF DELPHI 7* This update can be applied only to the English version of Delphi 7. There are separate updates for the German, French and Japanese ver

OutlookAttachView v2.73 Copyright (c) 2009 - 2014 Nir Sofer Web site: http://www.nirsoft.net Related Utilities ================= * NK2Edit - Edit, merge and fix the AutoComplete files (.NK2) of Microsoft Outlook. Description =========== OutlookAttachView scans all messages stored in your Outlook, and displays the list of all attached files that it finds. You can easily select one or more attachments and save all of them into the desired folder, as well as you can delete unwanted large attachments that take too much disk space in your mailbox. You can also save the list of attachments into xml/html/text/csv file. System Requirements =================== * Windows 2000/XP/Vista/7/8/2003/2008. * Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Outlook 2010, or Microsoft Outlook 2013. For the 64-bit version of Outlook 2010/2013, you should use the x64 version of OutlookAttachView. Be aware that OutlookAttachView doesn't work with Outlook Express. Versions History ================ * Version 2.73 o OutlookAttachView now also scans the root folder of the .pst file. * Version 2.72 o Added %from_email% and %to_email% variables to the attachment filename format. * Version 2.71 o Added %localmsgtime% and %localmsgdate% variables to the attachment filename format. o Fixed a crash problem occurred on some systems after version 2.70 update. * Version 2.70 o Fixed to display date/time values according to daylight saving time settings. * Version 2.69 o Fixed bug: OutlookAttachView crashed on some systems. * Version 2.68 o Added secondary sorting support: You can now get a secondary sorting, by holding down the shift key while clicking the column header. Be aware that you only have to hold down the shift key when clicking the second/third/fourth column. To sort the first column you should not hold down the Shift key. * Version 2.67 o Fixed bug: when turning on the 'Image Preview' option, OutlookAttachView displayed empty image or incorrect image. * Version 2.66 o Added more accelerator keys (in the menus). * Version 2.65 o Added 'Image Preview' option (Under the View menu). If you turn on this option, a preview of selected gif/png/jpg file will be displayed in the lower pane. Be aware that this feature is quite slow... * Version 2.63 o The number of attachments is now displayed in the status bar while scanning the mailbox of Outlook. * Version 2.62 o Added 'Recent Config Files' menu, which allows you to easily open the last 10 configuration files that you used. * Version 2.61 o Added GB and Automatic to the 'File Size Unit' option. * Version 2.60 o Added option to save and load the entire configuration of OutlookAttachView ('Save Configuration' and 'Load Configuration' under the File menu). * Version 2.56 o OutlookAttachView now remembers the last size and position of the 'Copy Selected Files To...' window. * Version 2.55 o You can now specify wildcards (For example: nir*.doc, abc???.txt) in the include/exclude filename option. * Version 2.51 o Added option to choose the file size display unit: Bytes, KB, or MB. * Version 2.50 o OutlookAttachView now remembers that last 20 strings you typed in the Extensions List, Excluded Extensions List, Subject contains string..., From string, and To string, and you can easily select a string again from a Combo-Box. * Version 2.47 o Added option to choose another font (font name and size) to display the attachments list. (Options -> Select Another Font) * Version 2.46 o Fixed the flickering occurred while scrolling the attachments list. * Version 2.45 o You can now resize the scan options dialog-box. Also, the last size and position of this dialog-box is saved to the config file. * Version 2.43 o Added %attach_id% variable to the attachment filename format. * Version 2.42 o Added option to change the maximum number of characters in every variable of formatted filename. (The default is 64 characters) * Version 2.41 o Added option to filter by the message direction (incoming or outgoing) in the Scan Options window. * Version 2.40 o Added %message_direction% and %message_entryid% variables to the attachment filename format. * Version 2.38 o The 'Show Inline Attachments' option is now turned on by default (In previous versions it was turned off). The reason for this changed: I found out that many users think that there is a bug in OutlookAttachView because they can't find some of the attachments, without understanding that they have to turn on the 'Show Inline Attachments' option. * Version 2.37 o Fixed issue: The properties and the options windows opened in the wrong monitor, on multi-monitors system. * Version 2.36 o Added 'Auto Size Columns+Headers' option, which allows you to automatically resize the columns according to the row values and column headers. * Version 2.35 o Added 'Message EntryID' column, which displays the ID string of the Outlook message. * Version 2.32 o Added %domain% variable to the attachment filename format. * Version 2.31 o Added /SaveDirect command line option, for using with the other save command-line options (/scomma, /stab, /sxml, and so on...) When you use the SaveDirect mode, the attachments list is saved directly to the disk, without loading them into the memory first. This means that you can save a list with large amount of attachment lines into your disk without any memory problem, as long as you have enough disk space to store the saved file. The drawback of this mode: You cannot sort the attachments according to the column you choose with /sort command-line option. * Version 2.30 o Added 'Domain' column, which displays the domain of the from/to email address. * Version 2.25 o Added 'Message Direction' column (Incoming or Outgoing). * Version 2.20 o Added 'From Email' and 'To Email' columns, which displays the From/To email addresses. (The existing To/From columns shows the 'Display Name') * Version 2.15 o Added 'Put Icon On Tray' option. * Version 2.11 o When trying to connect to Outlook 2010 with the wrong build of OutlookAttachView (OutlookAttachView 32-bit with Outlook x64 or OutlookAttachView x64 with Outlook 32-bit), OutlookAttachView now displays informative error message about the problem. * Version 2.10 o Changed the user interface of the Main Scan Options window, to make it useable for lower screen resolutions and to give more space to the folders/subjects/from/to include/exclude lists. * Version 2.05 o Added 'Skip Exchange public folders' option. * Version 2.00 o Added command-line options to change any configuration value. * Version 1.95 o Added /extractall command-line option, which allows you to extract all Outlook attachments from command-line, according to your saved settings. * Version 1.90 o Added option to scan only emails in the last xx days (alternative to the date/time range). * Version 1.85 o Added option to scan only emails with the specified 'From' and 'To' strings. * Version 1.82 o When adding a folder to scan (with the Add button), the folder path in now delimited with quotes, to ensure that it'll be scanned properly if the folder name contains a comma character. * Version 1.81 o Fixed a crash problem when trying to save outlook attachment. * Version 1.80 o Added 'Add' buttons, which allows you to easily add folders to scan or skip by choosing them from the list of Outlook folders. * Version 1.75 o Added the ability to choose the desired Outlook profile inside the 'Mailbox Scan Options' window. * Version 1.72 o You can now specify a folder with all its subfolders (to include or to skip) by adding * character to the folder string, for example: Personal Folders\Inbox* * Version 1.71 o Fixed OutlookAttachView to be able to scan the public folders of Exchange server. * Version 1.70 o Added option to specify a custom date/time format for the filename in the 'Copy Selected Files To...' option, for example: %msgdate:yyyyMMdd% , %msgtime:HHmmss% * Version 1.67 o OutlookAttachView now displays (in the status bar) the current copied filename while copying the attachments. It also allows you to stop the copying process by clicking the stop menu. * Version 1.66 o In the 'Copy Selected Files To...' window, you can now specify a subfolder in the attach filename format. For example, if the filename format is %folder_name%\%subject%_%attach_name%.%extension% - All attachments from the inbox will be saved under the Inbox subfolder, All attachments from Sent Items will be saved under the Sent Items subfolder, and so on... o You can also choose the 'Create subfolders automatically' option if you want that OutlookAttachView will automatically create the subfolders for you. * Version 1.65 o Added time fields for the scanning date range. o The date range is now saved in the .cfg file. * Version 1.63 o Added 2 actions to 'Double-Click Action': 'Open Selected Attachment With' and 'Copy Selected Attachment To' * Version 1.62 o Fixed bug: OutlookAttachView crashed when trying to extract a special type of attachment. * Version 1.61 o Added 'Mark Inline Attachments' option. When it's turned on, inline attachments are marked with blue background color. * Version 1.60 o Added /start command-line option, which instructs OutlookAttachView to start the mailbox scan immediately with the loaded configuraion, without displaying the Scan Options dialog-box. o Decreased the memory consumption when the list of found attachments is very large. * Version 1.57 o Added new option to specify the list of folders that you wish to skip (comma-delimited list). * Version 1.56 o Added 'Mark Odd/Even Rows' option, under the View menu. When it's turned on, the odd and even rows are displayed in different color, to make it easier to read a single line. * Version 1.55 o Added new option to specify the list of folders that you wish to scan (comma-delimited list), instead of scanning the entire mailbox. * Version 1.51 o Added 'Open Selected Attachment With...' option, which allows you to quickly view the content of the attachment with another application, instead of the default one. * Version 1.50 o Added 'Open Selected Attachment' option (F7), which allows you to quickly view the content of the attachment, without the need to extract the file and then open it from Explorer. Be aware that when you use this option, OutlookAttachView extracts the attachment into a temporary folder, and then opens it with the default application, according to the file extension. When you close OutlookAttachView, all temporary attachment files are automatically deleted. o Added to option to choose what to do when you double-click on a single attachment: Open Properties Window, Open Outlook Message, or Open Attachment File. * Version 1.47 o The status bar now displays the total size of selected attachments in KB/MB. * Version 1.46 o You can now send the attachments list to stdout by specifying an empty filename ("") in the command-line. (For example: OutlookAttachView.exe /stab "" > c:\temp\att.txt) * Version 1.45 o Add new filter: Scan only emails that their subject contains the specified string. * Version 1.41 o Added option to exclude one or more file extensions from the attachments list (in comma-delimited list). * Version 1.40 o Added Extension column, so now you can easily sort the list by the file extension of the attachments. o Added option to filter the attachments list by file extension - you can now specify the list of file extensions (in comma-delimited list) that you want to find. All attachments with file extensions that are not in the list won't be displayed. * Version 1.37 o Added /cfg command-line option for loading the configuration from another .cfg file. * Version 1.36 o Added %message_size% and %folder_path% (full folder path) variables to the attachment filename format. * Version 1.35 o Added an option to control the filename format for extracting the attachments. (In the 'Copy Selected Files To...' window) You can include the following fields in the created filename: Subject, From, To, Attachment Name, Folder Name, Message Date, and Message Time. o Added 'Set the modified time of the file to the time of the message' option. When it's turned on, the extracted attachment file will get the same modified time of the message that contains the attachment. * Version 1.30 o Added 'Email Software' column, which displays the email software that was used to send the message. The value is taken from x-mailer header line. This column is only relevant for received messages (Inbox). o Added 'Computer Address' column, which displays the computer name or IP addresses that sent the message. This column is only relevant for received messages (Inbox). * Version 1.25 o Added a new option to 'Mailbox Scan Options', which allows you to scan another profile of Outlook, instead of the default one. o Added 'Add Header Line To CSV/Tab-Delimited File' option. When this option is turned on, the column names are added as the first line when you export to csv or tab-delimited file. * Version 1.21 o Added support for embedded message attachments (attachments of another message). These attachments are saved as .msg files. * Version 1.20 o Added option to filter by attachment size. o Fixed issue: removed the wrong encoding from the xml string, which caused problems to some xml viewers. * Version 1.15 o Added 'MailBox Scan Options' window, which allows you to choose the dates range to scan. o Fixed bug: The 'Created On' column displayed wrong dates in some Outlook configurations. * Version 1.13 o Added 'Copy Selected Attachments To...' into the right-click context menu. Also, changed the 'Save Selected Items' to 'Export Attachments Information', to avoid the confusion between saving the attachment files and exporting the attachments details. o Added separated x64 version - for using only with x64 version of Outlook 2010. * Version 1.12 o Fixed a crash problem when using this utility with IMAP accounts. * Version 1.11 o Added sorting command-line options. * Version 1.10 o Added 'Open Message In Outlook' option. * Version 1.06 o Added 'Clean Selected Attachments' option - clean the content of attachment, but without removing the attachment entry. * Version 1.05 o Fixed bug: OutlookAttachView failed to scan sub-folders under main Outlook folders. o Added 'Folder Path' column. * Version 1.00 - First release. Using OutlookAttachView ======================= OutlookAttachView doesn't require any installation process or additional dll files. In order to start using it, simply run the executable file - OutlookAttachView.exe If you have only one profile in your Outlook, and this profile doesn't require any password, you can run OutlookAttachView even without starting Outlook, and it'll automatically scan the mailbox of your current Outlook profile. Otherwise, it's recommended to open Outlook in the right profile before starting OutlookAttachView. After running OutlookAttachView, the 'MailBox Scan Options' window will be displayed. This window allows to choose to scan your mailbox only in specific dates range. After choosing 'Ok' in the options window, OutlookAttachView starts to scan your Outlook messages and display the found attachments in the main window of OutlookAttachView. If you want to stop the scan process, simply choose the 'Stop' menu. After the scanning process is finished, you can select one or more of your attached files, and copy them into the desired folder, by using the 'Copy Selected Files To' option. If have large attachments that you want to delete, you can use the 'Delete Selected Attachments' option. Be aware that when you use the delete option, only the attachment file is deleted. The message itself remains on your mailbox. You can also use the 'Clean Selected Attachments' option to clean most of the attachment content, but without removing the attachment entry. If you use this option, you'll still see the attachment listed in your email message with small file size, but saving this attachment to a file will create a corrupted file. Inline Attachments ================== Attachments embedded as a part of the message body are detected as 'Inline Attachments'. By default, OutlookAttachView doesn't displays these inline attachments. If you can't find the attachments you're looking for, you should try to turn on the 'Show Inline Attachments' option, located under the Options menu. Control The Filename Format of Extracted Attachment =================================================== When you extract one or more attachments from your Outlook mailbox, you can control the way that the attach filename is generated. By default, OutlookAttachView use the following format: %attach_name%.%extension%, which means that the generated filename will only contain the original attachment name and the file extension. However, you can also use the following special variables to format the filename according to your needs: * %attach_name% - The original name of the attachment. * %extension% - The original file extension of the attachment. * %subject% - The subject of the email contains this attachment. * %folder_name% - The folder name of this email (Inbox, Sent Items, and so on) * %from% - The sender of the email. * %to% - The 'To' field of the email. * %message_date% - Message creation date in yyyymmdd format. * %message_time% - Message creation time in HHmmss format. * %message_size% - Attachment size, in bytes. * %folder_path% - Full folder path of this email. (For example: Personal Folder-Inbox) * %msgdate:[format]% - Message creation date (GMT), in any format you need, for example: %msgdate:yyyyMMdd% , %msgdate:ddMMyy% * %msgtime:[format]% - Message creation time (GMT), in any format you need, for example: %msgtime:HHmmss% * %localmsgdate:[format]% - Message creation date (local time), in any format you need, for example: %localmsgdate:yyyyMMdd% , %localmsgdate:ddMMyy% * %localmsgtime:[format]% - Message creation time (local time), in any format you need, for example: %localmsgtime:HHmmss% For example: If you want to generate the attachment filename with the subject, folder name, and attach name: %folder_name%_%subject%_%attach_name%.%extension% Be aware that some of the values are automatically truncated after 64 characters, in order to avoid from over-sized filenames. Scanning Outlook Attachments of External PST Files ================================================== If you want to search an attachment in one or more PST files that are not loaded in your Outlook profile, you can use the following trick: 1. Go to Control Panel -> Mail and choose 'Show Profiles' 2. Click 'Add' to create a new profile. 3. Fill the email account information with faked details (You can delete it afterwards) 4. After the profile is created, double click on the profile, and in the profile properties, click 'Data Files' and add the desired PST files that you wish to scan. 5. Also, you can click the 'E-mail Accounts' button, and remove the faked account that you previously created. 6. In the Mailbox Scan Options of OutlookAttachView, choose 'Allow me to choose the profile' in the Outlook Profile option. 7. When you are asked to choose the profile, you should choose the profile that you created, and OutlookAttachView will scan the PST files that you added into it. Command-Line Options ==================== /stext Save the list of all Outlook attachments into a regular text file. /stab Save the list of all Outlook attachments into a tab-delimited text file. /scomma Save the list of all Outlook attachments into a comma-delimited text file. /stabular Save the list of all Outlook attachments into a tabular text file. /shtml Save the list of all Outlook attachments into HTML file (Horizontal). /sverhtml Save the list of all Outlook attachments into HTML file (Vertical). /sxml Save the list of all Outlook attachments to XML file. /SaveDirect Save the Outlook attachments in SaveDirect mode. For using with the other save command-line options ( /scomma, /stab, /sxml, and so on...) When you use the SaveDirect mode, the attachments list is saved directly to the disk, without loading them into the memory first. This means that you can save a list with large amount of attachment lines into your disk without any memory problem, as long as you have enough disk space to store the saved file. The drawback of this mode: You cannot sort the attachments according to the column you choose with /sort command-line option. /sort This command-line option can be used with other save options for sorting by the desired column. If you don't specify this option, the list is sorted according to the last sort that you made from the user interface. The parameter can specify the column index (0 for the first column, 1 for the second column, and so on) or the name of the column, like "Filename" and "Subject". You can specify the '~' prefix character (e.g: "~Subject") if you want to sort in descending order. You can put multiple /sort in the command-line if you want to sort by multiple columns. Examples: OutlookAttachView.exe /shtml "f:\temp\attach.html" /sort 2 /sort ~1 OutlookAttachView.exe /shtml "f:\temp\attach.html" /sort "From" /sort "To" /sort "Subject" /nosort When you specify this command-line option, the list will be saved without any sorting. /cfg Starts OutlookAttachView with the specified configuration file instead of the default OutlookAttachView.cfg /start Starts the mailbox scan immediately with the loaded configuraion, without displaying the Scan Options dialog-box. /extractall Extracts all Outlook attachments from command-line, according to your last settings saved in the default .cfg file, or according to other configuration file that you load with /cfg command-line option. You can also use the following command-line options to change any configuarion value you wish: /CopyFilesFolder /NewNameIfExist /UpdateModifiedTimeMessage /FilenameFormat /ScanOptions.TimeZone /ScanOptions.OutlookProfile /ScanOptions.UseExtensionsList /ScanOptions.ExtensionsList /ScanOptions.UseExcludeExtensionsList /ScanOptions.ExcludeExtensionsList /ScanOptions.UseSubjectContains /ScanOptions.SubjectContains /ScanOptions.ScanOnlyFolders /ScanOptions.ScanFoldersList /ScanOptions.SkipFolders /ScanOptions.SkipFoldersList /ScanOptions.DateFrom /ScanOptions.DateTo /ScanOptions.UseDateRange /ScanOptions.OutlookProfileString /ScanOptions.UseFromList /ScanOptions.FromList /ScanOptions.UseToList /ScanOptions.ToList /ScanOptions.UseOnlyLastDays /ScanOptions.OnlyLastDays For example, if you want to extract all attachments into c:\myattach instead of using the folder specified in the config file: OutlookAttachView.exe /CopyFilesFolder "c:\myattach" /extractall Translating OutlookAttachView to other languages ================================================ In order to translate OutlookAttachView to other language, follow the instructions below: 1. Run OutlookAttachView with /savelangfile parameter: OutlookAttachView.exe /savelangfile A file named OutlookAttachView_lng.ini will be created in the folder of OutlookAttachView utility. 2. Open the created language file in Notepad or in any other text editor. 3. Translate all string entries to the desired language. Optionally, you can also add your name and/or a link to your Web site. (TranslatorName and TranslatorURL values) If you add this information, it'll be used in the 'About' window. 4. After you finish the translation, Run OutlookAttachView, and all translated strings will be loaded from the language file. If you want to run OutlookAttachView without the translation, simply rename the language file, or move it to another folder. License ======= This utility is released as freeware. You are allowed to freely distribute this utility via floppy disk, CD-ROM, Internet, or in any other way, as long as you don't charge anything for this. If you distribute this utility, you must include all files in the distribution package, without any modification ! Disclaimer ========== The software is provided "AS IS" without any warranty, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. The author will not be liable for any special, incidental, consequential or indirect damages due to loss of data or any other reason. Feedback ======== If you have any problem, suggestion, comment, or you found a bug in my utility, you can send a message to nirsofer@yahoo.com

当使用update语句时出现Data truncation: Truncated incorrect DOUBLE value:??错误. 把你的sql语句的"and"全部换成"逗号"！例如 update table set A = "a" and B = "b" where id = 1 （报错）改成 update table set A = "a" ， B= "b".........

56,678

社区成员

56,708

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章