база-данных

Can you tell me how to delete all the records from all the database tables without deleting the tables themselves?

{"status":"success","result":[ {"picture":"data:image\/png;base64,","name":"\u0420\u0430\u0437\u0431\u0430\u043d","username": ... , end=" ") print("username{}:".format(index), i["username"]) index += 1 time.sleep(1000)

There are two databases in MySQL. Their names are different, but the structure of the tables is the same. How do I make a bac ... p of one database and upload data to another? Please, with a description of the commands, what and how. Thank you in advance.

There are two files from the MS SQL database-mdf and ldf. The task is to get the data from there and transfer it to PostgreSQL. Is it possible? If so, with what and how?

I am making an application on Java with a small local database and I need this database to be created using an sql file. That ... maintainer SUPERUSER CREATEROLE CREATEDB; Tell me, will it work and create a database and if so, how do I run this script?

Why did they come up with them, if you can throw out a dump together with the source code? I feel that the question is the stupidest ^^ do not throw slippers.

Hello! I found video lessons on the course Apache+PHP+MySQL on the Internet, but all the actions take place there, as I und ... завершено"; else echo "Таблицу создать не удалось"; } ?> But still nothing works, and it doesn't create a table...

I wrote the following code conAcc = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\ThirdTask\Northw ... no encoding declared; see http://www.python.org/peps/pep-0263.html for details What should I do to make the error disappear?

When is it better to use built-in relationships between DB tables (in my case, MySQL) (one-to-one, one-to-many, etc.), and wh ... ent for me to use php tools, because it is a more flexible structure ( as it seems to me). So I wanted to hear more opinions.

$sql = "INSERT INTO league(user,email,password,rival,key) VALUES ('$this->user','$this->email','$t ... near 'key) VALUES ('user1','[email protected]','usrpsw','0','0')' at line 1 Key int(11) NULL(no) DEFAULT 0

I have a DB in phpmyadmin, as well as a website. I need to take data from this database( or site), analyze it, and then show ... videos, etc.), since I'm looking for information on the Internet, but I don't think it's quite the right one for my project.

I want to make a Java program for compiling pedigrees, genealogy classes. And I need that when creating a new project, a data ... a database based on SQL queries, but I do not know how. Or perhaps someone can advise a more convenient method for this case.

Tell me if I'm starting to build the database correctly: So far there are 3 tables: dbo.Exam, dbo.Offset, dbo.Session. The ... straint id primary key(SessionId, ExamId, OffsetId) ) P. s how can I then refer to id dbo.StudentSession from other tables?

The site has a simple registration form. We enter some data in our case (login password) and they get to us in the database. ... > <p><br/><input name="submit" type="submit" value="Отправить"/><br/></p> </form>

CREATE TABLE IF NOT EXISTS `book_shop`.`Book` ( `ISBN_BOOK` VARCHAR(20) NOT NULL, `YEAR_BOOK` YEAR NULL, `TITLE_BOOK` VARCHAR ... de: 1005. Can't create table book_shop.shoppingbaskets_have_books (errno: 150 "Foreign key constraint is incorrectly formed")

User Table: users ---------- `id` int(11) `email` varchar(55) `login` varchar(55) And the order table orders -------- `id` i ... to display a list of login's-users who have made more than two orders. is it possible to do this with a single SELECT query ?

Hello everyone. Let's say there are 2 tables - clients and payments. The client can have many payments, because here in the m ... nts of a particular client (clearly, the id characterizes a particular client). Please tell me who knows how to implement it.

I have sent data from the form, everything is fine, it is added to the database, I also output data from the database to the ... dy sent by) I reread a lot of options on the Internet, nothing helped, I think there is some error in my code. Please help me

There is a page As I found out the page data is stored in the database. In which database and how to edit the database?

Hello! I wanted to ask, is it possible to work with a mysql database via javascript? That is, in php there are standard fun ... such a login is already in the database, then the inscription immediately appears that "Such a login is already registered."