mysql - Spring Hibernate MySQL，MySQLSyntaxErrorException : table does not exist-6ren

mysql - Spring Hibernate MySQL，MySQLSyntaxErrorException : table does not exist

转载作者：行者123 更新时间：2023-11-29 23:07:43

在这里，我发布了过去一周我一直在处理的异常情况。

                     HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement


            type Exception report

            message Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement

            description The server encountered an internal error that prevented it from fulfilling this request.

            exception 
            org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
                org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
                org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
                org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:722)



            root cause 
            org.hibernate.exception.SQLGrammarException: could not execute statement
                org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
                org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
                org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
                org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
                org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:190)
                org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
                org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
                org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
                org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
                org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
                org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:490)
                org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:195)
                org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:179)
                org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:214)
                org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:324)
                org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)
                org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:194)
                org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
                org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
                org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
                org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
                org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
                org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
                com.project.pms.service.LoginService.createUser(LoginService.java:65)
                com.project.pms.controller.LoginController.createUser(LoginController.java:56)
                sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                java.lang.reflect.Method.invoke(Method.java:597)
                org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
                org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
                org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
                org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
                org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
                org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
                org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
                org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
                org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
                org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
                org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:722)



            root cause 
            com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'pms.itemmodel' doesn't exist
                sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
                sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                java.lang.reflect.Constructor.newInstance(Constructor.java:513)
                com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
                com.mysql.jdbc.Util.getInstance(Util.java:360)
                com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
                com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
                com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
                com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
                com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
                com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
                com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
                com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
                com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
                com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
                org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
                org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
                org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
                org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
                org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
                org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
                org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:490)
                org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:195)
                org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:179)
                org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:214)
                org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:324)
                org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)
                org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:194)
                org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
                org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
                org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
                org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
                org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
                org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
                org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
                com.project.pms.service.LoginService.createUser(LoginService.java:65)
                com.project.pms.controller.LoginController.createUser(LoginController.java:56)
                sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                java.lang.reflect.Method.invoke(Method.java:597)
                org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
                org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
                org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
                org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
                org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
                org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
                org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
                org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
                org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
                org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
                org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
                javax.servlet.http.HttpServlet.service(HttpServlet.java:722)



            note The full stack trace of the root cause is available in the Apache Tomcat/7.0.32 logs.

pom.xml(只是为了让您了解我正在使用的版本)

    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>com.project.pms</groupId>
      <artifactId>pms</artifactId>
      <packaging>war</packaging>
      <version>0.0.1-SNAPSHOT</version>
      <name>pms Maven Webapp</name>
      <url>http://maven.apache.org</url>
      <dependencies>
      <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>3.0.1</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>
        <!--SPRING FRAMEWORK DEPENDANCIES 
         -->
     <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>4.0.3.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>4.0.5.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>4.3.5.Final</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>4.0.3.RELEASE</version>
    </dependency>


    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.34</version>
    </dependency>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>



      </dependencies>
      <build>
        <finalName>pms</finalName>
      </build>
    </project>

web.xml

    <!DOCTYPE web-app PUBLIC
     "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
     "http://java.sun.com/dtd/web-app_2_3.dtd" >

    <web-app>
      <display-name>PMS</display-name>
      <welcome-file-list>
      <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>

      <servlet>
      <servlet-name>springmvc</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet
      </servlet-class>
      <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
      <servlet-name>springmvc</servlet-name>
      <url-pattern>*.do</url-pattern>
      </servlet-mapping>
    </web-app>

