PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Tuesday, October 11, 2022

[FIXED] how can I delete a database from my phpmyadmin dashboard which named with multiple strings like "coming soon"?

 October 11, 2022     phpmyadmin, sql     No comments   

Issue

how can I delete a database from my phpmyadmin dashboard which named with multiple strings like "coming soon"? I tried drop database coming soon but it's showing me this error.

drop database coming soon;

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'soon' at line 1


Solution

Backticks are used in MySQL to select columns and tables from your MySQL source. In the example below we are calling to the table titled Album and the column Title. Using backticks we are signifying that those are the column and table names. RESOURCE

SELECT `Album`.`Title`
FROM `Album` AS `Album`
GROUP BY `Album`.`Title`
ORDER BY `Title` ASC
LIMIT 10;

The thing that the article does NOT mention is the multiple stringed table or database names. The above statement would work with, or without, backticks. However this statement would not work without backticks:

SELECT `Album`.`Title One`, `Album`.`Title Two`


Answered By - Zak
Answer Checked By - Gilberto Lyons (PHPFixing Admin)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing