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

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -