18382

Do minus sign in mysql table column names cause issues?

Question:

Do minus sign in table column names effect performance or cause issues on some platforms or it is allowed or not?

e.g. user-names e.g cpy-name

Answer1:

Enclose the names within back-ticks

CREATE TABLE `my-table` ( `user-Id` int(11) NOT NULL, `url` varchar(100) NOT NULL, `epoch` int(11) NOT NULL );

Recommend

  • append to the same list with multiprocessing - python
  • Rails traverse deep array of hashes
  • “Read-Only” Entity Framework? I'm trying to use RIA Services, EF, and Silverlight
  • TeamCity: Scripting elements jsp:declaration, jsp:expression, jsp:scriptlet are disallowed here
  • Two view models ,one for the whole page & the other for a small area
  • When to use inputRef.current instead of this.inputRef React.js?
  • Contact us email sending is not working in codeigniter php
  • Viewport for ipad portrait [only]
  • OpenCv 2.4.3: can't find imread and SurfFeatureDetector::detect
  • Simulating a FULL OUTER JOIN in Access
  • How do you save a Linq object if you don't have its data context?
  • how to animate two continuous popup windows with jquery mobile?
  • How to write a method signature “T that implements Comparable” in Java?
  • Silent installation of Apache Tomcat
  • Processing dynamic MP3 URL
  • Fetch data from nested nodes in Firebase
  • Starting Bootstrap tour with a button after ending tour once
  • Extract the data specified in brackets '[ ]' from a string message in python
  • Limit # of records returned based on a form control
  • Adding custom message on Thank You page by shipping method
  • A library that can fill Java object with data declared in Excel file
  • Arc gradients in Flutter?
  • JavaFX Embed Custom Font Not Working
  • Java 11 and E(fx)clipse JavaFX plugin on Eclipse 4.9: An error has occurred - see the log file
  • Javascript / jQuery not executing in IE until the body of the page is moused over
  • Expression.Call GroupBy then Select and Count()?
  • android : speech recognition what are the technologies available
  • $this->a->b->c->d calling methods from a superclass in php
  • How does the dispatcher work when mixing sync/async with serial/concurrent queue?
  • How to check if a database and tables exist in sql server in a vb .net project?
  • Rotating Towards Path in OpenGL
  • How convert html to BBcode in C#
  • Is there a better way for handling SpatialPolygons that cross the antimeridian (date line)?
  • Change cell value based on cell color in google spreadsheet
  • How to change user identity when git pushing via ssh?
  • Computing the discrete fourier transform of audio data with FFTW
  • Using Service Component Runtime
  • What does the “id” field in an Android “Google Play Music” broadcast intent correspond to?
  • convert json to excel in java
  • Create/delete users from text file using Bash script