Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim query As String = "select * from testdata where rfid_tag='" & TextBox3.Text & "' and Date_serve<= '" & Date.Now.ToString("yyyy-MM-dd ") & "' and Start_Time<= '" & Date.Now.ToString("HH:mm:ss ") & "' and End_Time>= '" & Date.Now.ToString("HH:mm:ss ") & "' or amount_serve='' " Dim cm As New MySqlCommand(query, con) con.Open() Dim rd …

Member Avatar
Member Avatar
+1 forum 2

What's the difference between LCASE() and LOWER() in MySQL? I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?

Member Avatar
Member Avatar
+0 forum 1

I need help with implementing MySQL transactions with PHP. Specifically, I'm confused between the flags `WITH CONSISTENT SNAPSHOT`, `READ WRITE`, and `READ ONLY`, what their differences are, and how they relate to table locking. I already read the MySQL reference manual but I'm still confused.

Member Avatar
Member Avatar
+2 forum 6

If a bulk MySQL insert takes 5 minutes to complete, and one of the columns in the table is a TIMESTAMP column with a default value of CURRENT TIMESTAMP, will the timestamps of the rows that were inserted be reflective of the entire 5 minutes, or will they all default to the same timestamp from beginning or the end of the query? The bulk insert exists within a transaction.

Member Avatar
Member Avatar
+0 forum 3

Hi to all! I'm fairly new to using High availability group and i've been having issues with storage space from my Logs drive from my primary server.. I just want to know why is my Log file not shrinking after I do backups(Full) on the primary server.. also, another question.. can I do the backup on my secondary server before shrinking my Logs on the primary? the reason I want to do this because my primary server has a database primarily used for Production(MES) and I don't want any downtime on their part.. Thanks in Advance.

Member Avatar
Member Avatar
+0 forum 4

Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do?

Member Avatar
Member Avatar
+0 forum 1

I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this $query = "SELECT pubid, author FROM refs"; $sql=$con->prepare($query); $sql->execute(); $sql->setFetchMode(PDO::FETCH_ASSOC); while ($row=$sql->fetch()){ $id= $row['pubid']; $author = $row['author']; $name = explode('., ', $author); } How can one write sql/mysql query that does the same?

Member Avatar
Member Avatar
+0 forum 6

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and just gives out errors like " * Ending quote ' was expected. (near "" at position 4438), and " 42 values were expected, but found 21. (near "(" at position 3967)* I'm attaching 2 screeshots here so that you guys can see the contents of this file,somewhere it says mysql …

Member Avatar
Member Avatar
+0 forum 2

I was attempting to store chat logs in a MySQL database where the message field is utf8_general_ci However, when it came across an emoji, it would choke, and the message field would only include text up to the emoji character. I changed the message field to be utf8mb4_general_ci, which seemed to be suggested upon googling, and now emoji characters are replaced in the database with four question mark characters, instead of choking. What is the best way to encode/decode emoji characters so that they can be accurately represented? (Ideally with PHP)

Member Avatar
Member Avatar
+0 forum 6

Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); Error starting at line 1 in command: CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(3) NOT NULL, path VARCHAR2(200) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ) Error at Command Line:8 Column:44 Error report: SQL Error: ORA-00907: …

Member Avatar
Member Avatar
+0 forum 9

Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS dsfd from SALESMASTER GROUP BY DATEPART(MONTH, DATE), DATENAME(MONTH, DATE) ORDER BY DATEPART(MONTH, DATE)[/COde] I want to see the same data in the form of financial year i.e. [April-to-March] just take care financial year involves 9 months of previous year and 3 months of current year. please reply..

Member Avatar
Member Avatar
+0 forum 4

Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature of customers with fields of your choice -Nomenclature of items with fields of your choice -Nomenclature, which represents individual prices for certain items pertaining to specific customers. When selecting a customer, the database must show all items with the respective prices depending on whether a customer is using it individual …

Member Avatar
Member Avatar
+0 forum 4

I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `username` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `firstname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `lastname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `email` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `phone` VARCHAR( 30 ) COLLATE utf8_unicode_ci NOT …

Member Avatar
Member Avatar
+0 forum 2

I'm not sure if this is the right forum to ask this in, sorry if it isn't. It's been a while since I've been to this site. We have a MS SQL database that contains a table with some columns that are no longer used (or shouldn't be). The data isn't updated anymore and has been moved to different columns to extend functionality with the applications that access the data. Anyway, I would like to remove the columns, but I need to make sure that the ASP.NET website, an Access database and a C# WinForms application don't have any code …

Member Avatar
Member Avatar
+0 forum 4

The second annual Imperva Hacker Intelligence Initiative report, this one entitled [Monitoring Hacker Forums](http://www.imperva.com/docs/HII_Monitoring_Hacker_Forums_2012.pdf), is out and reveals that the threat surfaces being discussed by the hacker community are very different from those that businesses are spending money on defending against attack. ![dweb-hackers](/attachments/small/0/dweb-hackers.jpg "align-right") The Imperva research analysed the content of a number of online hacker communities, including many lesser known forums in order to get a more accurate snapshot of what those doing the hacking are actually discussing. By looking at a total of more than 400,000 different conversational threads, Imperva was able to determine that SQL injection and …

Member Avatar
Member Avatar
+0 forum 2

The End.