menu
  • Register

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

Recent questions tagged database

Recent questions tagged database

0 votes
1 answer 6 views
SQL: Which of the following commands is used to issue a query?
Problem: Hi there! I want to know which command is used to retrieve data from a database in SQL? How do we use it and when to use it? I am a beginner so I am looking for a detailed answer. Thanks!
asked 1 day ago Code Learner 5.5k points
0 votes
1 answer 13 views
SQL: You use aggregate functions to perform calculations based on groups of records
Problem: Hello! I am learning SQL. I came across the following statement while attempting a self-assessment quiz: You use aggregate functions to perform calculations based on groups of records (True/False) I do not know Aggregate functions so I skipped this question. Can someone from here please explain what the above statement means? Moreover, please explain the aggregated functions. Thanks!
asked 4 days ago Code Learner 5.5k points
0 votes
1 answer 3 views
SQL: Which of the following terms refers to commands that are used to create or modify database tables?
Problem: Hi there! I am learning SQL. Somewhere I saw a multiple choice question in which a list of terms was given and I had to choose the terms that refer to the commands used to create or modify database tables and columns. Following is the list of keywords: ... of most of these commands. I have learned only basics yet. If someone could explain all these commands, I would be grateful. Thanks!
asked 5 days ago Code Learner 5.5k points
0 votes
1 answer 12 views
What was zach’s database “filter?”
Problem: There is a database on postgresql. There is a Django script that collects data. The problem is that there is a LOT of data. The table, with which it is necessary to operate, contains, according to conservative estimates, from hundreds of millions ... {}'.format(str(self.origination_host), str(self.termination_host)) class Meta: verbose_name = 'CDR data' verbose_name_plural = 'CDR data'
asked Dec 7, 2020 sasha 5.3k points
0 votes
1 answer 26 views
String or binary data would be truncated in SQL
String or binary data would be truncated in SQL I have the error when I am inserting a row in SQL. Any idea?
asked Nov 25, 2020 miki 1.9k points
0 votes
1 answer 23 views
How to import large sql file in phpmyadmin
Problem: How can i import large SQL file in phpmyadmin?
asked Nov 17, 2020 prog_learner 2.5k points
0 votes
1 answer 7 views
Cannot open database requested by the login
Cannot open database requested by the login I can not log in to a database in SQL Server. Can you suggest a solution?
asked Nov 11, 2020 miki 1.9k points
0 votes
1 answer 13 views
C ++ - Declare multiple variables in a loop and use them to perform calculations
I need to make a [console] program that gets the full names of five people, as well as their three grades to calculate their average. Instead of declaring variable by variable string nom1, nom2 //... int cal1, cal2 //... I want to make a for loop (or ... at the end because "the identifiers are not defined". Is it possible to achieve this, or is it something that not even magic can achieve?
asked Nov 8, 2020 sasha 5.3k points
0 votes
1 answer 28 views
Cannot log in to the mysql server
Problem Hello Kodlogs I am getting Error: cannot log in to the MYSQL ; while logging on PhpMyAdmin. Need help in fix please.
asked Oct 31, 2020 hashq 1.1k points
0 votes
1 answer 11 views
insert update delete in php with source code
Question: Is there any available code in PHP that is ready to be used to insert, retrieve, update, and delete the records in a table? If it is possible it is a callable class that can be instantiated.
asked Oct 31, 2020 RJ Lam 650 points
0 votes
1 answer 12 views
If else condition in MySQL query in php
Problem: i wander how to use if else condition in mysql query in PHP. Can anyone assist me with a example of getting last inserted id using if else condtion with query.
asked Oct 29, 2020 prog_learner 2.5k points
0 votes
1 answer 10 views
how to insert special characters in mysql database using php
My small project is about making an entry of a recipe. So it includes some special characters. So when I made an entry and save them to the database, it generates an error. But when I tried to insert it to my PHPAdmin, everything works well. Here is my recipe ... ½ tablespoons water 6 cups chicken broth 2 ¼ tablespoons soy sauce 1 tablespoon fish sauce"; Anyone who can show me how to save this?
asked Oct 28, 2020 RJ Lam 650 points
0 votes
1 answer 13 views
how to get last insert id in php
I have three tables that are link to each other via id of the main entry. For example, I need to create a user entry with username, name and password in the user table. And then after this information is created into the database, I need to create two new information to handle its ... label> <input type="text" name="name" id="name"><br><br> <button id="submit" name="submit">Submit</button> </form>
asked Oct 28, 2020 RJ Lam 650 points
0 votes
1 answer 15 views
add field dynamically to form in jquery and php
Hello, I have a small project that requires me to create a dynamic form using jquery and php. This project has two sections. The Left side is the entry of at least two fields: <input type="text" name="first_name"> <input type="text" name="last_name"> Is it possible also to add and delte ... <tr> <td>1</td> <td>Abc</td> <td>Xyz</td> </tr> </table> I would be thankful in advance for helping me.
asked Oct 27, 2020 RJ Lam 650 points
0 votes
1 answer 15 views
How to rollback deleted data in SQL?
asked Oct 27, 2020 miki 1.9k points
0 votes
1 answer 14 views
How to open SQL server configuration manager
asked Oct 27, 2020 miki 1.9k points
0 votes
1 answer 12 views
How to create a database in SQL server 2008
asked Oct 26, 2020 miki 1.9k points
0 votes
1 answer 12 views
How to Restore Database in SQL server 2012
asked Oct 26, 2020 miki 1.9k points
0 votes
1 answer 23 views
update query in php mysql with example
Is there any PHP code that demonstrate on how to query my database and gives me the list using the &ldquo;select&rdquo; tag. And when I select any name from the list the form will retrieve the data and allows me to update the information and then update the information when I&rsquo;m done? Thanks in advance.
asked Oct 25, 2020 azriel 590 points
Page:
Dark theme