#MySQL

[futurebird]

Do not help them to build any more of this machine.

If you work with a database and are asked to alter the table structure to comply in advance for citizenship or gender categorizations it's really important to NOT do it.

"The governor is concerned about all this stuff they want us to update our record keeping so we store both gender AND biological sex."

"We need fields to store the country of origin of people's parents."

If you don't have the power to rebuff this yourself, ask for help. At minimum ask for help online anonymously.

Depending on your job you probably have in the past made compromises. Maybe to keep your job. Maybe to survive. This is a bright line. If you are asked to be the one to update the table don't let it be your fingers typing those changes.

If you can't just say "No I won't do that." Stall, run away, feign incompetence. Just don't let it happen.

I suspect this might be where the rubber hits the road first for us around here.

Nothing has changed. You do not have to do it. It is not even ordained.

I know someone who rebuffed such a request. Boss was apologetic "it's what the higher ups want, oh *I* think it's a lot of nonsense, but I don't want us to be out of step ... blah blah"

It was proposed to them in sheepish way. They said it would be a lot of work, not add anything of value, and most important they would not do it. It didn't come up again.

Fascism can be the work of zealots, but there are also many sheepish middle management helping hands who "don't even believe in this really"

There is a lively discussion of this on mastodon. (Mastodon is a very active social network where many people who left twitter have gone over the past few years to escape many problems of big centralized socail media. I like it a lot.) Posting a response to this post over there could be a way to get lots of help and ideas from tech people all over the world with similar values. If you do need help. Please say something.

Also, if you respond to this post I can pass what you say along if that would help too. People will respond and give you ideas to NOT do this should you be asked.

[nixcraft]

Wait what... ? this is dangerous knowledge.

[playstationvii]

[codingquill]

SQL Fundamentals #2: SQL Data Manipulation

In our previous database exploration journey, SQL Fundamentals #1: SQL Data Definition, we set the stage by introducing the "books" table nestled within our bookstore database. Currently, our table is empty, Looking like :

books

| title | author | genre | publishedYear | price |

Data manipulation

Now, let's embark on database interaction—data manipulation. This is where the magic happens, where our "books" table comes to life, and we finish our mission of data storage.

Inserting Data

Our initial task revolves around adding a collection of books into our "books" table. we want to add the book "The Great Gatsby" to our collection, authored F. Scott Fitzgerald. Here's how we express this in SQL:

INSERT INTO books(title, author, genre, publishedYear, price) VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Alternatively, you can use a shorter form for inserting values, but be cautious as it relies on the order of columns in your table:

INSERT INTO books VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Updating data

As time goes on, you might find the need to modify existing data in our "books" table. To accomplish this, we use the UPDATE command.For example :

UPDATE books SET price = 12.99 WHERE title = 'The Great Gatsby';

This SQL statement will locate the row with the title "The Great Gatsby" and modify its price to $12.99.

We'll discuss the where clause in (SQL fundamentals #3)

Deleting data

Sometimes, data becomes obsolete or irrelevant, and it's essential to remove it from our table. The DELETE FROM command allows us to delete entire rows from our table.For example :

DELETE FROM books WHERE title = 'Moby-Dick';

This SQL statement will find the row with the title "Moby-Dick" and remove it entirely from your "books" table.

To maintain a reader-friendly and approachable tone, I'll save the discussion on the third part of SQL, which focuses on data querying, for the upcoming post. Stay tuned ...

[xpertbytes]

Expert React & Laravel Solutions for Modern Businesses!

[skull-shore]

03.july23,mon ; internship

i had my first work-day today at my internship and my brain started melting alreadyyy D: i knew they were using PHP for their websites so i started off with learning HTML and CSS so far. Why does PHP seem so complicated compared to those two?:,)

I also didn't understand the connection between PHP and MySQL yet? can someone explain?

i decided to use my free night to begin the codecademy tutorial about PHP and just do that until i fall asleep, hopefully it will open my eyes a bit more than the website they provided me with. wish me luck(pls)<3

[mdidminfoway-blog]

🌟 Dreaming of a Career in Android App Development? 🌟

Start your journey with an internship at MDIDM INFOWAY – your first step towards a bright and successful future!

Why wait? Your future in tech starts here! 👉 Contact us today to secure your spot! +91 83471 93531

androiddevelopment

[kookiesdayum]

I want to learn AWS from scratch, but I'm not familiar with it and unsure where to start. Can anyone recommend good resources for beginners? Looking for structured courses, tutorials, or hands-on labs that can help me build a strong foundation.

If you know any resources then plz let me know.

Thanks 🍬

[amparol12]

Breaking Homework Barriers: Journey to Database Brilliance

In the fast-paced world of academia, students often find themselves grappling with the intricacies of database management and SQL homework. The challenges posed by these assignments can be daunting, leaving many seeking a guiding light to navigate the complexities of database design, queries, and optimization. If you're one of those students desperately searching for "help with mySQL homework," you've come to the right place. This blog will serve as your roadmap, guiding you through the journey to unlock the secrets of database brilliance.

Unraveling the Mysteries of mySQL Homework

Help with mySQL homework is more than just a search query; it's a plea for assistance in unraveling the mysteries of structured query language and database management systems. As you embark on your academic quest, you'll encounter challenges that test your understanding of data modeling, SQL syntax, and the nuances of optimizing database performance. Fear not, for every hurdle you face is an opportunity to grow and master the art of database design.

Navigating the Database Landscape

To embark on this journey, it's crucial to understand the landscape you're navigating. Databases are the backbone of modern applications, storing and managing vast amounts of information. SQL, or Structured Query Language, serves as the key to interacting with these databases, allowing you to retrieve, insert, update, and delete data seamlessly. However, the road to becoming proficient in SQL can be winding, filled with challenges that demand attention to detail and a deep understanding of database concepts.

The Role of Expert Guidance

In your quest for database brilliance, seeking expert guidance is akin to having a seasoned navigator on your journey. Platforms like DatabaseHomeworkHelp.com are designed to provide comprehensive help with mySQL homework. These services offer a lifeline for students drowning in assignments, providing expert assistance that goes beyond mere completion to ensure understanding and mastery of database principles.

Tailored Solutions for Individual Needs

One size does not fit all, especially when it comes to mastering database concepts. Help with mySQL homework should be tailored to your individual needs and learning style. A reliable service will not only assist with assignment completion but also provide detailed explanations, clarifying doubts and reinforcing your understanding of SQL. This personalized approach is the key to breaking down barriers and fostering true brilliance in database management.

Overcoming Common Challenges

As you delve into the world of databases, you'll likely encounter common challenges that can be stumbling blocks in your academic journey. Whether it's understanding normalization, crafting complex queries, or optimizing database performance, expert assistance can make all the difference. These challenges, when conquered with the right guidance, become stepping stones to a deeper understanding of database management.

Building a Foundation for Future Success

The journey to database brilliance is not just about completing assignments; it's about building a solid foundation for future success. The skills you acquire in navigating SQL and database design will prove invaluable in real-world scenarios. As industries increasingly rely on data-driven decision-making, your proficiency in database management will set you apart in the job market.

Embracing the Learning Process

Every stumble, every challenge, and every "help with mySQL homework" query is an integral part of your learning process. Embrace the journey, knowing that each assignment is an opportunity to enhance your skills. Don't shy away from seeking assistance when needed, as it's a sign of strength to recognize your limitations and actively work towards overcoming them.

Conclusion: Your Path to Database Brilliance

In conclusion, the journey to database brilliance is not a solitary one; it's a collaborative effort that involves seeking guidance, overcoming challenges, and embracing the learning process. When faced with the complexities of SQL homework, remember that help with mySQL homework is readily available. Take advantage of the resources at your disposal, and soon you'll find yourself not just completing assignments but mastering the art of database management. Your path to brilliance starts now.

[shwetaglobereach]

PHP & MySQL Essentials: Online Coding Course

Dive into dynamic web development! Our online course teaches PHP and MySQL for building robust, database-driven websites. Elevate your coding skills today!

[nixcraft]

[koshekdev]

Backend update

Had the most horrible time working with Sequelize today! As I usually do whenever I work with Sequelize! Sequelize is an SQL ORM - instead of writing raw SQL, ORM gives you an option to code it in a way that looks much more like an OOP, which is arguably simpler if you are used to programming that way. So to explain my project a little bit, it's a full stack web app - an online photo editor for dragging and dropping stickers onto canvas/picture. Here is the diagram.

I'm doing it with Next which I've never used before, I only did vanilla js, React and a lil bit of Angular before. The architecture of a next project immediately messed me up so much, it's way different from the ones I've used before and I often got lost in the folders and where to put stuff properly (this is a huge thing to me because I always want it to be organized by the industry standard and I had no reference Next projects from any previous jobs/college so it got really overwhelming really soon :/) . The next problem was setting up my MySQL database with Sequelize because I know from my past experience that Sequelize is very sensitive to where you position certain files/functions and in which order are they. I made all the models (Sequelize equivalent of tables) and when it was time to sync, it would sync only two models out of nine. I figured it was because the other ones weren't called anywhere. Btw a fun fact

So I imported them to my index.js file I made in my database folder. It was reporting an db.define() is not a function error now. That was weird because it didn't report that for the first two tables that went through. To make a really long story short - because I was used to an server/client architecture, I didn't properly run the index.js file, but just did an "npm run dev" and was counting on all of the files to run in an order I am used to, that was not the case tho. After about an hour, I figured I just needed to run index.js solo first. The only reasons those first two tables went through in the beginning is because of the test api calls I made to them in a separate file :I I cannot wait to finish this project, it is for my bachelors thesis or whatever it's called...wish me luck to finish this by 1.9. XD

Also if you have any questions about any of the technologies I used here, feel free to message me c: <3 Bye!

[the-real-wholesome-bitch]

There will never be a time that in my coding projects that I don’t put a Percy Jackson name as a place holder

[arshikasingh]

SQL Interview Questions

The following SQL interview questions and answers are designed to familiarize candidates with common interview questions.