Updating table in mysql

Thanks CREATE TABLE sample.taceledger ( `runno` INT(10) unsigned not null default '0', `doc_no` DECIMAL(6,0) unsigned NOT null , `doc_date` DATE, `gl` DECIMAL(4,0) unsigned not null , `slcode` VARCHAR(6) not null , `tr` VARCHAR(1) not null , `cr_db` VARCHAR(1) not null, `amount` DECIMAL(13,2)unsigned not null , `revcode` DECIMAL(4,0)unsigned not null , `narration` VARCHAR(30)unsigned not null, `cramt` DECIMAL(13,2) unsigned not null, `indi` VARCHAR(1)not null , `dbamt` DECIMAL(13,2) unsigned not null, `acctype` VARCHAR(1) unsigned not null, PRIMARY KEY (`runno`) )ENGINE=Inno DB; I am getting error #1064 on `indi` line I am unable to clear it can u find some solution I'm making a table with employees for a store.Only one employee can be the general manager for the store.My SQL Forum Imagine that you have a My SQL table that holds the information of all the employees in your company.

For versions prior to 4.1, the only workaround is to create two timestamp columns in a table, and explicitly set the second one when inserting the record.

Remember: the first DESC example; ------- -------------- ------ ----- --------- ------- | Field | Type | Null | Key | Default | Extra | ------- -------------- ------ ----- --------- ------- | id | int(11) | YES | | NULL |

Leave a Reply

  1. updating fields word document 11-Jan-2018 10:17

    Divorce, also known as dissolution of marriage, is the termination of a marriage or marital union, the canceling or reorganizing of the legal duties and responsibilities of marriage, thus dissolving the bonds of matrimony between a married couple under the rule of law of the particular country or state.

  2. updating typo3 06-Sep-2017 19:00

    Remember, once he meets you, he will most likely not change his relationship goals; thus, beware of the “kick the tires” type of dater who says “If the right one shows up, then I would be in a relationship.” The truth is, this person is more likely to be a casual kind of person rather than a partner who is really ready to commit. Opening up with your story is a great way to grease the wheels so that they feel comfortable opening up to you! While that’s acceptable, you want to be sure that the other person’s perspective on family matches yours. ” Think of your email as a coffee shop date: would you ask those types of questions on a first date?

  3. jon foster dating sophia bush 13-Nov-2017 07:32

    For British people from England, Wales, Scotland, Northern Ireland and all over the UK.

  4. Freesex chat roulette straw 15-Dec-2017 12:41

    On mobile devices there are two new menu icons in the header. Tapping on this displays a menu for Home, Help, News, Due date calculator and My Lilypie . When you are in the My Lilypie section, this gives you access to account options such as My tickers, Update email, etc.

  5. paul herold dating 08-Oct-2017 03:07

    Up until he confirmed his shocking relationship with a longtime fan, all we knew of Jake’s dating life came from rumors.