MySQL Database Forum

The following where clause returns data not wanted. select * from <someTable> where <Column1> like "%Lamp_I%" or <Column2> like "%Lamp_I%" My sample data should have returned one row but instead it returned all rows whether it had an underscore or a blank. sample data looked like this 12 records had the following "Lamp Inc." in...

I have a login table which as columns name, employee_id, date,login, logout; everything works fine until a regular updation of login and logout is done(i.e every login having a logout). my problem is when the person forgets to logout, and next session or next day he login's and again logout's the previous un-updated cell also gets updated which...

Hi, I am doing a project with dreamweaver and i ran into a hitch with my select statement. I have this SELECT * FROM client, `statement` WHERE client.client_id = `statement`.client_id when i execute this it selects everybody in the database. So i want to add another WHERE statement to this query, this time one that compares...

hi, I used MySQL database server and VB.Net for my project and need to make a client-server connection. can anyone help me? i have successfully connected my 2 laptops as server and client using ODBC connector.., but when I tried to access the database on the remote laptop, "Unknown database 'database_name'" appears. Can anyone tell me what...

How can I say this ? INSERT INTO table SET nr=MAX(nr)+1 WHERE date='xx.xx.xx xx:xx:xx' nr is not primary, so I can not use auto increment.

have a table client. --------------------- code Int blocked tinyint name varchar have a table sells. --------------------- data date client Int

my d.o.b is required in dd,mm,yyyy i wrote 02.07.1956 but keeps coming back as invalid date format please correct ,It is for digital trends panel

i'm new in the world of coding ^_^ , i need to know if there is any way i can keep the database listening if there is any operation contain ( SELECT * FROM `glpi_tickettemplates` WHERE `id` = '-2' ) and then change it with ( SELECT * FROM `glpi_tickettemplates` WHERE `id` = '1' ) thanks in advance

Hi Experts,im a SAP PI consultant. im new to SQL server. i have a requirement where i need to fetch the records that are added today. i only have read access to the database. can some one help me with the query. My Fields are Date, Empcode, start_time, End_Time. these records i need to fetch from the database.

I am writing a web-app in PHP and using MySQL as the storage and need to store a lot of data that will be constantly changing every time I query a server. Two of the data elements are arrays and I'm not sure how to store them since they will be updated the next time I query the server. I pretty much have a query that I run and it provides...

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br /> <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b' at line 112

hi all i just want the description what is dynamic SQL? how we can create Dynamic SQL database

I need to display the customer or business name as "Customer" & combine the following into 1 query: SELECT a.account_id, a.cust_id, a.last_activity_date, a.open_emp_id, CONCAT(e.fname, ' ', e.lname) AS opened_by, a.avail_balance FROM account a INNER JOIN employee e ON a.open_emp_id = e. emp_id WHERE NOT EXISTS (SELECT 1 FROM...

I have come across the words called active server and passive server can somebody help me out in understanding what they actually mean

Hi all I've connected Base to mySQL, I can read the data from the DB with a query. But I cannot seem to be able to add a Record to the BB via a Form in Base, Is there sum thing I'm missing or is there a primition that I need to add

Hi, I want to transfer a user record from one database to another database. I want to do that within a single transaction to maintain data integrity, ie INSERT record to db1 and DELETE record (same data) from db2. Can someone help me with the code? I am using c#. Thanks in advance If I have two databases, doesn't it means I have two...

Hi, Can someone check my code below? The second UPDATE fails because there is no GNameX column but the first UPDATE gets written to the db anyway. I have done a trace and it definitely executes the trans.rollback. Any help would be appreciated. MySqlConnection conn = new MySqlConnection(DefaultSettings.ConnString); ...

I'd like to create a trigger to export to csv the new data added to the table. I've written: delimiter | create trigger trg_customer_csv after insert on customers for each row begin select new.account_code into outfile 'e:/trigfile.csv' fields terminated by ';' lines terminated by '\n' from customers;

Database name : bd1 Table Name : schedule Fields : associate_name, Category, Aux, Time Raj ABC Login, 9:00:00 Raj ABC Logout 6:00:00 i want the below output associate_name, Category, Aux, Login Time, Logout Time Raj ABC Login 9:00:00 6:00:00

i am working on basic msi installshield12 , i want to connect with MySQL Server using msi instsllshield , i choose SQLScript , and check MySQL option and uncheck other two options but , i couldn't find Mysql server in drop down of server selection dialog Any body help me please .

I'm trying to open a command prompt window to my MySQL server. From reading online, I should be able to use /usr/local/mysql/bin/mysql -h hostname ...other options... However, I don't have MySQL on my laptop, so it doesn't recognise the MySQL command. Is there a way to connect, or do I have to install MySQL on my laptop so that I have the proper...

Hi all once again!! I have two tables in MYSQL, tblLogin and tblCustomers with the following Columns: tblLogin{LoginID as Primary_Key, UserName, Password} and tblCustomer{Customer_ID as Primary_Key, Customer_FullName, OrderID, OrderDetails, submission_date, Customer_LoginID as Foreign_key}. What I want is to let customers to view their own...

First am glad that there are people like you who really know stuff. im a newb in php but need some help here. Error in Query3Duplicate entry '127.0.0.1' for key 'lastupdateipaddress' am trying to log on to the system with a different user name. how can i succeed? Thx

I am currently trying to build a crud application to load name, address and picture data for members of an organization. I have the database set up, but when I run the application I get a null converter error for the blob data. What do I need do to get the application to work. I can send or post the application if more information is needed.

I have following code snippet to implement a multilingual website. Idea is to, depending on user's language i need to translate word "Man" to "Hombre" My Question: Will it be valid to use $user_language instead of hard coded column name "Spanish" here. code: //$user_language is passed from his profile after log in to the site SELECT...