• Register

Recent questions tagged database

0 votes
1 answer 6 views
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
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
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
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 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
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 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
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
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
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
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
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
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
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
0 votes
1 answer 14 views
0 votes
1 answer 12 views
0 votes
1 answer 12 views
0 votes
1 answer 23 views
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