insert into ParaResult([ID],[NetbarIP],[Confirtime],[dirdata],[score],[Optime])values('0','192.168.1.166','//cux2/p/au3+0/7N3+5X/tV/9y7Hb+n9q7f7T/s3f7lf+1X/ANy7Hb+n9q7f7T/s3L+luQ/45f8A3Lcdv9s+1dv9p/2bIf3X/Lx/x0/+LPs/95X/AIfMJfV/t31f0Pq/4n/pW//Z','0',getdate())dirdata,Confirtime的值均为图片转换过来的,到现在还没有查出是什么错,还是报缺少 SELECT 关键字望指教啊??
insert into ParaResult([WATCHID],[NetbarIP],[CARDPHOTO],[CARDPICTURE],[SCORE],[Optime])values('0','192.168.1.166','//cux2/p/au3+0/7N3+5X/tV/9y7Hb+n9q7f7T/s3f7lf+1X/ANy7Hb+n9q7f7T/s3L+luQ/45f8A3Lcdv9s+1dv9p/2bIf3X/Lx/x0/+LPs/95X/AIfMJfV/t31f0Pq/4n/pW//Z','0',getdate())
insert into ParaResult([WATCHID],[NetbarIP],[CARDPICTURE],[CARDPHOTO],[SCORE]) values('0','192.168.1.166','/9j/4AAQSkZJRgABAgEASABIAAD/4QTdRXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAABAAAAYgEbAAUAAAABAAAAagEoAAM', '/9j/4AAQSkZJRgABAgEASABIAAD/4QTdRXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAABAAAAYgEbAAUAAAABAAAAagEoAAM','0') 这下清楚了吧,不过还是那个错误啊?缺少 SELECT 关键字
'/9j/4AAQSkZJRgABAgEASABIAAD/4QTdRXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAABAAAAYgEbAAUAAAABAAAAagEoAAM','0')
这下清楚了吧,不过还是那个错误啊?缺少 SELECT 关键字
參考
你試試varchar()吧
这中语法在oracle中不好用