Databases Forum

Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if …

1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how …

Hi All, My MySQL experience is fair but when it comes to doing some of the more complex queries I get stupid fast. That said, in the past, I have written queries that INSERT data to the DB based on clicks. In this case I want to use the same …

I want to get a string in hex (example: "07DE" is 2014) and convert that to a char. How can I do this in MySQL Server? Sorry for the sloppy explanation Thank you

Greetings, I'm having a table that I need to retrieve its data in a specific order based on a column value(s). I need to retrieve first all rows that have the value 0 in that column in ascending order (default order) then rows that have value(s) greater than 0 in …

In MySQL server, I want to do a trigger that checks when a row inserted, if the row has the previous value in column A than the previous row, it should delete it. Im a little forgetful on how to check this correctly so if someone could lend a hand, …

I store "BYTE[]" type data into a BLOB. It stores it perfectly, the data being represented by hexadecimal pairs when I try to view it in MySQL. Now I want to convert that hexadecimal pairs into string. All the data is "simple" data such as strsing, intesger, floats, e the …

how to order rows in pl/sql? i have a table of numbers, i want to order in ascending order if id of table is odd and descending if id is even

Hi I am creating a database that will help monitor attendance at uni. We were given the following spec. Each course is made up of a number of modules. Students enrol in 6 modules. Each module has a timetable which includes times of classes. Class can be a lecture, tutorial …

Why did oracle start adding letters to their version numbers

Hi, I am trying to insert data into 3 tables using mysql.. At first, I was able to insert in the first table (staffinfo), after coding for the second table insert (empinfo), It inserted into second table without inserting in first table AND finally it echoes 1 record added Successfully …

I have a table with the following fields: client, project number, project manager, project manager email I have a form with text fields for each field of the table and I want to have a query run when the user presses a button on the form. How to i make …

I want to get the max(id) from a table colum with variable characters. it always returns 999 as the highest yet I have values like 6008 or even over 10000. I have tried the following: 1. SELECT Max(column_name) from table_name where column_name REGEXP '^[0-9]+$' 2. isNumeric as one of the …

I recently upgraded MySQL 5.5 to 5.6 because I needed some features but now Im not sure which my.cnf 5.6 loads... I try editing the my.cnf in /etc with some lines such as "port=hello" but it still loads and starts correctly. How can I see the exact route of the …

I am about to begin protecting a yet to be launched site againt injection attacks.(And other possible attacks) I am making use of a large database and must fortify this fully. I am researching this but am here to pose the question: **What should my main concerns be**? Please be …

i am trying to get data into oracle table from CSV file with SQL *LOADER but not getting the date which is in time zone format I.E. 2013-02-23T10:41:14.000Z in my csv file. i am using DATE as a type for Creation_Date. pls help me to resolve this problem asap.

hi. i'm gonna ask about creating a system in database using Java .. i have a problem about making system because they didn't thought us how to create system...

