Tsukuyomi's Profile User Rating: -----

Reputation: -3 Dishonored
Group:
Active Members
Active Posts:
96 (0.07 per day)
Joined:
22-February 11
Profile Views:
2,632
Last Active:
User is offline Nov 24 2014 10:10 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   Tsukuyomi has not set their status

Posts I've Made

  1. In Topic: SQL Create tables Error

    Posted 27 Apr 2014

    I solve it. Thanks everyone for your help :bigsmile:
  2. In Topic: SQL Create tables Error

    Posted 27 Apr 2014

    Thanks. I removed the colon on line 13 but I stay have an error:

    Quote

    mysql> source Tables2.sql
    Database changed
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': VARCHAR(30),
    IncreaseStudyTime VARCHAR(30),
    WorkOnAssignm' at line 11
  3. In Topic: SQL Create tables Error

    Posted 27 Apr 2014

    View Postandrewsw, on 27 April 2014 - 06:09 AM, said:

    That error is exactly the same so I suspect that you are still running the previous version of the statement.

    Thanks I fixed that. I have an error for one of my other tables. Here is the code:

    use myDatabase;
    
    CREATE TABLE Page2(
    UnderstandingConcepts									VARCHAR(30),
    FailureToTakeTests										VARCHAR(30),
    ListeningProblems										VARCHAR(30),
    FailureToTurnInAssignment								VARCHAR(30),
    InadequateStudyHabit									VARCHAR(30),
    WritingSkills											VARCHAR(30),
    PoorPerformanceOnAssignment								VARCHAR(30),
    ExcessiveAbsences										VARCHAR(30),
    LowTestScores											VARCHAR(30),
    Other:													VARCHAR(30),
    IncreaseStudyTime										VARCHAR(30),
    WorkOnAssignments										VARCHAR(30),
    HelpWithAssignment										VARCHAR(30),
    HelpWithSubjectMatterComprehensionUnderstanding			VARCHAR(50)
    );
    
    



    HERE IS THE ERRORS:

    mysql> source Tables2.sql;
    Database changed
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': VARCHAR(30),
    IncreaseStudyTime VARCHAR(30),
    WorkOnAssignm' at line 11
  4. In Topic: SQL Create tables Error

    Posted 27 Apr 2014

    View Postandrewsw, on 27 April 2014 - 05:51 AM, said:

    You have an extra comma on line 10.


    Do you mean I have to take off the last comma. Like this:

    use myDatabase; 
    
    CREATE TABLE Page3(
    TeachingAndLearningCenter								VARCHAR(30),
    ConferenceWithInstructor								VARCHAR(30),
    ProblemSolvingSkills									VARCHAR(30),
    ConferenceWithCounselor									VARCHAR(30),
    ReadingSkills											VARCHAR(30),
    WritingSkills											VARCHAR(30),
    ComputationSkills										VARCHAR(30)
    );
    
    


    I did the above but I got this error:

    mysql> source Tables3.sql;
    Database changed
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 9
  5. In Topic: How do you calculate this?

    Posted 3 Mar 2014

    View Postmodi123_1, on 03 March 2014 - 04:04 PM, said:

    Okay - would you elaborate on what is going on? Is it crashing? If so where? What's the error message? Is it not returning the values as expected? If so what are you inputting, what is it outputting, and what should it be returning?

    Remember - we are not there so just throwing out some code and a copy of a problem text doesn't go too far in helping to find out what your specific question/need is.
    e

    I'm trying to find out if my code is the correct way to solve the above statements.

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

Comments

Tsukuyomi has no profile comments yet. Why not say hello?