3 ms·

So, when you read these parts of my post: > Edit your query to add an ORDER BY clause? > Check the primary key and write an UPDATE query? Hope not to make a t

by philh 11y ago

So, when you read these parts of my post: > Edit your query to add an ORDER BY clause? > Check the primary key and write an UPDATE query? Hope not to make a typo when writing the key. > write a SELECT query? did you think that I was saying: "I think this is how I would do it in SQL, if only I knew SQL. Won't you please point me to somewhere I can learn SQL so that all my problems will be solved"? Because what I was going for was: "here is how I would do it in the CLI, but I much prefer how I would do it in PMA. Please tell me if there's a better way to do it in the CLI". I know SQL, I thought it was obvious that I knew SQL, and pointing me towards SQL tutorials is super unhelpful.

baldfat 11y ago
Go to Stack Overflow. Yes the reason why no one gave you your SQL code is we know that the GUI is just making SQL code for you. Sorry we probably have the mindset of we pointed you to the answer and we are not going to give you specific answer to your questions. I googled searched by copy and paste your question for 5 seconds for each question: > Edit your query to add an ORDER BY clause? http://www.techonthenet.com/sql/order_by.php http://www.techonthenet.com/sql/order_by.php > Check the primary key and write an UPDATE query? http://stackoverflow.com/questions/3930338/sql-server-get-table-primary-key-using-sql-query http://stackoverflow.com/questions/3930338/sql-server-get-ta... > write a SELECT query http://www.w3schools.com/sql/sql_select.asp http://www.w3schools.com/sql/sql_select.asp I think your issue is you are biased against CLI and think you get more benefit from a GUI. We can convince you what is best for you. We are just saying everything you pointed out is easily done in CLI with SQL commands. We believe everyone who works with databases should use CLI for a number of benefits because of our own experience.
- philh 11y ago
  ...what part of > I know SQL, I thought it was obvious that I knew SQL, and pointing me towards SQL tutorials is super unhelpful. makes you think that I just need really basic SQL tutorials? I get the impression that you're glancing at my posts, picking out a few words, making up a question that someone else might have asked using those words, and answering that question instead of the one I'm actually asking. This is incredibly frustrating for me. As such, I decline to continue this conversation.
  - baldfat 11y ago
    No I am being super Ironic. You are listing EASY to do SQL commands as things that you don't know how to do. You than ask use to show you. What is your question besides show me how to do 1, 2, 3?

by philh 11y ago

baldfat 11y ago

Go to Stack Overflow. Yes the reason why no one gave you your SQL code is we know that the GUI is just making SQL code for you. Sorry we probably have the mindset of we pointed you to the answer and we are not going to give you specific answer to your questions. I googled searched by copy and paste your question for 5 seconds for each question: > Edit your query to add an ORDER BY clause? http://www.techonthenet.com/sql/order_by.php http://www.techonthenet.com/sql/order_by.php > Check the primary key and write an UPDATE query? http://stackoverflow.com/questions/3930338/sql-server-get-table-primary-key-using-sql-query http://stackoverflow.com/questions/3930338/sql-server-get-ta... > write a SELECT query http://www.w3schools.com/sql/sql_select.asp http://www.w3schools.com/sql/sql_select.asp I think your issue is you are biased against CLI and think you get more benefit from a GUI. We can convince you what is best for you. We are just saying everything you pointed out is easily done in CLI with SQL commands. We believe everyone who works with databases should use CLI for a number of benefits because of our own experience.

philh 11y ago
...what part of > I know SQL, I thought it was obvious that I knew SQL, and pointing me towards SQL tutorials is super unhelpful. makes you think that I just need really basic SQL tutorials? I get the impression that you're glancing at my posts, picking out a few words, making up a question that someone else might have asked using those words, and answering that question instead of the one I'm actually asking. This is incredibly frustrating for me. As such, I decline to continue this conversation.
- baldfat 11y ago
  No I am being super Ironic. You are listing EASY to do SQL commands as things that you don't know how to do. You than ask use to show you. What is your question besides show me how to do 1, 2, 3?