Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

SQLite3. Strange behavior in setting the table.

R
rielyn last edited by
```
create table Group(recordId integer primary key, name text);
```
Makes a mistake.
```
Error: near "Group": syntax error
```
Removing or adding a symbol makes it normal. ♪
Maybe who's gonna tell me what's wrong or confirm that behavior?
X. I'm in the middle of a sqlite3, version 3.7.9-2, OS Debian Wheezy
Reply Quote 0
1 Reply Last reply
Analeea last edited by

The Group is a key word reserved for use in the teams. Read: http://www.sqlite.org/search?q=Group
Reply Quote 0
1 Reply Last reply

sqlite3 618

2
Posts

0
Views

Suggested Topics

A

Is it possible to do the query "INSERT INTO table SET field = 'value'" in the PostgreSQL?
Software Programming • postgresql database query • • Avante

2

0
Votes

2
Posts

0
Views

N

It's not possible.This is one of the problems of doing something out of the pattern.Actually this is a great demonstration that migrating database used by an application is not something trivial and does not work automatically.Unfortunately the biggest problems are not so visible and cause huge problems without being noticed right away and people tend to think it's something else, including blaming the DB and always someone will argue that they shouldn't have migrated because it proved worse than it was "sold".Unfortunately, PDO was used. His only real advantage is an illusion. Database migration involves a total re-evaluation of data access semantics. PDO only helps a bit in syntax that is the easy part. Therefore PDO helps less than 10%, probably less, in migration. But the most tragic is that it gives the illusion that helped close or 100%, which is not true.If to cause few problems is because it was already bad before.An ORM may have the same or worse effect. ORM is useful in some scenarios, but the exchange of the database is an illusion. In fact it is worse because it tends to leave bad access always, a layer like PDO, if done right, can get good and would only be bad in case of migration.Here we always see questions talking about these things and the person thinks that "will press a button" and everything will be solved. Architecture problems are the most difficult to solve and unfortunately few people know how to make architecture, most believe in things that are not based on engineering, only marketing.So when the person uses PDO and uses syntax that cannot be migrated, the person did not know what he was doing. If the person did wrong in syntax, which is the easy part, imagine in semantics.
B

How to set the table heading
Software Programming • javascript • • baileigh

2

0
Votes

2
Posts

0
Views

S

I'm not sure I understood you correctly, but if that's right,function createthead(colNames) { let tr = document.createElement('tr'); for(var i = 0; i < colNames.length; i++){ let th = document.createElement('th'); let colName = colNames[i]; th.innerHTML = colName; th.id = "th_" + colName; tr.appendChild(th) } return tr; } console.log(createthead(['first','second']));
E

I don't know how to get the data from the database to telegram bot python.
Software Programming • python telegram bot sqlite3 • • emran

2

0
Votes

2
Posts

0
Views

C