We plan to record/read data as fast as 10 ms (that's milliseconds) to a database. Now, this database will be in a factory so there is gonna be a lot of vibrations, temps, etc... Logically the first choice to everyone is a SSD. The problem with the SSD is that …

I'm working on a Database assigment but I'm kind of stuck. It seems to be the Double value that's causing the issue because when I use the Varchar data type I can create my table. Is there any way I can use Double without using Varchar. Any help is much …

I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you

0 down vote favorite I have a table: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`) Now i want to create a stored procedure that will insert new column into this table with the next id (which is …

Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because …

I am tring to perform a calculation in my query. I've been working on it for hours, so I need another pair of eyes to see what I am missing. Everything in the query is working except for the g.courseFee part. The course fee is not being added to the …

Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of data in it.  What I want to achieve is to **STRIP** (with REGEXP?) all the strings starting with …

Oldest question in the book. Google says: SELECT NOW()+ 0; And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not including the miliseconds. Basically, I need, from MySQL's side the milliseconds. How can I do this?

hi there im currently do some simple webpage that can submit the data save into database into MYSQL Workbench. But currently i have an error for insert into table. The error is --------------------------- App_Web_kclqmsmh --------------------------- You have an error in your SQL syntax; check the manual that corresponds to your …

Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & …

Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users …

Hallo, This is funny. I export mysql codes to the webserver. Yet, I cannot run the codes correctly, there are some errors when I run the codes: Error SQL query: -- -- Database: `project_infracom` -- -- -------------------------------------------------------- -- -- Table structure for table `infracom_admin` -- CREATE TABLE IF NOT EXISTS …

INSERT into tbl_inquiry (name,phone,email,subject,message) values ('apoorva','000012345','email@email.com','subject','hi what's up')

how can connect database to SQL?

how to create table statement give examples thanks!

how to use sql like operator?how to use it give me example thanks!

I'm hoping that another set of eyes will see something that I'm not. I'm having an issue with a script that I just added a little routine to, so I know the issue is in the routine, because the sript as a whole was working before adding this... the routine …

Hi, If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error Error at Command Line : 4 Column : 21 Error …

Hello, I am a web developer who is having a hard time trying to get my scripts to connect to my new web host. The script works perfectly on my localhost (I'm using XAMPP) but once I try to use it on my web host, I get the following error: …

please guys i am making an app and i want to show the number of users online on the app i have this code function whoisonline() { //what are my variables values $email=$_SESSION['jwp_email']; $sqloo="SELECT `id` FROM users WHERE email='$email'"; #mysql_query($sqloo) if ($run=mysql_query($sqloo)) { $b=mysql_fetch_assoc($run); $b['id']; $c=$b['id']; } $ip=$_SERVER['REMOTE_ADDR']; $ip_ua=$_SERVER['HTTP_USER_AGENT']; $time=time(); …

Hi team, Kindly, clarify the below query, i am confused the difference between in and like statements in the mysql. mysql> select count(id) as tablename from postings where is_active=1 and publish in (2) ; result -- 38 mysql> SELECT COUNT(*) FROM tablename WHERE is_active=1 and publish like '%2%'; result -- …

We have 2 Tables, One is Primary Table and another one is a Transaction Table. Both Tables are identical. We have to insert or update the record in Primary Table, based on Transaction Table. If a record is found identical on primary keys for Primary and Transaction Table, we would …

Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I …

I have two identical fields table, say "tb1" and "tb2". "tb1" has records: 1 2 3 4 "tb2" has records: 1 4 5 6 Now how can I compare this two tables and insert differential from "tb1" into "tb2", so "tb2" will be: 1 2 3 4 5 6 Is …

hey guys. so first of im kinda confused as to which forum i should post to but i hope you guys arent mad if this isnt the appropriate forum. moving on, i have these bunch of images that i want to be able to be displayed after a button click …

This is what I have: create table Employee_T (EmployeeID varchar2(10) NOT NULL, EmployeeFirstName varchar2(10) NOT NULL, EmployeeLastName varchar2(15) NOT NULL, EmployeeAddress varchar2(20), EmployeeCity varchar2(10), EmployeeState char(2), EmployeeZip number(5), EmployeeDateHired date default sysdate, EmployeeBirthDate date, EmployeeSupervisorID varchar2(10), Constraint employee_PK primary key (EmployeeID), Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) ); create table …

I wrote my first trigger and it giving error UES TRY GO CREATE TRIGGER cust_update ON TRY FOR UPDATE AS IF UPDATE (custno) BEGIN TRANSACTION RAISERROR('CUST NO CANNOT BE UPDATED',10,1) ROLLBACK TRANSACTION END Any idea `

Hello everyone. I'm quiet new here and trying to get som helpå from you guys. My main problem is that I have made a form which I want to use to post data to my database. But it seem to never work. Firsta problem was; everytime the page loads the …

Hi all I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 …

`"SELECT IFNULL(count(id), 0) AS ctr FROM table WHERE date >= $from_date AND date <= $to_date AND GROUP BY WEEK(table.date)"` This should result to 0 row. But, instead of printing 0, it is returning an empty array rather than {0, 0, 0, ... }

I have a problem of creating mysql that return a single value, calculated from values in a column.what kinds of function i think to use?

Hi Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this …