如何通过导入.sql文件在xampp中创建表时修复此错误

ohfgkhjo  于 2021-07-24  发布在  Java
关注(0)|答案(1)|浏览(359)

在xampp数据库中导入sql代码文件时出现此错误。错误为:-----数据库: cywsitec_admin

2fjabf4q

2fjabf4q1#

--------表的表结构 admin --创建表 admin ( id int(255)不为空, user varchar(255)不为空, pass varchar(255)不为空,)engine=innodb default charset=latin1

下面是我的代码。请看一下并帮助我。提前谢谢。

  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.7
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: May 25, 2018 at 12:09 PM
  7. -- Server version: 10.1.30-MariaDB
  8. -- PHP Version: 7.2.1
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET AUTOCOMMIT = 0;
  11. START TRANSACTION;
  12. SET time_zone = "+00:00";
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8mb4 */;
  17. --
  18. -- Database: `cywsitec_admin`
  19. --
  20. -- --------------------------------------------------------
  21. --
  22. -- Table structure for table `admin`
  23. --
  24. CREATE TABLE `admin` (
  25. `id` int(255) NOT NULL,
  26. `user` varchar(255) NOT NULL,
  27. `pass` varchar(255) NOT NULL,
  28. )ENGINE=INNODB DEFAULT CHARSET=latin1;
  29. --
  30. -- Dumping data for table `admin`
  31. --
  32. INSERT INTO `admin` (`id`, `user`, `pass`) VALUES
  33. (1, 'admin', 'password');
  34. --
  35. -- Indexes for dumped tables
  36. --
  37. --
  38. -- Indexes for table `admin`
  39. --
  40. ALTER TABLE `admin`
  41. ADD PRIMARY KEY (`id`);
  42. --
  43. -- AUTO_INCREMENT for dumped tables
  44. --
  45. --
  46. -- AUTO_INCREMENT for table `users`
  47. --
  48. ALTER TABLE `admin`
  49. MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
  50. COMMIT;
  51. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  52. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  53. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
展开查看全部

相关问题