Related questions

MySQL rows deleted on varchar column

2018-07-11 05:18 Sana Ullah imported from Stackoverflow

I have a situation where I am stuck. I want to delete all the records in a table of varchar column. The query is to be:

DELETE FROM table WHERE column = 'value'

But istead of this query I mistakenly executed the following query

DELETE FROM table WHERE column = 0

All the records in the table are deleted. Why? Any suggestion

See also questions close to this topic

  • En dash cause error when Import data using load data in file

    we are using load data infile

    $this->db->query("LOAD DATA LOCAL INFILE '".$file_path."' 
INTO TABLE excel_details 
CHARACTER SET  utf8mb4
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY  '\"' 
LINES TERMINATED BY '\r\n' 
IGNORE 1 LINES 
(Email,name,address) 
SET cid =".$cid.", csvsheet_id=".$csvsheet_id
);

    string contain en dash cause 1300 error address contain 2–5

  • Woocommerce price filter ordering by Post ID rather than price high to low

    I'm stumped at this one.

    I've got Woocommerce and using the theme 2017 (All other plugins and themes disabled) and I'm looking to order them in price High to low however when I select this dropdown and press it the prices are not being ordered instead it's being ordered by Post ID instead.

    Example of the bug

    All the prices are correct inside of the database also

    Picture of Database

  • SQLAlchemy query the database and display to html form

    Working on flask web app and I have this working row SQL command to insert data to my database.

    if request.method == 'POST':
    cur = connection.cursor()
    employee_id = request.form['employee_id']
    emp_nums = {'1000': 'DEV', '1001': 'ANA'}
    if employee_id in emp_nums:
        print(employee_id)
        resultValue = cur.execute('''SELECT * FROM employee_data WHERE team 
        = "{}"'''.format(emp_nums[employee_id]))
        if resultValue > 0:
            print(resultValue)
            userDetails = cur.fetchall()
            return 
            render_template('attendance.html',userDetails=userDetails)
        return render_template('login.html')

    Am trying to modify this code to use SQLAlchemy but can't get the query result

    @app.route('/attendance', methods = ['GET', 'POST'])
def attendance():
    if request.method == 'POST':
        o_id = request.form['o__id']
        emp_nums = {'1000': 'DEV', '1001': 'ANA'}
        team = emp_nums.get(o_id,'')
        print('team is',team)
        userDetails = Employee_data.query.filter_by(team = team).all()
        print(userDetails)
       return render_template('take_attendance.html', 
       userDetails=userDetails)
    return 'no data corresponding '

    The above code returns nothing. Thank you for you help