Skip to content
Code Solution
  • Home
  • Technology
    • Android
    • AngularJS
    • ASP.NET
    • Computer Enthusiasts
    • Database Administrators
    • Graphic Design
    • HTML
    • Information Security
    • Laravel
    • Magento
    • MySQL
    • Node.js
    • PHP
    • Python
    • ReactJS
    • Salesforce
    • Ubuntu
    • Unix & Linux
    • Webmasters
    • WordPress
  • Magenaut Blog
  • Game & Software License Key
  • Privacy Policy

Home » Technology » MySQL

MySQL

mysql ERROR 1064 (42000): You have an error in your SQL syntax;

August 4, 2022 by cs_admin

i have installed mysql 8.0.12 into one linux node and when i try to give below grant permission to get access from other nodes, i am getting 42000 error

Categories MySQL, Technology Tags mysql Leave a comment

How to make MYSQL query results ORDER BY conditions order?

August 4, 2022 by cs_admin

My query string is like:

Categories MySQL, Technology Tags mysql, sql-order-by Leave a comment

Full-text search relevance is measured in?

August 4, 2022 by cs_admin

I am making a quiz system, and when quizmakers insert questions into the Question Bank, I am to check the DB for duplicate / very highly similar questions.

Categories MySQL, Technology Tags full-text-search, mysql, performance, relevance Leave a comment

mysql Multiple Foreign Keys in a Table to the Same Primary Key

August 4, 2022 by cs_admin

I have a table user with userID as the primary key. I have another table called Friends. In the Friends table, I have two Users as friends represented by the columns UserID and FrndID where both UserID and FrndID should be a userID in table user.

Categories MySQL, Technology Tags foreign-keys, mysql, primary-key, referential-integrity, sql Leave a comment

On using ini_set(‘max_execution_time’, 0);

August 4, 2022 by cs_admin

How do I use ini_set('max_execution_time', 0);?

Categories MySQL, Technology Tags apache, codeigniter, mysql, php Leave a comment

CakePHP: No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

August 4, 2022 by cs_admin

I have had a cakephp app running fine on my local machine (mac osx) for a while and then suddently I realise that I can’t connect to mysql.sock.

Categories MySQL, Technology Tags cakephp, mysql, mysql-error-2002, php Leave a comment

Taking input variables from a table(HTML) and supply the values as a variable name for a database table

August 4, 2022 by cs_admin

I would like to create a form for a patient database system. Then I will give some input data to each textbox of the form and the data will be stored in a MySQL database.

Categories MySQL, Technology Tags html, jdbc, jsp, mysql, prepared-statement Leave a comment

Copy table without copying data

August 4, 2022 by cs_admin

The question: CREATE TABLE foo SELECT * FROM bar copies the table foo and duplicates it as a new table called bar. How can I copy the schema of foo to a new table called bar without copying over the data as well? The Solutions: Below are the methods you can try. The first solution … Read more

Categories MySQL, Technology Tags mysql Leave a comment

MySQL Delete all rows from table and reset ID to zero

August 4, 2022 by cs_admin

I need to delete all rows from a table but when I add a new row, I want the primary key ID, which has an auto increment, to start again from 0 respectively from 1.

Categories MySQL, Technology Tags mysql Leave a comment

Object can’t be converted to a string in MySQLi PHP

August 4, 2022 by cs_admin

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:xampphtdocsxxxdash.php on line 20

Categories MySQL, Technology Tags mysql, mysqli, php Leave a comment
Post navigation
Older posts
Page1 Page2 … Page1,072 Next →

Recent Posts

  • Top 5 Programming Languages to Learn for Beginners in 2022!!
  • Why would you ever use asp.net’s ViewState storage object over the Session storage object?
  • Generate JSON with property names that include dot using SELECT FOR JSON
  • insertion in a table of objects with nested table in oracle
  • Compare occurence of chars in PostgreSQL string
  • How to fix unicode REPLACEMENT CHARACTER � in postgres database
  • Junction table or denormalize?
  • Mariadb Benchmarking – Low transaction and query per second
  • SQL Server / SSMS taking up lots of disk space
  • SQL Server: Is it worth checking for change in a field before the update?

Tags

.net adobe-illustrator ajax android angularjs apex asp.net asp.net-mvc authentication bash c# command-line css database eloquent encryption express html java javascript jquery json laravel laravel-4 laravel-5 lightning-web-components linux magento2 marketing-cloud mongodb mysql node.js pandas passwords performance php postgresql python reactjs sql sql-server tls typescript windows windows-7
© 2023 Code Solution • Built with GeneratePress