So the function add_user doesn't add value to the db, but tries to update what doesn't exist. Maybe I'll need my long-term work.class SQLighter: def init(self, database): """Подключаемся к БД и сохраняем курсор соединения""" self.connection = sqlite3.connect(database, check_same_thread = False) self.cursor = self.connection.cursor() def add_user(self, id,name,survived,infected): """Добавляем значение""" with self.connection: return self.cursor.execute("INSERT INTO stats (user_id, user_name, survived, infected) VALUES(?,?,?,?)", (id,name,survived,infected)) def get_nick(self, id): '''Эта функция позволяет извлекать нужное значение(в данном случае id) из таблицы stats''' with self.connection: return self.cursor.execute("SELECT user_id FROM stats WHERE id = ?", (id,)).fetchall() def set_fast(self, id): '''Эта функция позволяет устанавливать значение исходя из параметра id''' with self.connection: return self.cursor.execute("UPDATE stats SET infected=X WHERE id=? ", (id)) def close(self): """Закрываем соединение с БД""" self.connection.close()
J

Python3 _sqlite3.so: undefined symbol: _Py_ZeroStruct
Software Programming • python python 3.x sqlite3 nltk • • Jolied

2

0
Votes

2
Posts

0
Views

O

I don't know what the reason could have been, but by setting up a version of python 3.6, by building libraries like the last time, it's gone out of trouble. Apparently, the problem in sqlite3.so at the first installation of 3.7 sqlite3 comes from a box, probably with mistakes. A lot of others in other forums have recommended simply demolishing and re-establishing the python. That's probably the only way to help.
T

How do the distances between the cells of the table so that there are no holes in this table?
Software Programming • html cs tables • • Trenton

2

0
Votes

2
Posts

0
Views

J

Alternatively, negative fields equal to the value border-spacing♪table { border-spacing: 10px; border-collapse: separate; margin: -10px; } td { padding: 1em; border: 1px solid; } body { margin: 0; }<table> <tr> <td>1</td> <td>2</td> </tr> <tr> <td>3</td> <td>4</td> </tr> </table>
S

I'm trying to set up a table at MySQL, making a mistake.
Software Programming • mysql table • • shizuka

2

0
Votes

2
Posts

0
Views

J

First USE test; and then CREATE TABLE `Сотрудники` ( `Идентификатор сотрудника` INTEGER NOT NULL AUTO_INCREMENT, `Фамилия` VARCHAR(30), `Имя` VARCHAR(20), `Отчество` VARCHAR(35), `Дата рождения` DATE, `Серия и номер паспорта` VARCHAR(20) DEFAULT NULL, PRIMARY KEY (`Идентификатор сотрудника`) ) ENGINE InnoDB CHARACTER SET utf8; PS. Structural is so selfish. Especially a series and a passport number in one field... ♪
E

How is it better to keep small values in a big table sqlite3?
Software Programming • python sql sqlite sqlite3 • • elysha

2

0
Votes

2
Posts

0
Views

R

I'd advise you to use the shelve module in such a terrible way. It's a vocabulary interface to sqlite3.
A

Operating error in tkinter buttons
Software Programming • python tkinter sqlite3 python 3.7 • • Amritpal

2

0
Votes

2
Posts

0
Views

Looks like it's auto command You must pass a reference to the function to call when the button is pressed, you run the function and you pass it to command your return (None).On the other hand, you should never use string formatting to pass the parameters to a query, this is insecure, more when the parameters come from user inputs without healing. Exhibit your database to code injection attack. Instead, you must parameterize the query.from functools import partial def eleccion(val): cursor.execute("INSERT INTO pedido VALUES(null, %s)", (val, )) for c in cate: print("\n*", c[1], "") ttk.Label(marcoprincipal, text="{}*".format(c[1])).pack(fill="both", expand=1) libros = cursor.execute("SELECT * FROM libro WHERE categoria_id={%s}", (c[0], )) for l in libros: print("\t", l[1]) ttk.Button(marcoprincipal, text="{}".format(l[1]), command=partial(eleccion, l[0])).pack()
E

Combining tables by joining
Software Programming • sql sqlite select join sqlite3 • • emerson

2

0
Votes

2
Posts

0
Views

Y

As far as I can see, you just need to replaceanswer.side_id != question.side_id ♪answer.side_id > question.side_id That's assuming you have side_id always more. side_id question.
As when the table is set up in read bean PHP does not create `id`
Software Programming • php mysql • • emmalee

2

0
Votes

2
Posts

0
Views

P

Redbean is established in the calculation that column id is required to be present in the table of objects related to the base. Like in a class code. https://github.com/gabordemooij/redbean/blob/master/RedBeanPHP/Repository.php#L351 Method checkwhich leaves an exception if the id is not defined:if ( !isset( $bean->id ) ) { throw new RedException( 'Bean has incomplete Meta Information id ' ); } Unfortunately, the library code says that you can't just expand Repository and redesign this logic. If you already know how your database works, and you want to have more control over the logic of displaying objects in the bud, you have to give up Redbeans.Please note that, for example, for the InnoDB storage sub-system tables in MySQL (MariaDB) the primary key https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html even if you don't point it clearly. If you know what I'm talking about, you can throw Redbean away. For the first time, if you can hear, don't rush off this ORM, its limitations are the price of simple interface and universality.
B

Prevent DROP TABLE
Software Programming • sql sqlite databank permissions sqlite3 • • baileigh

2

0
Votes

2
Posts

0
Views

D

It just doesn't. Any attempt will fail.You have not given context to what you want to do so it may be that your problem is another.Prevent access to the fileIf you want to prevent a user from causing problems with the data. Forget it. He can do whatever he wants in one way or another.The only way not to allow it to do damage is not to let it have access to the file where the database is and only its application access where the file is. This is virtually impossible in the environment that you do not have full control of what is unlikely to have.Prevent access to SQLIf your application is giving SQL access to the user and is afraid of it doing something wrong, take access. It does not matter if it is useful to give this access, if it has to limit in this way, it cannot give full access. You would have to make an interpreter check whether you can command or not. It's complicated.When I speak of user, it is any user, even some programmer.Note that it does not prevent direct access to the file. Remember that you are using a database made to https://www.sqlite.org/whentouse.html (I even use for other cases but I know what I'm doing). Get access to your file and I do whatever I want with the data there, even delete the records individually. I'll finish with this TRIGGER that you created in less than a minute.This recommendation to prevent direct use of SQL is only valid if the user/programmer has no access to the file.Prevent security failureIf you're worried about a security breach letting you delete the data, don't waste time. Security failures can bring more problems than this. And the solution is to solve security flaws. No other way.Prevent your mistakesIf you're worried about this, it would be nice to think of another database. SQLite is made for relatively simple applications (neither need to be so simple) and programmers who manage to handle the entire base without making catastrophic errors. It gives you speed, flexibility, freedom and even reliability, but does not provide security through access privileges.Alternative solutionsCorrect toolIf you have a strong reason that requires personalization of even privileges, then you will have to use another database. One that provides the very granular possibility of what each user can do. But note that even in this case, if someone has access to the process of this database and access to the files it may with some work pass over this type of restriction as well.Limit SQLiteYou can modify the SQLite code to prevent the command in this or under all conditions. You will need to know a little C, study the code, be careful, but it is possible to adapt to what you want.I am not advising to do this, just giving an alternative.Again this does not solve anything if there is direct access to the file.ConclusionIf you have full control over the database hardly this protection will be necessary.If the user has access to the file, he can do whatever he wants for as much as you protect it.In thesis there is a way to protect more that is to encrypt the entire file so that only your application can access it. But even if this is effective falls in the first case, you will protect yourself. It does not seem necessary since no one makes a mistake and gives a DROP TABLE unintentionally.
A

Strange behavior .bind in jquery
Software Programming • jquery • • Anderson

2

0
Votes

2
Posts

0
Views

It's not weird, you pick a button with a selector, and the next thing happens.to create button Hang an event button // тут кнопка одна на нее вешаем обработчикto create button Hang an event button // а тут кнопки две, вешаем еще раз на первую и на новуюTo win what you're doing in res3 turn into jQuery, and you're putting the processor on it.$button = $(res_3).appendTo(this.$element); /...../ $button.on('click',function(){ /......./ }); Don't forget to announce $button where the thread is above.
O

Strange behavior recycleview and data in it
Software Programming • java android sql recyclerview • • Oba22

2

0
Votes

2
Posts

0
Views

You're probably using HashMap, and he doesn't guarantee the retention of the additives when it's lost.If you replace him on LinkedHashMap, the order will be maintained.Also, in the case of id sorting, TreeMap would be appropriate, but only for this particular case.
A

Setting up a table in the database wordpress
Software Programming • mysql wordpress database • • Anderson

2

0
Votes

2
Posts

0
Views

A

The assigned function only makes one: creates a local variable $sql_create_paramsthe SQL-Comanda, which is intended to create the necessary table. Then the function ends. The team doesn't do that, why would she do something?
S

How do you download a db file in sqlite3 if his exact name is not known in advance?
Software Programming • php sqlite3 • • simrah

2

0
Votes

2
Posts

0
Views

Z

You'll be able to help. http://php.net/glob ♪ Find the right files and connect. $baseDir = __DIR__ . '/db'; $databases = glob($baseDir . '/*.db'); var_dump($databases);

SQLite3. Strange behavior in setting the table.

Suggested Topics

Is it possible to do the query "INSERT INTO table SET field = 'value'" in the PostgreSQL? Software Programming • postgresql database query • • Avante

How to set the table heading Software Programming • javascript • • baileigh

I don't know how to get the data from the database to telegram bot python. Software Programming • python telegram bot sqlite3 • • emran

Python3 _sqlite3.so: undefined symbol: _Py_ZeroStruct Software Programming • python python 3.x sqlite3 nltk • • Jolied

How do the distances between the cells of the table so that there are no holes in this table? Software Programming • html cs tables • • Trenton

I'm trying to set up a table at MySQL, making a mistake. Software Programming • mysql table • • shizuka

How is it better to keep small values in a big table sqlite3? Software Programming • python sql sqlite sqlite3 • • elysha

Operating error in tkinter buttons Software Programming • python tkinter sqlite3 python 3.7 • • Amritpal

Combining tables by joining Software Programming • sql sqlite select join sqlite3 • • emerson

As when the table is set up in read bean PHP does not create `id` Software Programming • php mysql • • emmalee

Prevent DROP TABLE Software Programming • sql sqlite databank permissions sqlite3 • • baileigh

Strange behavior .bind in jquery Software Programming • jquery • • Anderson

Strange behavior recycleview and data in it Software Programming • java android sql recyclerview • • Oba22

Setting up a table in the database wordpress Software Programming • mysql wordpress database • • Anderson

How do you download a db file in sqlite3 if his exact name is not known in advance? Software Programming • php sqlite3 • • simrah

Is it possible to do the query "INSERT INTO table SET field = 'value'" in the PostgreSQL?
Software Programming • postgresql database query • • Avante

How to set the table heading
Software Programming • javascript • • baileigh

I don't know how to get the data from the database to telegram bot python.
Software Programming • python telegram bot sqlite3 • • emran

Python3 _sqlite3.so: undefined symbol: _Py_ZeroStruct
Software Programming • python python 3.x sqlite3 nltk • • Jolied

How do the distances between the cells of the table so that there are no holes in this table?
Software Programming • html cs tables • • Trenton

I'm trying to set up a table at MySQL, making a mistake.
Software Programming • mysql table • • shizuka

How is it better to keep small values in a big table sqlite3?
Software Programming • python sql sqlite sqlite3 • • elysha

Operating error in tkinter buttons
Software Programming • python tkinter sqlite3 python 3.7 • • Amritpal

Combining tables by joining
Software Programming • sql sqlite select join sqlite3 • • emerson

As when the table is set up in read bean PHP does not create `id`
Software Programming • php mysql • • emmalee

Prevent DROP TABLE
Software Programming • sql sqlite databank permissions sqlite3 • • baileigh

Strange behavior .bind in jquery
Software Programming • jquery • • Anderson

Strange behavior recycleview and data in it
Software Programming • java android sql recyclerview • • Oba22

Setting up a table in the database wordpress
Software Programming • mysql wordpress database • • Anderson

How do you download a db file in sqlite3 if his exact name is not known in advance?
Software Programming • php sqlite3 • • simrah