Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 3 of 3

Thread: Java

  1. #1
    Junior Member
    Join Date
    Nov 2023
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Java

    how to delete a row in the employee table without entering the employee ID in MySQL



    please tell me anyone solution

  2. #2
    Member Helium c2's Avatar
    Join Date
    Nov 2023
    Location
    Kekaha, Kaua'i
    Posts
    105
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default Re: Java

    MySQL is an application software. And not a system software. So this program comes with a manual of some sort. I think they might have some in the library. Public library. There are books on them.

    I am here or we're here to study Java programs. This Java is like C ++ which was invented in 1974 just about. So that other users can interact with the computer and use it. Windows came out in 1981 for the general public to use. Java was invented on top of C++ so that only computer knowledgeable users can interact with any operating system. Windows. MySQL deals with application issues for web developers, using only MySQL. And for that issue. I feel that learning Java is a more general approach to system software, and a better approach. Even for website applications.
    Last edited by Helium c2; November 29th, 2023 at 03:55 PM. Reason: added logic

  3. #3
    Member
    Join Date
    Jan 2024
    Posts
    73
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default Re: Java

    Sure! In MySQL, you can delete a row from a table without specifying the employee ID by using a condition in the DELETE statement that matches the criteria you want to delete. However, without a specific identifier like the employee ID, you'll need to rely on other criteria to identify the row(s) you want to delete.

    For example, let's say you want to delete a row based on the employee's name. Here's how you could do it:

    ```sql
    DELETE FROM employee
    WHERE name = 'EmployeeName';
    ```

    Replace 'EmployeeName' with the actual name of the employee you want to delete.

    Or if you want to delete rows based on some other criteria like department or job title, you can adjust the WHERE clause accordingly.

    Just remember to be cautious when deleting rows without a specific identifier, as it can potentially affect multiple rows if your criteria are not specific enough. Always double-check your conditions before executing the DELETE statement. If you find yourself needing further help with SQL assignment, there are various resources available online like programminghomeworkhelp.com, where you can seek guidance and support.