调度程序 Servlet

    <?xml version="1.0" encoding="UTF-8"?>
    <beans  xmlns="http://www.springframework.org/schema/beans"
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
            xmlns:mvc="http://www.springframework.org/schema/mvc"
            xmlns:context="http://www.springframework.org/schema/context"
            xsi:schemaLocation="http://www.springframework.org/schema/beans
             http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
             http://www.springframework.org/schema/mvc
             http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
             http://www.springframework.org/schema/context
             http://www.springframework.org/schema/context/spring-context-3.2.xsd">

            <mvc:annotation-driven></mvc:annotation-driven>
            <context:component-scan base-package="com.project.pms"></context:component-scan>

            <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <property name="prefix" value="/WEB-INF/jsp/"></property>
            <property name="suffix" value=".jsp"></property>
            </bean>

            <bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
            <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://localhost:3306/pms"></property>
            <property name="username" value="root"></property>
            <property name="password" value="root"></property>
            </bean>

            <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="myDataSource"></property>
            <property name="packagesToScan" value="com.project.pms"></property>
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                    <prop key="hibernate.hbm2ddl.auto">create</prop>
                    <prop key="hibernate.show_sql">true</prop>
                </props>
            </property>
            </bean> 


            <import resource="codeSpecificBeans.xml"/>


    </beans>

调度程序 servlet 中导入的资源 (codeSpecificBeans.xml)

    <beans  xmlns="http://www.springframework.org/schema/beans"
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
            xmlns:mvc="http://www.springframework.org/schema/mvc"
            xmlns:context="http://www.springframework.org/schema/context"
            xsi:schemaLocation="http://www.springframework.org/schema/beans
             http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
             http://www.springframework.org/schema/mvc
             http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
             http://www.springframework.org/schema/context
             http://www.springframework.org/schema/context/spring-context-3.2.xsd">



    <bean id="loginService"  class="com.project.pms.service.LoginService">
    </bean>


    <bean id="itemService"  class="com.project.pms.service.ItemService">
    </bean>




    </beans>

项目模型

    package com.project.pms.model;

    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.GenerationType;
    import javax.persistence.Id;


    @Entity
    public class ItemModel
    {


        @Id
        @GeneratedValue(strategy=GenerationType.IDENTITY)
        private String itemId;
        private String itemName;
        private String itemType;
        private String itemSubType;
        private String itemDescription;
        private String itemImageUrl;
        private String itemPrice;
        private String itemVolumePerUnit;
        private String itemCompanyName;



        private String currentItemQtyInStock;
        private String itemUnitsOfMeasurement;// ex % , KG ,
                    //..... and so on with getters and setters 
        }

            package com.project.pms.controller;

            import javax.servlet.http.HttpServletRequest;

            import org.hibernate.SessionFactory;
            import org.springframework.beans.factory.annotation.Autowired;
            import org.springframework.stereotype.Controller;
            import org.springframework.ui.ModelMap;
            import org.springframework.web.bind.annotation.ModelAttribute;
            import org.springframework.web.bind.annotation.RequestMapping;

            import com.project.pms.beans.ItemBean;
            import com.project.pms.beans.UserBean;
            import com.project.pms.service.LoginService;
            import com.project.pms.utils.DatabaseQueries;



            @Controller
            public class LoginController
            {


                @Autowired
                LoginService loginService;

                @Autowired
                SessionFactory sessionFactory;


                @ModelAttribute("userbean")
                public UserBean getUserBean(){
                    return new UserBean();
                }
                @ModelAttribute("itemBean")
                public ItemBean getItemBean(){
                    return new ItemBean();
                }

                @RequestMapping(value="/login")
                public String loadLogin()
                {
            //      DatabaseQueries.populateDataBaseAtStartup(sessionFactory);
                    return "login/Login";
                }

                @RequestMapping(value="/signup")
                public String loadSignUp()
                {
                    return "login/SignUp";
                }

                @RequestMapping(value="/createUser")
                public String createUser(@ModelAttribute("userbean") UserBean userBean, HttpServletRequest request)
                {
                    boolean createUserSuccessful=loginService.createUser(userBean);
                    if(createUserSuccessful)
                    {return "login/Login";
                    }
                    else 
                    {
                        request.setAttribute("createUserSuccessful", createUserSuccessful);
                        return "login/SignUp";
                    }
                }

                @RequestMapping(value="/authenticate")
                public String authenticateLogin(@ModelAttribute("userbean") UserBean userBean, HttpServletRequest request,ModelMap model)
                {
                    System.out.println("Authenticating");
                    boolean authenticateLogin=loginService.retrieveAuthenticationDetails(userBean);
                    if(authenticateLogin)
                    {
                    request.getSession().setAttribute("username", userBean.getUsername());  
                    model.addAttribute("userbean",userBean);

                    return "items/AllItems";
                    }
                    else
                    request.setAttribute("authenticationFailed", true); 
                    return "login/Login";   

                }


            }

