Mburns1973 Posted December 5, 2017 Share Posted December 5, 2017 Help, OK was able to create my database, all is working fine. When I was trying to INSERT the information is what I need help with. I keep getting a ~> Not sure what to do there??? Thank you Link to comment Share on other sites More sharing options...
Mburns1973 Posted December 5, 2017 Author Share Posted December 5, 2017 I need to update something here. When I try to INSERT the info I get a '> And it won't let me do anything??? Link to comment Share on other sites More sharing options...
Larry Posted December 10, 2017 Share Posted December 10, 2017 You haven't provided much information, but that cursor in the MySQL client indicates you have started a string--you have an opening single quote--and it's waiting for you to complete the string. Link to comment Share on other sites More sharing options...
Mburns1973 Posted December 11, 2017 Author Share Posted December 11, 2017 Larry, Sorry for the lack of information. I'm new to this. But thank you for the feed back. That is what I get when I write this code. INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES ('Mike','Burns','email@wow.com','SHA1('mypass'), NOW()); '> This is what happens??? Thank you Mike Link to comment Share on other sites More sharing options...
Larry Posted December 11, 2017 Share Posted December 11, 2017 In what interface are you seeing this? When running a script or when using the command-line MySQL client or...? Link to comment Share on other sites More sharing options...
Mburns1973 Posted December 12, 2017 Author Share Posted December 12, 2017 I'm seeing this in MySql console. My php version is 5,7,14. Thank you Link to comment Share on other sites More sharing options...
abigail Posted December 12, 2017 Share Posted December 12, 2017 'SHA1('mypass') You have an extra single quote at the start of this snippet. Link to comment Share on other sites More sharing options...
Mburns1973 Posted December 12, 2017 Author Share Posted December 12, 2017 Abigail, That did something on the right path. I'm past that thank you. Now it's saying "Column count doesn't match value count at row 1" ??? Thank you Link to comment Share on other sites More sharing options...
Mburns1973 Posted December 13, 2017 Author Share Posted December 13, 2017 I got it!!! Thank you Larry and Abigail !!! Link to comment Share on other sites More sharing options...
Larry Posted December 13, 2017 Share Posted December 13, 2017 Excellent. Thanks, Abigail!!!! Link to comment Share on other sites More sharing options...
Recommended Posts