MySQL

kurtttlogan · 01-24-2017, 01:37 PM

I am a student looking her help on my senior design project. I have downloaded MySQL and have made a database, but for some reason it is not allowing me to create a table. I need to insert complex numbers into this table that will be coming from GNU Radio and ultimately from some USRPs. If I could get any help it would be greatly appreciated!

szboardstretcher · 01-24-2017, 01:38 PM

Can we see the output?

Edit: Can we see the output of the command you are running? The errors? The permissions? Any commands you have run against it? We have to see some sort of output to focus in on helping you.

kurtttlogan · 01-24-2017, 01:41 PM

Currently I can get the data to be stored into files, but they cannot be viewed. I can utilize the files for the post processing I am doing, but this does not allow me to make my system real time.

Turbocapitalist · 01-24-2017, 01:44 PM

Which distro are you using and which package manager did you use to get MySQL (or MariaDB) installed?

hydrurga · 01-24-2017, 01:51 PM

Quote:

Originally Posted by kurtttlogan

Currently I can get the data to be stored into files, but they cannot be viewed. I can utilize the files for the post processing I am doing, but this does not allow me to make my system real time.

By "Can we see the output?", I think that szboardstretcher means the error output from MySQL when you try to create a table.

kurtttlogan · 01-24-2017, 02:03 PM

Trying to type in CREATE TABLE ant1, data ENUM();

Have tried it multiple ways and I keep getting the same error message. Tried to put numbers into the ENUM also.
The error message says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL version server for the right syntax to use near ' data ENUM()' at line 1.

I am using Ubuntu.

Turbocapitalist · 01-24-2017, 02:05 PM

Quote:

Originally Posted by kurtttlogan

I am using Ubuntu.

Thanks. Which version and did you use the Software Center or APT or Synaptic to install MySQL?

kurtttlogan · 01-24-2017, 02:08 PM

Quote:

Originally Posted by Turbocapitalist

Thanks. Which version and did you use the Software Center or APT or Synaptic to install MySQL?

I used APT

Turbocapitalist · 01-24-2017, 02:14 PM

Ok. Thanks. Just checking the background. It would help to know the version of Ubuntu and of MySQL. There are small details that vary from version to version. Every once in a while there are big changes.

As far as creating the tables, the syntax is quite different. Here is a short sample excerpted from a very old MySQL database:

Code:

CREATE TABLE `ISO3166` (
  `code2` char(2) NOT NULL default '',
  `country` char(30) NOT NULL default '',
  UNIQUE KEY `code2` (`code2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

The current syntax is here:

https://dev.mysql.com/doc/refman/5.7...ate-table.html

Be sure to look up the reference that matches the version of MySQL you are using.

hydrurga · 01-24-2017, 02:14 PM

Quote:

Originally Posted by kurtttlogan

Trying to type in CREATE TABLE ant1, data ENUM();

Have tried it multiple ways and I keep getting the same error message. Tried to put numbers into the ENUM also.
The error message says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL version server for the right syntax to use near ' data ENUM()' at line 1.

I am using Ubuntu.

You may want to look at this: https://dev.mysql.com/doc/refman/5.7...ate-table.html

In English, which columns within the table are you trying to set up?

szboardstretcher · 01-24-2017, 02:17 PM

If you have a requirement to use ENUM,. here are some examples:

Code:

CREATE TABLE ant1 (data ENUM(''));
CREATE TABLE ant2 (bands ENUM('zep', 'floyd', 'slayer'));

describe ant1;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| data  | enum('') | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+

describe ant2;
+-------+------------------------------+------+-----+---------+-------+
| Field | Type                         | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+---------+-------+
| bands | enum('zep','floyd','slayer') | YES  |     | NULL    |       |
+-------+------------------------------+------+-----+---------+-------+

This is available at the documentation: https://dev.mysql.com/doc/refman/5.7/en/enum.html