amazon web services - MySQL Error: 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COL' at line 8 -
i couldn't figure out wrong script table generated working database. using dbschema add table database , connected amazon aws rds instance. following code:
-- mysql dump 10.13 distrib 5.7.17, linux (i686) -- -- host: localhost database: mydb_new -- ------------------------------------------------------ -- server version 5.7.17-0ubuntu0.16.04.1 /*!40101 set @old_character_set_client=@@character_set_client */; /*!40101 set @old_character_set_results=@@character_set_results */; /*!40101 set @old_collation_connection=@@collation_connection */; /*!40101 set names utf8 */; /*!40103 set @old_time_zone=@@time_zone */; /*!40103 set time_zone='+00:00' */; /*!40014 set @old_unique_checks=@@unique_checks, unique_checks=0 */; /*!40014 set @old_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0 */; /*!40101 set @old_sql_mode=@@sql_mode, sql_mode='no_auto_value_on_zero' */; /*!40111 set @old_sql_notes=@@sql_notes, sql_notes=0 */; -- -- table structure table `package` -- drop table if exists `package`; /*!40101 set @saved_cs_client = @@character_set_client */; /*!40101 set character_set_client = utf8 */; create table `package` ( `id` int(11) not null auto_increment, `student_id` int(11) not null, `student_email` varchar(45) not null, `subscription_date` datetime default null, `expiry_date` datetime default null, `is_active` tinyint(1) default null, `package_price` int(11) default null, `stripe_id` varchar(45) default null, `package_type` varchar(45) default null, `subscription_id` varchar(45) default null, primary key (`id`), key `student_package` (`student_id`), constraint `student_package` foreign key (`student_id`) references `student_profile` (`id`) on delete no action on update no action ) engine=innodb auto_increment=124 default charset=latin1; /*!40101 set character_set_client = @saved_cs_client */; -- -- dumping data table `package` -- lock tables `package` write; /*!40000 alter table `package` disable keys */; insert `package` values (105,557,'nosubscription@gmail.com',null,null,1,null,'cus_ajnddjf0pcsnyn','monthly','sub_ajndjrzz3dvkil'),(106,558,'coupon31817@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(107,559,'partnerschool@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(108,560,'best@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(110,562,'mz@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(111,564,'nosubscription2@gmail.com',null,null,1,null,'cus_ajihtv2uq93ekb','monthly','sub_ajii6u6ovtnusr'),(112,565,'partnerschool2@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(113,566,'coupon2@gmail.com',null,null,1,null,'n/a group subscriber','groupsubsciption','n/a group subscriber'),(123,567,'nopackage4@gmail.com',null,null,1,null,null,'groupsubscription',null); /*!40000 alter table `package` enable keys */; unlock tables; /*!40103 set time_zone=@old_time_zone */; /*!40101 set sql_mode=@old_sql_mode */; /*!40014 set foreign_key_checks=@old_foreign_key_checks */; /*!40014 set unique_checks=@old_unique_checks */; /*!40101 set character_set_client=@old_character_set_client */; /*!40101 set character_set_results=@old_character_set_results */; /*!40101 set collation_connection=@old_collation_connection */; /*!40111 set sql_notes=@old_sql_notes */; -- dump completed on 2017-03-27 16:37:38
it says error on following line:
/*!40101 set @old_character_set_results=@@character_set_results */;
Comments
Post a Comment