• 0

mysql error


Question

1. create a database-table:

CREATE TABLE useronline (

time int(15) NOT NULL,

ip varchar(15) NOT NULL,

file varchar(50) NOT NULL,

PRIMARY KEY (time),

KEY ip (ip),

KEY file (file) );

these are the instructions to create the tables.

ive atatched a jpg of what ive entered and here is the error message im receiving when trying to save the tables.

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(time), `key ip` TEXT(ip), `key file` TEXT(file))' at line 1

any help appreciated

post-46-1095717021.jpg

Link to comment
https://www.neowin.net/forum/topic/220407-mysql-error/
Share on other sites

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Apple watchOS 26 to likely work on following list of devices by Hamid Ganji Apple's WWDC 2025 event is inching closer, where the iPhone maker is expected to reveal its latest software developments. This year's WWDC is focused on introducing a design overhaul to a wide range of Apple operating systems with a glass-like UI. The new UI overhaul takes most of its clues from visionOS, bringing a unified appearance to Apple devices. It has already been reported that Apple plans to change the name of its operating systems. So, we should expect to see watchOS 26 at the upcoming event, alongside iOS 26, iPadOS 26, and tvOS 26. The codename for Apple’s UI overhaul project is Solarium, which means a kind of glass that lights can go through. Here is the list of compatible Apple Watch models with watchOS 26: Apple Watch Series 6 Apple Watch Series 7 Apple Watch Series 8 Apple Watch Series 9 Apple Watch Series 10 Apple Watch SE (2nd generation) Apple Watch Ultra Apple Watch Ultra 2 Note that this is not Apple's official compatibility list, and the company might extend support to older Apple Watch models. However, given the previous records, the above models are more likely to get watchOS 26. Alongside these models, the Apple Watch Series 11, Apple Watch Ultra 3, and a new Apple Watch SE with plastic body will also receive watchOS 26 right off the bat. These models will drop in September next to the iPhone 17 series. While it was initially believed Apple would keep the upcoming UI overhaul to iPhones, iPads, and Mac devices, Bloomberg said the new UI also reaches watchOS and tvOS. However, the scope of changes on the watchOS are less likely to be significant. Yet little details exist about watchOS 26 and its features, but it's expected to support new watch faces and third-party shortcuts in the Control Center. Source: MacRumors
    • I probably use Messages two or three times a month. It’s Messenger and WhatsApp. I can’t be the only one?
    • I’m not sure interest free credit qualifies as a ‘discount’ 🤔
    • I am confused on how the demand for AMD CPUs is relevant to this discussion?
  • Recent Achievements

    • One Month Later
      EdwardFranciscoVilla earned a badge
      One Month Later
    • One Month Later
      MoyaM earned a badge
      One Month Later
    • One Month Later
      qology earned a badge
      One Month Later
    • One Year In
      Frinco90 earned a badge
      One Year In
    • Apprentice
      Frinco90 went up a rank
      Apprentice
  • Popular Contributors

    1. 1
      +primortal
      451
    2. 2
      +FloatingFatMan
      247
    3. 3
      snowy owl
      240
    4. 4
      ATLien_0
      196
    5. 5
      Xenon
      141
  • Tell a friend

    Love Neowin? Tell a friend!