LoginService - 仅 createUser() 方法

  public boolean createUser(UserBean userBean)
                {

                userModel=UserHelper.convertBeanToModel(userBean);  
                ItemModel itemModel= new ItemModel();
                itemModel.setItemName("Q");
                itemModel.setItemType("Q");
                itemModel.setItemSubType("Q");
                itemModel.setItemDescription("Q");
                itemModel.setItemCompanyName("Q");
                try{

                Session session=getSession();
                session.beginTransaction();

                session.save(itemModel);
                session.save(userModel);

                session.getTransaction().commit();
                session.close();
                }
                catch(ConstraintViolationException e)
                {

                    return false;
                }

                    return true;
                }

除此之外，您可能想知道的一些事情是:
1)我使用的是MySQL版本5.2.37。

2)如果我仅坚持 userModel ，应用程序运行绝对正常，但是对于 ItemModel ，似乎存在一些我无法理解的问题()

3)userModel和itemModel之间没有很大的区别，只是itemModel中有一个生成策略

我尝试过的策略包括将 hbm2ddl.auto 更改为“create-drop”，将 Dialect 更改为 MySQL5InnoDb，我希望这不是 MYSQL 缺陷，以及我的一些错误。请帮助我解决这个问题，(如果这个问题不得到解决，我可能会死，严肃的事情。)

最佳答案

 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'pms.itemmodel' doesn't exist

异常表明不存在名为“pms.itemmodel”的表。

我注意到的几件事如下:

以下是您的类声明。您已在包“com.project.pms.model”中定义了 ItemModel

package com.project.pms.model;

@Entity
public class ItemModel
{

但是在packagesToScan中您已定义为

<property name="packagesToScan" value="com.project.pms"></property>

“packagesToScan”不会在子包(com.project.pms.model)中查找，而只会在指定的包(“com.project.pms”)中查找。

http://forum.spring.io/forum/spring-projects/data/68231-annotationsessionfactorybean-packagestoscan-scanning-of-sub-packages

此外，您的实体类没有 @Table(name="some-name") 注释。这意味着您的非限定类名“ItemModel”和表名称相同。如果不同，则包含 @Table 注释并指定正确的表名称。

关于mysql - Spring Hibernate MySQL，MySQLSyntaxErrorException : table does not exist，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/28222362/

文章推荐： javascript - 是否可以在我的服务器上为我的网站禁用 JS

文章推荐： javascript - 使用 Qr 图像的学生考勤系统包含学生 ID

文章推荐： mysql - Thinking Sphinx - 搜索博客文章的标题、内容和标签

文章推荐： javascript - 对嵌套对象排序

MYSQL IF NOT EXISTS/WHERE NOT EXISTS 错误
我在 SQL 查询中使用了一个简单的 IF NOT EXISTS/WHERE NOT EXISTS 语句(我都尝试过)，但我总是收到 mysql 错误，不知道为什么。尝试使用不同的引号，检查我的 My
MySQL - 来自同一表的 NOT EXISTS/EXISTS 值更快
我有 2 个表:tbl1 和 tbl2。我想从 tbl1 返回一行，其中包含以下列:col1、col2、col3、can_be_deleted 、有重要项目。这个想法是，can_be_deleted
sql - 喜欢你的用户 (EXISTS) 但你没有与之聊天 (NOT EXISTS)
如果您是 "t1".persona_1_id = 2，则预期结果应返回 persona_id = 4。 like --- id persona_1_id persona_2_id liked 1 2
SQL - 如何在幂等插入示例中使用连接而不是 EXISTS 和 NOT EXISTS
我遇到了这个用于执行幂等插入的 github SQL 代码示例。完全按照我想要的方式工作。我不想使用 EXISTS，因为我觉得它有点困惑。可以使用联接对相同的操作进行编码吗？下面是我在 github
c# - 检查表是否存在 : Table doesn't exist while it exists
public bool CheckTblExist(string TblName) { try { string cmTxt = "s
sql-server - 如何在一个查询中使用 EXISTS 和 NOT EXISTS？
表1 Id Name DemoID 1 a 33 2 b 44 3 c 33 4 d 33 5 e 44 表2 Id DemoID IsT
sql - SQL中 "IF EXISTS"和 "IF NOT EXISTS"之间的区别？
我对 SQL 非常陌生。我想知道当我使用“IF EXISTS”或“IF NOT EXISTS”时会发生什么。例如:以下两个语句有什么区别: 语句 1:(存在) IF EXISTS( SELECT OR
exist-db - 如何为 exist-db 中的属性创建索引
我正在更新 exist-db 集合中的 XML 文件，我必须检查是否存在 id 以决定是否必须在我的文档中替换或插入某些内容。我注意到随着文件的增长，查询执行时间显着恶化，我决定为我的文件添加一个索
javascript - postgreSQL 错误 : "constraint does not exist" (but it does exist. ..)
我有一个正在尝试更新的数据库，但我不明白为什么会收到有关不存在的列的奇怪错误。当我使用“heroku pg:psql”访问数据库时，我完全可以看到该列。我找到了couple其他questions遇到类
mysql - SELECT EXISTS 和 EXISTS 之间的区别
我有一个这样的查询 SELECT ... FROM ... WHERE (SELECT EXISTS (SELECT...)) which did not return anything th
php - SQL : INSERT if no exist and UPDATE if exist
我有一个可以对数据库执行插入和更新的程序，我从 API 获取数据。这是我得到的示例数据: $uname = $get['userName']; $oname = $get['offerNa
Windows 批处理 : "if exist" -- path exists but it says no -- why?
我的批处理文件中有这个脚本 -- if not exist "%JAVA_HOME%" ( echo JAVA_HOME '%JAVA_HOME%' path doesn't exist) -
c# - 区分大小写 Directory.Exists/File.Exists
有没有办法让 Directory.Exists/File.Existssince 区分大小写 Directory.Exists(folderPath) 和 Directory.Exists(folde
mysql - SQL - EXISTS 和 NOT EXISTS 不等式
考虑使用这两个表和以下查询: SELECT Product. * FROM Product WHERE EXISTS ( SELECT * FROM Codes
eclipse - 在子剪辑 : How do I connect an existing workspace with an existing repository
我正在使用 Subclipse 1.6.18 使用 Eclipse 3.72 (Indigo) 来处理 SVN 1.6 存储库。这一切都在 Ubuntu 下运行。我有一个项目，在我更新我的 Ecli
Azure存储: Error checking for existence of existing Storage Share
我正在尝试使用 Terraform 配置 Azure 存储帐户和文件共享: resource "random_pet" "prefix" {} provider "azurerm" { versi
sql - 编写带有 NOT EXISTS 子句的查询，但不包含 NOT EXISTS 的子查询
我有兴趣为需要使用 NOT EXISTS 的应用程序编写查询。子句来检查一行是否存在。我正在使用 Sybase，但我想知道一般 SQL 中是否有一个示例，您可以在其中编写具有 NOT EXISTS
Azure存储: Error checking for existence of existing Storage Share
我正在尝试使用 Terraform 配置 Azure 存储帐户和文件共享: resource "random_pet" "prefix" {} provider "azurerm" { versi
sql - EXISTS 与 JOIN 以及 EXISTS 子句的使用
下面是代码示例: CREATE TABLE #titles( title_id varchar(20), title varchar(80)
sql - 使用 Exists 1 或 Exists * 的子查询
我曾经这样编写 EXISTS 检查: IF EXISTS (SELECT * FROM TABLE WHERE Columns=@Filters) BEGIN UPDATE TABLE SET

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

mysql - Spring Hibernate MySQL，MySQLSyntaxErrorException : table does not exist